Jump to content
Froxlor Forum
  • 0

Problems updating from 0.9.29 to 0.9.30

michapixel

Asked by michapixel,

Question

michapixel Newbie

michapixel

Posted
Posted

i'm not worthy!

 

i have apticron running on my server, and today it announced an update to my froxlor-installation

The following packages are currently pending an upgrade:
    froxlor 0.9.30-1+squeeze1

. so far so good. i did the usual apt-get thingy, then logged into my froxlor-admin-account, like i should. i checked the 'i-have-read-the-warning' box, and tried to continue the update, but it got stuck in the middle somewhere.

 

too bad for me: i didn't read anywhere that this update is a 'dev'-update, as the admin interface shows me

Updating from 0.9.29 to 0.9.29.1-dev1

(of course after i have tried to update!)

 

turns out there's a mysql-error which looks like this:

 

25.10.2013 17:56 --- MySQL - Error: Invalid SQL: INSERT INTO `panel_domaintoip` SET                        `id_domain` = 1,                        `id_ipandports` = 2; ErrNo: 1062; Desc: Duplicate entry '1-2' for key 'PRIMARY';

 

i hope there's an easy fix for this. oh quick would be cool too :-)

 

 

Link to comment
Share on other sites

11 answers to this question

Recommended Posts

d00p Grand Master

d00p

Posted
Posted

The update is not only a dev-update. When updating, all the development updates are run until the final Version is reached.

 

Please check the froxlor/install/update.log to check where the update died exactly. Try to clean the table 'panel_domaintoip' and rerun the update

Link to comment
Share on other sites
michapixel Newbie

michapixel

Posted
  • Author
Posted

first of all thanks for the quick reply.

the last entry in the log is :

 

25.10.2013 18:05:44 [warning] [administrator-action (updater)] Convert old domain to ip - mappings

 

nothing new here i guess.

 

what exactly do you mean by "Try to clean the table 'panel_domaintoip' and rerun the update"?

- empty it?

Link to comment
Share on other sites
michapixel Newbie

michapixel

Posted
  • Author
Posted

ok, i deleted the one entry there, re-run the update, like above, now it stops like:

 

25.10.2013 19:13:02 [warning] [administrator-action (updater)] -------------- START LOG --------------
25.10.2013 19:13:02 [warning] [administrator-action (updater)] Updating from 0.9.29 to 0.9.29.1-dev1
25.10.2013 19:13:02 [warning] [administrator-action (updater)] Updating from 0.9.29 to 0.9.29.1-dev1
25.10.2013 19:13:02 [warning] [administrator-action (updater)] Success
25.10.2013 19:13:02 [warning] [administrator-action (updater)] Adding new ip to domain - mapping-table
25.10.2013 19:13:02 [warning] [administrator-action (updater)] Adding new ip to domain - mapping-table
25.10.2013 19:13:02 [warning] [administrator-action (updater)] Success
25.10.2013 19:13:02 [warning] [administrator-action (updater)] Convert old domain to ip - mappings
25.10.2013 19:13:02 [warning] [administrator-action (updater)] Convert old domain to ip - mappings

 

loooking at the table, it did restore exactly what has been there before ...

 

what else can i do now?

 

(mysql-error-log shows the exact same error like before.)

Link to comment
Share on other sites
d00p Grand Master

d00p

Posted
Posted

That sounds weird. Can you tell me your IP/port settings? The most helpful would be a dump of panel_ipsandports and panel_domains (if you want you can email that to me -> d00p@froxlor.org in order to keep your data private ;))

Link to comment
Share on other sites
michapixel Newbie

michapixel

Posted
  • Author
Posted 




-- phpMyAdmin SQL Dump



-- version 3.3.7deb7



-- http://www.phpmyadmin.net



--



-- Host: localhost



-- Generation Time: Oct 25, 2013 at 07:33 PM



-- Server version: 5.1.72



-- PHP Version: 5.3.3-7+squeeze17


 



SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


 


 



/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;



/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;



/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;



/*!40101 SET NAMES utf8 */;


 



--



-- Database: `froxlor`



--


 



-- --------------------------------------------------------


 



--



-- Table structure for table `panel_ipsandports`



--


 



CREATE TABLE IF NOT EXISTS `panel_ipsandports` (



  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,



  `ip` varchar(39) NOT NULL DEFAULT '',



  `port` int(5) NOT NULL DEFAULT '80',



  `listen_statement` tinyint(1) NOT NULL DEFAULT '0',



  `namevirtualhost_statement` tinyint(1) NOT NULL DEFAULT '0',



  `vhostcontainer` tinyint(1) NOT NULL DEFAULT '0',



  `vhostcontainer_servername_statement` tinyint(1) NOT NULL DEFAULT '0',



  `specialsettings` text NOT NULL,



  `ssl` tinyint(4) NOT NULL DEFAULT '0',



  `ssl_cert_file` varchar(255) NOT NULL,



  `ssl_key_file` varchar(255) NOT NULL,



  `ssl_ca_file` varchar(255) NOT NULL,



  `default_vhostconf_domain` text NOT NULL,



  `ssl_cert_chainfile` varchar(255) NOT NULL,



  `docroot` varchar(255) NOT NULL DEFAULT '',



  PRIMARY KEY (`id`)



) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;


 



--



-- Dumping data for table `panel_ipsandports`



--


 



INSERT INTO `panel_ipsandports` (`id`, `ip`, `port`, `listen_statement`, `namevirtualhost_statement`, `vhostcontainer`, `vhostcontainer_servername_statement`, `specialsettings`, `ssl`, `ssl_cert_file`, `ssl_key_file`, `ssl_ca_file`, `default_vhostconf_domain`, `ssl_cert_chainfile`, `docroot`) VALUES



(1, 'xxx.xxx.xxx.124', 80, 0, 1, 1, 1, '', 0, '', '', '', '', '', ''),



(2, 'xxx.xxx.xxx.124', 443, 0, 1, 1, 1, '', 1, '/etc/apache2/ssl/apache.crt', '/etc/apache2/apache.key', '', '', '', '');


 







			
		


		

		
	


	

	





	
Link to comment

	
		
	
	
	

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					






	
		



	
	
    
	
		
	
	




	

	

	

		

			

				


	
		michapixel
	

				
				
					
						
Newbie
					
				
			

		

		

			

				


michapixel
			

			

				Posted 
				
			

		

	

	
	

		




	

		

			

				
    
					
						
  • Author
    • 
					
					
					
					
					
				

			

			
		


		

			Posted 
			
			
				
				
			
		

	


	

    

	

		
		

			






-- phpMyAdmin SQL Dump



-- version 3.3.7deb7



-- http://www.phpmyadmin.net



--



-- Host: localhost



-- Generation Time: Oct 25, 2013 at 08:19 PM



-- Server version: 5.1.72



-- PHP Version: 5.3.3-7+squeeze17


 



SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


 


 



/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;



/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;



/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;



/*!40101 SET NAMES utf8 */;


 



--



-- Database: `froxlor`



--


 



-- --------------------------------------------------------


 



--



-- Table structure for table `panel_domains`



--


 



CREATE TABLE IF NOT EXISTS `panel_domains` (



  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,



  `domain` varchar(255) NOT NULL DEFAULT '',



  `adminid` int(11) unsigned NOT NULL DEFAULT '0',



  `customerid` int(11) unsigned NOT NULL DEFAULT '0',



  `aliasdomain` int(11) unsigned DEFAULT NULL,



  `documentroot` varchar(255) NOT NULL DEFAULT '',



  `ipandport` int(11) unsigned NOT NULL DEFAULT '1',



  `isbinddomain` tinyint(1) NOT NULL DEFAULT '0',



  `isemaildomain` tinyint(1) NOT NULL DEFAULT '0',



  `email_only` tinyint(1) NOT NULL DEFAULT '0',



  `iswildcarddomain` tinyint(1) NOT NULL DEFAULT '1',



  `subcanemaildomain` tinyint(1) NOT NULL DEFAULT '0',



  `caneditdomain` tinyint(1) NOT NULL DEFAULT '1',



  `zonefile` varchar(255) NOT NULL DEFAULT '',



  `dkim` tinyint(1) NOT NULL DEFAULT '0',



  `dkim_id` int(11) unsigned NOT NULL,



  `dkim_privkey` text NOT NULL,



  `dkim_pubkey` text NOT NULL,



  `wwwserveralias` tinyint(1) NOT NULL DEFAULT '1',



  `parentdomainid` int(11) unsigned NOT NULL DEFAULT '0',



  `openbasedir` tinyint(1) NOT NULL DEFAULT '0',



  `openbasedir_path` tinyint(1) NOT NULL DEFAULT '0',



  `speciallogfile` tinyint(1) NOT NULL DEFAULT '0',



  `ssl` tinyint(4) NOT NULL DEFAULT '0',



  `ssl_redirect` tinyint(4) NOT NULL DEFAULT '0',



  `ssl_ipandport` tinyint(4) NOT NULL DEFAULT '0',



  `specialsettings` text NOT NULL,



  `deactivated` tinyint(1) NOT NULL DEFAULT '0',



  `bindserial` varchar(10) NOT NULL DEFAULT '2000010100',



  `add_date` int(11) NOT NULL DEFAULT '0',



  `registration_date` date NOT NULL,



  `phpsettingid` int(11) unsigned NOT NULL DEFAULT '1',



  `mod_fcgid_starter` int(4) DEFAULT '-1',



  `mod_fcgid_maxrequests` int(4) DEFAULT '-1',



  `ismainbutsubto` int(11) unsigned NOT NULL DEFAULT '0',



  PRIMARY KEY (`id`),



  KEY `customerid` (`customerid`),



  KEY `parentdomain` (`parentdomainid`),



  KEY `domain` (`domain`)



) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;


 



--



-- Dumping data for table `panel_domains`



--


 



INSERT INTO `panel_domains` (`id`, `domain`, `adminid`, `customerid`, `aliasdomain`, `documentroot`, `ipandport`, `isbinddomain`, `isemaildomain`, `email_only`, `iswildcarddomain`, `subcanemaildomain`, `caneditdomain`, `zonefile`, `dkim`, `dkim_id`, `dkim_privkey`, `dkim_pubkey`, `wwwserveralias`, `parentdomainid`, `openbasedir`, `openbasedir_path`, `speciallogfile`, `ssl`, `ssl_redirect`, `ssl_ipandport`, `specialsettings`, `deactivated`, `bindserial`, `add_date`, `registration_date`, `phpsettingid`, `mod_fcgid_starter`, `mod_fcgid_maxrequests`, `ismainbutsubto`) VALUES



(1, 'xxx.xxx.xxx.xx', 1, 1, NULL, '/var/customers/webs/XXX/', 2, 1, 0, 0, 1, 0, 1, '', 0, 0, '', '', 1, 0, 0, 0, 1, 1, 0, 2, '', 0, '2013080101', 2013, '0000-00-00', 1, -1, -1, 0),



(2, 'xxx.xx', 1, 1, NULL, '/var/customers/webs/XXX/xxx.xx/', 1, 1, 1, 0, 1, 0, 1, '', 1, 0, '', '', 1, 0, 0, 0, 1, 1, 0, 2, '', 0, '2013080101', 1371132703, '0000-00-00', 1, -1, -1, 0),



(3, 'xxx.xxx.xx', 1, 1, NULL, '/var/customers/webs/XXX/chat/', 1, 0, 0, 0, 0, 0, 1, '', 0, 0, '', '', 1, 2, 0, 0, 1, 0, 1, 0, '', 0, '2000010100', 0, '0000-00-00', 1, -1, -1, 0),



(4, 'xxx.xxx.xxx.xx', 1, 1, NULL, '/var/customers/webs/XXX/xxx.xxx.xxx.xx/', 1, 1, 1, 0, 1, 0, 1, '', 1, 0, '', '', 0, 0, 0, 0, 1, 1, 0, 2, '', 0, '2013080101', 1371134783, '0000-00-00', 1, -1, -1, 0),



(10, 'mail.xxx.xxx.xx', 1, 1, NULL, '/var/customers/webs/XXX/mail.xxx.xxx.xx/', 1, 1, 1, 0, 1, 0, 1, '', 1, 0, '', '', 0, 0, 1, 0, 1, 1, 1, 2, '', 0, '2013080101', 1371210155, '0000-00-00', 1, -1, -1, 0),



(11, 'mail.xxx.xx', 0, 1, NULL, '/var/customers/webs/XXX/mail.xxx.xxx.xx/', 1, 0, 0, 0, 0, 0, 1, '', 0, 0, '', '', 1, 2, 0, 0, 1, 0, 1, 0, '', 0, '2000010100', 0, '0000-00-00', 1, -1, -1, 0),



(7, 'xxx.xxx.xxx.xx', 1, 1, NULL, '/var/customers/webs/XXX/xxx.xxx.xxx.xx/', 1, 1, 1, 0, 0, 0, 1, '', 1, 0, '', '', 0, 0, 0, 0, 1, 1, 1, 2, '', 0, '2013080101', 1371194317, '0000-00-00', 1, -1, -1, 0),



(8, 'xxx.xxx.xx', 0, 1, NULL, '/var/customers/webs/XXX/xxx.xxx.xxx.xx/', 1, 0, 0, 0, 0, 0, 1, '', 0, 0, '', '', 1, 2, 0, 0, 1, 0, 1, 0, '', 0, '2000010100', 0, '0000-00-00', 1, -1, -1, 0);


 






 



			
		


		

		
	


	

	





	
Link to comment

	
		
	
	
	

	
	
Share on other sites

	

	


	

	

	




	



					
					
					
				

					

					
					





					
					
					
				

					

					
					





					
					
					
				

					

					
					





					
					
					
				

					

					
					





					
					
					
				

					

					
					





					
					
					
				
			
			



		

	


	
	
	
		

			
Archived

			

				This topic is now archived and is closed to further replies.
			

		

	
	
	

	







	

		
			
				Go to question listing
			
		
	

	




						


					

					


	

		
		
		
      
      


		


	

		
    
			
				
					
					
  • 
				
			
		

	


	


					

				

			

			
		

		
		


	

		×
		

			
				

					
				

			

			

			

			
		

	






	

		×
		

			
    
				
  • Create New...
    •