[Spce-user] Error rating CDR batch - after upgrade

[Skyler]

Hi,

 ok so it was a line commented out a while ago for some other reason. I
uncommented and now rate-o-mat starts ok.

 However, it seems mediator also has an issue...

root at prod1:~# tail -500 /var/log/ngcp/cdr.log
Apr 25 03:33:26 prod1-p1 mediator[7357]: Locking process.
Apr 25 03:33:26 prod1-p1 mediator[7357]: Daemonizing process.
Apr 25 03:33:26 prod1-p1 mediator[7358]: Writing pid file.
Apr 25 03:33:26 prod1-p1 mediator[7358]: ACC acc database host='localhost',
port='3306', user='kamailio', name='kamailio'
Apr 25 03:33:26 prod1-p1 mediator[7358]: CDR acc database host='localhost',
port='3306', user='mediator', name='accounting'
Apr 25 03:33:26 prod1-p1 mediator[7358]: Setting up mysql connections.
Apr 25 03:33:26 prod1-p1 mediator[7358]: Up and running, daemonized=1,
pid-path='/var/run/mediator.pid', interval=10
Apr 25 03:33:26 prod1-p1 mediator[7358]: Call-Id '
714a1694467d16185676e5851a754d4b at 209.15.226.21' has no separated source
user id, '0'
Apr 25 03:33:26 prod1-p1 mediator[7358]: Call-Id '
74d8b9c31f5be8a960ca08ad362c37b3 at 209.15.226.21' has no separated source
user id, '0'
Apr 25 03:33:26 prod1-p1 mediator[7358]: Error inserting cdrs: Data
truncated for column 'call_type' at row 28
Apr 25 03:33:26 prod1-p1 mediator[7358]: Shutting down.
Apr 25 03:33:26 prod1-p1 mediator[7358]: Successfully shut down.
Apr 25 03:33:26 prod1-p1 mediator[7358]: Unlocking mediator.


Skyler

On Wed, Apr 25, 2012 at 2:11 AM, Skyler <skchopperguy at gmail.com> wrote:

> Hi,
>
>  After upgrade from 2.4 - 2.5 rate-o-mat will not start. I have checked
> contracts and I have 2 + default, all with .* destination right now.
>
> root at prod1:/etc/init.d# /etc/init.d/ngcp-rate-o-mat start
> root at prod1:/etc/init.d# Error rating CDR batch: Can't use string ("60")
> as a SCALAR ref while "strict refs" in use at /usr/sbin/rate-o-mat line 908.
>
>
> root at prod1:/etc/init.d# tail -f /var/log/ngcp/rate-o-mat.log
> Apr 25 02:00:28 prod1-p1 rate-o-mat[4474]: Up and running.
> Apr 25 02:00:28 prod1-p1 rate-o-mat[4474]: rate cdr #4
> Apr 25 02:00:28 prod1-p1 rate-o-mat[4474]: Error rating CDR batch: Can't
> use string ("60") as a SCALAR ref while "strict refs" in use at
> /usr/sbin/rate-o-mat line 908.
> Apr 25 02:06:03 prod1-p1 rate-o-mat[6155]: Trying to connect to billing
> db...
> Apr 25 02:06:03 prod1-p1 rate-o-mat[6155]: Successfully connected to
> billing db...
> Apr 25 02:06:03 prod1-p1 rate-o-mat[6155]: Trying to connect to accounting
> db...
> Apr 25 02:06:03 prod1-p1 rate-o-mat[6155]: Successfully connected to
> accounting db...
> Apr 25 02:06:03 prod1-p1 rate-o-mat[6155]: Up and running.
> Apr 25 02:06:03 prod1-p1 rate-o-mat[6155]: rate cdr #4
> Apr 25 02:06:03 prod1-p1 rate-o-mat[6155]: Error rating CDR batch: Can't
> use string ("60") as a SCALAR ref while "strict refs" in use at
> /usr/sbin/rate-o-mat line 908.
>
>
> mysql> select * from billing.billing_mappings;
>
> +----+---------------------+----------+--------------------+-------------+------------+
> | id | start_date          | end_date | billing_profile_id | contract_id |
> product_id |
>
> +----+---------------------+----------+--------------------+-------------+------------+
> |  1 | NULL                | NULL     |               NULL |           1 |
>          3 |
> |  2 | NULL                | NULL     |                  1 |           2 |
>          2 |
> |  3 | NULL                | NULL     |                  2 |           3 |
>       NULL |
> |  4 | 2012-04-16 10:27:22 | NULL     |                  2 |           2 |
>          2 |
> |  6 | 2012-04-25 01:44:45 | NULL     |                  1 |           2 |
>          2 |
> |  8 | 2012-04-25 01:51:28 | NULL     |                  2 |           2 |
>          2 |
> |  9 | NULL                | NULL     |                  1 |           5 |
>          2 |
>
> +----+---------------------+----------+--------------------+-------------+------------+
> 7 rows in set (0.00 sec)
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20120425/06962d01/attachment-0001.html>