Re: [Serusers] [Serweb-users] OpenSER and SERWeb problems logging on (that old chestnut)
29 May
2007
29 May
'07
8:46 p.m.
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<http://www.voipuser.org/ship_to.php?url=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
*
********************************
29 May
29 May
8:57 p.m.
New subject: [Serusers] [Serweb-users] OpenSER and SERWeb problems logging on (that old chestnut)
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
<http://www.voipuser.org/ship_to.php?url=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
*
********************************
9:12 p.m.
New subject: [Serusers] [Serweb-users] OpenSER and SERWeb problems logging on (that old chestnut)
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
*
********************************
--
********************************
* (o< ing. Patria Flavio
* //\ phone 0823451358
* V_/_ mobile 3407873357
*
********************************
31 May
31 May
8:35 p.m.
New subject: [Serusers] [Serweb-users] OpenSER and SERWeb problems logging on (that old chestnut)
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
*
********************************
9:19 p.m.
New subject: [Serusers] [Serweb-users] OpenSER and SERWeb problems logging on (that old chestnut)
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
--
********************************
* (o< ing. Patria Flavio
* //\ phone 0823451358
* V_/_ mobile 3407873357
*
********************************
1 Jun
1 Jun
3:18 p.m.
New subject: [Serusers] [Serweb-users] OpenSER and SERWeb problems logging on (that old chestnut)
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
4:09 p.m.
New subject: [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!
--
********************************
* (o< ing. Patria Flavio
* //\ phone 0823451358
* V_/_ mobile 3407873357
*
********************************
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
5:18 p.m.
New subject: [Serusers] [Serweb-users] OpenSER and SERWeb problems logging on (that old chestnut)
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
5:46 p.m.
New subject: [Serusers] [Serweb-users] OpenSER and SERWeb problems logging on (that old chestnut)
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.
--
********************************
* (o< ing. Patria Flavio
* //\ phone 0823451358
* V_/_ mobile 3407873357
*
********************************
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
>
>
7:27 p.m.
New subject: [Serusers] [Serweb-users] OpenSER and SERWeb problems logging on (that old chestnut)
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
>>
>>
>
>
6 Jun
6 Jun
12:20 p.m.
New subject: [Serusers] [Serweb-users] OpenSER and SERWeb problems logging on (that old chestnut)
Hi Steve,
I think you should check configuration of "session" in your php.ini
Karel
Stephen McVarnock napsal(a):
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>:
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers 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
>>>
>>>
>>
>
9:29 p.m.
New subject: [Serusers] SERWeb stalling
Has anyone every seen SerWeb stalling intermittently?
I have looked at my Apache logs and the SerWeb logs but can't see
anything unusual.
But every so often (in fact, frequently) SerWeb grinds to a halt and I
have to restart
my proxy and Apache.
Anyone else experienced (and, more importantly, resolved) this?
Steve.
7 Jun
7 Jun
10:49 a.m.
New subject: [Serusers] SERWeb stalling
Hi,
I never meet this behaviour. Please let me know if you find any cause of
this grinds. Is restarting of proxy necessary? I dont think so. But if
you have to restart apacha, there could be something wrong with your
apache/php installation/configuration.
Karel
Stephen McVarnock napsal(a):
Has anyone every seen SerWeb stalling intermittently?
I have looked at my Apache logs and the SerWeb logs but can't see
anything unusual.
But every so often (in fact, frequently) SerWeb grinds to a halt and I
have to restart
my proxy and Apache.
Anyone else experienced (and, more importantly, resolved) this?
Steve.
5:59 p.m.
New subject: [Serusers] SERWeb stalling
Looks like Apache problem to me. Latest versions, i.e. Apache 2.x are
not working well these days with MySQL and PHP. Which Apache are you
using and which OS? In my case i used installation from packages on
either Ubuntu 6.x/7.x ( i think manual install of Apache/MySQL/PHP
from source might be a better idea).
On 6/7/07, Karel Kozlik <karel(a)iptel.org> wrote:
Hi,
I never meet this behaviour. Please let me know if you find any cause of
this grinds. Is restarting of proxy necessary? I dont think so. But if
you have to restart apacha, there could be something wrong with your
apache/php installation/configuration.
Karel
Stephen McVarnock napsal(a):
Has anyone every seen SerWeb stalling
intermittently?
I have looked at my Apache logs and the SerWeb logs but can't see
anything unusual.
But every so often (in fact, frequently) SerWeb grinds to a halt and I
have to restart
my proxy and Apache.
Anyone else experienced (and, more importantly, resolved) this?
Steve.
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
7:01 p.m.
New subject: [Serusers] SERWeb stalling
Well, the Apache version is 2.0.59. This is running on SunOS 5.9.
However I have noticed that it is not enough to just restart Apache - I
also have to restart openser!
I am noticing the following entries in the serweb log - these lines are
only generated when clicking on the "my account" tab -
and it seems when I click on this tab I notice SerWeb stalling.
Jun 07 14:32:55 serweb [debug] Html form was not assigned to APU
apu_aliases3. Useing default.
Jun 07 14:32:55 serweb [debug] Html form was not assigned to APU
apu_acl4. Useing default
Could this be a symptom of the problem?
Secondly, I have noticed that the issue does not occur when I have
certain permissions set for the openser_fifo file. I normally see the
following on the
"my account" tab when first opened....
*"Warning*: fopen(/tmp/openser_fifo) [function.fopen
<http://delta:8081/serweb/user/function.fopen>]: failed to open stream:
Permission denied in */opt/serweb-0.9.6/html/functions.php* on line *345*
*Warning*: Cannot modify header information - headers already sent by
(output started at /opt/serweb-0.9.6/html/functions.php:345) in
*/opt/serweb-0.9.6/html/page.php* on line *35"
*So I would go in and chmod 777 the fifo file (overkill I know but bear
with me).
Later when I went back to the "my account" tab, SerWeb would stall......
However when the permissions remain at 660 on the fifo file the stall
problem does not happen but I do get the annoying warnings....
....so it appears to be a permissions issue (and who the owner of the
openser_fifo file actually is) that is the root cause of all this. We
can all ignore point 1!
I'll look into it a bit more and let you know what happens.
Thanks guys.
Steve
Looks like Apache problem to me. Latest versions, i.e.
Apache 2.x are
not working well these days with MySQL and PHP. Which Apache are you
using and which OS? In my case i used installation from packages on
either Ubuntu 6.x/7.x ( i think manual install of Apache/MySQL/PHP
from source might be a better idea).
On 6/7/07, Karel Kozlik <karel(a)iptel.org> wrote:
Hi,
I never meet this behaviour. Please let me know if you find any cause of
this grinds. Is restarting of proxy necessary? I dont think so. But if
you have to restart apacha, there could be something wrong with your
apache/php installation/configuration.
Karel
Stephen McVarnock napsal(a):
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
Has anyone every seen SerWeb stalling
intermittently?
I have looked at my Apache logs and the SerWeb logs but can't see
anything unusual.
But every so often (in fact, frequently) SerWeb grinds to a halt and I
have to restart
my proxy and Apache.
Anyone else experienced (and, more importantly, resolved) this?
Steve.
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
7:06 p.m.
New subject: [Serusers] SERWeb stalling
See inline
On 6/7/07, Stephen McVarnock <stephen.mcvarnock(a)aepona.com> wrote:
Well, the Apache version is 2.0.59. This is running on
SunOS 5.9.
However I have noticed that it is not enough to just restart Apache - I
also have to restart openser!
I am noticing the following entries in the serweb log - these lines are
only generated when clicking on the "my account" tab -
and it seems when I click on this tab I notice SerWeb stalling.
Jun 07 14:32:55 serweb [debug] Html form was not assigned to APU
apu_aliases3. Useing default.
Jun 07 14:32:55 serweb [debug] Html form was not assigned to APU
apu_acl4. Useing default
Could this be a symptom of the problem?
Nope. I have these messages all the time. Nothing to do with stalling,
although, i cant explain to you why they are generated.
Secondly, I have noticed that the issue does not occur
when I have
certain permissions set for the openser_fifo file. I normally see the
following on the
"my account" tab when first opened....
*"Warning*: fopen(/tmp/openser_fifo) [function.fopen
<http://delta:8081/serweb/user/function.fopen>]: failed to open stream:
Permission denied in */opt/serweb-0.9.6/html/functions.php* on line *345*
*Warning*: Cannot modify header information - headers already sent by
(output started at /opt/serweb-0.9.6/html/functions.php:345) in
*/opt/serweb-0.9.6/html/page.php* on line *35"
*So I would go in and chmod 777 the fifo file (overkill I know but bear
with me).
Later when I went back to the "my account" tab, SerWeb would stall......
However when the permissions remain at 660 on the fifo file the stall
problem does not happen but I do get the annoying warnings....
I dont know about OpenSER really, but in SER i set fifo permissions
from config file:
fifo_mode=766
Hope that helps.
....so it appears to be a permissions issue (and who the owner of the
openser_fifo file actually is) that is the root cause of all this. We
can all ignore point 1!
I'll look into it a bit more and let you know what happens.
Thanks guys.
Steve
Looks like Apache problem to me. Latest versions,
i.e. Apache 2.x are
not working well these days with MySQL and PHP. Which Apache are you
using and which OS? In my case i used installation from packages on
either Ubuntu 6.x/7.x ( i think manual install of Apache/MySQL/PHP
from source might be a better idea).
On 6/7/07, Karel Kozlik <karel(a)iptel.org> wrote:
Hi,
I never meet this behaviour. Please let me know if you find any cause of
this grinds. Is restarting of proxy necessary? I dont think so. But if
you have to restart apacha, there could be something wrong with your
apache/php installation/configuration.
Karel
Stephen McVarnock napsal(a):
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
Has anyone every seen SerWeb stalling
intermittently?
I have looked at my Apache logs and the SerWeb logs but can't see
anything unusual.
But every so often (in fact, frequently) SerWeb grinds to a halt and I
have to restart
my proxy and Apache.
Anyone else experienced (and, more importantly, resolved) this?
Steve.
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
6171
days inactive
6180
days old
15 comments
4 participants
participants (4)
-
Andrey Kuprianov -
flavio -
Karel Kozlik -
Stephen McVarnock