Autologin for PMA in trunk #1521 doesn´t work ? - Printable Version +- ispCP - Board - Support (http://www.isp-control.net/forum) +-- Forum: ispCP Omega Support Area (/forum-30.html) +--- Forum: Update/Upgrade (/forum-44.html) +--- Thread: Autologin for PMA in trunk #1521 doesn´t work ? (/thread-5755.html) |
Autologin for PMA in trunk #1521 doesn´t work ? - BeNe - 02-18-2009 06:13 PM I did upgrade ispCP form an older NighlyBuild to the trunk #1521 yesterday evening. ispCP just runs fine, but the autologin for PMA doesn´t work anymore I try to fix it on my own and compared it with my other Servers - but could not find the error. When i click on Databases -> phpMyAdmin which links to this URL: Code: https://admin.domain.tld/client/sql_auth.php?id=34 Code: https://admin.domain.tldpma/ Also there is no key or cookie session in the link to auth. I checked the the "sql_auth.php" about the Path and only see that we use the 'BASE_SERVER_VHOST'. This is set correct in the ispcp.conf like Code: BASE_SERVER_VHOST = admin.domain.tld Can somebody confirm this Error or went something wrong during my Upgrade ? // EDIT: PMA itself works fine. Greez BeNe RE: Autologin for PMA in trunk #1521 doesn´t work ? - sci2tech - 02-18-2009 07:08 PM (02-18-2009 06:13 PM)BeNe Wrote: HTTPS is the problem. If you use ssl you need to modify Code: $fp = fsockopen(Config::get('BASE_SERVER_IP'), 80, $errno, $errstr, 5); Code: $fp = fsockopen(Config::get('BASE_SERVER_IP'), 443, $errno, $errstr, 5); RE: Autologin for PMA in trunk #1521 doesn´t work ? - BeNe - 02-18-2009 07:35 PM I understand, thank you! After the change i get this Error in ispCP: Code: Error while authenticating! I tested it now with non SSL. There the URL is ok, but the auth doesn´t also not work. I only get the PMA Loginpage. But no Error in ispCP. Checked my config.inc.php which is up2date with the trunk. Code: /* Parameters set by ispCP */ I copied it simple from my old config.inc.php to the new one from the trunk. Is this the same "pma" user in my MySQL DB that we use? If so, i can set it again in the MySQL DB an in the Config. Or better, what is exactly needed for the autologin ? So i can take a look about it. Saw that a Ticket is open about the PMA User --> http://www.isp-control.net/ispcp/ticket/1676[/code] But i did the Update manually so this could not be the problem in my case. Greez BeNe RE: Autologin for PMA in trunk #1521 doesn´t work ? - sci2tech - 02-18-2009 07:50 PM Lets clarify a little . sql_auth.php perform like a proxy. It take from ispcp.conf BASE_SERVER_IP, (previvios was BASE_SERVER_VHOST), username and password is taken from database (password is decrypted) then using POST method with fsockopen sent to BASE_SERVER_IP/pma/ login data. If BASE_SERVER_IP is wrong (previous BASE_SERVER_VHOST, I droped this because it need to convert first into IP so I took BASE_SERVER_IP instead) or it cannot connect to it you will get an Error while authenticating!. If everything was ok server will return some cookies and a redirect. This are passed via setcookie and header functions to browser and you get are logged in. If something go wrong you also get a nice Error while authenticating!. If you alter some way how pma is default handled, you get errors (like you did with a port). I did explain this to eliminate every "custom errors". Anyway I`ll check it today / tonight and see what else can make it to fail. Maybe some characters from password and username? Can you provide some examples that do fail. Thank you for helping me with this. That ticket seems to be another problem. RE: Autologin for PMA in trunk #1521 doesn´t work ? - BeNe - 02-18-2009 09:00 PM Thank you for that detailed info, sci2tech! So lets talk about the non-ssl case to get a more default ispCP situation. The MySQL Users in the ispCP table "sql_user" are there and the passwords are crypted. Here is an example: Code: sqlu_id sqld_id sqlu_name sqlu_pass Code: http://admin.domain.tld/client/sql_auth.php?id=12 After a click on this PMA Link the URL is: Code: http://admin.domain.tld/pma/index.php?lang=de-utf-8&convcharset=utf-8&collation_connection=utf8_general_ci&token=a39395b51c7241e541edd0b04XXXXXX&phpMyAdmin=xzFfmqN57pXiRpzLKIAL-XXXXXX The Username is directly in the Form "v126XXX" - correct! The Password is empty! Of course i can now type the password into the field and Login. This happend with _every_ Login, so the problem can´t be any special chars in the Password/Username/DBName Here is the access.log Code: 62.75.XX.XX - - [18/Feb/2009:10:46:58 +0000] "POST /pma/ HTTP/1.1" 302 - Greez BeNe RE: Autologin for PMA in trunk #1521 doesn´t work ? - sci2tech - 02-18-2009 09:05 PM Can you please test this file: Code: <?php RE: Autologin for PMA in trunk #1521 doesn´t work ? - BeNe - 02-18-2009 09:27 PM Tested, but this does not solve the problem. Same situation. Greez BeNe RE: Autologin for PMA in trunk #1521 doesn´t work ? - sci2tech - 02-18-2009 09:29 PM Bene do you have time to track this down? If yes add me to yahoo messenger (sci2tech). BTW delete browsers cookies si cache. RE: Autologin for PMA in trunk #1521 doesn´t work ? - BeNe - 02-18-2009 09:32 PM Yes, i have time! But the only messanger i use every half year is ICQ. Maybe we can get there togehter ? Or in a other chat ? Greez BeNe RE: Autologin for PMA in trunk #1521 doesn´t work ? - sci2tech - 02-18-2009 09:40 PM Do not have icq. maibe irc? chat.freenode.net ? http://www.isp-control.net/documentation/chat |