Current time: 02-20-2020, 10:06 AM Hello There, Guest! (LoginRegister)


Post Reply 
no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5
Author Message
thoand Offline
Junior Member
*

Posts: 30
Joined: May 2010
Reputation: 0
Post: #1
Question no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5
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
05-26-2010 10:05 AM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #2
RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5
Hi Thoand

maybe the configs need to be analyzed - in rc2 some things were totally different...

/J
05-26-2010 05:15 PM
Visit this user's website Find all posts by this user Quote this message in a reply
thoand Offline
Junior Member
*

Posts: 30
Joined: May 2010
Reputation: 0
Post: #3
RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5
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
05-26-2010 06:10 PM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #4
RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5
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
05-26-2010 06:40 PM
Visit this user's website Find all posts by this user Quote this message in a reply
thoand Offline
Junior Member
*

Posts: 30
Joined: May 2010
Reputation: 0
Post: #5
RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5
(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 allowed

I 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
05-26-2010 08:16 PM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #6
RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5
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
05-26-2010 09:53 PM
Visit this user's website Find all posts by this user Quote this message in a reply
thoand Offline
Junior Member
*

Posts: 30
Joined: May 2010
Reputation: 0
Post: #7
RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5
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!
and enabled the ispcp one
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 OK

But on the mainpage nothing has changed, the page still tells me that there is no mysql_connect().

regards,
thoand
05-27-2010 02:43 AM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #8
RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5
dpkg -l | grep php
05-27-2010 08:14 AM
Visit this user's website Find all posts by this user Quote this message in a reply
thoand Offline
Junior Member
*

Posts: 30
Joined: May 2010
Reputation: 0
Post: #9
RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5
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+lenny8
05-27-2010 03:05 PM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #10
RE: no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5
ok, and do you use php4 or php5 for the joomla domain?
05-27-2010 04:56 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)