This is the first beta version of the upcoming ISPConfig 3.0.2 release. The latest installation instructions for new setup options like Dovecot and BIND support can be found in the docs folder of the ISPConfig-3.0.2-beta1.tar.gz file. Please report bugs here: http://bugtracker.ispconfig.org Beta versions are meant for testing and bugfixing. Please wait for the final version to update your production systems. Changelog and new features ------------------------------------ http://bugtracker.ispconfig.org/index.php?do=index&tasks=&project=3&due=21&status[]= IMPORTANT: Backup your installation before updating --------------------------------------------------- http://www.faqforge.com/linux/controlpanels/ispconfig3/how-to-update-ispconfig-3/ New Installation ------------------------------------ Execute the following commands as root user on the shell: Code: cd /tmp wget http://www.ispconfig.org/downloads/ISPConfig-3.0.2-beta1.tar.gz tar xvfz ISPConfig-3.0.2-beta1.tar.gz cd ispconfig3_install/install/ php -q install.php cd /tmp/ rm -rf ispconfig3_install rm -f ISPConfig-3.0.2-beta1.tar.gz Update of an existing ISPConfig installation Installation ------------------------------------ Execute the following commands as root user on the shell: Code: cd /tmp wget http://www.ispconfig.org/downloads/ISPConfig-3.0.2-beta1.tar.gz tar xvfz ISPConfig-3.0.2-beta1.tar.gz cd ispconfig3_install/install/ php -q update.php cd /tmp/ rm -rf ispconfig3_install rm -f ISPConfig-3.0.2-beta1.tar.gz
Thanks for this new beta release On the moment i don't have the possibility to do some testing. I think it's also good to mention that on an multiple server environment, you first need to upgrade the slave servers and after that the master server with the ISPConfig controlpanel.
When running the update script, I am unable to login to the ISPConfig pages. The password is gone. When I open phpmyadmin, all of the tables are empty. There are no records. Any ideas on how to fix this? Here is the error: Code: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Warning: The option '--all' is deprecated and will be removed in a future releas' at line 1
1) Which ispconfig version did you use before the update? 2) Have edited a table in the ispconfig database before, added a field or another table in the ispconfig database?
I was running the latest version of 3.1.6. I have not added anything to the database dbispconfig. Thanks.
Ok. You should find a backup of the database in the /root/ folder. Please try to insert this sql file into the ispconfig database again e.g. with phpmyadmin or the commandline mysql client and if this fails, post the error message.
I got the file, and I tried to import it through phpmyadmin. Here is the error that I got. Code: Error SQL query: Warning : The OPTION '--all' IS deprecated AND will be removed IN a future release.Please USE - - CREATE - options instead.-- MySQL dump 10.13 Distrib 5.1.44, for debian-linux-gnu (i486) -- -- Host: localhost Database: dbispconfig -- ------------------------------------------------------ -- Server version 5.1.44-0.dotdeb.0 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Warning: The option '--all' is deprecated and will be removed in a future releas' at line 1
The problem seems to be that mysqldump has inserted a warning in the sql file which causes the import to fail. Please edit the sql file and remove the line: Warning : The OPTION '--all' IS deprecated AND will be removed IN a future release.Please USE - - CREATE - options instead.-- MySQL dump 10.13 Distrib 5.1.44, for debian-linux-gnu (i486) and try the import again.
Till, Thanks for the help with this. I deleted the line that was there. It allowed me to get further in the process, but I still got an error. Here is the new one: Code: Error SQL query: INSERT INTO `sys_ini` ( `sysini_id` , `config` ) VALUES ( 1, '[mail]\nmailboxlist_webmail_link=y\n\n[sites]\ndbname_prefix=[CLIENTNAME]\ndbuser_prefix=[CLIENTNAME]\nftpuser_prefix=[CLIENTNAME]\nshelluser_prefix=[CLIENTNAME]\ndblist_phpmyadmin_link=y\n\n' ) ; MySQL said: Documentation #1062 - Duplicate entry '1' for key 'PRIMARY'
Thats caused by the failed partly import. Please empty all tables in the ispconfig database (just "truncate" them and not delete them) with phpmyadmin and then try to import again.
This is the error that I have been getting. Code: Error SQL query: INSERT INTO `web_traffic` (`hostname`, `traffic_date`, `traffic_bytes`) VALUES ('server.clardyhost.info','2009-11-06',574599),('drewclardy.info','2009-11-06',4944),('clardyhost.info','2009-11-07',150421),('drewclardy.info','2009-11-07',692767),('server.clardyhost.info','2009-11-07',203244),('drewclardy.info','2009-11-08',667662),('clardyhost.info','2009-11-08',180916),('server.clardyhost.info','2009-11-08',2648),('server.clardyhost.info','2009-11-09',570438),('drewclardy.info','2009-11-09',365443),('clardyhost.info','2009-11-09',2412464),('jessicamelendrez.com','2009-11-09',5830),('thedonutdepot.com','2009-11-09',1915),('clardyhost.info','2009-11-10',3234649),('drewclardy.info','2009-11-10',2738740),('thedonutdepot.com','2009-11-10',3811572),('server.clardyhost.info','2009-11-10',796318),('jessicamelendrez.com','2009-11-10',801952),('clardyhost.info','2009-11-11',1540940),('drewclardy.info','2009-11-11',9037398),('thedonutdepot.com','2009-11-11',798139),('jessicamelendrez.com','2009-1[...] MySQL said: Documentation #1062 - Duplicate entry 'drewclardy.info-2010-02-25' for key 'PRIMARY' I am not exactly sure that it means, but I am able to log in and see everything again.
It's a bit strange that there is a duplicate item. What you can do is to remove the table web_traffic, truncate all tableas an try a reimport. but if everything works now, you can leave it as it is as the only missing part is some historic web traffic data.
I agree. Not sure what it is, but it is fine that I don't have some traffic data. The other stuff is what really matters. On another note, how do we configure DNS replication now? I know that was a feature that I was looking for. I assume that it is in the auto-notify section of the DNS tab. Do I just place the server name to notify? Thanks.
So I updated and it was up for a little while, but the webserver went down. Here is the error: Code: Restarting web server: apache2Syntax error on line 7 of /etc/apache2/sites-enabled/000-apps.vhost: Listen requires 1 or 2 arguments. failed! I realized that this is happening by going to the Server Config page. The Apps Vhost port is empty. ISPConfig is rewriting it to a blank when it is saved.
Works for me in 3.0.2 beta 1. So thats most likel yrelated to the failed update. Please redo the ispconfig 3.0.2 update, so that the updater is able to modify the server settings too.
There are many different ways to do this available now. The auto notify option has been available in ispcinfig 3.0.1.6 already, it is for mydns only. But mydns has some bugs regarding this feature. Other options are to use the builtin mirroring faeture in ispconfig which is the preferred way for multiserver setups (it is configurable in the server config settings), requirement is that all dns servers run ispconfig 3. This new feature works for all supported dns daemons (mydns, bind and powerdns).
Re-running the update.php script, I get the same error that I had before. Code: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma nual that corresponds to your MySQL server version for the right syntax to use n ear 'Warning: The option '--all' is deprecated and will be removed in a future r eleas' at line 1 Nothing is placed into the table.
