Takk Olle,
that was a good way to learn what is going on. It turned out that my problem
was caused by insufficient rights to /tmp/ser_fifo for the apache user id.
Jon Ole
----- Original Message -----
From: "Olle E. Johansson" <oej@edvina.net>
To: "Klaus Darilion" <darilion@ict.tuwien.ac.at>
Cc: "Jon Ole Nome" <jonome@avitrans.no>; <serusers@lists.iptel.org>
Sent: Tuesday, November 25, 2003 8:00 PM
Subject: Re: [Serusers] Fw: Serweb problems - 0.8.12
Hej Jon Ole!
Check which script sends the confirmation mail - user/reg/confirmation.php -
and see if
you can find the problem there. Otherwise, configure mysql to log to log
file, and you'll
see each query as it pops into the database. Very useful for debugging, both
ser and serweb.
Not only debugging, but also to understand what happens :-)
From confirmation.php:
41 $q="insert into ".$config->table_subscriber."
select * from ".$config->table_pending." where confirmation='$nr'
";
42 $res=mySQL_query($q);
43 if (!$res) {$errors[]="error in SQL query, line:
".__LINE__. "\n<br>$q"; break;}
Good luck!
/Olle
Klaus Darilion wrote:
Sorry, no answers left, you have to debug the php script.
Klaus
-----Original Message-----
*From:* Jon Ole Nome [mailto:jonome@avitrans.no]
*Sent:* Monday, November 24, 2003 10:51 PM
*To:* Klaus Darilion
*Cc:* serusers@lists.iptel.org
*Subject:* Re: [Serusers] Fw: Serweb problems - 0.8.12
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.
Jon Ole
----- Original Message -----
*From:* Klaus Darilion <mailto:darilion@ict.tuwien.ac.at>
*To:* Jon Ole Nome <mailto:jonome@avitrans.no>
*Cc:* serusers@lists.iptel.org <mailto:serusers@lists.iptel.org>
*Sent:* Monday, November 24, 2003 10:44 PM
*Subject:* RE: [Serusers] Fw: Serweb problems - 0.8.12
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@lists.iptel.org <mailto:serusers@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@lists.iptel.org <mailto:serusers@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@lists.iptel.org <mailto:serusers@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@lists.iptel.org
<mailto:serusers@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@lists.iptel.org
<mailto:serusers@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@lists.iptel.org
<mailto:serusers@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@ringsip.com
<mailto:info@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
------------------------------------------------------------------------
_______________________________________________
Serusers mailing list
serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
--
*** Olle E. Johansson, oej@edvina.net
Mobile +46 70 593 68 51, Edvina AB, http://www.edvina.net
Runbovägen 10, 192 48 Sollentuna, Sweden
Phone: +46 8 594 78 810, Fax: +46 8 594 78 820
_______________________________________________
Serusers mailing list
serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers