[Serusers] [Serweb-users] OpenSER and SERWeb problems logging on (that old chestnut)
Stephen McVarnock
stephen.mcvarnock at aepona.com
Fri Jun 1 12:18:10 CEST 2007
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
>>
>>
>
>
More information about the sr-users
mailing list