+- 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)
no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - thoand - 05-26-2010 10:05 AM
Hi there,
I had a long night yesterday and during this I totaly broke my system.
Ok most things are working, but not the mainpage...
What I did:
1. I updatet my Debian etch, no problem
2. I updatet my ispCP from 1.0.0rc2 to 1.0.0, ispCP works fine, but I have problems with joomla now. It tells me that I do not have "mysql_connect()". php5-mysql is installed.
3. I thought it might help to update to 1.0.5 so I did, but it did not help.
4. I found out that fcgid makes problems in etch, so I tried to get back to fastCGI, did not work
5. I fully Upgraded my Debian etch to lenny and rerun the isp-update, ispCP, Mail and co works, but joomla tells me that there is no mysql_connect().
6. I tried a bit with fastcgi vs. fcgid, but nothing helped.
What surprises me, I edited /var/www/fcgi/DOMAIN/php/php.ini to allow phpinfo(); but even after a restart of apache it told me, that it is forbidden.
Any suggestions?
kind regards,
thoand
PS: the Joomla error I get is Error 1 http://forum.joomla.org/viewtopic.php?t=3647
RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - joximu - 05-26-2010 05:15 PM
Hi Thoand
maybe the configs need to be analyzed - in rc2 some things were totally different...
/J
RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - thoand - 05-26-2010 06:10 PM
hi,
that is why I updated to 1.0.0 first, there it was possible to choose from which rc I came.
Which are the configs I should look at, which logs may help? I did not find something helpful.
regards thoand
RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - joximu - 05-26-2010 06:40 PM
apache2 -M
ls -la /etc/apache2/mods-enabled/
and next the /etc/apache2/sites-enabled/iscp.conf - you may change the domain names and paths...
/J
RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - thoand - 05-26-2010 08:16 PM
(05-26-2010 06:40 PM)joximu Wrote: apache2 -M
Code:
h1202717:~# apache2 -M
apache2: bad user name ${APACHE_RUN_USER}
h1202717:~# export APACHE_RUN_USER=vu2000
h1202717:~# apache2 -M
apache2: bad group name ${APACHE_RUN_GROUP}
h1202717:~# export APACHE_RUN_GROUP=vu2000
h1202717:~# apache2 -M
Syntax error on line 29 of /etc/apache2/mods-enabled/fastcgi.conf:
FastCgiWrapper: "/usr/lib/apache2/suexec" execute access for server (uid 2000, gid 2000) failed: execute not allowedI have chosen the vu2000 becaus it is the ispCP one, I think the missing rights are my problem, but where do I have to allow it?
(05-26-2010 06:40 PM)joximu Wrote: ls -la /etc/apache2/mods-enabled/
Code:
h1202717:~# ls -la /etc/apache2/mods-enabled/
insgesamt 8
drwxr-xr-x 2 root root 4096 25. Mai 13:11 .
drwxr-xr-x 8 root root 4096 25. Mai 13:11 ..
lrwxrwxrwx 1 root root 30 25. Mai 12:30 actions.conf -> ../mods-available/actions.conf
lrwxrwxrwx 1 root root 30 25. Apr 2007 actions.load -> ../mods-available/actions.load
lrwxrwxrwx 1 root root 28 25. Mai 12:30 alias.conf -> ../mods-available/alias.conf
lrwxrwxrwx 1 root root 28 25. Apr 2007 alias.load -> ../mods-available/alias.load
lrwxrwxrwx 1 root root 33 25. Apr 2007 auth_basic.load -> ../mods-available/auth_basic.load
lrwxrwxrwx 1 root root 33 25. Apr 2007 authn_file.load -> ../mods-available/authn_file.load
lrwxrwxrwx 1 root root 36 25. Apr 2007 authz_default.load -> ../mods-available/authz_default.load
lrwxrwxrwx 1 root root 38 25. Apr 2007 authz_groupfile.load -> ../mods-available/authz_groupfile.load
lrwxrwxrwx 1 root root 33 25. Apr 2007 authz_host.load -> ../mods-available/authz_host.load
lrwxrwxrwx 1 root root 33 25. Apr 2007 authz_user.load -> ../mods-available/authz_user.load
lrwxrwxrwx 1 root root 32 25. Mai 12:30 autoindex.conf -> ../mods-available/autoindex.conf
lrwxrwxrwx 1 root root 32 25. Apr 2007 autoindex.load -> ../mods-available/autoindex.load
lrwxrwxrwx 1 root root 28 24. Mai 23:55 cband.conf -> ../mods-available/cband.conf
lrwxrwxrwx 1 root root 28 24. Mai 23:55 cband.load -> ../mods-available/cband.load
lrwxrwxrwx 1 root root 27 25. Mai 12:36 cgid.conf -> ../mods-available/cgid.conf
lrwxrwxrwx 1 root root 27 25. Mai 12:36 cgid.load -> ../mods-available/cgid.load
lrwxrwxrwx 1 root root 26 25. Mai 11:09 cgi.load -> ../mods-available/cgi.load
lrwxrwxrwx 1 root root 26 25. Apr 2007 dir.conf -> ../mods-available/dir.conf
lrwxrwxrwx 1 root root 26 25. Apr 2007 dir.load -> ../mods-available/dir.load
lrwxrwxrwx 1 root root 26 25. Apr 2007 env.load -> ../mods-available/env.load
lrwxrwxrwx 1 root root 30 25. Mai 13:11 fastcgi.conf -> ../mods-available/fastcgi.conf
lrwxrwxrwx 1 root root 30 25. Mai 13:11 fastcgi.load -> ../mods-available/fastcgi.load
lrwxrwxrwx 1 root root 27 25. Mai 12:30 mime.conf -> ../mods-available/mime.conf
lrwxrwxrwx 1 root root 27 25. Apr 2007 mime.load -> ../mods-available/mime.load
lrwxrwxrwx 1 root root 34 25. Mai 12:30 negotiation.conf -> ../mods-available/negotiation.conf
lrwxrwxrwx 1 root root 34 25. Apr 2007 negotiation.load -> ../mods-available/negotiation.load
lrwxrwxrwx 1 root root 28 24. Mai 23:59 proxy.conf -> ../mods-available/proxy.conf
lrwxrwxrwx 1 root root 33 24. Mai 23:59 proxy_http.load -> ../mods-available/proxy_http.load
lrwxrwxrwx 1 root root 28 24. Mai 23:59 proxy.load -> ../mods-available/proxy.load
lrwxrwxrwx 1 root root 30 25. Apr 2007 rewrite.load -> ../mods-available/rewrite.load
lrwxrwxrwx 1 root root 31 25. Mai 12:30 setenvif.conf -> ../mods-available/setenvif.conf
lrwxrwxrwx 1 root root 31 25. Apr 2007 setenvif.load -> ../mods-available/setenvif.load
lrwxrwxrwx 1 root root 29 25. Mai 12:30 status.conf -> ../mods-available/status.conf
lrwxrwxrwx 1 root root 29 25. Apr 2007 status.load -> ../mods-available/status.load
lrwxrwxrwx 1 root root 29 25. Apr 2007 suexec.load -> ../mods-available/suexec.load(05-26-2010 06:40 PM)joximu Wrote: and next the /etc/apache2/sites-enabled/iscp.conf - you may change the domain names and paths...
Everythink in there looks ok.
regards,
thoand
RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - joximu - 05-26-2010 09:53 PM
sorry: "apache2ctl -M"
if you want to use fastcgi or fcgid then you need something like fastcgi_ispcp.conf activated...
I have:
Code:
lrwxrwxrwx 1 root root 30 22. Jan 01:10 actions.conf -> ../mods-available/actions.conf
lrwxrwxrwx 1 root root 30 9. Apr 2007 actions.load -> ../mods-available/actions.load
lrwxrwxrwx 1 root root 28 22. Jan 01:10 alias.conf -> ../mods-available/alias.conf
lrwxrwxrwx 1 root root 28 9. Apr 2007 alias.load -> ../mods-available/alias.load
lrwxrwxrwx 1 root root 33 9. Apr 2007 auth_basic.load -> ../mods-available/auth_basic.load
lrwxrwxrwx 1 root root 33 9. Apr 2007 authn_file.load -> ../mods-available/authn_file.load
lrwxrwxrwx 1 root root 36 9. Apr 2007 authz_default.load -> ../mods-available/authz_default.load
lrwxrwxrwx 1 root root 38 9. Apr 2007 authz_groupfile.load -> ../mods-available/authz_groupfile.load
lrwxrwxrwx 1 root root 33 9. Apr 2007 authz_host.load -> ../mods-available/authz_host.load
lrwxrwxrwx 1 root root 33 9. Apr 2007 authz_user.load -> ../mods-available/authz_user.load
lrwxrwxrwx 1 root root 32 22. Jan 01:10 autoindex.conf -> ../mods-available/autoindex.conf
lrwxrwxrwx 1 root root 32 9. Apr 2007 autoindex.load -> ../mods-available/autoindex.load
lrwxrwxrwx 1 root root 27 9. Apr 2007 cgid.conf -> ../mods-available/cgid.conf
lrwxrwxrwx 1 root root 27 9. Apr 2007 cgid.load -> ../mods-available/cgid.load
lrwxrwxrwx 1 root root 26 9. Apr 2007 dir.conf -> ../mods-available/dir.conf
lrwxrwxrwx 1 root root 26 9. Apr 2007 dir.load -> ../mods-available/dir.load
lrwxrwxrwx 1 root root 26 9. Apr 2007 env.load -> ../mods-available/env.load
lrwxrwxrwx 1 root root 36 14. Sep 2007 fastcgi_ispcp.conf -> ../mods-available/fastcgi_ispcp.conf
lrwxrwxrwx 1 root root 36 14. Sep 2007 fastcgi_ispcp.load -> ../mods-available/fastcgi_ispcp.load
lrwxrwxrwx 1 root root 28 8. Jan 01:11 fcgid.conf -> ../mods-available/fcgid.conf
lrwxrwxrwx 1 root root 28 8. Jan 01:11 fcgid.load -> ../mods-available/fcgid.load
lrwxrwxrwx 1 root root 27 22. Jan 01:10 mime.conf -> ../mods-available/mime.conf
lrwxrwxrwx 1 root root 27 9. Apr 2007 mime.load -> ../mods-available/mime.load
lrwxrwxrwx 1 root root 34 22. Jan 01:10 negotiation.conf -> ../mods-available/negotiation.conf
lrwxrwxrwx 1 root root 34 9. Apr 2007 negotiation.load -> ../mods-available/negotiation.load
lrwxrwxrwx 1 root root 30 9. Apr 2007 rewrite.load -> ../mods-available/rewrite.load
lrwxrwxrwx 1 root root 31 22. Jan 01:10 setenvif.conf -> ../mods-available/setenvif.conf
lrwxrwxrwx 1 root root 31 9. Apr 2007 setenvif.load -> ../mods-available/setenvif.load
lrwxrwxrwx 1 root root 29 22. Jan 01:10 status.conf -> ../mods-available/status.conf
lrwxrwxrwx 1 root root 29 9. Apr 2007 status.load -> ../mods-available/status.load
lrwxrwxrwx 1 root root 29 9. Apr 2007 suexec.load -> ../mods-available/suexec.load/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 02:43 AM
Hi,
I have deactivated the normal module
Code:
h1202717:/etc/apache2/mods-enabled# a2dismod fastcgi
Module fastcgi disabled.
Run '/etc/init.d/apache2 restart' to activate new configuration!Code:
h1202717:/etc/apache2/mods-enabled# a2enmod fastcgi_ispcp
Enabling module fastcgi_ispcp.
Run '/etc/init.d/apache2 restart' to activate new configuration!
h1202717:/etc/apache2/mods-enabled# /etc/init.d/apache2 restart
Restarting web server: apache2 ... waiting .....then I listed all the modules:
Code:
h1202717:/etc/apache2/mods-enabled# apache2ctl -M
Loaded Modules:
core_module (static)
log_config_module (static)
logio_module (static)
mpm_worker_module (static)
http_module (static)
so_module (static)
actions_module (shared)
alias_module (shared)
auth_basic_module (shared)
authn_file_module (shared)
authz_default_module (shared)
authz_groupfile_module (shared)
authz_host_module (shared)
authz_user_module (shared)
autoindex_module (shared)
cband_module (shared)
cgi_module (shared)
cgid_module (shared)
dir_module (shared)
env_module (shared)
fastcgi_module (shared)
mime_module (shared)
negotiation_module (shared)
proxy_module (shared)
proxy_http_module (shared)
rewrite_module (shared)
setenvif_module (shared)
status_module (shared)
suexec_module (shared)
Syntax OKBut on the mainpage nothing has changed, the page still tells me that there is no mysql_connect().
regards,
thoand
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:14 AM
dpkg -l | grep php
RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5 - thoand - 05-27-2010 03:05 PM
Code:
h1202717:~# dpkg -l | grep php
rc libapache2-mod-php5 5.2.0+dfsg-8+etch16
ii php-db 1.7.13-2
ii php-http 1.4.0-1
ii php-mail 1.1.14-1+lenny1
ii php-net-smtp 1.3.1-1
ii php-net-socket 1.0.8-2
ii php-pear 5.2.6.dfsg.1-1+lenny8
ii php-xml-parser 1.2.8-1
rc php4-auth-pam 0.4-9.2
rc php4-cgi 6:4.4.4-8+etch6
ii php4-common 6:4.4.4-8+etch6
rc php4-curl 6:4.4.4-8+etch6
rc php4-gd 6:4.4.4-8+etch6
rc php4-mcrypt 6:4.4.4-8+etch6
rc php4-mysql 6:4.4.4-8+etch6
ii php5 5.2.6.dfsg.1-1+lenny8
ii php5-adodb 5.04-3
ii php5-auth-pam 0.4-10
ii php5-cgi 5.2.6.dfsg.1-1+lenny8
ii php5-cli 5.2.6.dfsg.1-1+lenny8
ii php5-common 5.2.6.dfsg.1-1+lenny8
rc php5-curl 5.2.0+dfsg-8+etch16
ii php5-gd 5.2.6.dfsg.1-1+lenny8
ii php5-idn 1.2b-5.3
ii php5-imap 5.2.6.dfsg.1-1+lenny8
ii php5-mcrypt 5.2.6.dfsg.1-1+lenny8
ii php5-mhash 5.2.6.dfsg.1-1+lenny8
ii php5-mysql 5.2.6.dfsg.1-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 04:56 PM
ok, and do you use php4 or php5 for the joomla domain?