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

[Antonio Anderson M. de Souza]

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>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?
> >
> > [1] -
> >
> http://dl.dropbox.com/u/2134454/strace-opensips-crashs-ubuntu9.10-64.log.tar.gz
> >
> > Antonio Anderson M. Souza
> > Voice Technology
> > http://www.antonioams.com
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
>
>
> --
> Bogdan-Andrei Iancu
> www.voice-system.ro
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20100104/4ea61f1e/attachment.htm