[Serusers] Fw: Serweb problems - 0.8.12
Jim Burwell
jimb at jsbc.cc
Tue Nov 25 23:49:11 CET 2003
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 at edvina.net>
>To: "Klaus Darilion" <darilion at ict.tuwien.ac.at>
>Cc: "Jon Ole Nome" <jonome at avitrans.no>; <serusers at 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 at avitrans.no]
>> *Sent:* Monday, November 24, 2003 10:51 PM
>> *To:* Klaus Darilion
>> *Cc:* serusers at 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 at ict.tuwien.ac.at>
>> *To:* Jon Ole Nome <mailto:jonome at avitrans.no>
>> *Cc:* serusers at lists.iptel.org <mailto:serusers at 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 at avitrans.no]
>> *Sent:* Monday, November 24, 2003 10:32 PM
>> *To:* Klaus Darilion
>> *Cc:* serusers at lists.iptel.org <mailto:serusers at 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 at ict.tuwien.ac.at>
>> *To:* Jon Ole Nome <mailto:jonome at avitrans.no>
>> *Cc:* serusers at lists.iptel.org <mailto:serusers at 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 at avitrans.no]
>> *Sent:* Monday, November 24, 2003 9:56 PM
>> *To:* Klaus Darilion
>> *Cc:* serusers at lists.iptel.org <mailto:serusers at 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 at ict.tuwien.ac.at>
>> *To:* Jon Ole Nome <mailto:jonome at avitrans.no>
>> *Cc:* serusers at lists.iptel.org
>> <mailto:serusers at 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 at 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 at ict.tuwien.ac.at>
>> *To:* Jon Ole Nome
>> <mailto:jonome at avitrans.no> ;
>> serusers at lists.iptel.org
>> <mailto:serusers at 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 at avitrans.no]
>> *Sent:* Monday, November 24, 2003
>> 9:29 PM
>> *To:* serusers at lists.iptel.org
>> <mailto:serusers at 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 at ringsip.com
>> <mailto:info at 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 at lists.iptel.org
>>http://lists.iptel.org/mailman/listinfo/serusers
>>
>>
>
>
>--
>*** Olle E. Johansson, oej at 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 at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
>
>
--
+---------------------------------------------------------------------------+
| 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 at jsbc.cc ICQ UIN: 1695089 |
+---------------------------------------------------------------------------+
| Reply problems ? Turn off the "sign" function in email prog. Blame MS. |
+---------------------------------------------------------------------------+
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20031125/e645c5ba/attachment.htm>
More information about the sr-users
mailing list