New subject: [Serusers] Fw: Serweb problems - 0.8.12

24 Nov 2003

So, aliases should be fine.

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 

klaus

-----Original Message-----
From: Jon Ole Nome [mailto:jonome@avitrans.no] 
Sent: Monday, November 24, 2003 10:32 PM
To: Klaus Darilion
Cc: serusers(a)lists.iptel.org
Subject: Re: [Serusers] Fw: Serweb problems - 0.8.12

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.

----- Original Message ----- 

From: Klaus Darilion <mailto:darilion@ict.tuwien.ac.at>  
To: Jon Ole Nome <mailto:jonome@avitrans.no>  
Cc: serusers(a)lists.iptel.org 
Sent: Monday, November 24, 2003 10:25 PM
Subject: RE: [Serusers] Fw: Serweb problems - 0.8.12

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.

klaus

-----Original Message-----
From: Jon Ole Nome [mailto:jonome@avitrans.no] 
Sent: Monday, November 24, 2003 9:56 PM
To: Klaus Darilion
Cc: serusers(a)lists.iptel.org
Subject: Re: [Serusers] Fw: Serweb problems - 0.8.12

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 :)

Jon Ole

----- Original Message ----- 
From: Klaus Darilion <mailto:darilion@ict.tuwien.ac.at>  
To: Jon Ole Nome <mailto:jonome@avitrans.no>  
Cc: serusers(a)lists.iptel.org 
Sent: Monday, November 24, 2003 9:44 PM
Subject: RE: [Serusers] Fw: Serweb problems - 0.8.12

Hi!

Please CC to the list!

Looks like serweb copies the new user from 'pending' to 'subscriber'
table, but failes to delete the new user from the 'pending' table.

I think these activities of serweb are unrelated to ser - serweb
interacts directly with the DB. Maybe the table/colum names have changed
slightly.

Klaus

-----Original Message-----
From: Jon Ole Nome [mailto:jonome@avitrans.no] 
Sent: Monday, November 24, 2003 9:39 PM
To: Klaus Darilion
Subject: Re: [Serusers] Fw: Serweb problems - 0.8.12

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?

Jon Ole

----- Original Message ----- 
From: Klaus Darilion <mailto:darilion@ict.tuwien.ac.at>  
To: Jon Ole Nome <mailto:jonome@avitrans.no>  ; serusers(a)lists.iptel.org 
Sent: Monday, November 24, 2003 9:33 PM
Subject: RE: [Serusers] Fw: Serweb problems - 0.8.12

The aliases table is unrelated to this!

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".

Klaus

-----Original Message-----
From: Jon Ole Nome [mailto:jonome@avitrans.no] 
Sent: Monday, November 24, 2003 9:29 PM
To: serusers(a)lists.iptel.org
Subject: [Serusers] Fw: Serweb problems - 0.8.12

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:

ringsip.com User Management

error in SQL query, line: 43
We regret but your ringsip.com confirmation attempt failed.
Please contact info(a)ringsip.com for further assistance. 

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!

Jon Ole