Re: [Serusers] [Serweb-users] OpenSER and SERWeb problems logging on (that old chestnut)
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/serhttp://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.
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.
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:
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.
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:
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!
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:
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:
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.
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.
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):
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@iptel.org 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?
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
See inline
On 6/7/07, Stephen McVarnock stephen.mcvarnock@aepona.com wrote:
Nope. I have these messages all the time. Nothing to do with stalling, although, i cant explain to you why they are generated.
I dont know about OpenSER really, but in SER i set fifo permissions from config file:
fifo_mode=766
Hope that helps.
-
Andrey Kuprianov -
flavio -
Karel Kozlik -
Stephen McVarnock