[Serusers] Cannot add "alias" mysql DB (using default passwords)

Lenny Tropiano lenny at voiping.com
Wed Feb 19 14:42:05 CET 2003


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 at voiping.com
MySql Password: 
new user added

$ serctl alias add 1234 sip:lenny at voiping.com
sip:lenny at 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 at voiping.com
Partner, Networking Specialist          Pager:  pager-lenny at voiping.com
VoIPing, LLC                            URL:    http://www.voiping.com/
PO Box 867, Cedar Park, TX 78630-0867   Mobile: 512-698-VOIP [8647] 





More information about the sr-users mailing list