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).<div><br></div><div>I think the whole idea of a "default db_url" is a mistake... that's my personal opinion. Thanks for helping me find this..</div>
<div>-Brett</div><div><br><br><div class="gmail_quote">On Tue, Jun 30, 2009 at 12:48 PM, Uwe Kastens <span dir="ltr"><<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi Brett,<br>
<br>
Could be broken libs. I would start opensips with strace and look for<br>
errors.<br>
<br>
Which OS are you using?<br>
<div class="im"><br>
BR<br>
<br>
Uwe<br>
<br>
Brett Nemeroff schrieb:<br>
</div><div><div></div><div class="h5">> Still can't connect :( What could I be doing wrong? I wonder if it's the<br>
> mysql client libs somehow?!<br>
><br>
> Access-rights<br>
> for USER 'opensips', from HOST 'localhost', to DB 'opensips'<br>
> +-----------------+---+ +-----------------+---+<br>
> | Select_priv | Y | | Lock_tables_priv | Y |<br>
> | Insert_priv | Y | | Execute_priv | Y |<br>
> | Update_priv | Y | | Repl_slave_priv | N |<br>
> | Delete_priv | Y | | Repl_client_priv | N |<br>
> | Create_priv | Y | | Create_view_priv | Y |<br>
> | Drop_priv | Y | | Show_view_priv | Y |<br>
> | Reload_priv | N | | Create_routine_priv | Y |<br>
> | Shutdown_priv | N | | Alter_routine_priv | Y |<br>
> | Process_priv | N | | Create_user_priv | N |<br>
> | File_priv | N | | Ssl_type | ? |<br>
> | Grant_priv | N | | Ssl_cipher | ? |<br>
> | References_priv | Y | | X509_issuer | ? |<br>
> | Index_priv | Y | | X509_subject | ? |<br>
> | Alter_priv | Y | | Max_questions | 0 |<br>
> | Show_db_priv | N | | Max_updates | 0 |<br>
> | Super_priv | N | | Max_connections | 0 |<br>
> | Create_tmp_table_priv | Y | | Max_user_connections | 0 |<br>
> +-----------------+---+ +-----------------+---+<br>
> NOTE: A password is required for user `opensips' :-(<br>
><br>
> The following rules are used:<br>
> db :<br>
> '127.0.0.1','opensips','opensips','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'<br>
> host : 'Not processed: host-field is not empty in db-table.'<br>
> user :<br>
> '%','opensips','*4DDB979A2666D0CF0A83FCCED820A64E8EBB6AFD','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','','0','0','0','0'<br>
><br>
><br>
><br>
> On Tue, Jun 30, 2009 at 11:01 AM, Uwe Kastens <<a href="mailto:kiste@kiste.org">kiste@kiste.org</a><br>
</div></div><div class="im">> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>>> wrote:<br>
><br>
</div><div class="im">> Hmm,<br>
><br>
> And you did change the host in the opensips url from localhost to<br>
> 127.0.0.1?<br>
><br>
> For a test change the 127.0.0.1 in the mysql to % and try again. And<br>
> mabye change the password with update user set<br>
> password=password("yourpassword") where user="opensips";<br>
><br>
><br>
> Your password entry looks like from a elder version.<br>
><br>
> BR<br>
><br>
> Uwe<br>
><br>
><br>
> Brett Nemeroff schrieb:<br>
> > Here is what I got:<br>
> > password too long? really? it's not that long.. <shrug><br>
> ><br>
> ><br>
> > mysqlaccess Version 2.06, 20 Dec 2000<br>
> > By RUG-AIV, by Yves Carlier (<a href="mailto:Yves.Carlier@rug.ac.be">Yves.Carlier@rug.ac.be</a><br>
> <mailto:<a href="mailto:Yves.Carlier@rug.ac.be">Yves.Carlier@rug.ac.be</a>><br>
</div>> > <mailto:<a href="mailto:Yves.Carlier@rug.ac.be">Yves.Carlier@rug.ac.be</a> <mailto:<a href="mailto:Yves.Carlier@rug.ac.be">Yves.Carlier@rug.ac.be</a>>>)<br>
<div class="im">> > Changes by Steve Harvey (<a href="mailto:sgh@vex.net">sgh@vex.net</a> <mailto:<a href="mailto:sgh@vex.net">sgh@vex.net</a>><br>
</div>> <mailto:<a href="mailto:sgh@vex.net">sgh@vex.net</a> <mailto:<a href="mailto:sgh@vex.net">sgh@vex.net</a>>>)<br>
<div><div></div><div class="h5">> > This software comes with ABSOLUTELY NO WARRANTY.<br>
> > Password for MySQL superuser root:<br>
> ><br>
> > Access-rights<br>
> > for USER 'opensips', from HOST 'localhost', to DB 'opensips'<br>
> > +-----------------+---+ +-----------------+---+<br>
> > | Select_priv | Y | | Lock_tables_priv | Y |<br>
> > | Insert_priv | Y | | Execute_priv | Y |<br>
> > | Update_priv | Y | | Repl_slave_priv | N |<br>
> > | Delete_priv | Y | | Repl_client_priv | N |<br>
> > | Create_priv | Y | | Create_view_priv | Y |<br>
> > | Drop_priv | Y | | Show_view_priv | Y |<br>
> > | Reload_priv | N | | Create_routine_priv | Y |<br>
> > | Shutdown_priv | N | | Alter_routine_priv | Y |<br>
> > | Process_priv | N | | Create_user_priv | N |<br>
> > | File_priv | N | | Ssl_type | ? |<br>
> > | Grant_priv | N | | Ssl_cipher | ? |<br>
> > | References_priv | Y | | X509_issuer | ? |<br>
> > | Index_priv | Y | | X509_subject | ? |<br>
> > | Alter_priv | Y | | Max_questions | 0 |<br>
> > | Show_db_priv | N | | Max_updates | 0 |<br>
> > | Super_priv | N | | Max_connections | 0 |<br>
> > | Create_tmp_table_priv | Y | | Max_user_connections | 0 |<br>
> > +-----------------+---+ +-----------------+---+<br>
> > NOTE: A password is required for user `opensips' :-(<br>
> ><br>
> > The following rules are used:<br>
> > db :<br>
> ><br>
> '127.0.0.1','opensips','opensips','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'<br>
> > host : 'Not processed: host-field is not empty in db-table.'<br>
> > user :<br>
> ><br>
> '127.0.0.1','opensips','641b9f69397f5d64','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','','0','0','0','0'<br>
> ><br>
> ><br>
> > On Tue, Jun 30, 2009 at 10:41 AM, Uwe Kastens <<a href="mailto:kiste@kiste.org">kiste@kiste.org</a><br>
> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>><br>
</div></div><div class="im">> > <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>>>> wrote:<br>
> ><br>
> > Hi,<br>
> ><br>
</div><div class="im">> > Hmmm.<br>
> > - password to long<br>
> ><br>
> > Have you mysqlaccess on the system?<br>
> > This is how the output looks on my testsystem<br>
> ><br>
> ><br>
> ><br>
> > mysqlaccess localhost opensips opensips -U root -P<br>
> > mysqlaccess Version 2.06, 20 Dec 2000<br>
> > By RUG-AIV, by Yves Carlier (<a href="mailto:Yves.Carlier@rug.ac.be">Yves.Carlier@rug.ac.be</a><br>
> <mailto:<a href="mailto:Yves.Carlier@rug.ac.be">Yves.Carlier@rug.ac.be</a>><br>
</div>> > <mailto:<a href="mailto:Yves.Carlier@rug.ac.be">Yves.Carlier@rug.ac.be</a> <mailto:<a href="mailto:Yves.Carlier@rug.ac.be">Yves.Carlier@rug.ac.be</a>>>)<br>
<div class="im">> > Changes by Steve Harvey (<a href="mailto:sgh@vex.net">sgh@vex.net</a> <mailto:<a href="mailto:sgh@vex.net">sgh@vex.net</a>><br>
</div>> <mailto:<a href="mailto:sgh@vex.net">sgh@vex.net</a> <mailto:<a href="mailto:sgh@vex.net">sgh@vex.net</a>>>)<br>
<div><div></div><div class="h5">> > This software comes with ABSOLUTELY NO WARRANTY.<br>
> > Password for MySQL superuser root:<br>
> ><br>
> > Access-rights<br>
> > for USER 'opensips', from HOST 'localhost', to DB 'opensips'<br>
> > +-----------------+---+ +-----------------+---+<br>
> > | Select_priv | Y | | Lock_tables_priv | Y |<br>
> > | Insert_priv | Y | | Execute_priv | Y |<br>
> > | Update_priv | Y | | Repl_slave_priv | N |<br>
> > | Delete_priv | Y | | Repl_client_priv | N |<br>
> > | Create_priv | Y | | Create_view_priv | Y |<br>
> > | Drop_priv | Y | | Show_view_priv | Y |<br>
> > | Reload_priv | N | | Create_routine_priv | Y |<br>
> > | Shutdown_priv | N | | Alter_routine_priv | Y |<br>
> > | Process_priv | N | | Create_user_priv | N |<br>
> > | File_priv | N | | Ssl_type | ? |<br>
> > | Grant_priv | N | | Ssl_cipher | ? |<br>
> > | References_priv | Y | | X509_issuer | ? |<br>
> > | Index_priv | Y | | X509_subject | ? |<br>
> > | Alter_priv | Y | | Max_questions | 0 |<br>
> > | Show_db_priv | N | | Max_updates | 0 |<br>
> > | Super_priv | N | | Max_connections | 0 |<br>
> > | Create_tmp_table_priv | Y | | Max_user_connections<br>
> | 0 |<br>
> > +-----------------+---+ +-----------------+---+<br>
> > NOTE: A password is required for user `opensips' :-(<br>
> ><br>
> > The following rules are used:<br>
> > db :<br>
> ><br>
> '%','opensips','opensips','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'<br>
> > host : 'Not processed: host-field is not empty in db-table.'<br>
> > user :<br>
> ><br>
> '%','opensips','*30C28A928E2BE5EFD59FF20CB8705B31ACCF3730','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','','0','0','0','0'<br>
> ><br>
> > BUGs can be reported by email to <a href="mailto:bugs@mysql.com">bugs@mysql.com</a><br>
</div></div>> <mailto:<a href="mailto:bugs@mysql.com">bugs@mysql.com</a>> <mailto:<a href="mailto:bugs@mysql.com">bugs@mysql.com</a> <mailto:<a href="mailto:bugs@mysql.com">bugs@mysql.com</a>>><br>
<div class="im">> ><br>
> ><br>
> > BR<br>
> ><br>
> > Uwe<br>
> ><br>
> ><br>
> > Brett Nemeroff schrieb:<br>
> > > Yeah, it's in there. I'm really puzzled. This should be the easy<br>
> > part. ;)<br>
> > ><br>
> > > Any other ideas?<br>
> > ><br>
> > ><br>
> > ><br>
> > > On Tue, Jun 30, 2009 at 10:25 AM, Uwe Kastens<br>
> <<a href="mailto:kiste@kiste.org">kiste@kiste.org</a> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>><br>
> > <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>>><br>
</div><div><div></div><div class="h5">> > > <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>><br>
> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>>>>> wrote:<br>
> > ><br>
> > > Hi,<br>
> > ><br>
> > > looks good for me. Did you reload mysql after grant or<br>
> flush priv?<br>
> > ><br>
> > > Should be, otherwise you wont be able to connect via<br>
> mysql client.<br>
> > ><br>
> > > Your /etc/hosts have the entry for localhost?<br>
> > ><br>
> > > BR<br>
> > ><br>
> > > Uwe<br>
> > ><br>
> > > Brett Nemeroff schrieb:<br>
> > > > yeah, I tried localhost, 127.0.0.1, and the actual ip (I<br>
> > usually use<br>
> > > > localhost)<br>
> > > ><br>
> > > > here's my connect string:<br>
> > > > modparam("auth_db", "db_url",<br>
> > > ><br>
> "mysql://opensips:23u83fwhwkgh@localhost/opensips")<br>
> > > ><br>
> > > > Here's the mysql grant:<br>
> > > > GRANT ALL ON opensips.* TO 'opensips'@'localhost'<br>
> IDENTIFIED BY<br>
> > > > '23u83fwhwkgh';<br>
> > > ><br>
> > > > On Tue, Jun 30, 2009 at 9:56 AM, Uwe Kastens<br>
> > <<a href="mailto:kiste@kiste.org">kiste@kiste.org</a> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>><br>
> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>>><br>
> > > <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>><br>
> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>>>><br>
> > > > <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>><br>
> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>>><br>
> > <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>><br>
> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a> <mailto:<a href="mailto:kiste@kiste.org">kiste@kiste.org</a>>>>>> wrote:<br>
> > > ><br>
> > > > Brett,<br>
> > > ><br>
> > > > Could you post your URL from your config please?<br>
> > > ><br>
> > > > 127.0.0.1 is not the same as localhost!<br>
> > > > BR<br>
> > > ><br>
> > > > Uwe<br>
> > > ><br>
> > > > > Hey all,<br>
> > > > > sorry for such a noob question here, but I just<br>
> can't<br>
> > figure<br>
> > > out what<br>
> > > > > I'm doing wrong.. I'm getting the error:<br>
> > > > > Jun 30 15:36:33 nguenj297<br>
> /usr/local/sbin/opensips[10159]:<br>
> > > > > ERROR:db_mysql:db_mysql_new_connection: driver<br>
> > error(1045):<br>
> > > Access<br>
> > > > > denied for user 'opensips'@'localhost' (using<br>
> > password: YES)<br>
> > > > ><br>
> > > > > So of course, I checked the usernames and<br>
> passwords..<br>
> > I tried<br>
> > > > logging in<br>
> > > > > manually with:<br>
> > > > > mysql -u opensips -h localhost -p opensips<br>
> > > > > (with the same password of course)<br>
> > > > ><br>
> > > > > And it works fine.. so I'm not sure where the hangup<br>
> > is.. Where<br>
> > > > should I<br>
> > > > > debug this?<br>
> > > > ><br>
> > > > > Thanks,<br>
> > > > > Brett<br>
> > > > ><br>
> > > > ><br>
> > > > ><br>
> > > > ><br>
> > > > ><br>
> > > > ><br>
> > > ><br>
> > ><br>
> ><br>
> ------------------------------------------------------------------------<br>
> > > > ><br>
> > > > > _______________________________________________<br>
> > > > > Users mailing list<br>
> > > > > <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>><br>
> > <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>>> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>><br>
> > <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>>>><br>
> > > <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>><br>
> > <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>>> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>><br>
> > <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>>>>><br>
> > > > ><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
> > > ><br>
> > > ><br>
> > > > --<br>
> > > ><br>
> > > > kiste lat: 54.322684, lon: 10.13586<br>
> > > ><br>
> > > ><br>
> > ><br>
> > ><br>
> > > --<br>
> > ><br>
> > > kiste lat: 54.322684, lon: 10.13586<br>
> > ><br>
> > ><br>
> ><br>
> ><br>
> > --<br>
> ><br>
> > kiste lat: 54.322684, lon: 10.13586<br>
> ><br>
> ><br>
><br>
><br>
> --<br>
><br>
> kiste lat: 54.322684, lon: 10.13586<br>
><br>
><br>
<br>
<br>
</div></div>--<br>
<div><div></div><div class="h5"><br>
kiste lat: 54.322684, lon: 10.13586<br>
</div></div></blockquote></div><br></div>