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

Guilherme Dal Pizzol gpizzol at telenova.net
Thu Feb 20 22:49:39 CET 2003


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




More information about the sr-users mailing list