<div class="gmail_extra">Hi,</div><div class="gmail_extra"><br></div><div class="gmail_extra"> ok so it was a line commented out a while ago for some other reason. I uncommented and now rate-o-mat starts ok.</div><div class="gmail_extra">
<br></div><div class="gmail_extra"> However, it seems mediator also has an issue...</div><div class="gmail_extra"><br></div><div class="gmail_extra">root@prod1:~# tail -500 /var/log/ngcp/cdr.log</div><div class="gmail_extra">
<div class="gmail_extra">Apr 25 03:33:26 prod1-p1 mediator[7357]: Locking process.</div><div class="gmail_extra">Apr 25 03:33:26 prod1-p1 mediator[7357]: Daemonizing process.</div><div class="gmail_extra">Apr 25 03:33:26 prod1-p1 mediator[7358]: Writing pid file.</div>
<div class="gmail_extra">Apr 25 03:33:26 prod1-p1 mediator[7358]: ACC acc database host='localhost', port='3306', user='kamailio', name='kamailio'</div><div class="gmail_extra">Apr 25 03:33:26 prod1-p1 mediator[7358]: CDR acc database host='localhost', port='3306', user='mediator', name='accounting'</div>
<div class="gmail_extra">Apr 25 03:33:26 prod1-p1 mediator[7358]: Setting up mysql connections.</div><div class="gmail_extra">Apr 25 03:33:26 prod1-p1 mediator[7358]: Up and running, daemonized=1, pid-path='/var/run/mediator.pid', interval=10</div>
<div class="gmail_extra">Apr 25 03:33:26 prod1-p1 mediator[7358]: Call-Id '<a href="mailto:714a1694467d16185676e5851a754d4b@209.15.226.21">714a1694467d16185676e5851a754d4b@209.15.226.21</a>' has no separated source user id, '0'</div>
<div class="gmail_extra">Apr 25 03:33:26 prod1-p1 mediator[7358]: Call-Id '<a href="mailto:74d8b9c31f5be8a960ca08ad362c37b3@209.15.226.21">74d8b9c31f5be8a960ca08ad362c37b3@209.15.226.21</a>' has no separated source user id, '0'</div>
<div class="gmail_extra">Apr 25 03:33:26 prod1-p1 mediator[7358]: Error inserting cdrs: Data truncated for column 'call_type' at row 28</div><div class="gmail_extra">Apr 25 03:33:26 prod1-p1 mediator[7358]: Shutting down.</div>
<div class="gmail_extra">Apr 25 03:33:26 prod1-p1 mediator[7358]: Successfully shut down.</div><div class="gmail_extra">Apr 25 03:33:26 prod1-p1 mediator[7358]: Unlocking mediator.</div><div class="gmail_extra"><br></div>
<div class="gmail_extra"><br></div></div><div class="gmail_extra">Skyler<br><br><div class="gmail_quote">On Wed, Apr 25, 2012 at 2:11 AM, Skyler <span dir="ltr"><<a href="mailto:skchopperguy@gmail.com" target="_blank">skchopperguy@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<div><br></div><div> 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.</div>
<div><br></div><div>root@prod1:/etc/init.d# /etc/init.d/ngcp-rate-o-mat start</div>
<div>root@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.</div><div><br></div><div><br></div><div><div>
root@prod1:/etc/init.d# tail -f /var/log/ngcp/rate-o-mat.log </div><div>Apr 25 02:00:28 prod1-p1 rate-o-mat[4474]: Up and running.</div><div>Apr 25 02:00:28 prod1-p1 rate-o-mat[4474]: rate cdr #4</div><div>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.</div>
<div>Apr 25 02:06:03 prod1-p1 rate-o-mat[6155]: Trying to connect to billing db...</div><div>Apr 25 02:06:03 prod1-p1 rate-o-mat[6155]: Successfully connected to billing db...</div><div>Apr 25 02:06:03 prod1-p1 rate-o-mat[6155]: Trying to connect to accounting db...</div>
<div>Apr 25 02:06:03 prod1-p1 rate-o-mat[6155]: Successfully connected to accounting db...</div><div>Apr 25 02:06:03 prod1-p1 rate-o-mat[6155]: Up and running.</div><div>Apr 25 02:06:03 prod1-p1 rate-o-mat[6155]: rate cdr #4</div>
<div>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.</div></div><div><br></div>
<div><br></div><div><div>mysql> select * from billing.billing_mappings;</div><div>+----+---------------------+----------+--------------------+-------------+------------+</div><div>| id | start_date | end_date | billing_profile_id | contract_id | product_id |</div>
<div>+----+---------------------+----------+--------------------+-------------+------------+</div><div>| 1 | NULL | NULL | NULL | 1 | 3 |</div><div>| 2 | NULL | NULL | 1 | 2 | 2 |</div>
<div>| 3 | NULL | NULL | 2 | 3 | NULL |</div><div>| 4 | 2012-04-16 10:27:22 | NULL | 2 | 2 | 2 |</div><div>| 6 | 2012-04-25 01:44:45 | NULL | 1 | 2 | 2 |</div>
<div>| 8 | 2012-04-25 01:51:28 | NULL | 2 | 2 | 2 |</div><div>| 9 | NULL | NULL | 1 | 5 | 2 |</div><div>+----+---------------------+----------+--------------------+-------------+------------+</div>
<div>7 rows in set (0.00 sec)</div></div><div><br></div><div><br></div>
</blockquote></div><br></div>