[Serusers] [Serweb-users] OpenSER and SERWeb problems logging on (that old chestnut)

[Karel Kozlik]

Hi Steve,
I think you should check configuration of "session" in your php.ini

Karel

Stephen McVarnock napsal(a):
> well, a new problem has been encountered - SerWeb seems to be stalling 
> when I try to log on.
> 
> I see the following in my log file using one idt:-
> 
> Jun 01 15:24:32 serweb [debug] User login: redirecting to page: 
> my_account.php
> Jun 01 15:24:33 serweb [debug] Html form was not assigned to APU 
> apu_aliases3.  Useing default.
> Jun 01 15:24:33 serweb [debug] Html form was not assigned to APU 
> apu_acl4.  Useing default.
> 
> this is using the id I have added to the subscriber table in openser db 
> (it was present in the mysql db).
> 
> I then added the id that was in openser db to the mysql.user table 
> (confused yet?) - with it I see
> 
> Jun 01 15:24:32 serweb [debug] User login: redirecting to page: 
> my_account.php and then the same old
> 'Session expired'.
> 
> I feel this is quite close to being resolved and its just something 
> foolish thats preventing it from working....
> probably some obscure config file...
> 
> Steve.
> 
> 
> 
>> When I had the problem as you, after upgrade php to 4.4.7 from 4.4.4,
>> it was because I've deleted admin/heslo user on mysql.user table and
>> then added into by mysql prompt manually.
>> So I backup my ser ad mysql db and I reload mysql ser script to
>> rebuild and populate that tables. In the end, all works fine.
>>
>> Sorry for nothing that may help you! :-)
>>
>> F.
>>
>>
>> 2007/6/1, Stephen McVarnock <stephen.mcvarnock at aepona.com>:
>>
>>> Aye,
>>>   pear with log module is installed on the machine.
>>>
>>> Steve.
>>>
>>>> Just one thoughts..
>>>>
>>>> Have you installed pear with Log module?
>>>>
>>>> pear list
>>>>
>>>> to verify!!
>>>>
>>>> Bye,
>>>>
>>>> F.
>>>>
>>>>
>>>>
>>>> 2007/6/1, Stephen McVarnock <stephen.mcvarnock at aepona.com>:
>>>>
>>>>> well, the log suggests that I have logged on successfully. The last
>>>>> action that seems to be carried out is a
>>>>> check on the usr_preferences table...and then nothing. The Session
>>>>> Expired screen is still coming up.
>>>>>
>>>>> This is the check on the usr_preferences table - it looks ok and the
>>>>> table is populated in the db.
>>>>>
>>>>> select attribute from usr_preferences where (username='admin' and
>>>>> domain='localhost');
>>>>>
>>>>> any more thoughts?
>>>>>
>>>>> p.s. thanks for all your help on this!
>>>>>
>>>>>> Verify your mysql query log if yuo really login into serweb.
>>>>>>
>>>>>> http://dev.mysql.com/doc/refman/5.0/en/query-log.html
>>>>>>
>>>>>> I hope this help you.
>>>>>>
>>>>>> F.
>>>>>>
>>>>>> 2007/5/31, Stephen McVarnock <stephen.mcvarnock at aepona.com>:
>>>>>>
>>>>>>>  Thanks for the previous advice flavio.
>>>>>>>
>>>>>>>  I am ALMOSt able to log on to SerWeb but whilst the log 
>>> indicates I
>>>>>>> have
>>>>>>> successfully logged on the moment I
>>>>>>>  do my session seems to expire and I get the following.
>>>>>>>
>>>>>>>
>>>>>>> Session expired
>>>>>>>  Your session expired, please relogin.
>>>>>>>  Can anybody shed any light on the issue and how to resolve it?
>>>>>>>
>>>>>>>  Regards,
>>>>>>>     Steve.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Try to run mysqldb.sh script in ser src code dir, after bakcup
>>>>> your db.
>>>>>>>  It creates ser user (with password heslo) to access mysql ser db,
>>>>> with
>>>>>>>  right grants, also via serweb.
>>>>>>>  If you have DB error connection too, try with --old-password
>>>>> option as
>>>>>>>  previous suggested.
>>>>>>>
>>>>>>>  I solved that problem so :-)
>>>>>>>
>>>>>>>  bye
>>>>>>>
>>>>>>>  F.
>>>>>>>
>>>>>>>
>>>>>>>  2007/5/29, Stephen McVarnock <stephen.mcvarnock at aepona.com>:
>>>>>>>
>>>>>>>
>>>>>>>   Actually, I use another username (openser) to log on directly to
>>>>> the
>>>>>>>  database. This user id was created by the mysqldb.sh script with
>>>>>>> OpenSer.
>>>>>>>
>>>>>>>   Should it be added to the subscriber/admin_privileges database?
>>>>>>>
>>>>>>>   Strangely, no matter what userid I try I get the same output 
>>> in the
>>>>>>> log as
>>>>>>>  shown below i.e. userid always seems to be 'ser' and domain is
>>>>>>> 'localhost'.
>>>>>>>
>>>>>>>   Steve.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>  May 29 11:49:19 serweb [error] file:
>>>>>>>  /opt/serweb-0.9.6/html/data_layer.php:465: DB Error: connect
>>>>> failed -
>>>>>>>  [nativecode=Access denied for user 'ser'@'localhost' (using
>>>>>>> password: YES)]
>>>>>>>  ** mysql://ser:heslo@localhost/ser
>>>>>>>
>>>>>>>   Do  you access mysql with mysql -u ser -p
>>>>>>>   $>password: heslo
>>>>>>>   ?
>>>>>>>
>>>>>>>   If yes, try to start mysqld with --old-password option following
>>>>>>> tips at
>>>>>>>  url:
>>>>>>> http://dev.mysql.com/doc/refman/5.0/en/old-client.html
>>>>>>>
>>>>>>>   Bye,
>>>>>>>   F.
>>>>>>>
>>>>>>>
>>>>>>>   --
>>>>>>>   ********************************
>>>>>>>   * (o<     ing. Patria Flavio
>>>>>>>   * //\      phone 0823451358
>>>>>>>   * V_/_  mobile 3407873357
>>>>>>>   *
>>>>>>>   ********************************
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Serusers mailing list
>>>>>>> Serusers at lists.iptel.org
>>>>>>> http://lists.iptel.org/mailman/listinfo/serusers
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
> 
> _______________________________________________
> Serusers mailing list
> Serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers