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

[Stephen McVarnock]

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
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>