<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
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.<br>
<br>
- Jim<br>
<br>
<br>
Jon Ole Nome wrote:<br>
<blockquote type="cite"
cite="mid000b01c3b39d$a2c85060$e60110ac@avitrans.biz">
<pre wrap="">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" <a class="moz-txt-link-rfc2396E" href="mailto:oej@edvina.net"><oej@edvina.net></a>
To: "Klaus Darilion" <a class="moz-txt-link-rfc2396E" href="mailto:darilion@ict.tuwien.ac.at"><darilion@ict.tuwien.ac.at></a>
Cc: "Jon Ole Nome" <a class="moz-txt-link-rfc2396E" href="mailto:jonome@avitrans.no"><jonome@avitrans.no></a>; <a class="moz-txt-link-rfc2396E" href="mailto:serusers@lists.iptel.org"><serusers@lists.iptel.org></a>
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:
</pre>
<blockquote type="cite">
<pre wrap="">Sorry, no answers left, you have to debug the php script.
Klaus
-----Original Message-----
*From:* Jon Ole Nome [<a class="moz-txt-link-freetext" href="mailto:jonome@avitrans.no">mailto:jonome@avitrans.no</a>]
*Sent:* Monday, November 24, 2003 10:51 PM
*To:* Klaus Darilion
*Cc:* <a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a>
*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 <a class="moz-txt-link-rfc2396E" href="mailto:darilion@ict.tuwien.ac.at"><mailto:darilion@ict.tuwien.ac.at></a>
*To:* Jon Ole Nome <a class="moz-txt-link-rfc2396E" href="mailto:jonome@avitrans.no"><mailto:jonome@avitrans.no></a>
*Cc:* <a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a> <a class="moz-txt-link-rfc2396E" href="mailto:serusers@lists.iptel.org"><mailto:serusers@lists.iptel.org></a>
*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 [<a class="moz-txt-link-freetext" href="mailto:jonome@avitrans.no">mailto:jonome@avitrans.no</a>]
*Sent:* Monday, November 24, 2003 10:32 PM
*To:* Klaus Darilion
*Cc:* <a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a> <a class="moz-txt-link-rfc2396E" href="mailto:serusers@lists.iptel.org"><mailto:serusers@lists.iptel.org></a>
*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 <a class="moz-txt-link-rfc2396E" href="mailto:darilion@ict.tuwien.ac.at"><mailto:darilion@ict.tuwien.ac.at></a>
*To:* Jon Ole Nome <a class="moz-txt-link-rfc2396E" href="mailto:jonome@avitrans.no"><mailto:jonome@avitrans.no></a>
*Cc:* <a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a> <a class="moz-txt-link-rfc2396E" href="mailto:serusers@lists.iptel.org"><mailto:serusers@lists.iptel.org></a>
*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
</pre>
</blockquote>
<pre wrap=""><!---->ser.cfg.
</pre>
<blockquote type="cite">
<pre wrap=""> klaus
-----Original Message-----
*From:* Jon Ole Nome [<a class="moz-txt-link-freetext" href="mailto:jonome@avitrans.no">mailto:jonome@avitrans.no</a>]
*Sent:* Monday, November 24, 2003 9:56 PM
*To:* Klaus Darilion
*Cc:* <a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a> <a class="moz-txt-link-rfc2396E" href="mailto:serusers@lists.iptel.org"><mailto:serusers@lists.iptel.org></a>
*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
<a class="moz-txt-link-rfc2396E" href="mailto:darilion@ict.tuwien.ac.at"><mailto:darilion@ict.tuwien.ac.at></a>
*To:* Jon Ole Nome <a class="moz-txt-link-rfc2396E" href="mailto:jonome@avitrans.no"><mailto:jonome@avitrans.no></a>
*Cc:* <a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a>
<a class="moz-txt-link-rfc2396E" href="mailto:serusers@lists.iptel.org"><mailto:serusers@lists.iptel.org></a>
*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
[<a class="moz-txt-link-freetext" href="mailto:jonome@avitrans.no">mailto:jonome@avitrans.no</a>]
*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
<a class="moz-txt-link-rfc2396E" href="mailto:darilion@ict.tuwien.ac.at"><mailto:darilion@ict.tuwien.ac.at></a>
*To:* Jon Ole Nome
<a class="moz-txt-link-rfc2396E" href="mailto:jonome@avitrans.no"><mailto:jonome@avitrans.no></a> ;
<a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a>
<a class="moz-txt-link-rfc2396E" href="mailto:serusers@lists.iptel.org"><mailto:serusers@lists.iptel.org></a>
*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
[<a class="moz-txt-link-freetext" href="mailto:jonome@avitrans.no">mailto:jonome@avitrans.no</a>]
*Sent:* Monday, November 24, 2003
9:29 PM
*To:* <a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a>
<a class="moz-txt-link-rfc2396E" href="mailto:serusers@lists.iptel.org"><mailto:serusers@lists.iptel.org></a>
*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 <a class="moz-txt-link-abbreviated" href="mailto:info@ringsip.com">info@ringsip.com</a>
<a class="moz-txt-link-rfc2396E" href="mailto:info@ringsip.com"><mailto:info@ringsip.com></a> 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
<a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a>
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
<pre wrap=""><!---->
--
*** Olle E. Johansson, <a class="moz-txt-link-abbreviated" href="mailto:oej@edvina.net">oej@edvina.net</a>
Mobile +46 70 593 68 51, Edvina AB, <a class="moz-txt-link-freetext" href="http://www.edvina.net">http://www.edvina.net</a>
Runbovägen 10, 192 48 Sollentuna, Sweden
Phone: +46 8 594 78 810, Fax: +46 8 594 78 820
_______________________________________________
Serusers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a>
<a class="moz-txt-link-freetext" href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="78">--
+---------------------------------------------------------------------------+
| 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: <a class="moz-txt-link-abbreviated" href="mailto:jimb@jsbc.cc">jimb@jsbc.cc</a> ICQ UIN: 1695089 |
+---------------------------------------------------------------------------+
| Reply problems ? Turn off the "sign" function in email prog. Blame MS. |
+---------------------------------------------------------------------------+
</pre>
</body>
</html>