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