ISPConfig 2.2.1 released

[till]

ISPConfig 2.2.1 is available for download.

This release adds support for Fedora Core 5 and CentOS 4.3,
clamassassin was added (replaces trashscan) and many bugs
were fixed.


Detailed Changelog
------------------

- New: Added support for Fedora Core 5.
- New: Added support for CentOS 4.3.
- Update: Update of the Italian translation.
- Update: Replaced trashscan with clamassassin.
- Update: Updated ClamAV to version 0.88.1.
- Bugfix: Server hostname is now recognized correctly in ISPConfig interface.
- Bugfix: Added some patches for more secure passwords.
- Bugfix: Create backup of existing ISPConfig installation in case of an update.
- Bugfix: When a client deletes a user from the recycle bin, the user is now
removed from /etc/passwd and /etc/shadow correctly.
- Bugfix: Default MX records now use the full hostname of the system.
- Bugfix: ISPConfig userdb passwords do not show up in logfile anymore.
- Bugfix: Missing newline at end of named.conf.
- Bugfix: Partitions are now shown correctly even with LVM partitions.
- Bugfix: Web space statistics: Usages of more than 1 GB are now shown as GB, not KB.
- Bugfix: Logsplit does not fail for "localhost" records anymore.
- Bugfix: Firewall and monitoring rules do not disappear anymore after an update.
- Bugfix: Removal of web groups is now working.
- Bugfix: The email addresses were shown with the full hostname. Example
name@www.domain.com instead of name@domain.com. This has been fixed.
- Bugfix: The monitoring summary (Management -> Server -> Services -> Monitoring)
now displays the port numbers that are monitored.
- Bugfix: /root/ispconfig/uninstall does now delete the ISPConfig entries from the
Apache configuration.


Download
--------

http://www.ispconfig.org/downloads.htm

Forums
------

http://www.howtoforge.com/forums


Installation Instructions
-------------------------

Download the ISPConfig-2.2.1.tar.gz from sourceforge.net

http://prdownloads.sourceforge.net/ispconfig/ISPConfig-2.2.1.tar.gz?download


Installation on the shell as root User:

tar xvfz ISPConfig-2.2.1.tar.gz
cd install_ispconfig
./setup

The installer automatically detects the installed ISPConfig version and performs an update.

[Cirox]

Hi,

great work, guys :)

greetings cirox

[danf.1979]

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:

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

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?

[danf.1979]

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

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?

[adamluz]

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.....

[danf.1979]

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

[danf.1979]

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

[lyndros]

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

thks to all the ispconfig team

[falko]

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.....

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.

[adamluz]

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.

[fobicodam]

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 john@mydomain.com its rejected couse there are no MX for mydomain.com !! you must send emails to john@www.mydomain.com !!! :eek:
2.- No client want to see their provider hostname on their MX record :mad:


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

[till]

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 john@mydomain.com its rejected couse there are no MX for mydomain.com !! you must send emails to john@www.mydomain.com !!! :eek:
2.- No client want to see their provider hostname on their MX record :mad:


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


There is no error or bug at all. Go to the ISPConfig DNS-Manager and have a look at the SOA for your domain, I'am pretty sure that there is "www" in the hostname field of the MX record. Remove it and hit save :)

Does your website in DNS-Manager has a co-domain with empty host and you checked the create MX option in the settings of the co-domain?

2) I know some providers that needs hostanmes in MX records.