migration from ispcp

oldev01 · Jun 20th 2011

with logs was so easy =).
sql code:

Code

DROP TABLE IF EXISTS `web_software`;
CREATE TABLE IF NOT EXISTS `web_software` (
`software_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`software_master_id` int(10) unsigned NOT NULL DEFAULT '0',
`reseller_id` int(10) unsigned NOT NULL DEFAULT '0',
`software_installtype` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
`software_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`software_version` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`software_language` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`software_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`software_db` tinyint(1) NOT NULL,
`software_archive` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`software_installfile` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`software_prefix` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`software_link` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`software_desc` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`software_active` int(1) NOT NULL,
`software_status` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`rights_add_by` int(10) unsigned NOT NULL DEFAULT '0',
`software_depot` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
PRIMARY KEY (`software_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `web_software_depot`
--
DROP TABLE IF EXISTS `web_software_depot`;
CREATE TABLE IF NOT EXISTS `web_software_depot` (
`package_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`package_install_type` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`package_title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`package_version` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`package_language` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`package_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`package_description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
`package_vendor_hp` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`package_download_link` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`package_signature_link` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`package_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `web_software_inst`
--
DROP TABLE IF EXISTS `web_software_inst`;
CREATE TABLE IF NOT EXISTS `web_software_inst` (
`domain_id` int(10) unsigned NOT NULL,
`alias_id` int(10) unsigned NOT NULL DEFAULT '0',
`subdomain_id` int(10) unsigned NOT NULL DEFAULT '0',
`subdomain_alias_id` int(10) unsigned NOT NULL DEFAULT '0',
`software_id` int(10) NOT NULL,
`software_master_id` int(10) unsigned NOT NULL DEFAULT '0',
`software_res_del` int(1) NOT NULL DEFAULT '0',
`software_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`software_version` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`software_language` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`path` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`software_prefix` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`db` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`database_user` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`database_tmp_pwd` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`install_username` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`install_password` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`install_email` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`software_status` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`software_depot` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
KEY `software_id` (`software_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `web_software_options`
--
DROP TABLE IF EXISTS `web_software_options`;
CREATE TABLE IF NOT EXISTS `web_software_options` (
`use_webdepot` tinyint(1) unsigned NOT NULL DEFAULT '1',
`webdepot_xml_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`webdepot_last_update` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `web_software_options`
--
INSERT INTO `web_software_options` (`use_webdepot`, `webdepot_xml_url`, `webdepot_last_update`) VALUES
(1, 'http://app-pkg.i-mscp.net/imscp_webdepot_list.xml', '0000-00-00 00:00:00');

Display More

Problem corrected in beta 2, but you must run this with pma. Then run again setup

**Kika** · Jun 20th 2011

running again

**Nuxwin** · Jun 20th 2011

My poor Kika, you are served with the migration.

**Kika** · Jun 20th 2011

Hi Nuxwin, you couldn't sleep?

**Nuxwin** · Jun 20th 2011

Quote from Kika

Hi Nuxwin, you couldn't sleep?

No, I'm still improve i-MSCP for you.

**Kika** · Jun 20th 2011

thanks

oldev01 · Jun 20th 2011

Well, was ok this time? So i can go sleep

**Kika** · Jun 20th 2011

maybe the rebuilding process was frozzen. The logs didn't changed in the last 10 minutes

oldev01 · Jun 20th 2011

No more probably is at permission step. with debug enabled take some time

**Kika** · Jun 20th 2011

sci2tech: you must go to sleep. Thanks for all.

if the setup do nothing than i will go too and we will see after wakeup. When i restart the apache, than the domains are works, the ftp and the mail are works so this will continue today evening.

migration from ispcp

Share

Daily visitors