[Kamailio-Users] Problem starting Kamailio

Sara EL KABIRI sara.elkabiri at gmail.com
Mon Mar 16 12:05:59 CET 2009


Thanks.
I have already logged on to the mysql server and granted all the privileges
to the user that was being rejected at kamailio's database authentication...
And i still get the same error.

What i don't understand is that in Kamailio's config file, whether i set the
db_url parameter to the "root" user or to the "openser" one:

*modparam("uri_db", "db_url", "mysql://root:<password>@localhost/openser")*
or
*modparam("uri_db", "db_url", "mysql://openser:<password>
@localhost/openser")*

i get indifferently "*Access denied for user 'openser'@'localhost' (using
password: YES)*".

I think there is a configuration problem somewhere in kamailio's files,
somewhere else than in the kamailio.cfg file... I tried to grep "openser"
but got nothing relevant.

Ideas?
Thanks in advance.

Regards,
Sara




On Mon, Mar 16, 2009 at 11:20 AM, Daniel-Constantin Mierla <
miconda at gmail.com> wrote:

>
>
> On 03/11/2009 04:32 PM, Sara EL KABIRI wrote:
>
>> Hello,
>>
>> In fact, the issue is still there.
>> I explain:
>>
>> I had added this line to the config file to set xml-rpc's listening port:
>> */modparam("mi-xmlrpc", "port", 8000)/*
>> And that was when kamailio couldn't start. I removed the said line, and
>> tried to restart kamailio. I got this in return:
>> */~$ sudo /etc/init.d/kamailio start
>>
>> Listening on
>>             udp: 127.0.0.1 [127.0.0.1]:5065
>>             udp: 192.168.0.99 [192.168.0.99]:5065
>>             tcp: 127.0.0.1 [127.0.0.1]:5065
>>             tcp: 192.168.0.99 [192.168.0.99]:5065
>> Aliases:
>>             tcp: ims-desktop.local:5065
>>             tcp: localhost:5065
>>             udp: ims-desktop.local:5065
>>             udp: localhost:5065/*
>>
>> I thought everything was ok, but it wasn't. I tried */netstat -anp/* to
>> see if the server was really listenning upon port 5065, it wasn't. Then i
>> tried */kamctl moni/* and there was appearently a problem:
>> */
>> ~$ sudo kamctl moni
>>
>> ERROR: Error opening Kamailio's FIFO /tmp/kamailio_fifo
>> ERROR: Make sure you have the line 'modparam("mi_fifo", "fifo_name",
>> "/tmp/kamailio_fifo")' in your config
>> ERROR: and also have loaded the mi_fifo module./*
>>
>> I allowed syslog_error in the config file, and tried to restart kamailio.
>> And here's what i got:
>>
>> */~$ sudo /etc/init.d/kamailio start
>>
>> Listening on
>>             udp: 127.0.0.1 [127.0.0.1]:5065
>>             udp: 192.168.0.99 [192.168.0.99]:5065
>>             tcp: 127.0.0.1 [127.0.0.1]:5065
>>             tcp: 192.168.0.99 [192.168.0.99]:5065
>> Aliases:
>>             tcp: ims-desktop.local:5065
>>             tcp: localhost:5065
>>             udp: ims-desktop.local:5065
>>             udp: localhost:5065
>>
>> Mar 11 11:02:20 [11473] INFO:core:init_tcp: using epoll_lt as the TCP io
>> watch method (auto detected)
>> Mar 11 11:02:20 [11475] NOTICE:core:main: version: kamailio 1.4.3-notls
>> (i386/linux)
>> Mar 11 11:02:20 [11475] INFO:core:main: using 32 Mb shared memory
>> Mar 11 11:02:20 [11475] INFO:core:main: using 1 Mb private memory per
>> process
>> Mar 11 11:02:20 [11475] INFO:sl:mod_init: Initializing StateLess engine
>> Mar 11 11:02:20 [11475] INFO:tm:mod_init: TM - initializing...
>> $ Mar 11 11:02:20 [11475] INFO:maxfwd:mod_init: initializing...
>> Mar 11 11:02:20 [11475] INFO:usrloc:ul_init_locks: locks array size 512
>> Mar 11 11:02:20 [11475] INFO:registrar:mod_init: initializing...
>> Mar 11 11:02:20 [11475] INFO:textops:mod_init: initializing...
>> Mar 11 11:02:20 [11475] INFO:xlog:mod_init: initializing...
>> Mar 11 11:02:21 [11475] INFO:acc:mod_init: initializing...
>> Mar 11 11:02:21 [11475] INFO:auth:mod_init: initializing...
>> Mar 11 11:02:21 [11475] INFO:auth_db:mod_init: initializing...
>> Mar 11 11:02:21 [11475] NOTICE:presence:mod_init: initializing module ...
>> Mar 11 11:02:21 [11475] INFO:presence:restore_db_subs: The query returned
>> no result
>> Mar 11 11:02:21 [11475] ERROR:db_mysql:db_mysql_new_connection: driver
>> error: Access denied for user 'openser'@'localhost' (using password: YES)
>> Mar 11 11:02:21 [11475] ERROR:core:db_do_init: could not add connection to
>> the poolMar 11 11:02:21 [11475] ERROR:usrloc:register_udomain: failed to
>> open database connection
>> Mar 11 11:02:21 [11475] ERROR:registrar:domain_fixup: failed to register
>> domain
>> Mar 11 11:02:21 [11475] ERROR:core:fix_actions: fixing failed (code=-1) at
>> cfg line 324
>> Mar 11 11:02:21 [11475] CRITICAL:core:fix_expr: fix_actions error
>> Mar 11 11:02:21 [11475] ERROR:core:main: failed to fix configuration with
>> err code -1
>> Mar 11 11:02:21 [11475] NOTICE:presence:destroy: destroy module .../*
>>
>>
>> I tried to log on MySQL database as root user, and i got exactly the same
>> error.
>> I can't understand why it says */"Access denied for user 'openser'@'localhost'
>> (using password: YES)" /*even when i log on as root,
>>
>
> You have to rea the mysdl manual and learn how to grant privileges to users
> and why this error appears. If someone else installed mysql for you, ask him
> for the root password and how to legin to the mysql server.
>
>  and i don't undestand the meaning of the last line */"Mar 11 11:02:21
>> [11475] NOTICE:presence:destroy: destroy module .../* " (may i recall that i
>> want to use Kamailio as a presence server).
>>
>
> This is a notice message that the module is destroying internal structure,
> it is nothing to worry about.
>
> Cheers,
> Daniel
>
>
>
>>
>> Thanks in advance for your help.
>> Cheers,
>> Sara
>>
>>
>>
>> On Wed, Mar 11, 2009 at 11:22 AM, Daniel-Constantin Mierla <
>> miconda at gmail.com <mailto:miconda at gmail.com>> wrote:
>>
>>    Please cc all the time to mailing lists.
>>
>>    If you reported an issue and solved it, then it is nice to close
>>    the discussion thread by saying what was wrong and how was solved.
>>    Others coming later and reading mailing list archive can learn
>>    from your experience.
>>
>>    Thanks,
>>    Daniel
>>
>>
>>
>>    On 03/11/2009 10:47 AM, Sara EL KABIRI wrote:
>>
>>        Hello,
>>
>>        Thanks a lot for you help.
>>        I've already solved the problem :-)
>>
>>        Regards,
>>        Sara
>>
>>        On Wed, Mar 11, 2009 at 8:09 AM, Daniel-Constantin Mierla
>>        <miconda at gmail.com <mailto:miconda at gmail.com>
>>        <mailto:miconda at gmail.com <mailto:miconda at gmail.com>>> wrote:
>>
>>           Hello,
>>
>>
>>           On 03/09/2009 08:48 PM, Sara EL KABIRI wrote:
>>
>>
>>               Hello,
>>
>>               I've installed kamailio 1.4.3 (without tls) on ubuntu by
>>               following the provided INSTALL guide. I want to use it as a
>>               presence server but i've got some problems starting it.
>>
>>               "kamctl start" returns nothing.
>>
>>           check the syslog file for errors. There you can get some hint.
>>
>>           Alternatively, set log_stderror=yes in your config file and run
>>           "kamailio" (/usr/sbin/kamailio or /usr/local/sbin/kamailio if
>>           installed from sources) and see what you get on the screen.
>>
>>           Cheers,
>>           Daniel
>>
>>               and "kamctl moni" returns "Error opening kamailio's FIFO
>>               /tmp/kamailio_fifo"
>>               I've checked in my .cfg file and the 'loadmodule' and
>>               'modparam' lines related to mi-fifo module are uncommented.
>>               I've checked also the mi-fifo module was installed indeed
>>               (mi_fifo.so appears in /usr/local/lib/kamailio/modules
>>        directory).
>>
>>
>>               Could anyone help please?
>>
>>               --
>>               Sara
>>
>> ------------------------------------------------------------------------
>>
>>               _______________________________________________
>>               Kamailio (OpenSER) - Users mailing list
>>               Users at lists.kamailio.org
>>        <mailto:Users at lists.kamailio.org>
>>        <mailto:Users at lists.kamailio.org
>>        <mailto:Users at lists.kamailio.org>>
>>
>>               http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>>
>> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
>>
>>
>>           --    Daniel-Constantin Mierla
>>           http://www.asipto.com
>>
>>
>>
>>
>>        --        S.
>>
>>
>>    --    Daniel-Constantin Mierla
>>    http://www.asipto.com
>>
>>
>>
>>
>> --
>> S.
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Kamailio (OpenSER) - Users mailing list
>> Users at lists.kamailio.org
>> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
>> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
>>
>
> --
> Daniel-Constantin Mierla
> http://www.asipto.com
>
>


-- 
S.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20090316/3ba40a65/attachment.htm 


More information about the Users mailing list