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

Just one thoughts.. Have you installed pear with Log module? pear list to verify!! Bye, F. 2007/6/1, Stephen McVarnock <stephen.mcvarnock(a)aepona.com>om>: > 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(a)aepona.com>om>: >> >>> Thanks for the previous advice flavio. >>> >>> I am ALMOSt able to log on to SerWeb but whilst the log

>>> 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(a)aepona.com>om>: >>> >>> >>> 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

>>> 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(a)lists.iptel.org >>> http://lists.iptel.org/mailman/listinfo/serusers >>> >>> >> >