Hi,

Thanks.
I see now in the log:

Mar 17 15:18:30 asterisk1 /root/ser/sbin/ser[25947]: Unknown domain - message should be forwarded?
Mar 17 15:18:30 asterisk1 /root/ser/sbin/ser[25946]: to: sip:3229%40test-domain.com@10.100.100.15 from: sip:3229%40test-domain.com@10.100.100.15

I guess I shouldn't add @test-domain.com to the user on client. It adds the server IP as domain already ?

So, maybe I should add "test-domain.com" to my hosts file (on client) ?


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

You can use xlog - something like:
xlog("L_ERR", "to: %tu from: %fu\n");

And you can catch messages using ngrep or ethereal...

        Vaclav
       
On Fri, Mar 17, 2006 at 12:02:19PM +0200, ?lker Aktuna (Koç.net) wrote:
> As you'll see below, I tried 3 different ways to connect and they all get the same result.
> Btw, now I changed the cfg file mysql urls to 127.0.0.1 again and ser starts.
> But I see the same "unknown domain"  messages in the log.
>
> How can I write the incoming user and domain names to the log files ?
>
>
> [root@asterisk1 serctl]# mysql -h localhost -user -pheslo ser Reading
> table information for completion of table and column names You can
> turn off this feature to get a quicker startup with -A
>
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 185 to server version: 3.23.58
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> use ser;
> Database changed
> mysql> select * from domain;
> +------+-----------------+----------------+-------+
> | did  | domain          | last_modified  | flags |
> +------+-----------------+----------------+-------+
> | test | test-domain.com | 20060316152632 |    37 |
> +------+-----------------+----------------+-------+
> 1 row in set (0.00 sec)
>
> mysql> exit
> Bye
> [root@asterisk1 serctl]# mysql -h 127.0.0.1 -user -pheslo ser Reading
> table information for completion of table and column names You can
> turn off this feature to get a quicker startup with -A
>
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 186 to server version: 3.23.58
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> use ser;
> Database changed
> mysql> select * from domain;
> +------+-----------------+----------------+-------+
> | did  | domain          | last_modified  | flags |
> +------+-----------------+----------------+-------+
> | test | test-domain.com | 20060316152632 |    37 |
> +------+-----------------+----------------+-------+
> 1 row in set (0.00 sec)
>
> mysql> exit
> Bye
> [root@asterisk1 serctl]# mysql  -user -pheslo ser Reading table
> information for completion of table and column names You can turn off
> this feature to get a quicker startup with -A
>
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 187 to server version: 3.23.58
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> use ser;
> Database changed
> mysql> select * from domain;
> +------+-----------------+----------------+-------+
> | did  | domain          | last_modified  | flags |
> +------+-----------------+----------------+-------+
> | test | test-domain.com | 20060316152632 |    37 |
> +------+-----------------+----------------+-------+
> 1 row in set (0.00 sec)
>
> mysql>
>
> -----Original Message-----
> From: Vaclav Kubart [mailto:vaclav.kubart@iptel.org]
> Sent: Friday, March 17, 2006 11:51 AM
> To: ?lker Aktuna (Koç.net)
> Cc: serusers@lists.iptel.org
> Subject: Re: [Serusers] Problem starting SER with Presence support
>
> It looks like that SER is using another database than serctl and mysql.
> Try to run "mysql -h localhost -user -pheslo ser" and try to list the domain table again. Is it the same?
>
> I have no other ideas...
>
>         Vaclav
>
> On Fri, Mar 17, 2006 at 11:39:34AM +0200, ?lker Aktuna (Koç.net) wrote:
> > Hi,
> >
> > as you know, I had to change mysql urls in the cfg to "mysql://ser:heslo@localhost:3306/ser" from "mysql://ser:heslo@127.0.0.1:3306/ser"
> > (because ser daemon were dying with error "Mar 16 13:26:33 asterisk1
> > ./ser[19374]: new_connection: Access denied for user:
> > 'ser@asterisk1.local' (Using password: YES)" )
> >
> > could it be that, now ser can't query the db ?
> >