Threaded Mode | Linear Mode

thoand · 06-03-2010 07:13 AM

If someone has an idea for the mysql problem im interested.

everything needed seems to be installed because ispCP works fine, even creating mysql databases works. so it must be some configuration problem in my domain.

the former problem that I could not execute phpinfo although I deleted it from the disabled_function list is solved. I think it has to do with the switch from fastcgi to fcgid.

Could it be that there are some fastcgi related informations in config files for my domain which are not in the master domain? I did not find any

/thoand

**mr.x** · 06-03-2010 07:16 AM

Hi,

is

Code:

mysql -u root -p

working?

/Mr.X

thoand · 06-03-2010 07:22 AM

Hi,

yes it does.

Code:

h1202717:~# mysql -u root -p

Enter password: 

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2711

Server version: 5.0.51a-24+lenny3 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit

Bye

/thoand

It even should, because the ispCP data are stored in this database too? and ispCP is working without any problem

**mr.x** · 06-03-2010 07:30 AM

Hi,

(06-03-2010 07:22 AM)thoand Wrote: Hi,

yes it does.

Code:

h1202717:~# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2711 Server version: 5.0.51a-24+lenny3 (Debian) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> quit Bye
/thoand
It even should, because the ispCP data are stored in this database too? and ispCP is working without any problem

ok !

What about dpkg -l|grep mysql?

/Mr.X

thoand · 06-03-2010 07:34 AM

Hi,

Code:

h1202717:~# dpkg -l|grep mysql

ii  libdbd-mysql-perl                 4.007-1+lenny1             A Perl5 database interface to the MySQL database

ii  libmysqlclient15off               5.0.51a-24+lenny3          MySQL database client library

ii  mysql-client                      5.0.51a-24+lenny3          MySQL database client (metapackage depending on the latest versi

ii  mysql-client-5.0                  5.0.51a-24+lenny3          MySQL database client binaries

ii  mysql-common                      5.0.51a-24+lenny3          MySQL database common files

ii  mysql-server                      5.0.51a-24+lenny3          MySQL database server (metapackage depending on the latest versi

ii  mysql-server-5.0                  5.0.51a-24+lenny3          MySQL database server binaries

rc  php4-mysql                        6:4.4.4-8+etch6            MySQL module for php4

ii  php5-mysql                        5.2.6.dfsg.1-1+lenny8      MySQL module for php5

ii  proftpd-mod-mysql                 1.3.1-17lenny4             versatile, virtual-hosting FTP daemon - MySQL module

One minute ago I saw that bind does not run, I am currently debugging it. Could it just be a problem with the name resolution?

ok, bind is working now. sadly it was not the solution for my other problems :-/

**mr.x** · 06-03-2010 06:21 PM

(06-03-2010 07:34 AM)thoand Wrote: Hi,

Code:

h1202717:~# dpkg -l|grep mysql ii libdbd-mysql-perl 4.007-1+lenny1 A Perl5 database interface to the MySQL database ii libmysqlclient15off 5.0.51a-24+lenny3 MySQL database client library ii mysql-client 5.0.51a-24+lenny3 MySQL database client (metapackage depending on the latest versi ii mysql-client-5.0 5.0.51a-24+lenny3 MySQL database client binaries ii mysql-common 5.0.51a-24+lenny3 MySQL database common files ii mysql-server 5.0.51a-24+lenny3 MySQL database server (metapackage depending on the latest versi ii mysql-server-5.0 5.0.51a-24+lenny3 MySQL database server binaries rc php4-mysql 6:4.4.4-8+etch6 MySQL module for php4 ii php5-mysql 5.2.6.dfsg.1-1+lenny8 MySQL module for php5 ii proftpd-mod-mysql 1.3.1-17lenny4 versatile, virtual-hosting FTP daemon - MySQL module

One minute ago I saw that bind does not run, I am currently debugging it. Could it just be a problem with the name resolution?
ok, bind is working now. sadly it was not the solution for my other problems :-/

please try this:

Code:

apt-get remove php4-mysql

Code:

dpkg-reconfigure php5-mysql

/Mr.X

thoand · 06-04-2010 01:50 AM

Hi,

I tried to remove php4-mysql, but it was not installed. Then I reconfigured php5-mysql an restarted apache.
But nothing has changed.

/thoand

**mr.x** · 06-04-2010 02:42 AM

(06-04-2010 01:50 AM)thoand Wrote: Hi,

I tried to remove php4-mysql, but it was not installed. Then I reconfigured php5-mysql an restarted apache.
But nothing has changed.

/thoand

May be you can try it with apt-get remove --purge php5-mysql
/Mr.X

thoand · 06-04-2010 06:46 AM

Hi,

I purged it before, but tried it again. But after installing it again it did not work.
To be sure I restarted apache.

Am I wrong that ispCP uses php5-mysql? If not it could not be a general installation problem, because ispCP works fine. It has to be some configuration problem. But php tells me that it has loaded the file /etc/php5/cgi/conf.d/mysql.ini in which is defined that php should load mysql.so.
So what domain specific configuration could be the problem. (I even switcht the support for php and cgi in ispCP for the domain from on to off to on. It did not help)

/thoand

PS: the problem occures on all three hosted domains (configured as separate customers)

**mr.x** · 06-04-2010 06:06 PM

Hi,

(06-04-2010 06:46 AM)thoand Wrote: Am I wrong that ispCP uses php5-mysql?

No, you are right.

Quote:PS: the problem occures on all three hosted domains (configured as separate customers)

Can you please activate DEBUG mode in /etc/ispcp/ispcp.conf, create a new domain and provide us the log files,
/mr.x

Threaded Mode \| Linear Mode no mySQL access via Joomla after update from 1.0.0rc2 to 1.0.0 to 1.0.5
Author	Message