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
