Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 25th February 2010, 16:44
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,573
Thanks: 792
Thanked 4,980 Times in 3,901 Posts
Default

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 Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Sponsored Links
  #12  
Old 25th February 2010, 16:47
dclardy dclardy is offline
Senior Member
 
Join Date: Sep 2009
Location: Dallas, TX
Posts: 347
Thanks: 10
Thanked 46 Times in 27 Posts
Default

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'
Reply With Quote
  #13  
Old 25th February 2010, 16:54
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,573
Thanks: 792
Thanked 4,980 Times in 3,901 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #14  
Old 25th February 2010, 17:46
dclardy dclardy is offline
Senior Member
 
Join Date: Sep 2009
Location: Dallas, TX
Posts: 347
Thanks: 10
Thanked 46 Times in 27 Posts
Default

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.
Reply With Quote
  #15  
Old 25th February 2010, 18:13
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,573
Thanks: 792
Thanked 4,980 Times in 3,901 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #16  
Old 25th February 2010, 18:15
dclardy dclardy is offline
Senior Member
 
Join Date: Sep 2009
Location: Dallas, TX
Posts: 347
Thanks: 10
Thanked 46 Times in 27 Posts
Default

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.
Reply With Quote
  #17  
Old 25th February 2010, 18:38
dclardy dclardy is offline
Senior Member
 
Join Date: Sep 2009
Location: Dallas, TX
Posts: 347
Thanks: 10
Thanked 46 Times in 27 Posts
Default

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 by dclardy; 25th February 2010 at 18:51.
Reply With Quote
  #18  
Old 25th February 2010, 18:56
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,573
Thanks: 792
Thanked 4,980 Times in 3,901 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #19  
Old 25th February 2010, 18:59
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,573
Thanks: 792
Thanked 4,980 Times in 3,901 Posts
Default

Quote:
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.
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).
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #20  
Old 25th February 2010, 19:08
dclardy dclardy is offline
Senior Member
 
Join Date: Sep 2009
Location: Dallas, TX
Posts: 347
Thanks: 10
Thanked 46 Times in 27 Posts
 
Default

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.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig installation into multiple OpenVZ containers letezo Installation/Configuration 11 3rd March 2009 22:47
ISPConfig 3.0.0.6 Beta released till General 38 21st September 2008 19:15
ISPConfig 2.3.2-dev released till General 9 4th June 2007 10:46
ISPConfig 2.3.1-dev released till General 0 8th May 2006 22:18
ISPConfig remoting plugin Beta 2 released till General 14 29th April 2006 14:13


All times are GMT +2. The time now is 19:01.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.