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

Jan Janak J.Janak at sh.cvut.cz
Thu Feb 20 22:56:24 CET 2003


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 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
> > >
> >
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20030220/990af186/attachment.pgp>


More information about the sr-users mailing list