<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Nachricht</TITLE>
<META content="MSHTML 6.00.2800.1276" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=187515521-24112003><FONT face=Arial color=#0000ff size=2>Sorry,
no answers left, y</FONT></SPAN><SPAN class=187515521-24112003><FONT face=Arial
color=#0000ff size=2>ou have to debug the php script.</FONT></SPAN></DIV>
<DIV><SPAN class=187515521-24112003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=187515521-24112003><FONT face=Arial color=#0000ff
size=2>Klaus</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Jon Ole Nome
[mailto:jonome@avitrans.no] <BR><B>Sent:</B> Monday, November 24, 2003 10:51
PM<BR><B>To:</B> Klaus Darilion<BR><B>Cc:</B>
serusers@lists.iptel.org<BR><B>Subject:</B> Re: [Serusers] Fw: Serweb problems -
0.8.12<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>I am using MySQL 4.0.16. I should also mention
that I had serweb running on 0.8.11 and registration worked fine. Same server
and MySQL. I cleaned that out and got 0.8.12 and latest serweb tarball. Ran
ser_mysql.sh reinit to get an updated ser database.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Jon Ole</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=darilion@ict.tuwien.ac.at
href="mailto:darilion@ict.tuwien.ac.at">Klaus Darilion</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=jonome@avitrans.no
href="mailto:jonome@avitrans.no">Jon Ole Nome</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=serusers@lists.iptel.org
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, November 24, 2003 10:44
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [Serusers] Fw: Serweb
problems - 0.8.12</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=647223921-24112003><FONT face=Arial color=#0000ff
size=2>So, aliases should be fine.</FONT></SPAN></DIV>
<DIV><SPAN class=647223921-24112003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=647223921-24112003><FONT face=Arial color=#0000ff
size=2>Which MySQL version do you use? I had problems with the latest serweb
using mysql 3.x because the introduced new SQL queries which requries mysql
4.x </FONT></SPAN></DIV>
<DIV><SPAN class=647223921-24112003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=647223921-24112003><FONT face=Arial color=#0000ff
size=2>klaus</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Jon Ole Nome
[mailto:jonome@avitrans.no] <BR><B>Sent:</B> Monday, November 24, 2003
10:32 PM<BR><B>To:</B> Klaus Darilion<BR><B>Cc:</B> <A
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A><BR><B>Subject:</B>
Re: [Serusers] Fw: Serweb problems - 0.8.12<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>The lookup("aliases") is in the ser.cfg, in
the routing section, just after save location. Is that the right place?
Sorry for all the dumb questions.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=darilion@ict.tuwien.ac.at
href="mailto:darilion@ict.tuwien.ac.at">Klaus Darilion</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=jonome@avitrans.no
href="mailto:jonome@avitrans.no">Jon Ole Nome</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=serusers@lists.iptel.org
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, November 24, 2003
10:25 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [Serusers] Fw: Serweb
problems - 0.8.12</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=951261921-24112003><FONT face=Arial color=#0000ff
size=2>Yes, you're right. serweb adds an alias for every user - but you
carn turn this off. maybe the problem accours when adding the alias.
hint: there are often problems if the 'lookup("aliases")' statement is
missing in the ser.cfg.</FONT></SPAN></DIV>
<DIV><SPAN class=951261921-24112003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=951261921-24112003><FONT face=Arial color=#0000ff
size=2>klaus</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Jon Ole
Nome [mailto:jonome@avitrans.no] <BR><B>Sent:</B> Monday, November 24,
2003 9:56 PM<BR><B>To:</B> Klaus Darilion<BR><B>Cc:</B> <A
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A><BR><B>Subject:</B>
Re: [Serusers] Fw: Serweb problems - 0.8.12<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hello again, do you know where I can find
line 43 in the SQL query? Maybe I can figure out what is wrong if I
know what it's trying to do. Doesn't serweb add an alias for the user?
That was the next thing I wanted to look into. I don't want users to
select their own usernames, I want to assign a number when they
register. Not sure how to set that up, though :)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Jon Ole</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=darilion@ict.tuwien.ac.at
href="mailto:darilion@ict.tuwien.ac.at">Klaus Darilion</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=jonome@avitrans.no
href="mailto:jonome@avitrans.no">Jon Ole Nome</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=serusers@lists.iptel.org
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, November 24, 2003
9:44 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [Serusers] Fw:
Serweb problems - 0.8.12</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=102214120-24112003><FONT face=Arial color=#0000ff
size=2>Hi!</FONT></SPAN></DIV>
<DIV><SPAN class=102214120-24112003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=102214120-24112003><FONT face=Arial color=#0000ff
size=2>Please CC to the list!</FONT></SPAN></DIV>
<DIV><SPAN class=102214120-24112003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=102214120-24112003><FONT face=Arial color=#0000ff
size=2>Looks like serweb copies the new user from 'pending' to
'subscriber' table, but failes to delete the new user from the
'pending' table.</FONT></SPAN></DIV>
<DIV><SPAN class=102214120-24112003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=102214120-24112003><FONT face=Arial color=#0000ff
size=2>I think these activities of serweb are unrelated to ser -
serweb interacts directly with the DB. Maybe the table/colum names
have changed slightly.</FONT></SPAN></DIV>
<DIV><SPAN class=102214120-24112003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=102214120-24112003><FONT face=Arial color=#0000ff
size=2>Klaus</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Jon
Ole Nome [mailto:jonome@avitrans.no] <BR><B>Sent:</B> Monday,
November 24, 2003 9:39 PM<BR><B>To:</B> Klaus
Darilion<BR><B>Subject:</B> Re: [Serusers] Fw: Serweb problems -
0.8.12<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Thanks for the quick reply! Looking
in the database I see that the new user is both in the pending and
subscriber tables. Does that tell you anything?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Jon Ole</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message -----
</DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=darilion@ict.tuwien.ac.at
href="mailto:darilion@ict.tuwien.ac.at">Klaus Darilion</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=jonome@avitrans.no href="mailto:jonome@avitrans.no">Jon
Ole Nome</A> ; <A title=serusers@lists.iptel.org
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, November 24,
2003 9:33 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [Serusers] Fw:
Serweb problems - 0.8.12</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=853313220-24112003><FONT face=Arial
color=#0000ff size=2>The aliases table is unrelated to
this!</FONT></SPAN></DIV>
<DIV><SPAN class=853313220-24112003><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=853313220-24112003><FONT face=Arial
color=#0000ff size=2>Serweb adds the user to the "pending" table
and when you confirm the registration by clicking the link,
serweb moves the user from "pending" to
"subscriber".</FONT></SPAN></DIV>
<DIV><SPAN class=853313220-24112003><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=853313220-24112003><FONT face=Arial
color=#0000ff size=2>Klaus</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=de dir=ltr
align=left><FONT face=Tahoma size=2>-----Original
Message-----<BR><B>From:</B> Jon Ole Nome
[mailto:jonome@avitrans.no] <BR><B>Sent:</B> Monday, November
24, 2003 9:29 PM<BR><B>To:</B> <A
href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</A><BR><B>Subject:</B>
[Serusers] Fw: Serweb problems - 0.8.12<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>I am running ser 0.8.12 with
MySQL support on a RH9 server. Downloaded the latest serweb
tarball from the cvs. I can log in with existing userids, both
on the admin and user_interface web pages. If I try to
register a new user in serweb the registration process runs ok
and I get a mail asking for confirmation, but when I click the
link to confirm I get this error:</FONT></DIV>
<DIV> </DIV>
<DIV>ringsip.com User Management<BR>
<DIV class=errors>error in SQL query, line: 43</DIV><SPAN
class=txt_norm>We regret but your ringsip.com confirmation
attempt failed.<BR>Please contact <A
href="mailto:info@ringsip.com">info@ringsip.com</A> for
further assistance.</SPAN> <BR></DIV>
<DIV><FONT face=Arial size=2>I have verified that the new user
is added to the database, and I can log in to user_interface
with the new userid. But there is nothing in the "aliases"
table in the database. Any ideas? Grateful for any
help!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Jon
Ole</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>