[Spce-user] Rate-o-mat Missing Billing DB User

[Robert Cuaresma]

Can anyone help me with this problem?

Thanks!!

Saludos,
De: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] En nombre de Robert Cuaresma
Enviado el: viernes, 15 de julio de 2016 23:44
Para: spce-user at lists.sipwise.com
Asunto: [Spce-user] Rate-o-mat Missing Billing DB User

Hi community,

I have a spce 2.8 version and billing status is unrated. If I run command rate-o-mat restart I have this error:
Missing billing DB user setting. at /usr/sbin/rate-o-mat line 33.

Log of /var/log/ngcp/rate-o-mat.log:
Jul 15 23:23:53 softswitch rate-o-mat[1318]: Error executing update cdr statement: MySQL server has gone away
Jul 15 23:23:53 softswitch rate-o-mat[1318]: Caught DBI:err 2006
Jul 15 23:23:53 softswitch rate-o-mat[1318]: DB connection gone, retrying...
Jul 15 23:23:53 softswitch rate-o-mat[1318]: Trying to connect to billing db...
Jul 15 23:23:53 softswitch rate-o-mat[1318]: Successfully connected to billing db...
Jul 15 23:23:53 softswitch rate-o-mat[1318]: Trying to connect to accounting db...
Jul 15 23:23:53 softswitch rate-o-mat[1318]: Successfully connected to accounting db...
Jul 15 23:23:53 softswitch rate-o-mat[1318]: rate cdr #375191
Jul 15 23:23:53 softswitch rate-o-mat[1318]: missing destination profile, so we can't calculate destination_reseller_cost for destination_provider_info $VAR1 = {#012
       'contract_id' => '1',#012          'profile_id' => undef,#012          'class' => 'reseller'#012        };
Jul 15 23:23:53 softswitch rate-o-mat[1318]: rate cdr #375200

It seems that can be a problem with MySQL but I don't know how solve this. I restarted the server but the problem persist.

Any idea?

Thanks a lot.

Robert Cuaresma

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20160725/e68922a2/attachment-0001.html>