ISPConfig 3.0.2 Beta 1 released

Discussion in 'Developers' Forum' started by till, Feb 24, 2010.

  1. till

    till Super Moderator Staff Member ISPConfig Developer

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

    NetCat911 New Member

    Cheers! Changelog?
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    And what do you think that the link for changelog in the above text is for ;)
     
  4. NetCat911

    NetCat911 New Member

    Omg, sorry ;(
     
  5. Hans

    Hans Moderator ISPConfig Developer

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

    dclardy New Member

    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
     
    Last edited: Feb 25, 2010
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    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?
     
  8. dclardy

    dclardy New Member

    I was running the latest version of 3.1.6. I have not added anything to the database dbispconfig.

    Thanks.
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

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

    dclardy New Member

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

    till Super Moderator Staff Member ISPConfig Developer

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

    dclardy New Member

    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' 
     
  13. till

    till Super Moderator Staff Member ISPConfig Developer

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

    dclardy New Member

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

    till Super Moderator Staff Member ISPConfig Developer

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

    dclardy New Member

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

    dclardy New Member

    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.
     
    Last edited: Feb 25, 2010
  18. till

    till Super Moderator Staff Member ISPConfig Developer

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

    till Super Moderator Staff Member ISPConfig Developer

    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).
     
  20. dclardy

    dclardy New Member

    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.
     

Share This Page