ISPConfig 2.2.1 released

Hi,

great work, guys

greetings cirox

 

I got problems here:
ISPConfig db has now cero tables. I thought It was a problem with my character collation in ispconfig db. I had utf8 and this lines in the mysql class constructor:

PHP:

mysql_query("SET character_set_client = 'latin1'");
mysql_query("SET character_set_results = latin1");
mysql_query("SET character_set_connection = utf8"); 


As with the update my db got dead, I decided to take out those lines and define ispconfig db as latin1. I did that and then uploaded a sql backup and began updating again. Same result. The database is there, but there are no tables. Also, the db dump found on /tmp did nothing for me. i had to use my own backup.

Here are the errors, but they say nothing really important

PHP:

All prerequisites are fulfilled.
Here we go...

Connected successfully to db isp_config

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/dan/src/install_ispconfig/install.php on line 776

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/dan/src/install_ispconfig/install.php on line 781

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/dan/src/install_ispconfig/install.php on line 791

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/dan/src/install_ispconfig/install.php on line 808

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/dan/src/install_ispconfig/install.php on line 1114
Restarting some services...
/usr/sbin/apachectl restart: httpd restarted
 * Stopping Postfix Mail Transport Agent...                                                                                          [ ok ]
 * Starting Postfix Mail Transport Agent...                                                                                          [ ok ]
Restarting ProFTPD ftp daemon.proftpd.
.. - mod_tls/2.0.7: using OpenSSL 0.9.7g 11 Apr 2005
 - parsing '/etc/proftpd.conf' configuration
 - parsing '/etc/proftpd_ispconfig.conf' configuration
proftpd.
 done.
Shutting down ISPConfig system...
/root/ispconfig/httpd/bin/apachectl stop: httpd (no pid file) not running
ISPConfig system stopped!
Starting ISPConfig system...
/root/ispconfig/httpd/bin/apachectl startssl: httpd started

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47
No results found!ISPConfig system is now up and running!
Congratulations! Your ISPConfig system is now installed. If you had to install quota, please take the steps described in the installation manual. Otherwise your system is now available without reboot.


Anything to check?

 

Ok. So, this file is in /tmp/:
existing_db_04_11_2006__17_43_18.sql
So the following line works:

Code:

caselog("cp -f existing_db.sql /tmp/existing_db_".date("m_d_Y__H_i_s", $current_date).".sql", $FILE, __LINE__,"copied existing_db.sql to /tmp/existing_db_".date("m_d_Y__H_i_s", $current_date).".sql"

Could it be the -f option?
I read in man cp:
-----------
-f, --force
if an existing destination file cannot be opened, remove it and
try again
-----------
Could that be why I can't find anywhere the existing_db.sql file?

 

Error - Mysql keeps shutting down

Everytime I try to install the upgrade mysql dies...


[root@fc4 install_ispconfig]# service mysqld restart
Stopping MySQL: [FAILED]
Starting MySQL: [ OK ]
[root@fc4 install_ispconfig]# service mysqld status
mysqld (pid 28397) is running...

Mysql will run all night until

[root@fc4 install_ispconfig]# ./setup
Fedora 4.0

########## INSTALLATION ##########
[EDITED LICENCE CONTENT OUT OF POST]

ERROR: MySQL is not running! Please start your MySQL database and run the ISPConfig setup again.
[root@fc4 install_ispconfig]# service mysqld status
mysqld dead but subsys locked
[root@fc4 install_ispconfig]# service mysqld restart
Stopping MySQL: [FAILED]
Starting MySQL: [ OK ]
[root@fc4 install_ispconfig]# ./setup
Repeat.....

 

Buh, I think it was because I decompressed the files as my user and not root. I'm running the update again...

 

Buh, I think it was because I decompressed the files as my user and not root. I'm running the update again...

 

great work u all guys,
with people like u is a pleasure

thks to all the ispconfig team

 

I experienced something like this on CentOS 4.3, and the solution was to change MySQL's init script as outlined here: http://www.howtoforge.com/perfect_setup_centos_4.3_p4
Given that Fedora and CentOS are very similar, you might have to do the same.

 

Thanks

In /etc/init.d/mysqld

I changed:
restart(){
stop
start
}

to

restart(){
stop
sleep 3
start
}

and that fixed everything. Thought I would post it here for quicker results when searching.

 

Mx Big Error !!!

I found a big mistake when you create the domain zone !!! you create this:

A record
XXX.XXX.XXX.XXX www.mydomain.com

MX record
www.mywebserver.com www


This is wrong !!! if you do that:

1.- No email will be served to this server !! if you send a mail to [email protected] its rejected couse there are no MX for mydomain.com !! you must send emails to [email protected] !!!
2.- No client want to see their provider hostname on their MX record


How can i fix it?!?!?!!!