19 Feb
2003
19 Feb
'03
3:42 p.m.
I have turned on mysql authentication, and was able to add users, but
aliases complain that "table" doesn't exist:
$ serctl add lenny abcdef lenny(a)voiping.com
MySql Password:
new user added
$ serctl alias add 1234 sip:lenny@voiping.com
sip:lenny@voiping.com
400 Table 'aliases' Not Found
$ mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 243 to server version: 3.23.53
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> connect ser;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Connection id: 244
Current database: ser
mysql> show tables;
+-----------------+
| Tables_in_ser |
+-----------------+
| acc |
| active_sessions |
| aliases |
| config |
| event |
| grp |
| location |
| missed_calls |
| pending |
| phonebook |
| reserved |
| silo |
| subscriber |
| version |
+-----------------+
14 rows in set (0.00 sec)
mysql>
---
Lenny Tropiano E-mail: lenny(a)voiping.com
Partner, Networking Specialist Pager: pager-lenny(a)voiping.com
VoIPing, LLC URL: http://www.voiping.com/
PO Box 867, Cedar Park, TX 78630-0867 Mobile: 512-698-VOIP [8647]
19 Feb
19 Feb
3:45 p.m.
Hello,
you must put lookup("aliases") somewhere in your script. The command
tries to update cache and if you don't use the table somewhere in the
script, the cache is not created.
The error message has been changed to a more descriptive one in the CVS.
regards, Jan.
On 19-02 07:42, Lenny Tropiano wrote:
I have turned on mysql authentication, and was able to
add users, but
aliases complain that "table" doesn't exist:
$ serctl add lenny abcdef lenny(a)voiping.com
MySql Password:
new user added
$ serctl alias add 1234 sip:lenny@voiping.com
sip:lenny@voiping.com
400 Table 'aliases' Not Found
$ mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 243 to server version: 3.23.53
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> connect ser;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Connection id: 244
Current database: ser
mysql> show tables;
+-----------------+
| Tables_in_ser |
+-----------------+
| acc |
| active_sessions |
| aliases |
| config |
| event |
| grp |
| location |
| missed_calls |
| pending |
| phonebook |
| reserved |
| silo |
| subscriber |
| version |
+-----------------+
14 rows in set (0.00 sec)
mysql>
---
Lenny Tropiano E-mail: lenny(a)voiping.com
Partner, Networking Specialist Pager: pager-lenny(a)voiping.com
VoIPing, LLC URL: http://www.voiping.com/
PO Box 867, Cedar Park, TX 78630-0867 Mobile: 512-698-VOIP [8647]
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
20 Feb
20 Feb
11:49 p.m.
Hi Jan,
What do you mean by "put lookup("aliases") somewhere in your script"?
I'm using serctl and I'm also getting this error. Do I need to change serctl
script?
Thanks and regards,
Guilherme.
----- Original Message -----
From: <J.Janak(a)sh.cvut.cz>
To: <lenny(a)voiping.com>
Cc: <serusers(a)lists.iptel.org>
Sent: Wednesday, February 19, 2003 10:45 AM
Subject: Re: [Serusers] Cannot add "alias" mysql DB (using default
passwords)
Hello,
you must put lookup("aliases") somewhere in your script. The command
tries to update cache and if you don't use the table somewhere in the
script, the cache is not created.
The error message has been changed to a more descriptive one in the CVS.
regards, Jan.
On 19-02 07:42, Lenny Tropiano wrote:
I have turned on mysql authentication, and was
able to add users, but
aliases complain that "table" doesn't exist:
$ serctl add lenny abcdef lenny(a)voiping.com
MySql Password:
new user added
$ serctl alias add 1234 sip:lenny@voiping.com
sip:lenny@voiping.com
400 Table 'aliases' Not Found
$ mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 243 to server version: 3.23.53
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> connect ser;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Connection id: 244
Current database: ser
mysql> show tables;
+-----------------+
| Tables_in_ser |
+-----------------+
| acc |
| active_sessions |
| aliases |
| config |
| event |
| grp |
| location |
| missed_calls |
| pending |
| phonebook |
| reserved |
| silo |
| subscriber |
| version |
+-----------------+
14 rows in set (0.00 sec)
mysql>
---
Lenny Tropiano E-mail: lenny(a)voiping.com
Partner, Networking Specialist Pager: pager-lenny(a)voiping.com
VoIPing, LLC URL: http://www.voiping.com/
PO Box 867, Cedar Park, TX 78630-0867 Mobile: 512-698-VOIP [8647]
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
11:56 p.m.
Hello,
if your ser configuration script doesn't use aliases table then aliases
cache is not created and serctl fails. So to solve the problem, you must
use aliases table in your script, which means using lookup("aliases") or
save("aliases").
You don't need to change serctl script, you need to change configuration
script of ser.
regards, Jan.
On 20-02 18:49, Guilherme Dal Pizzol wrote:
Hi Jan,
What do you mean by "put lookup("aliases") somewhere in your
script"?
I'm using serctl and I'm also getting this error. Do I need to change serctl
script?
Thanks and regards,
Guilherme.
----- Original Message -----
From: <J.Janak(a)sh.cvut.cz>
To: <lenny(a)voiping.com>
Cc: <serusers(a)lists.iptel.org>
Sent: Wednesday, February 19, 2003 10:45 AM
Subject: Re: [Serusers] Cannot add "alias" mysql DB (using default
passwords)
Hello,
you must put lookup("aliases") somewhere in your script. The command
tries to update cache and if you don't use the table somewhere in the
script, the cache is not created.
The error message has been changed to a more descriptive one in the CVS.
regards, Jan.
On 19-02 07:42, Lenny Tropiano wrote:
I have turned on mysql authentication, and was
able to add users, but
aliases complain that "table" doesn't exist:
$ serctl add lenny abcdef lenny(a)voiping.com
MySql Password:
new user added
$ serctl alias add 1234 sip:lenny@voiping.com
sip:lenny@voiping.com
400 Table 'aliases' Not Found
$ mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 243 to server version: 3.23.53
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> connect ser;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Connection id: 244
Current database: ser
mysql> show tables;
+-----------------+
| Tables_in_ser |
+-----------------+
| acc |
| active_sessions |
| aliases |
| config |
| event |
| grp |
| location |
| missed_calls |
| pending |
| phonebook |
| reserved |
| silo |
| subscriber |
| version |
+-----------------+
14 rows in set (0.00 sec)
mysql>
---
Lenny Tropiano E-mail: lenny(a)voiping.com
Partner, Networking Specialist Pager: pager-lenny(a)voiping.com
VoIPing, LLC URL: http://www.voiping.com/
PO Box 867, Cedar Park, TX 78630-0867 Mobile: 512-698-VOIP [8647]
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
21 Feb
21 Feb
12:03 a.m.
Hi Jan,
What do you mean by "put lookup("aliases") somewhere in your
script"?
I'm using serctl and I'm also getting this error. Do I need to change serctl
script?
Thanks and regards,
Guilherme.
In /usr/local/etc/ser/ser.cfg put a "lookup("aliases"); in the route
{}"
statement before you do the processing ...
I just added it after the rewriteRoute()...
10:39 a.m.
New subject: [Serusers] no mysql authentication on solaris8
sorry to bother you guys again, but really wasting too much time here...
bet it's something simple in my ser.cfg, still can't get authentication over mysql
running...
can anyone help? got my ser.cfg and the log result of an connection attempt attached...
account "kamil" already in database with correct realm (host5.ince.net)...
what might be wrong???
muchos tia
-k
24 Feb
24 Feb
2:11 a.m.
New subject: [Serusers] no mysql authentication on solaris8
We'ld to see the messages too.
thanks,
-Jiri
At 09:39 AM 2/21/2003, Kamil Ince wrote:
sorry to bother you guys again, but really wasting too
much time here...
bet it's something simple in my ser.cfg, still can't get authentication over mysql
running...
can anyone help? got my ser.cfg and the log result of an connection attempt attached...
account "kamil" already in database with correct realm (host5.ince.net)...
what might be wrong???
muchos tia
-k
--
Jiri Kuthan http://iptel.org/~jiri/
7947
days inactive
7952
days old
6 comments
5 participants
participants (5)
-
Guilherme Dal Pizzol -
Jan Janak -
Jiri Kuthan -
Kamil Ince -
Lenny Tropiano