[OpenSIPS-Users] mysql database connection error

[Brett Nemeroff]

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 <kiste at kiste.org> 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:23u83fwhwkgh@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 <kiste at kiste.org
> > <mailto:kiste at kiste.org>> 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
> >     > Users at lists.opensips.org <mailto:Users at lists.opensips.org>
> >     > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >
> >
> >     --
> >
> >     kiste lat: 54.322684, lon: 10.13586
> >
> >
>
>
> --
>
> kiste lat: 54.322684, lon: 10.13586
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090630/fdeaa7ea/attachment.htm