[OpenSIPS-Users] Opensips 1.6.1 dos not start on Ubuntu 9.1 64bits

[Bogdan-Andrei Iancu]

Hi Antonio,

It should not work on any OS....maybe your mysql setups are different on 
the OSs you tested. NOTE that db_url has a default value which may work 
if the DB was created with default access users.

Regards,
Bogdan

Antonio Anderson M. de Souza wrote:
> Bogdan,
>
> Thank you very much, the problem was because I forgot to add the 
> module dialplan in the modparam db_url:
>
> Before:
> modparam("domain|alias_db|auth_db|usrloc|drouting","db_url", 
> "mysql://user:user@localhost/db")
>
> After:
> modparam("domain|alias_db|auth_db|usrloc|drouting*|dialplan*","db_url", 
> "mysql://user:user@localhost/db")
>
> The biggest problem that take longer time to discover the problem was 
> because in the CentOS the same configuration script works properly, do 
> you have some explanation to this behavior in other OS?
>
> An improvement in the Script Compiler ("opensips -c") could be to 
> check if the db_url is properly set, what do you think?
>
> Best regards,
>
> Antonio Anderson M. Souza
> Voice Technology
> http://www.antonioams.com
>
>
> On Mon, Jan 4, 2010 at 9:22 AM, Bogdan-Andrei Iancu 
> <bogdan at voice-system.ro <mailto:bogdan at voice-system.ro>> wrote:
>
>     Hi Antonio,
>
>     The relevant part is:
>
>     14752 socket(PF_FILE, SOCK_STREAM, 0)   = 5
>     14752 fcntl(5, F_SETFL, O_RDONLY)       = 0
>     14752 fcntl(5, F_GETFL)                 = 0x2 (flags O_RDWR)
>     14752 connect(5, {sa_family=AF_FILE,
>     path="/var/run/mysqld/mysqld.sock"}, 110) = 0
>     14752 setsockopt(5, SOL_SOCKET, SO_RCVTIMEO,
>     "\2003\341\1\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
>     14752 setsockopt(5, SOL_SOCKET, SO_SNDTIMEO,
>     "\2003\341\1\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
>     14752 setsockopt(5, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation
>     not supported)
>     14752 setsockopt(5, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
>     14752 read(5, "=\0\0\0\n5.1.37-1ubuntu5\0\223\1\0\00076JP4Q|"...,
>     16384)
>     = 65
>     14752 write(5,
>     "I\0\0\1\215\242\3\200\0\0\0@\10\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"...,
>     77) = 77
>     14752 read(5, "O\0\0\2\377\24\4#42000Access denied for u"...,
>     16384) = 83
>
>     Seams mysql refuses the a connection from opensips.  Are you sure you
>     properly configured the db_url for all the module that requires DB
>     connection ?
>
>     Regards,
>     Bogdan
>
>     Antonio Anderson M. de Souza wrote:
>     > Bogdan,
>     >
>     > I started the Opensips with debug=6 and there weren't changes on the
>     > initialization log, I've used the strace [1], I'm not an expert
>     in the
>     > strace, but the only thing that i could see was a message "14752
>     > read(5, "O\0\0\2\377\24\4#42000Access denied for u"..., 16384) = 83"
>     > after that the shutdown process started.
>     >
>     > I already double checked the user and password of the mysql, and
>     it's
>     > right in the script, and in the opensipsctlrc, the opensipsctl is
>     > working properly.
>     >
>     > Could somebody take a look in the stracelog to help me?
>     >
>


-- 
Bogdan-Andrei Iancu
www.voice-system.ro