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 at sh.cvut.cz>
To: <lenny at voiping.com>
Cc: <serusers at 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 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]
> >
> >
> > _______________________________________________
> > Serusers mailing list
> > serusers at lists.iptel.org
> > http://lists.iptel.org/mailman/listinfo/serusers
> >
>