After upgrade from old svn to 3.0.1.6 no more apache config updates

Discussion in 'Installation/Configuration' started by quentusrex, Feb 14, 2010.

  1. quentusrex

    quentusrex New Member

    -- phpMyAdmin SQL Dump
    -- version 2.11.8.1deb1ubuntu0.2
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generation Time: Feb 24, 2010 at 02:40 AM
    -- Server version: 5.0.67
    -- PHP Version: 5.2.6-2ubuntu4.6

    SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

    --
    -- Database: `dbispconfig`
    --

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

    --
    -- Table structure for table `sys_datalog`
    --

    CREATE TABLE IF NOT EXISTS `sys_datalog` (
    `datalog_id` int(11) unsigned NOT NULL auto_increment,
    `server_id` int(11) unsigned NOT NULL,
    `dbtable` varchar(255) NOT NULL default '',
    `dbidx` varchar(255) NOT NULL default '',
    `action` char(1) NOT NULL default '',
    `tstamp` int(11) NOT NULL default '0',
    `user` varchar(255) NOT NULL default '',
    `data` text NOT NULL,
    `status` set('pending','ok','warning','error') NOT NULL default 'pending',
    PRIMARY KEY (`datalog_id`),
    KEY `server_id` (`server_id`,`status`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=127 ;

    --
    -- Dumping data for table `sys_datalog`
    --

    INSERT INTO `sys_datalog` (`datalog_id`, `server_id`, `dbtable`, `dbidx`, `action`, `tstamp`, `user`, `data`, `status`) VALUES
    (123, 1, 'web_domain', 'domain_id:47', 'i', 1266871539, 'admin', 'a:2:{s:3:"new";a:39:{s:9:"domain_id";s:2:"47";s:10:"sys_userid";s:1:"1";s:11:"sys_groupid";s:1:"8";s:13:"sys_perm_user";s:4:"riud";s:14:"sys_perm_group";s:2:"ru";s:14:"sys_perm_other";s:0:"";s:9:"server_id";s:1:"1";s:10:"ip_address";s:1:"*";s:6:"domain";s:25:"test.test.mydomain.com";s:4:"type";s:5:"vhost";s:16:"parent_domain_id";s:1:"0";s:10:"vhost_type";s:4:"name";s:13:"document_root";s:26:"/var/clients/client7/web47";s:11:"system_user";s:5:"web47";s:12:"system_group";s:7:"client7";s:8:"hd_quota";s:2:"-1";s:13:"traffic_quota";s:1:"0";s:3:"cgi";s:1:"n";s:3:"ssi";s:1:"n";s:6:"suexec";s:1:"n";s:9:"errordocs";s:1:"1";s:15:"is_subdomainwww";s:1:"1";s:9:"subdomain";s:4:"none";s:3:"php";s:5:"suphp";s:13:"redirect_type";N;s:13:"redirect_path";N;s:3:"ssl";s:1:"n";s:9:"ssl_state";N;s:12:"ssl_locality";N;s:16:"ssl_organisation";N;s:21:"ssl_organisation_unit";N;s:11:"ssl_country";N;s:11:"ssl_request";N;s:8:"ssl_cert";N;s:10:"ssl_bundle";N;s:10:"ssl_action";N;s:14:"stats_password";N;s:17:"apache_directives";N;s:6:"active";s:1:"y";}s:3:"old";a:39:{s:9:"domain_id";N;s:10:"sys_userid";N;s:11:"sys_groupid";N;s:13:"sys_perm_user";N;s:14:"sys_perm_group";N;s:14:"sys_perm_other";s:0:"";s:9:"server_id";N;s:10:"ip_address";N;s:6:"domain";N;s:4:"type";N;s:16:"parent_domain_id";N;s:10:"vhost_type";N;s:13:"document_root";N;s:11:"system_user";N;s:12:"system_group";N;s:8:"hd_quota";N;s:13:"traffic_quota";N;s:3:"cgi";N;s:3:"ssi";N;s:6:"suexec";N;s:9:"errordocs";N;s:15:"is_subdomainwww";N;s:9:"subdomain";N;s:3:"php";N;s:13:"redirect_type";N;s:13:"redirect_path";N;s:3:"ssl";N;s:9:"ssl_state";N;s:12:"ssl_locality";N;s:16:"ssl_organisation";N;s:21:"ssl_organisation_unit";N;s:11:"ssl_country";N;s:11:"ssl_request";N;s:8:"ssl_cert";N;s:10:"ssl_bundle";N;s:10:"ssl_action";N;s:14:"stats_password";N;s:17:"apache_directives";N;s:6:"active";N;}}', 'pending'),
    (124, 1, 'web_domain', 'domain_id:48', 'i', 1266874911, 'admin', 'a:2:{s:3:"new";a:39:{s:9:"domain_id";s:2:"48";s:10:"sys_userid";s:1:"1";s:11:"sys_groupid";s:1:"8";s:13:"sys_perm_user";s:4:"riud";s:14:"sys_perm_group";s:2:"ru";s:14:"sys_perm_other";s:0:"";s:9:"server_id";s:1:"1";s:10:"ip_address";s:1:"*";s:6:"domain";s:21:"test3.mydomain.com";s:4:"type";s:5:"vhost";s:16:"parent_domain_id";s:1:"0";s:10:"vhost_type";s:4:"name";s:13:"document_root";s:26:"/var/clients/client7/web48";s:11:"system_user";s:5:"web48";s:12:"system_group";s:7:"client7";s:8:"hd_quota";s:2:"-1";s:13:"traffic_quota";s:1:"0";s:3:"cgi";s:1:"n";s:3:"ssi";s:1:"n";s:6:"suexec";s:1:"n";s:9:"errordocs";s:1:"1";s:15:"is_subdomainwww";s:1:"1";s:9:"subdomain";s:4:"none";s:3:"php";s:2:"no";s:13:"redirect_type";N;s:13:"redirect_path";N;s:3:"ssl";s:1:"n";s:9:"ssl_state";N;s:12:"ssl_locality";N;s:16:"ssl_organisation";N;s:21:"ssl_organisation_unit";N;s:11:"ssl_country";N;s:11:"ssl_request";N;s:8:"ssl_cert";N;s:10:"ssl_bundle";N;s:10:"ssl_action";N;s:14:"stats_password";N;s:17:"apache_directives";N;s:6:"active";s:1:"y";}s:3:"old";a:39:{s:9:"domain_id";N;s:10:"sys_userid";N;s:11:"sys_groupid";N;s:13:"sys_perm_user";N;s:14:"sys_perm_group";N;s:14:"sys_perm_other";s:0:"";s:9:"server_id";N;s:10:"ip_address";N;s:6:"domain";N;s:4:"type";N;s:16:"parent_domain_id";N;s:10:"vhost_type";N;s:13:"document_root";N;s:11:"system_user";N;s:12:"system_group";N;s:8:"hd_quota";N;s:13:"traffic_quota";N;s:3:"cgi";N;s:3:"ssi";N;s:6:"suexec";N;s:9:"errordocs";N;s:15:"is_subdomainwww";N;s:9:"subdomain";N;s:3:"php";N;s:13:"redirect_type";N;s:13:"redirect_path";N;s:3:"ssl";N;s:9:"ssl_state";N;s:12:"ssl_locality";N;s:16:"ssl_organisation";N;s:21:"ssl_organisation_unit";N;s:11:"ssl_country";N;s:11:"ssl_request";N;s:8:"ssl_cert";N;s:10:"ssl_bundle";N;s:10:"ssl_action";N;s:14:"stats_password";N;s:17:"apache_directives";N;s:6:"active";N;}}', 'pending');
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Short update regarding your SQL query "SELECT * FROM server WHERE update = 1 AND server_id ...". Did you notice that this code is commented out in server.php in ISPConfig 3.0.1.6 and not in use? The query that is used is:

    "SELECT updated, config FROM server WHERE server_id = ".$conf["server_id"]

    which a few lines below.
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    Looks good. Please take a look into the table server, which number is in the field "updated" for the row with server_id = 1
     
  4. quentusrex

    quentusrex New Member

    That might be where the corruption is located. the field value is 796
     
  5. quentusrex

    quentusrex New Member

    I just changed it to 1 below the lowest row id. And ran the server script. It updated everything.

    Thanks a ton for the help till. Is there something I can do to help out?
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Please take a look in the sys_datalog and try to find out the datalog_id since when approx. the changes stopped and then enter this datalog_id into the updated field of the server table. Afterwards, run the server.sh script. If it works then, donte vorget to activate it in crontab again.
     
  7. quentusrex

    quentusrex New Member

    Till,

    One more question. How do I get the ISPConfig update/install script to regenerate the postfix and other service config files? I have made a few local modifications that I want to remove, but forgot which ones they were.
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    You did this already by running the update again. ut ispconfig does not overwrite complete config files, it just changes variables selectively. So you can not use ispconfig to restore settings that where not configured by ispconfig in e.g. postfix main.cf.
     
  9. quentusrex

    quentusrex New Member

    Is there a way that an option can be added to regenerate the configs from scratch?
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    No, as ISPConfig does not know the setup before as it does not contain copy of the config files and these config files might be different depending on your server hosting provider.

    I recommend to make regular backups of your system so you always have a copy of all files then.
     

Share This Page