ispCP - Board - Support
Login Problems after Upgrade from 1.0.6 to 1.0.7RC1 - 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: Login Problems after Upgrade from 1.0.6 to 1.0.7RC1 (/thread-11717.html)



Login Problems after Upgrade from 1.0.6 to 1.0.7RC1 - MasterTH - 09-21-2010 05:19 PM

Hello,

sry for my bad english, but nuxwin suggested me to post this problem in the english spoken section. German Thread

First, i know thats not really good to use an RC in a productive environment, but in past i made good expiriences with RCs from ispcp, also nightly versions.

Now the problem,
I updated my ISPCP-Installation vom 1.0.6 to 1.0.7 on sunday. After that, the login into the Admin-Section wasn't possible. I always encouter into following Error-Message

Code:
Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute. - Query: SELECT `admin_id`, `created_by`, `admin_type` FROM `admin` WHERE `admin_id` = ? ;

After this i recieve an email from system:
Code:
Dear admin,

An exception with the following message was raised in file
/var/www/ispcp/gui/include/sql.php (Line: 90):

=================================================================

Cannot execute queries while other unbuffered queries are active.
Consider using PDOStatement::fetchAll(). Alternatively, if your code
is only ever going to run against mysql, you may enable query
buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
- Query:
SELECT
*
FROM
`custom_menus`
WHERE
`menu_level` = 'admin'
;

=================================================================

Debug backtrace:
---------------

File: /var/www/ispcp/gui/include/admin-functions.php (Line: 144)
Function: exec_query()
File: /var/www/ispcp/gui/admin/index.php (Line: 188)
Function: gen_admin_mainmenu()

Additional information:
----------------------

Http User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de;
rv:1.9.2.8) Gecko/20100722 Firefox/3.6.8 ( .NET CLR 3.5.30729)
Request Uri: /admin/index.php
Remote Addr: 79.240.206.86
Server Addr:

after this, i thougt make an reupgrade to 1.0.6 will fix my problems, but this wasn't really good. After that no Mail-Access was possible. So i went back to 1.0.7RC1. I found out that the problem was in double-crypting the passwords in the database. After replacing the mail_users table with a backup the regeneration process for mailboxes set the right passwords.


my server is running under etch, php5.2.0-etch8... (if u need something else, please ask me, i'll try to give it to you)


Yesterday i searched a long time in google and this forum. Then i tried to change
Code:
        if (version_compare(PHP_VERSION, '5.2.5', '<')) {
            if (preg_match('/(ALTER |CREATE |DROP |GRANT |REVOKE |FLUSH )/i',
                $stmt)) {

                $this->_db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, true);
            } else {
                $this->_db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, false);
            }
        }

into

Code:
        if (version_compare(PHP_VERSION, '5.2.5', '<')) {
            if (preg_match('/(ALTER |CREATE |DROP |GRANT |REVOKE |FLUSH )/i',
                $stmt)) {

                $this->_db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, true);
            } else {
                $this->_db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, true);
            }
        }

after this i always recieve the message, that passwords incorrect. but i know there's an option to set a new password. tried this for an domain-account. Entered the new sent password, nothing happens, just get back to the login-page.


Right now, the Admin-Login doesn't work, and i don't know what else to do...


Please help. Thanks a lot!!!


RE: Login Problems after Upgrade from 1.0.6 to 1.0.7RC1 - Nuxwin - 09-21-2010 05:28 PM

Ok ;

The better is to help you via a support session. I recommends you to install teamspeak on your desktop and then invite me by providing the relevant credentials (teamspeak). PM me.

Why ? Because first, ispCP support for etch is ended already since few month and so, some test are needed on etch. I've not etch, I've only Lenny and Squeeze.

Of course, the support will be free here.


RE: Login Problems after Upgrade from 1.0.6 to 1.0.7RC1 - sci2tech - 09-21-2010 05:38 PM

engine in rc1 is not compatible with etch.


RE: Login Problems after Upgrade from 1.0.6 to 1.0.7RC1 - MasterTH - 09-21-2010 05:40 PM

ok, thats not good,

what do i have to do to roll back to 1.0.6 cleanly?
Documentation:

ispCP Version 1.0.7 RC1
INSTALL Script 2.7
Maintainer ispCP DevTeam
Linux Distros Debian Etch, Lenny, Squeeze
Last Update 04.08.2010

http://isp-control.net/documentation/start:upgrade:debian
if etch isn't supported this has to be changed (just a note)


RE: Login Problems after Upgrade from 1.0.6 to 1.0.7RC1 - Nuxwin - 09-21-2010 06:20 PM

Sorry but you use etch so if you want support, upgrade to Lenny.
(09-21-2010 05:40 PM)MasterTH Wrote:  ok, thats not good,

what do i have to do to roll back to 1.0.6 cleanly?
Documentation:

ispCP Version 1.0.7 RC1
INSTALL Script 2.7
Maintainer ispCP DevTeam
Linux Distros Debian Etch, Lenny, Squeeze
Last Update 04.08.2010

http://isp-control.net/documentation/start:upgrade:debian
if etch isn't supported this has to be changed (just a note)

The up to date documentation is in the ispCP archive. And then, if you have downloaded the archive, you have surely seen that the package file for etch was removed. so...


RE: Login Problems after Upgrade from 1.0.6 to 1.0.7RC1 - MasterTH - 09-21-2010 07:45 PM

fixed the problem....
did a rollback to 1.0.6 from a backup....


RE: Login Problems after Upgrade from 1.0.6 to 1.0.7RC1 - Nuxwin - 09-21-2010 08:08 PM

So you will live with 1.0.6 and etch for 10 year again ? God..


RE: Login Problems after Upgrade from 1.0.6 to 1.0.7RC1 - MasterTH - 09-21-2010 08:20 PM

no not really Wink

but i won't do the update now.


Big Thanks for spending time on this problem.
(09-21-2010 06:20 PM)Nuxwin Wrote:  The up to date documentation is in the ispCP archive. And then, if you have downloaded the archive, you have surely seen that the package file for etch was removed. so...


oh i didn't know that, and nope i didn't realize