Hi,

I get the following results with your suggested commands:
mysql> GRANT ALL ON ser.* TO 'ser'@'127.0.0.1' IDENTIFIED BY 'heslo';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL ON ser.* TO 'ser'@'localhost' IDENTIFIED BY 'heslo';
Query OK, 0 rows affected (0.00 sec)

So no rows are affected ?

Btw, if I change all 127.0.0.1 with "localhost" on cfg file, Ser starts successfully.

This time I couldn't register my client. When I get tcpdump traces I see the error 483 "too many hops"
Btw, which password should I use with my users ?
Your dbinit script creates some users but what are their passwords ?

Thanks,
ilker

-----Original Message-----
From: Vaclav Kubart [mailto:vaclav.kubart@iptel.org]
Sent: Thursday, March 16, 2006 2:42 PM
To: İlker Aktuna (Koç.net)
Cc: serusers@lists.iptel.org
Subject: Re: [Serusers] Problem starting SER with Presence support

You have probably badly set privileges in database. Try to tun

GRANT ALL ON ser.* TO 'ser'@'localhost' IDENTIFIED BY 'heslo';

or

GRANT ALL ON ser.* TO 'ser'@'127.0.0.1' IDENTIFIED BY 'heslo';

or something like that in mysql (you must be root for that) and try it again.

        Vaclav

On Thu, Mar 16, 2006 at 02:13:35PM +0200, ?lker Aktuna (Koç.net) wrote:
> I can login with:
> # mysql  -P 3306 -user -pheslo ser
>
> but I can't login with:
> # mysql -h 127.0.0.1 -P 3306 -user -pheslo ser
>
> ________________________________
>
> From: ?lker Aktuna (Koç.net)
> Sent: Thursday, March 16, 2006 2:11 PM
> To: 'Vaclav Kubart'
> Cc: serusers@lists.iptel.org
> Subject: RE: [Serusers] Problem starting SER with Presence support
>
>
>
> I got the folowing error:
>
> # mysql -h 127.0.0.1 -P 3306 -user -pheslo ser ERROR 1045: Access
> denied for user: 'ser@asterisk1.local' (Using password: YES)
>
>
> -----Original Message-----
> From: Vaclav Kubart [mailto:vaclav.kubart@iptel.org]
> Sent: Thursday, March 16, 2006 1:58 PM
> To: ?lker Aktuna (Koç.net)
> Cc: serusers@lists.iptel.org
> Subject: Re: [Serusers] Problem starting SER with Presence support
>
> Are you able to work with ser database using mysql like this?
>
> mysql -h 127.0.0.1 -P 3306 -user -pheslo ser
>
> You can try to increase debug level in SER's config file (debug=4) and see messages in log.
>
>         Vaclav
>
>
> On Thu, Mar 16, 2006 at 01:36:20PM +0200, ?lker Aktuna (Koç.net) wrote:
> > Hi,
> >
> > Thanks; I did it that way and now the server starts but then exits.
> > I see the following lines in my /var/log/messages file:
> >
> > Mar 16 13:26:33 asterisk1 ./ser[19374]: new_connection: Access
> > denied for user: 'ser@asterisk1.local' (Using password: YES) Mar 16
> > 13:26:33
> > asterisk1 ./ser[19374]: uri_db:mod_init: Unable to open database
> > connection Mar 16 13:26:33 asterisk1 ./ser[19374]: init_mod(): Error
> > while initializing module uri_db
> >
> > However, I can login to mysql db by user ser/heslo.
> > Where might be the problem ?
> >
> > Thanks,
> > ilker