# serctl alias add 7004 sip:graff@isc.org sip:graff@isc.org 400 Table 'aliases' Not Found
The table IS there:
+-----------------+ | 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)
This is on FreeBSD 4.7-RELEASE-p2 i386
--Michael
You must have lookup("aliases") somewhere in your configuration script otherwise in-memory cache of aliases table will be not created and you will get this error message.
I admit this is not very nice, it will be fixed by the next release. Thanks for the report !
Jan.
On 09-01 23:10, Michael Graff wrote:
# serctl alias add 7004 sip:graff@isc.org sip:graff@isc.org 400 Table 'aliases' Not Found
The table IS there:
+-----------------+ | 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)
This is on FreeBSD 4.7-RELEASE-p2 i386
--Michael _______________________________________________ Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Do you use the aliases table in your script?
serctl is a tool for direct manipulation of ser's cache. Caching sql tables is good for performance. however, it poses a problem: how to change content of the cache without rebooting ser? (there is no way to propagate changes to mysql database to the cache). That's what we use serctl for. It manipuilates ser's cache via FIFO server in run-time.
If a lookup table is not used from a script, it is not cached and it cannot be updated using serctl.
-Jiri
(manipulation in sql are not reflected in ser's
At 12:10 AM 1/10/2003, Michael Graff wrote:
# serctl alias add 7004 sip:graff@isc.org sip:graff@isc.org 400 Table 'aliases' Not Found
The table IS there:
+-----------------+ | 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)
This is on FreeBSD 4.7-RELEASE-p2 i386
--Michael _______________________________________________ Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-- Jiri Kuthan http://iptel.org/~jiri/
-
Jan Janak -
Jiri Kuthan -
Michael Graff