[Serusers] Problem starting SER with Presence support

[İlker Aktuna (Koç.net)]

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 at 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 at 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 at 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 at iptel.org]
Sent: Friday, March 17, 2006 11:51 AM
To: İlker Aktuna (Koç.net)
Cc: serusers at 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 at asterisk1.local' (Using password: YES)" )
> 
> could it be that, now ser can't query the db ?
> 
> 



 <http://271570.sigclick.mailinfo.com/sigclick/07060504/01094A09/07004803/15141696.jpg>
_____________________________________________________________________________________________________________________________________________
Bu e-posta mesaji kisiye ozel olup, gizli bilgiler iceriyor olabilir. Eger bu e-posta mesaji size yanlislikla ulasmissa,  icerigini hic bir sekilde kullanmayiniz ve ekli dosyalari acmayiniz. Bu durumda lutfen e-posta mesajini kullaniciya hemen geri gonderiniz  ve  tum kopyalarini mesaj kutunuzdan siliniz. Bu e-posta mesaji, hic bir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve para karsiligi satilamaz.  Bu e-posta mesaji viruslere karsi anti-virus sistemleri tarafindan taranmistir. Ancak yollayici, bu e-posta mesajinin - virus koruma sistemleri ile kontrol ediliyor olsa bile - virus icermedigini garanti etmez ve meydana gelebilecek zararlardan dogacak hicbir sorumlulugu kabul etmez. 
This message is intended solely for the use of the individual or entity to whom it is addressed , and may contain confidential  information. If you are not the intended recipient of this message or you receive this mail in error, you should refrain from making any use of the contents and from opening any attachment. In that case, please notify the sender immediately and return the message to the sender, then, delete and destroy all copies. This e-mail message, can not be copied, published or sold for any reason. This e-mail message has been swept by anti-virus systems for the presence of computer viruses. In doing so, however,  sender  cannot warrant that virus or other forms of data corruption may not be present and do not take any responsibility in any occurrence.
_____________________________________________________________________________________________________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20060317/f730c610/attachment.htm>