Биллинговая система Nodeny

g /usr/local/nodeny/sat.cfg

<<< Подключение всех модулей >>>

Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.019386 sec

SELECT * FROM config ORDER BY time DESC LIMIT 1
Строк: 0. Время выполнения sql: 0.0003 сек


--- Module MyNetwork ---

File patch.RU_user.pl

  { file=>'web/lang/RU_user.pl',hook=>'main' }

File patch.UA_user.pl

  { file=>'web/lang/UA_user.pl',hook=>'main' }

File patch.web_plugins


--- Module NoDeny ---

Tablespace is missing for table `nodeny`.`pon_onu`.

{
  'sql' => 'CREATE TABLE IF NOT EXISTS `pon_onu` (
  `id` mediumint(7) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sn` char(32) NOT NULL,
  `vendor` char(64) NOT NULL DEFAULT \'\',
  `model` char(24) NOT NULL DEFAULT \'\',
  `firmware` char(24) NOT NULL DEFAULT \'\',
  `descr` char(255) NOT NULL DEFAULT \'\',
  `changed` int(11) NOT NULL DEFAULT \'0\',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sn` (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=\'ONU list\';
',
  'param' => []
};

 CREATE TABLE IF NOT EXISTS `pon_onu` (
  `id` mediumint(7) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sn` char(32) NOT NULL,
  `vendor` char(64) NOT NULL DEFAULT '',
  `model` char(24) NOT NULL DEFAULT '',
  `firmware` char(24) NOT NULL DEFAULT '',
  `descr` char(255) NOT NULL DEFAULT '',
  `changed` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sn` (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ONU list';


Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.000554 sec

Tablespace is missing for table `nodeny`.`data1`.

{
  'param' => [],
  'sql' => 'INSERT INTO data1 (uid) SELECT id FROM users ON DUPLICATE KEY UPDATE uid=uid;'
};

 INSERT INTO data1 (uid) SELECT id FROM users ON DUPLICATE KEY UPDATE uid=uid;

Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.000341 sec

Tablespace is missing for table `nodeny`.`pon_ports`.

{
  'sql' => 'CREATE TABLE IF NOT EXISTS `pon_ports` (
  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `olt_id` smallint(11) NOT NULL,
  `name` varchar(30) NOT NULL DEFAULT \'new olt\',
  `p_index` varchar(30) NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT \'\',
  `shelf` tinyint(2) NOT NULL DEFAULT \'0\',
  `slot` tinyint(2) NOT NULL DEFAULT \'0\',
  `port` tinyint(2) NOT NULL DEFAULT \'0\',
  `tx` varchar(10) NOT NULL DEFAULT \'\',
  `descr` varchar(250) NOT NULL DEFAULT \'\',
  `status` tinyint(1) NOT NULL DEFAULT \'9\',
  `enable` tinyint(1) NOT NULL DEFAULT \'0\',
  `changed` int(11) NOT NULL DEFAULT \'0\',
  PRIMARY KEY (`id`),
  UNIQUE KEY `olt_id` (`olt_id`,`p_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=\'OLT ports\';
',
  'param' => []
};

 CREATE TABLE IF NOT EXISTS `pon_ports` (
  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `olt_id` smallint(11) NOT NULL,
  `name` varchar(30) NOT NULL DEFAULT 'new olt',
  `p_index` varchar(30) NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT '',
  `shelf` tinyint(2) NOT NULL DEFAULT '0',
  `slot` tinyint(2) NOT NULL DEFAULT '0',
  `port` tinyint(2) NOT NULL DEFAULT '0',
  `tx` varchar(10) NOT NULL DEFAULT '',
  `descr` varchar(250) NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '9',
  `enable` tinyint(1) NOT NULL DEFAULT '0',
  `changed` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `olt_id` (`olt_id`,`p_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OLT ports';


Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.000333 sec

Tablespace is missing for table `nodeny`.`services_log`.

{
  'param' => [],
  'sql' => 'CREATE TABLE IF NOT EXISTS `services_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(64) NOT NULL,
  `uid` bigint(20) unsigned NOT NULL,
  `token` bigint(20) unsigned NOT NULL,
  `service_id` int(10) unsigned,
  `tm_start` int(10) unsigned NOT NULL,
  `tm_end` int(10) unsigned NOT NULL DEFAULT \'0\',
  `price` float NOT NULL DEFAULT \'0\',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `module` (`module`(16)),
  KEY `tm_start` (`tm_start`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
'
};

 CREATE TABLE IF NOT EXISTS `services_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(64) NOT NULL,
  `uid` bigint(20) unsigned NOT NULL,
  `token` bigint(20) unsigned NOT NULL,
  `service_id` int(10) unsigned,
  `tm_start` int(10) unsigned NOT NULL,
  `tm_end` int(10) unsigned NOT NULL DEFAULT '0',
  `price` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `module` (`module`(16)),
  KEY `tm_start` (`tm_start`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;


Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.000342 sec

Tablespace is missing for table `nodeny`.`pon_bind`.

{
  'sql' => 'CREATE TABLE IF NOT EXISTS pon_bind (
  id smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  sn char(18) NOT NULL,
  olt_id smallint(4) NOT NULL,
  llid char(16) NOT NULL,
  name char(32) NOT NULL DEFAULT \'\',
  user int(10) NOT NULL DEFAULT \'0\',
  place int(10) NOT NULL DEFAULT \'0\',
  tx char(6) DEFAULT NULL,
  rx char(6) DEFAULT NULL,
  status char(30) DEFAULT NULL,
  dereg char(24) DEFAULT NULL,
  changed int(11) NOT NULL DEFAULT \'0\',
  PRIMARY KEY (id),
  UNIQUE KEY uniq (olt_id,llid) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=\'ONU binds\';
',
  'param' => []
};

 CREATE TABLE IF NOT EXISTS pon_bind (
  id smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  sn char(18) NOT NULL,
  olt_id smallint(4) NOT NULL,
  llid char(16) NOT NULL,
  name char(32) NOT NULL DEFAULT '',
  user int(10) NOT NULL DEFAULT '0',
  place int(10) NOT NULL DEFAULT '0',
  tx char(6) DEFAULT NULL,
  rx char(6) DEFAULT NULL,
  status char(30) DEFAULT NULL,
  dereg char(24) DEFAULT NULL,
  changed int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (id),
  UNIQUE KEY uniq (olt_id,llid) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ONU binds';


Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.000322 sec

Tablespace is missing for table `nodeny`.`notifications_users`.



sql error. Run with -v at /usr/local/nodeny/modules/NoDeny/run.pl line 86.