Still can't connect :( What could I be doing wrong? I wonder if it's the mysql client libs somehow?!<div><br></div><div><div>Access-rights</div><div>for USER 'opensips', from HOST 'localhost', to DB 'opensips'</div>
<div> +-----------------+---+ +-----------------+---+</div><div> | Select_priv | Y | | Lock_tables_priv | Y |</div><div> | Insert_priv | Y | | Execute_priv | Y |</div><div> | Update_priv | Y | | Repl_slave_priv | N |</div>
<div> | Delete_priv | Y | | Repl_client_priv | N |</div><div> | Create_priv | Y | | Create_view_priv | Y |</div><div> | Drop_priv | Y | | Show_view_priv | Y |</div><div> | Reload_priv | N | | Create_routine_priv | Y |</div>
<div> | Shutdown_priv | N | | Alter_routine_priv | Y |</div><div> | Process_priv | N | | Create_user_priv | N |</div><div> | File_priv | N | | Ssl_type | ? |</div><div> | Grant_priv | N | | Ssl_cipher | ? |</div>
<div> | References_priv | Y | | X509_issuer | ? |</div><div> | Index_priv | Y | | X509_subject | ? |</div><div> | Alter_priv | Y | | Max_questions | 0 |</div><div> | Show_db_priv | N | | Max_updates | 0 |</div>
<div> | Super_priv | N | | Max_connections | 0 |</div><div> | Create_tmp_table_priv | Y | | Max_user_connections | 0 |</div><div> +-----------------+---+ +-----------------+---+</div><div>NOTE: A password is required for user `opensips' :-(</div>
<div><br></div><div>The following rules are used:</div><div> db : '127.0.0.1','opensips','opensips','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'</div>
<div> host : 'Not processed: host-field is not empty in db-table.'</div><div> user : '%','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'</div>
<div><br></div><div><br></div><br><div class="gmail_quote">On Tue, Jun 30, 2009 at 11:01 AM, 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;">
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>
<div class="im"><br>
BR<br>
<br>
Uwe<br>
<br>
<br>
Brett Nemeroff schrieb:<br>
</div><div class="im">> 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>
</div>> <mailto:<a href="mailto:Yves.Carlier@rug.ac.be">Yves.Carlier@rug.ac.be</a>>)<br>
> 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><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>
> '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>
> '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>
</div></div><div class="im">> <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>
</div>> <mailto:<a href="mailto:Yves.Carlier@rug.ac.be">Yves.Carlier@rug.ac.be</a>>)<br>
> 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><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>
> '%','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','*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>
</div></div>> BUGs can be reported by email to <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 <<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></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>>>> wrote:<br>
> ><br>
> > Hi,<br>
> ><br>
> > looks good for me. Did you reload mysql after grant or flush priv?<br>
> ><br>
> > Should be, otherwise you wont be able to connect via 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>
> > > "mysql://opensips:23u83fwhwkgh@localhost/opensips")<br>
> > ><br>
> > > Here's the mysql grant:<br>
> > > GRANT ALL ON opensips.* TO 'opensips'@'localhost' 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>>>>> 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 can't<br>
> figure<br>
> > out what<br>
> > > > I'm doing wrong.. I'm getting the error:<br>
> > > > Jun 30 15:36:33 nguenj297 /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 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>
> > > > 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>> <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>
> > > > <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>
</div></div>--<br>
<div><div></div><div class="h5"><br>
kiste lat: 54.322684, lon: 10.13586<br>
</div></div></blockquote></div><br></div>