Welcome, Guest
Email: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: Mailborder server cant show logs. MySQL Error: 1064

Mailborder server cant show logs. MySQL Error: 1064 03 Feb 2019 20:22 #7

  • Jerry Benton
  • Jerry Benton's Avatar
  • Offline
  • Administrator
  • Administrator
  • Rawr
  • Posts: 2595
  • Thank you received: 319
Did you run out of disk space or something? You might need ot run the repair command from above again.

Please Log in or Create an account to join the conversation.

--
Jerry Benton
Mailborder Systems
LinkedIn Profile

Mailborder server cant show logs. MySQL Error: 1064 03 Feb 2019 20:31 #8

  • Jerry Benton
  • Jerry Benton's Avatar
  • Offline
  • Administrator
  • Administrator
  • Rawr
  • Posts: 2595
  • Thank you received: 319
Use this as a last resort:
drop table cp_maillog;

CREATE TABLE IF NOT EXISTS `cp_maillog` (
  `db_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `id` varchar(30) NOT NULL,
  `size` bigint(20) DEFAULT '0',
  `from_address` varchar(255) DEFAULT NULL,
  `from_domain` varchar(255) DEFAULT NULL,
  `to_address` varchar(255) DEFAULT NULL,
  `to_domain` varchar(255) DEFAULT NULL,
  `subject` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `clientip` varchar(15) DEFAULT NULL,
  `archive` varchar(100) DEFAULT NULL,
  `isspam` tinyint(1) DEFAULT '0',
  `ishighspam` tinyint(1) DEFAULT '0',
  `issaspam` tinyint(1) DEFAULT '0',
  `isrblspam` tinyint(1) DEFAULT '0',
  `spamwhitelisted` tinyint(1) DEFAULT '0',
  `spamblacklisted` tinyint(1) DEFAULT '0',
  `sascore` decimal(7,2) DEFAULT '0.00',
  `spamreport` text,
  `virusinfected` tinyint(1) DEFAULT '0',
  `nameinfected` tinyint(1) DEFAULT '0',
  `sizeinfected` tinyint(1) DEFAULT '0',
  `otherinfected` tinyint(1) DEFAULT '0',
  `report` text,
  `ismcp` tinyint(1) DEFAULT '0',
  `ishighmcp` tinyint(1) DEFAULT '0',
  `issamcp` tinyint(1) DEFAULT '0',
  `mcpwhitelisted` tinyint(1) DEFAULT '0',
  `mcpblacklisted` tinyint(1) DEFAULT '0',
  `mcpsascore` decimal(7,2) DEFAULT '0.00',
  `mcpreport` text,
  `hostname` varchar(100) DEFAULT NULL,
  `date` date NOT NULL DEFAULT '0000-00-00',
  `time` time DEFAULT NULL,
  `headers` text,
  `quarantined` tinyint(1) DEFAULT '0',
  `released` tinyint(1) DEFAULT '0',
  `guid` varchar(40) NOT NULL,
  PRIMARY KEY (`db_id`,`date`),
  KEY `id` (`id`),
  KEY `timestamp` (`timestamp`),
  KEY `from_address` (`from_address`),
  KEY `from_domain` (`from_domain`),
  KEY `to_address` (`to_address`),
  KEY `to_domain` (`to_domain`),
  KEY `guid` (`guid`),
  KEY `isspam` (`isspam`),
  KEY `ishighspam` (`ishighspam`),
  KEY `issaspam` (`issaspam`),
  KEY `isrblspam` (`isrblspam`),
  KEY `spamwhitelisted` (`spamwhitelisted`),
  KEY `spamblacklisted` (`spamblacklisted`),
  KEY `virusinfected` (`virusinfected`),
  KEY `nameinfected` (`nameinfected`),
  KEY `otherinfected` (`otherinfected`),
  KEY `quarantined` (`quarantined`),
  KEY `sizeinfected` (`sizeinfected`),
  KEY `ismcp` (`ismcp`),
  KEY `ishighmcp` (`ishighmcp`),
  KEY `issamcp` (`issamcp`),
  KEY `mcpwhitelisted` (`mcpwhitelisted`),
  KEY `mcpblacklisted` (`mcpblacklisted`),
  KEY `released` (`released`),
  KEY `size` (`size`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Please Log in or Create an account to join the conversation.

--
Jerry Benton
Mailborder Systems
LinkedIn Profile

Mailborder server cant show logs. MySQL Error: 1064 03 Feb 2019 20:32 #9

  • Jerry Benton
  • Jerry Benton's Avatar
  • Offline
  • Administrator
  • Administrator
  • Rawr
  • Posts: 2595
  • Thank you received: 319
You will then need to open /mailborder/config and get the database user name (5th line) and grant access to the maillog table in mysql . Again, last resort.

Please Log in or Create an account to join the conversation.

--
Jerry Benton
Mailborder Systems
LinkedIn Profile
Last Edit: by Jerry Benton.

Mailborder server cant show logs. MySQL Error: 1064 04 Feb 2019 19:26 #10

  • Eferaki.com.tr
  • Eferaki.com.tr's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 7
  • Thank you received: 0
mail log is running.
drop database and then
create new database
end the end grand permission.
it works.
thank you very much.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2
Time to create page: 0.030 seconds
Powered by Kunena Forum