ispCP - Board - Support
no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - 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: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 (/thread-10789.html)

Pages: 1 2 3 4 5 6


RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - thoand - 05-27-2010 06:27 PM

I am not sure what it uses, it should use php5.

In the /etc/apache2/sites-enabled/ispcp.conf is the following domain entry:
Code:
# httpd [domain.tld] dmn group entry BEGIN.

<IfModule mod_cband.c>
    <CBandUser domain.tld>
        # CBandUserLimit 0Mi
        # CBandUserScoreboard /var/www/scoreboards/domain.tld
        # CBandUserPeriod 4W
        # CBandUserPeriodSlice 1W
        # CBandUserExceededURL http://admin.h1202717.stratoserver.net/errors/bw_exceeded.html
    </CBandUser>
</IfModule>


# httpd [moodle.domain.tld] sub entry BEGIN.
<VirtualHost 85.214.85.156:80>

    #
    #User vu2003
    #Group vu2003
    #

    <IfModule suexec_module>
           SuexecUserGroup vu2003 vu2003
    </IfModule>

    ServerAdmin     webmaster@domain.tld
    DocumentRoot    /var/www/virtual/domain.tld/moodle/htdocs

    ServerName      moodle.domain.tld
    ServerAlias     www.moodle.domain.tld moodle.domain.tld *.moodle.domain.tld

    Alias /errors /var/www/virtual/domain.tld/errors/

    RedirectMatch permanent ^/ftp[\/]?$         http://admin.h1202717.stratoserver.net/ftp/
    RedirectMatch permanent ^/pma[\/]?$         http://admin.h1202717.stratoserver.net/pma/
    RedirectMatch permanent ^/webmail[\/]?$     http://admin.h1202717.stratoserver.net/webmail/
    RedirectMatch permanent ^/ispcp[\/]?$       http://admin.h1202717.stratoserver.net/

    ErrorDocument 401 /errors/401.html
    ErrorDocument 403 /errors/403.html
    ErrorDocument 404 /errors/404.html
    ErrorDocument 500 /errors/500.html
    ErrorDocument 503 /errors/503.html

    <IfModule mod_cband.c>
        CBandUser domain.tld
    </IfModule>

    # httpd sub entry cgi support BEGIN.
    ScriptAlias /cgi-bin/ /var/www/virtual/domain.tld/moodle/cgi-bin/
    <Directory /var/www/virtual/domain.tld/moodle/cgi-bin>
        AllowOverride AuthConfig
        #Options ExecCGI
        Order allow,deny
        Allow from all
    </Directory>
    # httpd sub entry cgi support END.

    <Directory /var/www/virtual/domain.tld/moodle/htdocs>
        # httpd sub entry PHP support BEGIN.
        # httpd sub entry PHP support END.
        Options -Indexes Includes FollowSymLinks MultiViews
        AllowOverride All
        Order allow,deny
        Allow from all
    </Directory>

    # httpd sub entry PHP2 support BEGIN.
    <IfModule mod_php5.c>
        php_admin_value open_basedir "/var/www/virtual/domain.tld/:/var/www/virtual/domain.tld/phptmp/:/usr/share/php/"
        php_admin_value upload_tmp_dir "/var/www/virtual/domain.tld/phptmp/"
        php_admin_value session.save_path "/var/www/virtual/domain.tld/phptmp/"
        php_admin_value sendmail_path '/usr/sbin/sendmail -f vu2003 -t -i'
    </IfModule>
    <IfModule mod_fastcgi.c>
        ScriptAlias /php5/ /var/www/fcgi/domain.tld/
        <Directory "/var/www/fcgi/domain.tld">
            AllowOverride None
            Options +ExecCGI -MultiViews -Indexes
            Order allow,deny
            Allow from all
        </Directory>
    </IfModule>
    <IfModule mod_fcgid.c>
                Include /etc/apache2/mods-available/fcgid_ispcp.conf
        <Directory /var/www/virtual/domain.tld/moodle/htdocs>
            FCGIWrapper /var/www/fcgi/domain.tld/php5-fcgi-starter .php
            Options +ExecCGI
        </Directory>
        <Directory "/var/www/fcgi/domain.tld">
            AllowOverride None
            Options +ExecCGI MultiViews -Indexes
            Order allow,deny
            Allow from all
        </Directory>
    </IfModule>
    # httpd sub entry PHP2 support END.

    Include /etc/apache2/ispcp/moodle.domain.tld.conf

</VirtualHost>
# httpd [moodle.domain.tld] sub entry END.

# httpd [info.domain.tld] sub entry BEGIN.
<VirtualHost 85.214.85.156:80>

    #
    #User vu2003
    #Group vu2003
    #

    <IfModule suexec_module>
           SuexecUserGroup vu2003 vu2003
    </IfModule>

    ServerAdmin     webmaster@domain.tld
    DocumentRoot    /var/www/virtual/domain.tld/info/htdocs

    ServerName      info.domain.tld
    ServerAlias     www.info.domain.tld info.domain.tld *.info.domain.tld

    Alias /errors /var/www/virtual/domain.tld/errors/

    RedirectMatch permanent ^/ftp[\/]?$         http://admin.h1202717.stratoserver.net/ftp/
    RedirectMatch permanent ^/pma[\/]?$         http://admin.h1202717.stratoserver.net/pma/
    RedirectMatch permanent ^/webmail[\/]?$     http://admin.h1202717.stratoserver.net/webmail/
    RedirectMatch permanent ^/ispcp[\/]?$       http://admin.h1202717.stratoserver.net/

    ErrorDocument 401 /errors/401.html
    ErrorDocument 403 /errors/403.html
    ErrorDocument 404 /errors/404.html
    ErrorDocument 500 /errors/500.html
    ErrorDocument 503 /errors/503.html

    <IfModule mod_cband.c>
        CBandUser domain.tld
    </IfModule>

    # httpd sub entry cgi support BEGIN.
    ScriptAlias /cgi-bin/ /var/www/virtual/domain.tld/info/cgi-bin/
    <Directory /var/www/virtual/domain.tld/info/cgi-bin>
        AllowOverride AuthConfig
        #Options ExecCGI
        Order allow,deny
        Allow from all
    </Directory>
    # httpd sub entry cgi support END.

    <Directory /var/www/virtual/domain.tld/info/htdocs>
        # httpd sub entry PHP support BEGIN.
        # httpd sub entry PHP support END.
        Options -Indexes Includes FollowSymLinks MultiViews
        AllowOverride All
        Order allow,deny
        Allow from all
    </Directory>

    # httpd sub entry PHP2 support BEGIN.
    <IfModule mod_php5.c>
        php_admin_value open_basedir "/var/www/virtual/domain.tld/:/var/www/virtual/domain.tld/phptmp/:/usr/share/php/"
        php_admin_value upload_tmp_dir "/var/www/virtual/domain.tld/phptmp/"
        php_admin_value session.save_path "/var/www/virtual/domain.tld/phptmp/"
        php_admin_value sendmail_path '/usr/sbin/sendmail -f vu2003 -t -i'
    </IfModule>
    <IfModule mod_fastcgi.c>
        ScriptAlias /php5/ /var/www/fcgi/domain.tld/
        <Directory "/var/www/fcgi/domain.tld">
            AllowOverride None
            Options +ExecCGI -MultiViews -Indexes
            Order allow,deny
            Allow from all
        </Directory>
    </IfModule>
    <IfModule mod_fcgid.c>
                Include /etc/apache2/mods-available/fcgid_ispcp.conf
        <Directory /var/www/virtual/domain.tld/info/htdocs>
            FCGIWrapper /var/www/fcgi/domain.tld/php5-fcgi-starter .php
            Options +ExecCGI
        </Directory>
        <Directory "/var/www/fcgi/domain.tld">
            AllowOverride None
            Options +ExecCGI MultiViews -Indexes
            Order allow,deny
            Allow from all
        </Directory>
    </IfModule>
    # httpd sub entry PHP2 support END.

    Include /etc/apache2/ispcp/info.domain.tld.conf

</VirtualHost>
# httpd [info.domain.tld] sub entry END.

# httpd [mrbs.domain.tld] sub entry BEGIN.
<VirtualHost 85.214.85.156:80>

    #
    #User vu2003
    #Group vu2003
    #

    <IfModule suexec_module>
           SuexecUserGroup vu2003 vu2003
    </IfModule>

    ServerAdmin     webmaster@domain.tld
    DocumentRoot    /var/www/virtual/domain.tld/mrbs/htdocs

    ServerName      mrbs.domain.tld
    ServerAlias     www.mrbs.domain.tld mrbs.domain.tld *.mrbs.domain.tld

    Alias /errors /var/www/virtual/domain.tld/errors/

    RedirectMatch permanent ^/ftp[\/]?$         http://admin.h1202717.stratoserver.net/ftp/
    RedirectMatch permanent ^/pma[\/]?$         http://admin.h1202717.stratoserver.net/pma/
    RedirectMatch permanent ^/webmail[\/]?$     http://admin.h1202717.stratoserver.net/webmail/
    RedirectMatch permanent ^/ispcp[\/]?$       http://admin.h1202717.stratoserver.net/

    ErrorDocument 401 /errors/401.html
    ErrorDocument 403 /errors/403.html
    ErrorDocument 404 /errors/404.html
    ErrorDocument 500 /errors/500.html
    ErrorDocument 503 /errors/503.html

    <IfModule mod_cband.c>
        CBandUser domain.tld
    </IfModule>

    # httpd sub entry cgi support BEGIN.
    ScriptAlias /cgi-bin/ /var/www/virtual/domain.tld/mrbs/cgi-bin/
    <Directory /var/www/virtual/domain.tld/mrbs/cgi-bin>
        AllowOverride AuthConfig
        #Options ExecCGI
        Order allow,deny
        Allow from all
    </Directory>
    # httpd sub entry cgi support END.

    <Directory /var/www/virtual/domain.tld/mrbs/htdocs>
        # httpd sub entry PHP support BEGIN.
        # httpd sub entry PHP support END.
        Options -Indexes Includes FollowSymLinks MultiViews
        AllowOverride All
        Order allow,deny
        Allow from all
    </Directory>

    # httpd sub entry PHP2 support BEGIN.
    <IfModule mod_php5.c>
        php_admin_value open_basedir "/var/www/virtual/domain.tld/:/var/www/virtual/domain.tld/phptmp/:/usr/share/php/"
        php_admin_value upload_tmp_dir "/var/www/virtual/domain.tld/phptmp/"
        php_admin_value session.save_path "/var/www/virtual/domain.tld/phptmp/"
        php_admin_value sendmail_path '/usr/sbin/sendmail -f vu2003 -t -i'
    </IfModule>
    <IfModule mod_fastcgi.c>
        ScriptAlias /php5/ /var/www/fcgi/domain.tld/
        <Directory "/var/www/fcgi/domain.tld">
            AllowOverride None
            Options +ExecCGI -MultiViews -Indexes
            Order allow,deny
            Allow from all
        </Directory>
    </IfModule>
    <IfModule mod_fcgid.c>
                Include /etc/apache2/mods-available/fcgid_ispcp.conf
        <Directory /var/www/virtual/domain.tld/mrbs/htdocs>
            FCGIWrapper /var/www/fcgi/domain.tld/php5-fcgi-starter .php
            Options +ExecCGI
        </Directory>
        <Directory "/var/www/fcgi/domain.tld">
            AllowOverride None
            Options +ExecCGI MultiViews -Indexes
            Order allow,deny
            Allow from all
        </Directory>
    </IfModule>
    # httpd sub entry PHP2 support END.

    Include /etc/apache2/ispcp/mrbs.domain.tld.conf

</VirtualHost>
# httpd [mrbs.domain.tld] sub entry END.

# httpd [{SUB_NAME}] sub entry BEGIN.
# httpd [{SUB_NAME}] sub entry END.

# httpd [domain.tld] dmn entry BEGIN.
<VirtualHost 85.214.85.156:80>

    <IfModule suexec_module>
           SuexecUserGroup vu2003 vu2003
    </IfModule>

    ServerAdmin     webmaster@domain.tld
    DocumentRoot    /var/www/virtual/domain.tld/htdocs

    ServerName      domain.tld
    ServerAlias     www.domain.tld domain.tld *.domain.tld vu2003.admin.h1202717.stratoserver.net

    Alias /errors   /var/www/virtual/domain.tld/errors/

    RedirectMatch permanent ^/ftp[\/]?$         http://admin.h1202717.stratoserver.net/ftp/
    RedirectMatch permanent ^/pma[\/]?$         http://admin.h1202717.stratoserver.net/pma/
    RedirectMatch permanent ^/webmail[\/]?$     http://admin.h1202717.stratoserver.net/webmail/
    RedirectMatch permanent ^/ispcp[\/]?$       http://admin.h1202717.stratoserver.net/

    ErrorDocument 401 /errors/401.html
    ErrorDocument 403 /errors/403.html
    ErrorDocument 404 /errors/404.html
    ErrorDocument 500 /errors/500.html
    ErrorDocument 503 /errors/503.html

    <IfModule mod_cband.c>
        CBandUser domain.tld
    </IfModule>

    # httpd awstats support BEGIN.

   ProxyRequests Off

   <Proxy *>
      Order deny,allow
      Allow from all
   </Proxy>

   ProxyPass                    /stats  http://localhost/stats/domain.tld
   ProxyPassReverse             /stats  http://localhost/stats/domain.tld

    <Location /stats>
        <IfModule mod_rewrite.c>
            RewriteEngine on
            RewriteRule ^(.+)\?config=([^\?\&]+)(.*) $1\?config=domain.tld&$3 [NC,L]
        </IfModule>
        AuthType Basic
        AuthName "Statistics for domain domain.tld"
        AuthUserFile /var/www/virtual/domain.tld/.htpasswd
        AuthGroupFile /var/www/virtual/domain.tld/.htgroup
        Require group statistics
    </Location>

   # httpd awstats support END.

    # httpd dmn entry cgi support BEGIN.
    ScriptAlias /cgi-bin/ /var/www/virtual/domain.tld/cgi-bin/
    <Directory /var/www/virtual/domain.tld/cgi-bin>
        AllowOverride AuthConfig
        #Options ExecCGI
        Order allow,deny
        Allow from all
    </Directory>
    # httpd dmn entry cgi support END.

    <Directory /var/www/virtual/domain.tld/htdocs>
        # httpd dmn entry PHP support BEGIN.
        # httpd dmn entry PHP support END.
        Options -Indexes Includes FollowSymLinks MultiViews
        AllowOverride All
        Order allow,deny
        Allow from all
    </Directory>

    # httpd dmn entry PHP2 support BEGIN.
    <IfModule mod_php5.c>
        php_admin_value open_basedir "/var/www/virtual/domain.tld/:/var/www/virtual/domain.tld/phptmp/:/usr/share/php/"
        php_admin_value upload_tmp_dir "/var/www/virtual/domain.tld/phptmp/"
        php_admin_value session.save_path "/var/www/virtual/domain.tld/phptmp/"
        php_admin_value sendmail_path '/usr/sbin/sendmail -f vu2003 -t -i'
    </IfModule>
    <IfModule mod_fastcgi.c>
        ScriptAlias /php5/ /var/www/fcgi/domain.tld/
        <Directory "/var/www/fcgi/domain.tld">
            AllowOverride None
            Options +ExecCGI -MultiViews -Indexes
            Order allow,deny
            Allow from all
        </Directory>
    </IfModule>
    <IfModule mod_fcgid.c>
                Include /etc/apache2/mods-available/fcgid_ispcp.conf
        <Directory /var/www/virtual/domain.tld/htdocs>
            FCGIWrapper /var/www/fcgi/domain.tld/php5-fcgi-starter .php
            Options +ExecCGI
        </Directory>
        <Directory "/var/www/fcgi/domain.tld">
            AllowOverride None
            Options +ExecCGI MultiViews -Indexes
            Order allow,deny
            Allow from all
        </Directory>
    </IfModule>
    # httpd dmn entry PHP2 support END.

    Include /etc/apache2/ispcp/domain.tld.conf

</VirtualHost>
# httpd [domain.tld] dmn entry END.

# httpd [domain.tld] dmn group entry END.



RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - joximu - 05-27-2010 06:58 PM

<?php
// prints e.g. 'Current PHP version: 4.1.1'
echo 'Current PHP version: ' . phpversion();
?>

also see http://de.php.net/manual/en/function.php-ini-loaded-file.php
and http://de.php.net/manual/en/function.get-loaded-extensions.php

/J


RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - thoand - 05-27-2010 08:00 PM

Hi,

for the domain with the problems it tells me:
Code:
Current PHP version: 5.2.6-1+lenny8



RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - joximu - 05-27-2010 08:11 PM

ok, try the other commands (which I linked) to get more infos (without phpinfo, as you mentioned)....

there are examples in the online docu....

/J


RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - thoand - 05-27-2010 08:28 PM

Sorry, I have forgotten to follow your links...

Here is the output:
Code:
Loaded php.ini: /var/www/fcgi/mpg-bielefeld.de/php5/php.ini

and
Code:
Array ( [0] => zip [1] => xmlwriter [2] => libxml [3] => xml [4] => wddx [5] => tokenizer [6] => sysvshm [7] => sysvsem [8] => sysvmsg [9] => session [10] => SimpleXML [11] => sockets [12] => soap [13] => SPL [14] => shmop [15] => standard [16] => Reflection [17] => posix [18] => mime_magic [19] => mbstring [20] => json [21] => iconv [22] => hash [23] => gettext [24] => ftp [25] => filter [26] => exif [27] => dom [28] => dba [29] => date [30] => ctype [31] => calendar [32] => bz2 [33] => bcmath [34] => zlib [35] => pcre [36] => openssl [37] => xmlreader [38] => cgi-fcgi )



RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - joximu - 05-27-2010 08:45 PM

hm grep -r mysql.so /etc/php5/*

I have
Code:
Array
(
    [0] => zip
    [1] => xmlwriter
    [2] => libxml
    [3] => xml
    [4] => wddx
    [5] => tokenizer
    [6] => sysvshm
    [7] => sysvsem
    [8] => sysvmsg
    [9] => session
    [10] => SimpleXML
    [11] => sockets
    [12] => soap
    [13] => SPL
    [14] => shmop
    [15] => standard
    [16] => Reflection
    [17] => posix
    [18] => mime_magic
    [19] => mbstring
    [20] => json
    [21] => iconv
    [22] => hash
    [23] => gettext
    [24] => ftp
    [25] => filter
    [26] => exif
    [27] => dom
    [28] => dba
    [29] => date
    [30] => ctype
    [31] => calendar
    [32] => bz2
    [33] => bcmath
    [34] => zlib
    [35] => pcre
    [36] => openssl
    [37] => xmlreader
    [38] => cgi-fcgi
    [39] => ADOdb
    [40] => curl
    [41] => gd
    [42] => imap
    [43] => mcrypt
    [44] => mhash
    [45] => mysql
    [46] => mysqli
    [47] => PDO
    [48] => pdo_mysql
    [49] => suhosin
)

maybe remove all php5 packages (with clean etc) and reinstall again...

or at least php5-mysql reconfigure...

don't know how to fix - but should be possible to reinstall....

/J


RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - thoand - 05-28-2010 01:03 AM

Hi,

(05-27-2010 08:45 PM)joximu Wrote:  hm grep -r mysql.so /etc/php5/*

this gave me:
Code:
h1202717:~# grep -r mysql.so /etc/php5/*
/etc/php5/apache2/php.ini:;extension=mysql.so
/etc/php5/cgi/conf.d/pdo_mysql.ini:extension=pdo_mysql.so
/etc/php5/cgi/conf.d/mysql.ini:extension=mysql.so
/etc/php5/cgi/php.ini:;extension=mysql.so
/etc/php5/cli/conf.d/pdo_mysql.ini:extension=pdo_mysql.so
/etc/php5/cli/conf.d/mysql.ini:extension=mysql.so
/etc/php5/cli/php.ini:;extension=mysql.so
/etc/php5/conf.d/pdo_mysql.ini:extension=pdo_mysql.so
/etc/php5/conf.d/mysql.ini:extension=mysql.so

(05-27-2010 08:45 PM)joximu Wrote:  maybe remove all php5 packages (with clean etc) and reinstall again...

or at least php5-mysql reconfigure...

don't know how to fix - but should be possible to reinstall....

What do you think about a:
Code:
aptitude purge $(cat ./docs/Debian/debian-packages-`lsb_release -cs`)
aptitude install $(cat ./docs/Debian/debian-packages-`lsb_release -cs`)
(executed in the untared isp-omega-1.0.5 dir)

or do I have to reconfigure ispCP then?

thoand


RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - joximu - 05-28-2010 01:37 AM

make a backup of /etc and then try Wink

But I would not reinstall every package - only php5 things.


Can you check this php code on the domain?

Code:
<?php
if ($filelist = php_ini_scanned_files()) {
    if (strlen($filelist) > 0) {
        $files = explode(',', $filelist);

        foreach ($files as $file) {
            echo "<li>" . trim($file) . "</li>\n";
        }
    }
}
?>

this gives a list of php.ini files which have been processed...

Somewhere in theese files the mysql extension should be included...

I have:
# /etc/php5/cgi/conf.d/adodb.ini
# /etc/php5/cgi/conf.d/curl.ini
# /etc/php5/cgi/conf.d/gd.ini
# /etc/php5/cgi/conf.d/idn.ini
# /etc/php5/cgi/conf.d/imap.ini
# /etc/php5/cgi/conf.d/mcrypt.ini
# /etc/php5/cgi/conf.d/mhash.ini
# /etc/php5/cgi/conf.d/mysql.ini
# /etc/php5/cgi/conf.d/mysqli.ini
# /etc/php5/cgi/conf.d/pdo.ini
# /etc/php5/cgi/conf.d/pdo_mysql.ini
# /etc/php5/cgi/conf.d/suhosin.ini

if you have the same - then the mysql.so should be included...

hm... difficult...

/J


RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - thoand - 05-28-2010 03:16 AM

It tells me:
Code:
# /etc/php5/cgi/conf.d/adodb.ini
# /etc/php5/cgi/conf.d/curl.ini
# /etc/php5/cgi/conf.d/gd.ini
# /etc/php5/cgi/conf.d/idn.ini
# /etc/php5/cgi/conf.d/imap.ini
# /etc/php5/cgi/conf.d/mcrypt.ini
# /etc/php5/cgi/conf.d/mhash.ini
# /etc/php5/cgi/conf.d/mysql.ini
# /etc/php5/cgi/conf.d/mysqli.ini
# /etc/php5/cgi/conf.d/pam_auth.ini
# /etc/php5/cgi/conf.d/pdo.ini
# /etc/php5/cgi/conf.d/pdo_mysql.ini

The only one missing is # /etc/php5/cgi/conf.d/suhosin.ini.
Do I need this? The package php5-suhosin is not installed.

regards, thoan


RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - joximu - 05-28-2010 09:00 AM

ok - let me sum up:

php starts and loads many php.ini, one is /etc/php5/cgi/conf.d/mysql.ini but php does not load the mysql extension...

so - either the files are not readable or there is another problem...

since ispcp runs - php-mysql should run... so we may concentrate more on the domain php.ini???

Or is it a different setting for joomla?

/J