Here is what I got:<div><div>password too long? really? it's not that long.. <shrug></div><div><br></div><div><br></div><div>mysqlaccess Version 2.06, 20 Dec 2000</div><div>By RUG-AIV, by Yves Carlier (<a href="mailto:Yves.Carlier@rug.ac.be">Yves.Carlier@rug.ac.be</a>)</div>
<div>Changes by Steve Harvey (<a href="mailto:sgh@vex.net">sgh@vex.net</a>)</div><div>This software comes with ABSOLUTELY NO WARRANTY.</div><div>Password for MySQL superuser root: </div><div><br></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 : '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'</div>
<div><br></div><br><div class="gmail_quote">On Tue, Jun 30, 2009 at 10:41 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;">
Hi,<br>
<br>
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>
Changes by Steve Harvey (<a href="mailto:sgh@vex.net">sgh@vex.net</a>)<br>
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>
BUGs can be reported by email to <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>
</div><div class="im">> Yeah, it's in there. I'm really puzzled. This should be the easy 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>
</div><div class="im">> <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 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 <<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>
> > 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 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 error(1045):<br>
> Access<br>
> > > denied for user 'opensips'@'localhost' (using password: YES)<br>
> > ><br>
> > > So of course, I checked the usernames and passwords.. 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 is.. Where<br>
> > should I<br>
> > > debug this?<br>
> > ><br>
> > > Thanks,<br>
> > > Brett<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> <mailto:<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>><br>
</div></div>> <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>
<div class="im">> > > <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>
</div>--<br>
<div><div></div><div class="h5"><br>
kiste lat: 54.322684, lon: 10.13586<br>
</div></div></blockquote></div><br></div>