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). I think the whole idea of a "default db_url" is a mistake... that's my personal opinion. Thanks for helping me find this.. -Brett
On Tue, Jun 30, 2009 at 12:48 PM, Uwe Kastens <[email protected]> wrote: > Hi Brett, > > Could be broken libs. I would start opensips with strace and look for > errors. > > Which OS are you using? > > BR > > Uwe > > Brett Nemeroff schrieb: > > Still can't connect :( What could I be doing wrong? I wonder if it's the > > mysql client libs somehow?! > > > > 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 : > > > '%','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' > > > > > > > > On Tue, Jun 30, 2009 at 11:01 AM, Uwe Kastens <[email protected] > > <mailto:[email protected]>> wrote: > > > > Hmm, > > > > And you did change the host in the opensips url from localhost to > > 127.0.0.1? > > > > For a test change the 127.0.0.1 in the mysql to % and try again. And > > mabye change the password with update user set > > password=password("yourpassword") where user="opensips"; > > > > > > Your password entry looks like from a elder version. > > > > BR > > > > Uwe > > > > > > Brett Nemeroff schrieb: > > > 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] > > <mailto:[email protected]> > > > <mailto:[email protected] <mailto:[email protected]>>) > > > Changes by Steve Harvey ([email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[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] > > <mailto:[email protected]> > > > <mailto:[email protected] <mailto:[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] > > <mailto:[email protected]> > > > <mailto:[email protected] <mailto:[email protected] > >>) > > > Changes by Steve Harvey ([email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[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] > > <mailto:[email protected]> <mailto:[email protected] <mailto: > [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]> > > > <mailto:[email protected] <mailto:[email protected]>> > > > > <mailto:[email protected] <mailto:[email protected]> > > <mailto:[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]>> > > > > <mailto:[email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>>> > > > > > <mailto:[email protected] <mailto:[email protected]> > > <mailto:[email protected] <mailto:[email protected]>> > > > <mailto:[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]>> <mailto:[email protected] > > <mailto:[email protected]> > > > <mailto:[email protected] > > <mailto:[email protected]>>> > > > > <mailto:[email protected] > > <mailto:[email protected]> > > > <mailto:[email protected] > > <mailto:[email protected]>> <mailto:[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 > > > > > > > > > > > > -- > > > > 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
