[Spce-user] [km_dbase.c:122]
Crexpedio Support Team
jesse at crexpedio.com
Thu Jun 11 23:38:33 EDT 2015
I’ve had some issues which I believe are all related to a database issue but haven’t found a fix. Server is installed following documentation and config files have not been manually edited.
For example:
- subscriber gets failed registration multiple times prior to extension logging in.
- no data in Call Distribution report on GUI
- CDR’s are empty
Enviornment
mr3.8.1-1433635162
Logs from Kamailio-proxy.log (subscriber number, domain and IP are bogus but logs are real)
Jun 11 21:02:20 secure proxy[4537]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=w1vwnvtiLSC4oMtd3cb0NUZN2CrhqcWO
Jun 11 21:02:20 secure proxy[4537]: NOTICE: <script>: Authentication failed, no credentials - R=sip:secure.domain.com ID=w1vwnvtiLSC4oMtd3cb0NUZN2CrhqcWO
Jun 11 21:02:20 secure proxy[4525]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=w1vwnvtiLSC4oMtd3cb0NUZN2CrhqcWO
Jun 11 21:02:26 secure proxy[4525]: ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query
Jun 11 21:02:26 secure proxy[4525]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jun 11 21:02:26 secure proxy[4525]: ERROR: usrloc [ucontact.c:629]: db_insert_ucontact(): inserting contact in db failed
Jun 11 21:02:26 secure proxy[4525]: ERROR: usrloc [urecord.c:548]: insert_ucontact(): failed to insert in database
Jun 11 21:02:26 secure proxy[4525]: ERROR: registrar [save.c:521]: insert_contacts(): failed to insert contact
Jun 11 21:02:31 secure proxy[4531]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=FeMkULbvDUDm6B29o92VtjpCpAuD.UXq
Jun 11 21:02:31 secure proxy[4531]: NOTICE: <script>: Authentication failed, no credentials - R=sip:secure.domain.com ID=FeMkULbvDUDm6B29o92VtjpCpAuD.UXq
Jun 11 21:02:31 secure proxy[4534]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=FeMkULbvDUDm6B29o92VtjpCpAuD.UXq
Jun 11 21:02:37 secure proxy[4534]: ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query
Jun 11 21:02:37 secure proxy[4534]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jun 11 21:02:37 secure proxy[4534]: ERROR: usrloc [ucontact.c:629]: db_insert_ucontact(): inserting contact in db failed
Jun 11 21:02:37 secure proxy[4534]: ERROR: usrloc [urecord.c:548]: insert_ucontact(): failed to insert in database
Jun 11 21:02:37 secure proxy[4534]: ERROR: registrar [save.c:521]: insert_contacts(): failed to insert contact
Jun 11 21:02:44 secure proxy[4520]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=eBGfI1JFE.oUd.vPpswiXsv8KEtxnlpn
Jun 11 21:02:44 secure proxy[4520]: NOTICE: <script>: Authentication failed, no credentials - R=sip:secure.domain.com ID=eBGfI1JFE.oUd.vPpswiXsv8KEtxnlpn
Jun 11 21:02:44 secure proxy[4537]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=eBGfI1JFE.oUd.vPpswiXsv8KEtxnlpn
Jun 11 21:02:45 secure proxy[4537]: NOTICE: <script>: Contacts successfully saved, expires in 900s - R=sip:secure.domain.com ID=eBGfI1JFE.oUd.vPpswiXsv8KEtxnlpn
Jun 11 21:02:45 secure proxy[4519]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=eBGfI1JFE.oUd.vPpswiXsv8KEtxnlpn
Jun 11 21:02:45 secure proxy[4525]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=b.Ibsie7kDB0pcL20jjqvTJDLVqpbLgg
Jun 11 21:02:45 secure proxy[4525]: NOTICE: <script>: Authentication failed, no credentials - R=sip:secure.domain.com ID=b.Ibsie7kDB0pcL20jjqvTJDLVqpbLgg
Jun 11 21:02:45 secure proxy[4522]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=b.Ibsie7kDB0pcL20jjqvTJDLVqpbLgg
Jun 11 21:02:48 secure proxy[4519]: NOTICE: <script>: Contacts successfully deleted - R=sip:secure.domain.com ID=eBGfI1JFE.oUd.vPpswiXsv8KEtxnlpn
Jun 11 21:02:54 secure proxy[4522]: ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query
Jun 11 21:02:54 secure proxy[4522]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jun 11 21:02:54 secure proxy[4522]: ERROR: usrloc [ucontact.c:629]: db_insert_ucontact(): inserting contact in db failed
Jun 11 21:02:54 secure proxy[4522]: ERROR: usrloc [urecord.c:548]: insert_ucontact(): failed to insert in database
Jun 11 21:02:54 secure proxy[4522]: ERROR: registrar [save.c:521]: insert_contacts(): failed to insert contact
Jun 11 21:03:01 secure proxy[4534]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=3tipgKc0nT2Bdw3rxOrFzcikpgcanQKN
Jun 11 21:03:01 secure proxy[4534]: NOTICE: <script>: Authentication failed, no credentials - R=sip:secure.domain.com ID=3tipgKc0nT2Bdw3rxOrFzcikpgcanQKN
Jun 11 21:03:01 secure proxy[4520]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=3tipgKc0nT2Bdw3rxOrFzcikpgcanQKN
Jun 11 21:03:02 secure proxy[4520]: NOTICE: <script>: Contacts successfully saved, expires in 900s - R=sip:secure.domain.com ID=3tipgKc0nT2Bdw3rxOrFzcikpgcanQKN
Jun 11 21:03:02 secure proxy[4537]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=3tipgKc0nT2Bdw3rxOrFzcikpgcanQKN
Jun 11 21:03:02 secure proxy[4525]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=ySN6jCakYHYrnWtj6eJbJ5COHpbOp9Fe
Jun 11 21:03:02 secure proxy[4525]: NOTICE: <script>: Authentication failed, no credentials - R=sip:secure.domain.com ID=ySN6jCakYHYrnWtj6eJbJ5COHpbOp9Fe
Jun 11 21:03:02 secure proxy[4519]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=ySN6jCakYHYrnWtj6eJbJ5COHpbOp9Fe
Jun 11 21:03:04 secure proxy[4537]: NOTICE: <script>: Contacts successfully deleted - R=sip:secure.domain.com ID=3tipgKc0nT2Bdw3rxOrFzcikpgcanQKN
Jun 11 21:03:07 secure proxy[4519]: ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Duplicate entry 'uloc-55786194-11a7-b02' for key 'ruid_idx'
Jun 11 21:03:07 secure proxy[4519]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jun 11 21:03:07 secure proxy[4519]: ERROR: usrloc [ucontact.c:629]: db_insert_ucontact(): inserting contact in db failed
Jun 11 21:03:07 secure proxy[4519]: ERROR: usrloc [urecord.c:548]: insert_ucontact(): failed to insert in database
Jun 11 21:03:07 secure proxy[4519]: ERROR: registrar [save.c:521]: insert_contacts(): failed to insert contact
Jun 11 21:03:12 secure proxy[4522]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=objP.SyrDoQJOdyQzCSsutv-PrglhR37
Jun 11 21:03:12 secure proxy[4522]: NOTICE: <script>: Authentication failed, no credentials - R=sip:secure.domain.com ID=objP.SyrDoQJOdyQzCSsutv-PrglhR37
Jun 11 21:03:12 secure proxy[4528]: NOTICE: <script>: New request on proxy - M=REGISTER R=sip:secure.domain.com F=sip:88888888 at secure.domain.com T=sip:88888888 at secure.domain.com IP=200.200.200.200:39999 (127.0.0.1:5060) ID=objP.SyrDoQJOdyQzCSsutv-PrglhR37
^C
Mysql is running:
root at secure:/home/admin# ps aux | grep mysql
root 2229 0.0 0.0 4192 1548 ? S Jun10 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 3312 0.1 3.7 658404 144204 ? Sl Jun10 2:45 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/mysqld.err --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
root at secure:/home/admin# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 71051
Server version: 5.5.43-0+deb7u1-log (Debian)
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| accounting |
| billing |
| carrier |
| kamailio |
| mysql |
| ngcp |
| performance_schema |
| prosody |
| provisioning |
| sipstats |
| stats |
| syslog |
+--------------------+
13 rows in set (1.20 sec)
Please advise.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2547 bytes
Desc: not available
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20150611/95b51e61/attachment.p7s>
More information about the Spce-user
mailing list