+- 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)
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+lenny8RE: 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.iniand
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`)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
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.iniThe 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