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
?
>
>
