Re: [OpenSIPS-Users] mysql database connection error

2009-06-30 Thread Bogdan-Andrei Iancu
un...@lists.opensips.org [users-boun...@lists.opensips.org] On > Behalf Of Brett Nemeroff [br...@nemeroff.com] > Sent: 30 June 2009 18:50 > To: Uwe Kastens > Cc: users@lists.opensips.org > Subject: Re: [OpenSIPS-Users] mysql database connection error > > I think the whole idea of a "

Re: [OpenSIPS-Users] mysql database connection error

2009-06-30 Thread Gordon Ross
users-boun...@lists.opensips.org [users-boun...@lists.opensips.org] On Behalf Of Brett Nemeroff [br...@nemeroff.com] Sent: 30 June 2009 18:50 To: Uwe Kastens Cc: users@lists.opensips.org Subject: Re: [OpenSIPS-Users] mysql database connection error I think the whole idea of a "default db_url" is a mistake..

Re: [OpenSIPS-Users] mysql database connection error

2009-06-30 Thread Uwe Kastens
Hi Brett, good to know BR Uwe Brett Nemeroff schrieb: > Hey.. Ok I found the error and I feel like a complete idiot. I had > modules loaded without a db_url specified for it (one module's db_url > was missing). > > I think the whole idea of a "default db_url" is a mistake... that's my > perso

Re: [OpenSIPS-Users] mysql database connection error

2009-06-30 Thread Brett Nemeroff
Hey.. Ok I found the error and I feel like a complete idiot. I had modules loaded without a db_url specified for it (one module's db_url was missing). I think the whole idea of a "default db_url" is a mistake... that's my personal opinion. Thanks for helping me find this.. -Brett On Tue, Jun 30,

Re: [OpenSIPS-Users] mysql database connection error

2009-06-30 Thread Uwe Kastens
Hi Brett, Could be broken libs. I would start opensips with strace and look for errors. Which OS are you using? BR Uwe Brett Nemeroff schrieb: > Still can't connect :( What could I be doing wrong? I wonder if it's the > mysql client libs somehow?! > > Access-rights > for USER 'opensips', from

Re: [OpenSIPS-Users] mysql database connection error

2009-06-30 Thread Brett Nemeroff
Still can't connect :( What could I be doing wrong? I wonder if it's the mysql client libs somehow?! Access-rights for USER 'opensips', from HOST 'localhost', to DB 'opensips' +-+---+ +-+---+ | Select_priv | Y | | Lock_tables_priv | Y | |

Re: [OpenSIPS-Users] mysql database connection error

2009-06-30 Thread Uwe Kastens
Hmm, And you did change the host in the opensips url from localhost to 127.0.0.1? For a test change the 127.0.0.1 in the mysql to % and try again. And mabye change the password with update user set password=password("yourpassword") where user="opensips"; Your password entry looks like from a el

Re: [OpenSIPS-Users] mysql database connection error

2009-06-30 Thread Brett Nemeroff
Here is what I got:password too long? really? it's not that long.. mysqlaccess Version 2.06, 20 Dec 2000 By RUG-AIV, by Yves Carlier (yves.carl...@rug.ac.be) Changes by Steve Harvey (s...@vex.net) This software comes with ABSOLUTELY NO WARRANTY. Password for MySQL superuser root: Access-rights

Re: [OpenSIPS-Users] mysql database connection error

2009-06-30 Thread Uwe Kastens
Hi, Hmmm. - password to long Have you mysqlaccess on the system? This is how the output looks on my testsystem mysqlaccess localhost opensips opensips -U root -P mysqlaccess Version 2.06, 20 Dec 2000 By RUG-AIV, by Yves Carlier (yves.carl...@rug.ac.be) Changes by Steve Harvey (s...@vex.net)

Re: [OpenSIPS-Users] mysql database connection error

2009-06-30 Thread Brett Nemeroff
Yeah, it's in there. I'm really puzzled. This should be the easy part. ;) Any other ideas? On Tue, Jun 30, 2009 at 10:25 AM, Uwe Kastens wrote: > Hi, > > looks good for me. Did you reload mysql after grant or flush priv? > > Should be, otherwise you wont be able to connect via mysql client. >

Re: [OpenSIPS-Users] mysql database connection error

2009-06-30 Thread Uwe Kastens
Brett, Could you post your URL from your config please? 127.0.0.1 is not the same as localhost! BR Uwe > Hey all, > sorry for such a noob question here, but I just can't figure out what > I'm doing wrong.. I'm getting the error: > Jun 30 15:36:33 nguenj297 /usr/local/sbin/opensips[10159]: > ERR

[OpenSIPS-Users] mysql database connection error

2009-06-30 Thread Brett Nemeroff
Hey all,sorry for such a noob question here, but I just can't figure out what I'm doing wrong.. I'm getting the error: Jun 30 15:36:33 nguenj297 /usr/local/sbin/opensips[10159]: ERROR:db_mysql:db_mysql_new_connection: driver error(1045): Access denied for user 'opensips'@'localhost' (using password