Here is what I got:password too long? really? it's not that long.. <shrug>
mysqlaccess Version 2.06, 20 Dec 2000 By RUG-AIV, by Yves Carlier ([email protected]) Changes by Steve Harvey ([email protected]) This software comes with ABSOLUTELY NO WARRANTY. Password for MySQL superuser root: Access-rights for USER 'opensips', from HOST 'localhost', to DB 'opensips' +-----------------+---+ +-----------------+---+ | Select_priv | Y | | Lock_tables_priv | Y | | Insert_priv | Y | | Execute_priv | Y | | Update_priv | Y | | Repl_slave_priv | N | | Delete_priv | Y | | Repl_client_priv | N | | Create_priv | Y | | Create_view_priv | Y | | Drop_priv | Y | | Show_view_priv | Y | | Reload_priv | N | | Create_routine_priv | Y | | Shutdown_priv | N | | Alter_routine_priv | Y | | Process_priv | N | | Create_user_priv | N | | File_priv | N | | Ssl_type | ? | | Grant_priv | N | | Ssl_cipher | ? | | References_priv | Y | | X509_issuer | ? | | Index_priv | Y | | X509_subject | ? | | Alter_priv | Y | | Max_questions | 0 | | Show_db_priv | N | | Max_updates | 0 | | Super_priv | N | | Max_connections | 0 | | Create_tmp_table_priv | Y | | Max_user_connections | 0 | +-----------------+---+ +-----------------+---+ NOTE: A password is required for user `opensips' :-( The following rules are used: db : '127.0.0.1','opensips','opensips','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y' host : 'Not processed: host-field is not empty in db-table.' 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' On Tue, Jun 30, 2009 at 10:41 AM, Uwe Kastens <[email protected]> wrote: > 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 ([email protected]) > Changes by Steve Harvey ([email protected]) > This software comes with ABSOLUTELY NO WARRANTY. > Password for MySQL superuser root: > > Access-rights > for USER 'opensips', from HOST 'localhost', to DB 'opensips' > +-----------------+---+ +-----------------+---+ > | Select_priv | Y | | Lock_tables_priv | Y | > | Insert_priv | Y | | Execute_priv | Y | > | Update_priv | Y | | Repl_slave_priv | N | > | Delete_priv | Y | | Repl_client_priv | N | > | Create_priv | Y | | Create_view_priv | Y | > | Drop_priv | Y | | Show_view_priv | Y | > | Reload_priv | N | | Create_routine_priv | Y | > | Shutdown_priv | N | | Alter_routine_priv | Y | > | Process_priv | N | | Create_user_priv | N | > | File_priv | N | | Ssl_type | ? | > | Grant_priv | N | | Ssl_cipher | ? | > | References_priv | Y | | X509_issuer | ? | > | Index_priv | Y | | X509_subject | ? | > | Alter_priv | Y | | Max_questions | 0 | > | Show_db_priv | N | | Max_updates | 0 | > | Super_priv | N | | Max_connections | 0 | > | Create_tmp_table_priv | Y | | Max_user_connections | 0 | > +-----------------+---+ +-----------------+---+ > NOTE: A password is required for user `opensips' :-( > > The following rules are used: > db : > > '%','opensips','opensips','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y' > host : 'Not processed: host-field is not empty in db-table.' > user : > > '%','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' > > BUGs can be reported by email to [email protected] > > > BR > > Uwe > > > Brett Nemeroff schrieb: > > 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 <[email protected] > > <mailto:[email protected]>> 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. > > > > Your /etc/hosts have the entry for localhost? > > > > BR > > > > Uwe > > > > Brett Nemeroff schrieb: > > > yeah, I tried localhost, 127.0.0.1, and the actual ip (I usually > use > > > localhost) > > > > > > here's my connect string: > > > modparam("auth_db", "db_url", > > > "mysql://opensips:23u83fwhw...@localhost/opensips") > > > > > > Here's the mysql grant: > > > GRANT ALL ON opensips.* TO 'opensips'@'localhost' IDENTIFIED BY > > > '23u83fwhwkgh'; > > > > > > On Tue, Jun 30, 2009 at 9:56 AM, Uwe Kastens <[email protected] > > <mailto:[email protected]> > > > <mailto:[email protected] <mailto:[email protected]>>> wrote: > > > > > > 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]: > > > > ERROR:db_mysql:db_mysql_new_connection: driver error(1045): > > Access > > > > denied for user 'opensips'@'localhost' (using password: YES) > > > > > > > > So of course, I checked the usernames and passwords.. I tried > > > logging in > > > > manually with: > > > > mysql -u opensips -h localhost -p opensips > > > > (with the same password of course) > > > > > > > > And it works fine.. so I'm not sure where the hangup is.. > Where > > > should I > > > > debug this? > > > > > > > > Thanks, > > > > Brett > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------ > > > > > > > > _______________________________________________ > > > > Users mailing list > > > > [email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>> > > > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > > > -- > > > > > > kiste lat: 54.322684, lon: 10.13586 > > > > > > > > > > > > -- > > > > kiste lat: 54.322684, lon: 10.13586 > > > > > > > -- > > kiste lat: 54.322684, lon: 10.13586 >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
