Any idea if it's a setting that I can easily change that's wrong, or that it's
a bug?
> Sent: Wednesday, November 08, 2017 at 1:49 PM
> From: "hdssdsdsdsfsdf hdssdsdsdsfsdf" <hdssdsdsdsf...@mail.com>
> To: mico...@gmail.com
> Cc: "'Kamailio (SER) - Users Mailing List'" <sr-users@lists.kamailio.org>
> Subject: Re: [SR-Users] authenticating to mongodb fails
>
> That last email seems unrelated indeed. You were right about the logs. Below
> are the logs from syslog and the logs containing mongo in the debug logs.
> Please let me know if this format is not working for you or if you need more.
>
> If I start mongo without authentication *and* remove the "kam:kam@" in the
> debug url, everything works fine.
>
> in syslog:
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: <core>
> [db.c:314]: db_do_init2(): connection 0x7fe12901a318 not found in pool
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: db_mongodb
> [mongodb_connection.c:55]: db_mongodb_new_connection(): connection open to:
> mongodb://kam:kam@localhost/kamailio
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: db_mongodb
> [mongodb_dbase.c:851]: db_mongodb_query(): query to collection [version]
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: db_mongodb
> [mongodb_dbase.c:885]: db_mongodb_query(): query filter: { "table_name" :
> "location" }
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: db_mongodb
> [mongodb_dbase.c:904]: db_mongodb_query(): columns filter: { "table_version"
> : 1 }
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: <core>
> [db_res.c:116]: db_new_result(): allocate 56 bytes for result set at
> 0x7fe12901a508
> Nov 8 13:32:21 xxxxx mongod.27017[1290]: [thread1] connection accepted from
> 127.0.0.1:52663 #6 (1 connection now open)
> Nov 8 13:32:21 xxxxx kamailio[2289]: loading modules under config path:
> /opt/kamailio/lib64/kamailio/modules
> Nov 8 13:32:21 xxxxx kamailio[2289]: Listening on
> Nov 8 13:32:21 xxxxx kamailio[2289]: udp: <stripped>:5060
> Nov 8 13:32:21 xxxxx kamailio[2289]: Aliases:
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: db_mongodb
> [mongodb_dbase.c:733]: db_mongodb_store_result(): no result from mongodb
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: <core>
> [db.c:403]: db_table_version(): no row for table location found
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: ERROR: <core>
> [db.c:439]: db_check_table_version(): invalid version 0 for table location
> found, expected 8 (check table structure and table "version")
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: ERROR: usrloc
> [dlist.c:659]: register_udomain(): error during table version check.
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: <core>
> [db_pool.c:100]: pool_remove(): removing connection from the pool
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: ERROR: registrar
> [reg_mod.c:566]: domain_fixup(): failed to register domain
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: ERROR: <core>
> [route.c:1154]: fix_actions(): fixing failed (code=-1) at
> cfg:/opt/kamailio/etc/kamailio/kamailio.cfg:199
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: ERROR: <core>
> [route.c:1154]: fix_actions(): fixing failed (code=-1) at
> cfg:/opt/kamailio/etc/kamailio/kamailio.cfg:223
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: ERROR: <core>
> [route.c:1154]: fix_actions(): fixing failed (code=-1) at
> cfg:/opt/kamailio/etc/kamailio/kamailio.cfg:225
> Nov 8 13:32:21 xxxxx mongod.27017[1290]: [conn6] end connection
> 127.0.0.1:52663 (1 connection now open)
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: tm
> [t_funcs.c:86]: tm_shutdown(): DEBUG: tm_shutdown : start
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: tm
> [t_funcs.c:89]: tm_shutdown(): DEBUG: tm_shutdown : emptying hash table
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: tm
> [t_funcs.c:91]: tm_shutdown(): DEBUG: tm_shutdown : removing semaphores
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: tm
> [t_funcs.c:93]: tm_shutdown(): DEBUG: tm_shutdown : destroying tmcb lists
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: tm
> [t_funcs.c:96]: tm_shutdown(): DEBUG: tm_shutdown : done
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: INFO: <core>
> [sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: <core>
> [mem/shm.c:174]: shm_core_lock_destroy(): destroying the shared memory lock
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: <core>
> [mem/shm.c:266]: shm_destroy_manager(): destroying memory manager: f_malloc
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: <core>
> [mem/pkg.c:89]: pkg_destroy_manager(): destroying memory manager: f_malloc
> Nov 8 13:32:21 xxxxx systemd[1]: kamailio.service: control process exited,
> code=exited status=255
> Nov 8 13:32:21 xxxxx systemd[1]: Failed to start Kamailio (OpenSER) - the
> Open Source SIP Server.
> Nov 8 13:32:21 xxxxx systemd[1]: Unit kamailio.service entered failed state.
>
> grepped on mongo in debug:
> Nov 8 13:32:21 xxxxx kamailio: DEBUG: <core> [cfg.y:1595]: yyparse():
> loading module db_mongodb.so
> Nov 8 13:32:21 xxxxx kamailio: DEBUG: <core> [sr_module.c:575]:
> load_module(): trying to load
> </opt/kamailio/lib64/kamailio/modules/db_mongodb.so>
> Nov 8 13:32:21 xxxxx kamailio: DEBUG: <core> [cfg.lex:1703]: pp_define():
> defining id: MOD_db_mongodb
> Nov 8 13:32:21 xxxxx kamailio: DEBUG: <core> [cfg.lex:1812]:
> pp_define_get(): ### returning define ID [DBURL] value
> ["mongodb://kam:kam@localhost/kamailio"]
> Nov 8 13:32:21 xxxxx kamailio: DEBUG: <core> [cfg.lex:1812]:
> pp_define_get(): ### returning define ID [DBURL] value
> ["mongodb://kam:kam@localhost/kamailio"]
> Nov 8 13:32:21 xxxxx kamailio: DEBUG: <core> [cfg.lex:1812]:
> pp_define_get(): ### returning define ID [DBURL] value
> ["mongodb://kam:kam@localhost/kamailio"]
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: <core>
> [sr_module.c:694]: find_mod_export_record(): find_export_record: found
> <db_bind_api> in module db_mongodb
> [/opt/kamailio/lib64/kamailio/modules/db_mongodb.so]
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: <core>
> [db.c:209]: db_bind_mod(): using db bind api for db_mongodb
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: <core>
> [sr_module.c:965]: init_mod(): db_mongodb
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: db_mongodb
> [db_mongodb_mod.c:98]: mod_init(): module initializing
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: <core>
> [sr_module.c:694]: find_mod_export_record(): find_export_record: found
> <db_bind_api> in module db_mongodb
> [/opt/kamailio/lib64/kamailio/modules/db_mongodb.so]
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: <core>
> [db.c:209]: db_bind_mod(): using db bind api for db_mongodb
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: <core>
> [sr_module.c:694]: find_mod_export_record(): find_export_record: found
> <db_bind_api> in module db_mongodb
> [/opt/kamailio/lib64/kamailio/modules/db_mongodb.so]
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: <core>
> [db.c:209]: db_bind_mod(): using db bind api for db_mongodb
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: db_mongodb
> [mongodb_connection.c:55]: db_mongodb_new_connection(): connection open to:
> mongodb://kam:kam@localhost/kamailio
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: db_mongodb
> [mongodb_dbase.c:851]: db_mongodb_query(): query to collection [version]
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: db_mongodb
> [mongodb_dbase.c:885]: db_mongodb_query(): query filter: { "table_name" :
> "location" }
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: db_mongodb
> [mongodb_dbase.c:904]: db_mongodb_query(): columns filter: { "table_version"
> : 1 }
> Nov 8 13:32:21 xxxxx /opt/kamailio/sbin/kamailio[2291]: DEBUG: db_mongodb
> [mongodb_dbase.c:733]: db_mongodb_store_result(): no result from mongodb
>
>
> > Sent: Wednesday, November 08, 2017 at 9:21 AM
> > From: "Daniel-Constantin Mierla" <mico...@gmail.com>
> > To: tr...@lindows.org, "'Kamailio (SER) - Users Mailing List'"
> > <sr-users@lists.kamailio.org>, "'hdssdsdsdsfsdf hdssdsdsdsfsdf'"
> > <hdssdsdsdsf...@mail.com>
> > Subject: Re: [SR-Users] authenticating to mongodb fails
> >
> > This last response was either misdirected (reply to wrong email) or
> > lacks more details, because it feels somehow out of context...
> >
> > Cheers,
> > Daniel
> >
> >
> > On 07.11.17 22:10, Trent wrote:
> > > I went ahead and performed the firmware upgrade since it only takes less
> > > than 5 minutes to do.
> > >
> > > Do report your experience on this.
> > >
> > >
> > >
> > > Trent Creekmore
> > > Manager of Support
> > > IP PBX Support
> > > “Where the Support Comes before the Sale”
> > > (408) 414-7515 Extension 404
> > >
> > >
> > > -----Original Message-----
> > > From: sr-users [mailto:sr-users-boun...@lists.kamailio.org] On Behalf Of
> > > Daniel-Constantin Mierla
> > > Sent: Tuesday, November 7, 2017 10:46 AM
> > > To: hdssdsdsdsfsdf hdssdsdsdsfsdf <hdssdsdsdsf...@mail.com>
> > > Cc: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>
> > > Subject: Re: [SR-Users] authenticating to mongodb fails
> > >
> > > I do not see any log message with DEBUG (only INFO and WARNING), are you
> > > sure you set debug=3 properly?
> > >
> > > Cheers,
> > > Daniel
> > >
> > >
> > > On 07.11.17 16:43, hdssdsdsdsfsdf hdssdsdsdsfsdf wrote:
> > >> Thanks for looking into this. I set debug=3 which gives the following
> > >> debug messages. I included the mongod messages, which show a connection
> > >> and end, but no succesful or failed authentication.
> > >>
> > >> nov 7 15:45:21 kamailio: INFO: <core> [sctp_core.c:75]:
> > >> sctp_core_check_support(): SCTP API not enabled - if you want to use
> > >> it, load sctp module Nov 7 15:45:22 kamailio: WARNING: <core>
> > >> [socket_info.c:1303]: fix_hostname(): could not rev. resolve
> > >> <stripped> Nov 7 15:45:22 /opt/kamailio/sbin/kamailio[8905]: INFO: rr
> > >> [../outbound/api.h:54]: ob_load_api(): unable to import bind_ob -
> > >> maybe module is not loaded Nov 7 15:45:22
> > >> /opt/kamailio/sbin/kamailio[8905]: INFO: rr [rr_mod.c:174]:
> > >> mod_init(): outbound module not available Nov 7 15:45:22
> > >> /opt/kamailio/sbin/kamailio[8905]: INFO: usrloc [hslot.c:51]:
> > >> ul_init_locks(): locks array size 1024 Nov 7 15:45:22
> > >> /opt/kamailio/sbin/kamailio[8905]: INFO: auth [auth_mod.c:333]:
> > >> mod_init(): auth: qop set, but nonce-count (nc_enabled) support
> > >> disabled Nov 7 15:45:22 mongod.27017[8038]: [thread1] connection
> > >> accepted from 127.0.0.1:40737 #20 (2 connections now open) Nov 7
> > >> 15:45:22 /opt/kamailio/sbin/kamailio[8905]: INFO: <core>
> > >> [sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized Nov 7
> > >> 15:45:22 mongod.27017[8038]: [conn20] end connection 127.0.0.1:40737
> > >> (2 connections now open)
> > >>
> > >>
> > >>
> > >>> Sent: Tuesday, November 07, 2017 at 3:38 PM
> > >>> From: "Daniel-Constantin Mierla" <mico...@gmail.com>
> > >>> To: "Kamailio (SER) - Users Mailing List"
> > >>> <sr-users@lists.kamailio.org>, "hdssdsdsdsfsdf hdssdsdsdsfsdf"
> > >>> <hdssdsdsdsf...@mail.com>
> > >>> Subject: Re: [SR-Users] authenticating to mongodb fails
> > >>>
> > >>> Can you set debug=3 in kamailio.cfg and then look at debug messages
> > >>> to see there is some hint about what happens?
> > >>>
> > >>> Cheers,
> > >>> Daniel
> > >>>
> > >>>
> > >>> On 07.11.17 15:11, hdssdsdsdsfsdf hdssdsdsdsfsdf wrote:
> > >>>> When I connect using mongo, the credentials work:
> > >>>>
> > >>>> $ mongo kamailio -u "kam" -p "kam"
> > >>>> MongoDB shell version v3.4.9
> > >>>> connecting to: mongodb://127.0.0.1:27017/kamailio
> > >>>> MongoDB server version: 3.4.9
> > >>>>> db.subscriber.find()
> > >>>> { "_id" : ObjectI ...
> > >>>>
> > >>>> But when I use the following DBURL in kamailio.cfg, kamailio fails to
> > >>>> even login to mongo:
> > >>>>
> > >>>> #!define DBURL "mongodb://kam:kam@localhost/kamailio"
> > >>>>
> > >>>> If I disable mongodb authentication, kamailio starts up just fine
> > >>>> again. Any idea what's going wrong here?
> > >>>>
> > >>>> _______________________________________________
> > >>>> Kamailio (SER) - Users Mailing List
> > >>>> sr-users@lists.kamailio.org
> > >>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
> > >>> --
> > >>> Daniel-Constantin Mierla
> > >>> www.twitter.com/miconda -- www.linkedin.com/in/miconda Kamailio
> > >>> Advanced Training, Nov 13-15, 2017, in Berlin - www.asipto.com
> > >>> Kamailio World Conference - www.kamailioworld.com
> > >>>
> > >>>
> > > --
> > > Daniel-Constantin Mierla
> > > www.twitter.com/miconda -- www.linkedin.com/in/miconda Kamailio Advanced
> > > Training, Nov 13-15, 2017, in Berlin - www.asipto.com Kamailio World
> > > Conference - www.kamailioworld.com
> > >
> > >
> > > _______________________________________________
> > > Kamailio (SER) - Users Mailing List
> > > sr-users@lists.kamailio.org
> > > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
> > >
> >
> > --
> > Daniel-Constantin Mierla
> > www.twitter.com/miconda -- www.linkedin.com/in/miconda
> > Kamailio Advanced Training, Nov 13-15, 2017, in Berlin - www.asipto.com
> > Kamailio World Conference - www.kamailioworld.com
> >
> >
>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users@lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
