[Serusers] problem with serwev confirmation...

[Alistair Cunningham]

Barry,

You shouldn't need to delete pending users by hand. If it's not being 
done automatically, something's wrong.

Sure SER is running and is accessing the fifo? Try this command as root:

fuser -v /tmp/ser_fifo

It ought to list quite a few SER processes running.

If you'd like commercial help getting this fixed, I can ssh into your 
server and take a look if you like. It wouldn't be very much. Drop me an 
email off list if you're interested.

Alistair Cunningham,
Integrics Ltd,
Telephony, Database, Unix consulting worldwide
+44 (0)7870 699 479
http://integrics.com/


Barry Murphy wrote:
> Hi Alistair,
> 
> Same list different thread.
> 
> Yeah I did notice this mistake I made and corrected it, however since doing
> so, when I go to the confirmation page it says "opening page" with the vlue
> bar slowly moving across, never stops until timeout has exceeded. It's doing
> it's thing in the backround as it copys the user to subscribers but still
> not removing from pending, I may need to edit the code manually however
> didnt really want to do this. If I click the confirmation, see "Opening
> page" then click refresh  I get:
> 
> error in SQL query, line: 43
> We regret but your voipweb.fast.co.nz confirmation attempt failed.
> Please contact voip at fast.co.nz for further assistance.
> 
> Removing pended users, well I can do this at midnight every sunday maybe.
> 
> Barry
> 
> ----- Original Message -----
> From: "Alistair Cunningham" <acunningham at integrics.com>
> To: "Barry Murphy" <barry at unix.co.nz>
> Cc: <serusers at lists.iptel.org>
> Sent: Friday, March 11, 2005 8:57 AM
> Subject: Re: [Serusers] problem with serwev confirmation...
> 
> 
> 
>>Barry,
>>
>>(We seem to be meeting on more than one mailing list today!)
>>
>> From your output below, the fifo has owner 777, not permissions 777 -
>>perhaps you were doing chown when you meant chmod?
>>
>>The fifo needs to be writeable by the user your web server is running
>>as. On my lab system, it's:
>>
>>prw-rw-rw-  1 root root 0 Feb 21 10:53 /tmp/ser_fifo
>>
>>To get this, run the following commands as root:
>>
>>chown root.root /tmp/ser_fifo
>>chmod 0666 /tmp/ser_fifo
>>
>>On production systems, I like to make a 'ser' group, put the ser and
>>http server users in it, then chmod 0660 instead of 0666.
>>
>>Leaving the user in the pending table is a bit ugly, but the system will
>>probably still work. You may care to fire up the mysql command line
>>client, and do a 'delete from pending' when you know there's no-one in
>>the queue.
>>
>>Alistair Cunningham,
>>Integrics Ltd,
>>Telephony, Database, Unix consulting worldwide
>>+44 (0)7870 699 479
>>http://integrics.com/
>>
>>
>>Barry Murphy wrote:
>>
>>>Ok i've brought this up in the past but no one answered:
>>>
>>>1./ User signs up
>>>2./ User receives confirmation email
>>>3./ User clicks on URL
>>>4./ User receives:
>>>Warning: fopen(/tmp/ser_fifo): failed to open stream: Permission denied
> 
> in
> 
>>>/www/serweb/html/functions.php on line 206
>>>sorry -- cannot open write fifo
>>>We regret but your voipweb.fast.co.nz confirmation attempt failed.
>>>Please contact voip at fast.co.nz for further assistance.
>>>5./ In the backround user is actually added to subscription table but
> 
> left
> 
>>>in pending table too, is this a problem?
>>>
>>>prw-rw----  1 777  wheel  0 Mar 10 16:51 /tmp/ser_fifo
>>>I've tried chmod 777 this file many times, doesnt seem to help
>>>
>>>Any idea's people? Is this ser_fifo file needed, what does it do? How do
> 
> I
> 
>>>fix serweb?
>>>
>>>Barry
>>>
>>>P.S. Latest stable Serweb via cvs
>>>
>>>_______________________________________________
>>>Serusers mailing list
>>>serusers at lists.iptel.org
>>>http://lists.iptel.org/mailman/listinfo/serusers
>>>
>>>
>>
> 
> 
>