[Serusers] 400 Table 'aliases' not found in memory -- fixed again
steve
sgsubs at intechnology.co.uk
Mon May 10 18:25:34 CEST 2004
I did install from both at one point or another.
I will do some housekeeping.
Many thanks..
> -----Original Message-----
> From: Klaus Darilion [mailto:klaus.mailinglists at pernau.at]
> Sent: Monday 10 May 2004 17:15
> To: steve
> Cc: serusers at lists.iptel.org
> Subject: Re: [Serusers] 400 Table 'aliases' not found in
> memory -- fixed again
>
> probably you have installed ser from rpm and from source.
>
> ser rpm: -> /etc/ser/ser.cfg
> ser from source: /usr/local/etc/ser/ser.cfg
>
> I suggest to remove the ser rpms (also /etc/ser/*) and work
> with the self compiled version only.
>
> regards,
> klaus
>
> steve wrote:
> > Fixed again, I decided to leave this and work on other ser tests.
> >
> > I noticed that changes I made in /etc/ser/ser.cfg did not
> seem to take
> > effect.
> >
> > I did a search of the file system and found another ser.cfg in
> > /usr/local/etc/ser I renamed this file and everything is ok again.
> >
> > Any ideas why this file and directory was generated and why it was
> > used in place of /etc/ser/ser.cfg ??
> >
> > Thanks...
> >
> >
> >>-----Original Message-----
> >>From: serusers-bounces at lists.iptel.org
> >>[mailto:serusers-bounces at lists.iptel.org] On Behalf Of steve
> >>Sent: Monday 10 May 2004 12:29
> >>To: 'Jan Janak'
> >>Cc: serusers at lists.iptel.org
> >>Subject: RE: [Serusers] 400 Table 'aliases' not found in memory --
> >>checkedarchives added lookup("aliases") before if
> >>(!lookup("location")) {
> >>
> >>I had fixed this by adding the lookup("aliases"); as below, I have
> >>restarted ser this morning and get the error again?
> >>
> >>Can this error be caused by anything else? The config file
> looks the
> >>same as it did last night. (below)
> >>
> >>lookup("aliases");
> >>
> >> # native SIP destinations are handled using
> our USRLOC
> >>DB
> >> if (!lookup("location")) {
> >> sl_send_reply("404", "Not Found");
> >> break;
> >> };
> >>
> >> Very confusing as it has been ok all morning.
> >>
> >>Any ideas?
> >>
> >>Thanks in advance...
> >>
> >>
> >>>-----Original Message-----
> >>>From: Jan Janak [mailto:jan at iptel.org]
> >>>Sent: Sunday 09 May 2004 17:54
> >>>To: steve
> >>>Cc: serusers at lists.iptel.org
> >>>Subject: Re: [Serusers] 400 Table 'aliases' not found in memory --
> >>>checked archives added lookup("aliases") before if
> >>>(!lookup("location")) {
> >>>
> >>>On 07-05 17:18, steve wrote:
> >>>
> >>>>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;
> >>>> };
> >>>
> >>> Better put lookup("aliases") here.
> >>>
> >>>
> >>>> # 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");
> >>>
> >>> This does not matter actually -- you should get rid of
> the error
> >>> message if you put lookup("aliases") anywhere in the
> configuration
> >>> file. To make it work properly you should put it just before
> >>> lookup("location");
> >>>
> >>>
> >>>>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.
> >>>
> >>> That's possible, in this case simply remove the line
> from pending
> >>> table -- the account should be activated already if it is in
> >>> subscriber table.
> >>>
> >>> Jan.
> >>>
> >>>______________________________________________________________
> >>>__________
> >>>This message has been checked for all known viruses by the
> >>
> >>CitC Virus
> >>
> >>>Scanning Service powered by SkyLabs. For further information visit
> >>>http://www.citc.it
> >>>
> >>>___
> >>>
> >>
> >>
> >>_______________________________________________
> >>Serusers mailing list
> >>serusers at lists.iptel.org
> >>http://lists.iptel.org/mailman/listinfo/serusers
> >>
> >>______________________________________________________________
> >>__________
> >>This message has been checked for all known viruses by the
> CitC Virus
> >>Scanning Service powered by SkyLabs. For further information visit
> >>http://www.citc.it
> >>
> >>___
> >>
> >>______________________________________________________________
> >>__________
> >>This message has been checked for all known viruses by the
> CitC Virus
> >>Scanning Service powered by SkyLabs. For further information visit
> >>http://www.citc.it
> >>
> >>___
> >>
> >
> >
> >
> > _______________________________________________
> > Serusers mailing list
> > serusers at lists.iptel.org
> > http://lists.iptel.org/mailman/listinfo/serusers
> >
> >
>
> ______________________________________________________________
> __________
> This message has been checked for all known viruses by the
> CitC Virus Scanning Service powered by SkyLabs. For further
> information visit http://www.citc.it
>
> ___
>
More information about the sr-users
mailing list