1 Jun
2007
1 Jun
'07
5:27 p.m.
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(a)aepona.com>om>:
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(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
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(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
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(a)lists.iptel.org
>> http://lists.iptel.org/mailman/listinfo/serusers
>>
>>
>
>