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

[flavio]

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