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@sh.cvut.cz To: lenny@voiping.com Cc: serusers@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@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@voiping.com Partner, Networking Specialist Pager: pager-lenny@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers