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

flavio flavio.patria at gmail.com
Fri Jun 1 13:09:54 CEST 2007


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


-- 
********************************
* (o<     ing. Patria Flavio
* //\      phone 0823451358
* V_/_  mobile 3407873357
*
********************************



More information about the sr-users mailing list