Autologin for PMA in trunk #1521 doesn´t work ?

[BeNe]

Let´s go back to the roots -> IRC.
I´m in the channel now.

Greez BeNe

[Shayne]

Hey guys

I did a nightly update and am having a little difficulty with the pms as well. When I click on the phpmyadmin link from ISPcp it directs me to this page

http://**.**.**.**/client/error.php?lang=en&dir=ltr&type=Error&error=You+must+set+SignonURL!

And shows the Error 404!

/client/error.php

Page not found error.

If I go direct to the pma/index.php I get this phpMyAdmin - Error

You must set SignonURL!

They both seem to be related and Im sure its something simple but I just cant find it

[steff517]

Hi,

I had the same issue and found a solution to this. Line 51 of sql_auth.php must be

Code:

$fp = fsockopen('ssl://'.Config::get('BASE_SERVER_IP'), 443, $errno, $errstr, 5);

Yes, it needs to connect to port 443 but it cannot just communicate like before b/c it's now an ecrypted connection and fsockopen just opens a plain connection. With the 'ssl://' prefix you tell the function to use transparent ssl encryption. And - voila, works!

[Shayne]

(03-02-2009 04:44 AM)steff517 Wrote:  Hi,

I had the same issue and found a solution to this. Line 51 of sql_auth.php must be

Code:

$fp = fsockopen('ssl://'.Config::get('BASE_SERVER_IP'), 443, $errno, $errstr, 5);

Yes, it needs to connect to port 443 but it cannot just communicate like before b/c it's now an ecrypted connection and fsockopen just opens a plain connection. With the 'ssl://' prefix you tell the function to use transparent ssl encryption. And - voila, works!

Nope..now it just gives Authentication Failure!!

[sci2tech]

Try run this script to check if passwords are correctly encrypted. Save this script in /var/www/ispcp/engine and run it from that folder.
@Bene: steff517 did see what was wrong on trying to make it work with ssl.
@Shaine:

Quote:http://**.**.**.**

you do not have a domain server? Why you use ip?

[BeNe]

I will try it

Greez BeNe

[Arturo]

Here is a fix if those do not work.

This fix applies if you see 404 error when you go to http://yourserverip/pma/

The fix: run this commands

cd /var/www/ispcp/gui
ln -s tools/pma/

The last one must be run as root. This worked for me

[Shayne]

(03-03-2009 01:41 AM)sci2tech Wrote:  Try run this script to check if passwords are correctly encrypted. Save this script in /var/www/ispcp/engine and run it from that folder.
@Bene: steff517 did see what was wrong on trying to make it work with ssl.
@Shaine:

Quote:http://**.**.**.**

you do not have a domain server? Why you use ip?

I do have a name server but currently my ISP is forwarding to my Box.
When I run the script I get:

Quote:Name "main::db_host" used only once: possible typo at ./fixsql line 9.
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DBI connect('database=wag1_db1;host=localhost','wag_sqluser',...) failed: Access denied for user 'wag_sqluser'@'localhost' (using password: YES) at ./fixsql line 9
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Ending...
DBI connect('database=gol1_db1;host=localhost','gol_sqluser',...) failed: Access denied for user 'gol_sqluser'@'localhost' (using password: YES) at ./fixsql line 9
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Ending...
DBI connect('database=tecclient;host=localhost','webtec',...) failed: Access denied for user 'webtec'@'localhost' (using password: YES) at ./fixsql line 9
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Ending...
DBI connect('database=motoeurodb;host=localhost','mot_sqluser1',...) failed: Access denied for user 'mot_sqluser1'@'localhost' (using password: YES) at ./fixsql line 9
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Ending...
User name: wag_sqluser -> password seems already encrypted. Testing... Password is encrypted. Next...
User name: gol_sqluser -> password seems already encrypted. Testing... Password is encrypted. Next...
User name: webtec -> password seems already encrypted. Testing... Password is encrypted. Next...
User name: mot_sqluser1 -> password seems already encrypted. Testing... Password is encrypted. Next...

is this fine??

---

Also after running Stef517 's fix I dont get the URL error anymore instead I get this error:
[attachment=645]

[Shayne]

Anyone???

[BeNe]

Code:

DBI connect('database=tecclient;host=localhost','webtec',...) failed: Access denied for user 'webtec'@'localhost' (using password: YES)

Sure that this is the right PW ?

Greez BeNe