[Serusers] 400 Table 'aliases' not found in memory -- checked archives added lookup("aliases") before if (!lookup("location")) {

[steve]

Hi,
Looking back in the archives I see this problem referenced quite a lot.

My  issue seems to be the same as the others in the archive:

In serweb/user_interface click on the subscribe button, fill in the details
no problems.

When going to the confirmation page I see the message:

400 Table 'aliases' not found in memory, use save("aliases") or
lookup("aliases") in the configuration script first 

This is a snip of my config:

if (uri=~"labbox-b.noclan.lab") {
        lookup("aliases");
                if (method=="REGISTER") {
# Uncomment this if you want to use digest authentication
                        if (!www_authorize("labbox-b.noclan.lab",
"subscriber")) {
                                www_challenge("labbox-b.noclan.lab", "0");
                                break;
                        };

                        save("location");
                        break;
                };

                # native SIP destinations are handled using our USRLOC DB
                if (!lookup("location")) {
                        sl_send_reply("404", "Not Found");
                        break;
                };


I have tried this config in variations:

if (uri=="myself") {
lookup("aliases");

if (uri=~"labbox-b.noclan.lab") {
lookup("aliases")

if (uri=~"labbox-b.noclan.lab") {
lookup("aliases");

I have also tried adding the save("aliases") but this does not seem to be
referenced as much as lookup("aliases");

Is this a simple syntax issue? Ser starts ok using any of the config
variations.

I will attach the full ser.cfg in case I have made errors else where in the
file.

Interestingly this seems to be a precursor for the error "error in SQL
query, line: 43" that people see. The reason for this is that the user is
added to the subscriber table, but is not removed from pending, so when you
re-try you have a duplicate in the subscriber table and this I think is what
generates the error.

Any pointers will be appreciated.

Thanks...
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: ser.cfg.400-aliases-error.txt
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20040507/4715d5c4/attachment.txt>