24 Nov
2003
24 Nov
'03
10:56 p.m.
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(a)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(a)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(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 <mailto:jonome@avitrans.no> Ole Nome ; 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
25 Nov
25 Nov
8 p.m.
New subject: [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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
--
*** Olle E. Johansson, oej(a)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
10:46 p.m.
New subject: [Serusers] Fw: Serweb problems - 0.8.12
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(a)edvina.net>
To: "Klaus Darilion" <darilion(a)ict.tuwien.ac.at>
Cc: "Jon Ole Nome" <jonome(a)avitrans.no>no>; <serusers(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
--
*** Olle E. Johansson, oej(a)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
11:49 p.m.
New subject: [Serusers] Fw: Serweb problems - 0.8.12
Yes. When they changed the permissions on the FIFO, they made it
inaccessable to the normal Apache user. Too bad they didn't make the
fifo owner/permissions a config file setting. I just created a group
called "serfifo", made "apache" a member of it, and put something like
"(sleep 5; chgrp serfifo $SERFIFO) &" into my SER startup script. This
waits in the background for five seconds, then changes group ownership
of the FIFO to one the apache user is a member of. You have to wait a
few seconds before doing the chgrp, because SER forks immediately on
start, and can take some time to create the FIFO, so your chgrp can
actually execute before the FIFO is created (race condition), so you
must give it a few seconds. The FIFO already has group rw perms as
created by SER.
- Jim
Jon Ole Nome wrote:
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(a)edvina.net>
To: "Klaus Darilion" <darilion(a)ict.tuwien.ac.at>
Cc: "Jon Ole Nome" <jonome(a)avitrans.no>no>; <serusers(a)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:
--
+---------------------------------------------------------------------------+
| Jim Burwell - Sr. Systems/Network/Security Engineer, JSBC |
+---------------------------------------------------------------------------+
| "I never let my schooling get in the way of my education." - Mark Twain |
| "UNIX was never designed to keep people from doing stupid things, because |
| that policy would also keep them from doing clever things." - Doug Gwyn |
| "Cool is only three letters away from Fool" - Mike Muir, Suicyco |
| "..Government in its best state is but a necessary evil; in its worst |
| state an intolerable one.." - Thomas Paine, "Common Sense" (1776)
|
+---------------------------------------------------------------------------+
| Email: jimb(a)jsbc.cc ICQ UIN: 1695089 |
+---------------------------------------------------------------------------+
| Reply problems ? Turn off the "sign" function in email prog. Blame MS. |
+---------------------------------------------------------------------------+
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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
--
*** Olle E. Johansson, oej(a)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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
26 Nov
26 Nov
12:26 p.m.
New subject: [Serusers] Fw: Serweb problems - 0.8.12
On Nov 25, 2003 at 14:49, Jim Burwell <jimb(a)jsbc.cc> wrote:
Yes. When they changed the permissions on the FIFO,
they made it
inaccessable to the normal Apache user. Too bad they didn't make the
fifo owner/permissions a config file setting. I just created a group
called "serfifo", made "apache" a member of it, and put something
like
"(sleep 5; chgrp serfifo $SERFIFO) &" into my SER startup script. This
waits in the background for five seconds, then changes group ownership
of the FIFO to one the apache user is a member of. You have to wait a
few seconds before doing the chgrp, because SER forks immediately on
start, and can take some time to create the FIFO, so your chgrp can
actually execute before the FIFO is created (race condition), so you
must give it a few seconds. The FIFO already has group rw perms as
created by SER.
Fifo permissions can be changes from the config file. Use
fifo_mode=0666. You could try also to change your ser group (start ser
with -g serinfo or add group=serinfo in the cfg).
We changed the fifo permissions because it introduced some security
problems on multi-user (read untrusted users) systems (DOS on ser using
fifo, overwritting files using fifo and setting the reply fifo to a link
in /tmp to some file elsewhere on the filesystem.). Now also ser will
try to delete & recreate /tmp/fifo on startup to make sure it has the
proper permissions.
Andrei
27 Nov
27 Nov
12:03 a.m.
New subject: [Serusers] Fw: Serweb problems - 0.8.12
Ok. I didn't know that SER had the ability to change the GID it runs
under (and therefore change the group owner of the FIFO hopefully).
This would solve the problem. In my case I'd just set "group=serfifo".
HOWEVER, why I try this, I get:
{root@fs/pts/7}~# ser -P /var/run/ser.pid -dddd -g serfifo
Segmentation fault
I tried it both in ser.cfg (group=serfifo), and both as text group
names, and as a numeric group ID (499 in my case). Both caused a
SEGFAULT. This is the SER CVS from the "0.8.11-r1" branch, compiled on
a RH7.3 system w/ gcc 2.96.
I can't really see a reason for this SEGF except for a possible null
pointer dereference in this code seg:
if ((tmp==0) ||(*tmp)){
Don't have time to debug at the moment.
- Jim
Andrei Pelinescu-Onciul wrote:
On Nov 25, 2003 at 14:49, Jim Burwell
<jimb(a)jsbc.cc> wrote:
--
+---------------------------------------------------------------------------+
| Jim Burwell - Sr. Systems/Network/Security Engineer, JSBC |
+---------------------------------------------------------------------------+
| "I never let my schooling get in the way of my education." - Mark Twain |
| "UNIX was never designed to keep people from doing stupid things, because |
| that policy would also keep them from doing clever things." - Doug Gwyn |
| "Cool is only three letters away from Fool" - Mike Muir, Suicyco |
| "..Government in its best state is but a necessary evil; in its worst |
| state an intolerable one.." - Thomas Paine, "Common Sense" (1776)
|
+---------------------------------------------------------------------------+
| Email: jimb(a)jsbc.cc ICQ UIN: 1695089 |
+---------------------------------------------------------------------------+
| Reply problems ? Turn off the "sign" function in email prog. Blame MS. |
+---------------------------------------------------------------------------+
Yes. When they changed the permissions on the
FIFO, they made it
inaccessable to the normal Apache user. Too bad they didn't make the
fifo owner/permissions a config file setting. I just created a group
called "serfifo", made "apache" a member of it, and put something like
"(sleep 5; chgrp serfifo $SERFIFO) &" into my SER startup script. This
waits in the background for five seconds, then changes group ownership
of the FIFO to one the apache user is a member of. You have to wait a
few seconds before doing the chgrp, because SER forks immediately on
start, and can take some time to create the FIFO, so your chgrp can
actually execute before the FIFO is created (race condition), so you
must give it a few seconds. The FIFO already has group rw perms as
created by SER.
Fifo permissions can be changes from the config file. Use
fifo_mode=0666. You could try also to change your ser group (start ser
with -g serinfo or add group=serinfo in the cfg).
We changed the fifo permissions because it introduced some security
problems on multi-user (read untrusted users) systems (DOS on ser using
fifo, overwritting files using fifo and setting the reply fifo to a link
in /tmp to some file elsewhere on the filesystem.). Now also ser will
try to delete & recreate /tmp/fifo on startup to make sure it has the
proper permissions.
Andrei
12:50 a.m.
New subject: [Serusers] Fw: Serweb problems - 0.8.12
On Nov 26, 2003 at 15:03, Jim Burwell <jimb(a)jsbc.cc> wrote:
Ok. I didn't know that SER had the ability to
change the GID it runs
under (and therefore change the group owner of the FIFO hopefully).
This would solve the problem. In my case I'd just set "group=serfifo".
HOWEVER, why I try this, I get:
{root@fs/pts/7}~# ser -P /var/run/ser.pid -dddd -g serfifo
Segmentation fault
Thanks. It seems I never tried group= myself :-)
It's fixed on the cvs (rel_0_8_11, rel_0_8_12 and HEAD), so either
update or apply the attacged patch.
Andrei
1:41 a.m.
New subject: [Serusers] Fw: Serweb problems - 0.8.12
OMG! How did I not see that myself when looking at the code! I can't
believe I missed that when I was looking at the code, albeit briefly.
- Jim
Andrei Pelinescu-Onciul wrote:
On Nov 26, 2003 at 15:03, Jim Burwell
<jimb(a)jsbc.cc> wrote:
--
+---------------------------------------------------------------------------+
| Jim Burwell - Sr. Systems/Network/Security Engineer, JSBC |
+---------------------------------------------------------------------------+
| "I never let my schooling get in the way of my education." - Mark Twain |
| "UNIX was never designed to keep people from doing stupid things, because |
| that policy would also keep them from doing clever things." - Doug Gwyn |
| "Cool is only three letters away from Fool" - Mike Muir, Suicyco |
| "..Government in its best state is but a necessary evil; in its worst |
| state an intolerable one.." - Thomas Paine, "Common Sense" (1776)
|
+---------------------------------------------------------------------------+
| Email: jimb(a)jsbc.cc ICQ UIN: 1695089 |
+---------------------------------------------------------------------------+
| Reply problems ? Turn off the "sign" function in email prog. Blame MS. |
+---------------------------------------------------------------------------+
Ok. I didn't know that SER had the ability to
change the GID it runs
under (and therefore change the group owner of the FIFO hopefully).
This would solve the problem. In my case I'd just set "group=serfifo".
HOWEVER, why I try this, I get:
{root@fs/pts/7}~# ser -P /var/run/ser.pid -dddd -g serfifo
Segmentation fault
Thanks. It seems I never tried group= myself :-)
It's fixed on the cvs (rel_0_8_11, rel_0_8_12 and HEAD), so either
update or apply the attacged patch.
Andrei
------------------------------------------------------------------------
Index: main.c
===================================================================
RCS file: /cvsroot/ser/sip_router/main.c,v
retrieving revision 1.168
diff -u -r1.168 main.c
--- main.c 2003/10/12 15:09:08 1.168
+++ main.c 2003/11/26 23:34:48
@@ -1523,7 +1523,7 @@
}
}
if (group){
- gid=strtol(user, &tmp, 10);
+ gid=strtol(group, &tmp, 10);
if ((tmp==0) ||(*tmp)){
/* maybe it's a string */
gr_entry=getgrnam(group);
2:43 a.m.
New subject: [Serusers] Fw: Serweb problems - 0.8.12
I found another little bug, this time with the "fifo_mode" directive in
the ser.cfg file. Since the YACC/Bison config defines the directive as
a integer type, you can only use decimal integers. Therefore, config
lines such as "fifo_mode=0660" will be interpreted as "660" DECIMAL,
resulting in unexpected modes being set. If you use the decimal number
"432", the equivelant of octal "660" it sets modes as expected.
Unless YACC/Bison/[F]Lex can be made to interpret the value as octal
(I'm no expert in these), you should probably change the type to string
and just use strtol(in,out,8) or strtol(in,out,0) (which lets the user
use decimal, or 0xHEX, or 0NNN octal in the ser.cfg file) in the code
somewhere.
- Jim
Andrei Pelinescu-Onciul wrote:
On Nov 26, 2003 at 15:03, Jim Burwell
<jimb(a)jsbc.cc> wrote:
--
+---------------------------------------------------------------------------+
| Jim Burwell - Sr. Systems/Network/Security Engineer, JSBC |
+---------------------------------------------------------------------------+
| "I never let my schooling get in the way of my education." - Mark Twain |
| "UNIX was never designed to keep people from doing stupid things, because |
| that policy would also keep them from doing clever things." - Doug Gwyn |
| "Cool is only three letters away from Fool" - Mike Muir, Suicyco |
| "..Government in its best state is but a necessary evil; in its worst |
| state an intolerable one.." - Thomas Paine, "Common Sense" (1776)
|
+---------------------------------------------------------------------------+
| Email: jimb(a)jsbc.cc ICQ UIN: 1695089 |
+---------------------------------------------------------------------------+
| Reply problems ? Turn off the "sign" function in email prog. Blame MS. |
+---------------------------------------------------------------------------+
Ok. I didn't know that SER had the ability to
change the GID it runs
under (and therefore change the group owner of the FIFO hopefully).
This would solve the problem. In my case I'd just set "group=serfifo".
HOWEVER, why I try this, I get:
{root@fs/pts/7}~# ser -P /var/run/ser.pid -dddd -g serfifo
Segmentation fault
Thanks. It seems I never tried group= myself :-)
It's fixed on the cvs (rel_0_8_11, rel_0_8_12 and HEAD), so either
update or apply the attacged patch.
Andrei
------------------------------------------------------------------------
Index: main.c
===================================================================
RCS file: /cvsroot/ser/sip_router/main.c,v
retrieving revision 1.168
diff -u -r1.168 main.c
--- main.c 2003/10/12 15:09:08 1.168
+++ main.c 2003/11/26 23:34:48
@@ -1523,7 +1523,7 @@
}
}
if (group){
- gid=strtol(user, &tmp, 10);
+ gid=strtol(group, &tmp, 10);
if ((tmp==0) ||(*tmp)){
/* maybe it's a string */
gr_entry=getgrnam(group);
9:23 a.m.
New subject: [Serusers] Fw: Serweb problems - 0.8.12
On Nov 26, 2003 at 17:43, Jim Burwell <jimb(a)jsbc.cc> wrote:
I found another little bug, this time with the
"fifo_mode" directive in
the ser.cfg file. Since the YACC/Bison config defines the directive as
a integer type, you can only use decimal integers. Therefore, config
lines such as "fifo_mode=0660" will be interpreted as "660" DECIMAL,
resulting in unexpected modes being set. If you use the decimal number
"432", the equivelant of octal "660" it sets modes as expected.
I know about this. It is fixed on 0.8.12 and on cvs head. Since 0.8.12
is our new stable release I didn't backport it to 0.8.11.
(it is very easy to do it, just copy a few lines from 0.8.12 cfg.lex to
0.8.11 cfg.lex, but it's better to switch to 0.8.12)
Andrei
7471
days inactive
7474
days old
9 comments
5 participants
participants (5)
-
Andrei Pelinescu-Onciul -
Jim Burwell -
Jon Ole Nome -
Klaus Darilion -
Olle E. Johansson