From owner-freebsd-bugs@FreeBSD.ORG Thu Sep 20 17:40:03 2012 Return-Path: Delivered-To: freebsd-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 47832106564A for ; Thu, 20 Sep 2012 17:40:03 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 300488FC1C for ; Thu, 20 Sep 2012 17:40:03 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.5/8.14.5) with ESMTP id q8KHe2Hr049771 for ; Thu, 20 Sep 2012 17:40:02 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.5/8.14.5/Submit) id q8KHe235049770; Thu, 20 Sep 2012 17:40:02 GMT (envelope-from gnats) Date: Thu, 20 Sep 2012 17:40:02 GMT Message-Id: <201209201740.q8KHe235049770@freefall.freebsd.org> To: freebsd-bugs@FreeBSD.org From: Ametov Imil Ilimdarovich Cc: Subject: Re: misc/171801: Problem with creating MySQL database from squid_db.sql. X-BeenThere: freebsd-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Ametov Imil Ilimdarovich List-Id: Bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 20 Sep 2012 17:40:03 -0000 The following reply was made to PR misc/171801; it has been noted by GNATS. From: Ametov Imil Ilimdarovich To: bug-followup@FreeBSD.org, charlz_klug@mail.ru Cc: Subject: Re: misc/171801: Problem with creating MySQL database from squid_db.sql. Date: Thu, 20 Sep 2012 21:59:43 +0500 --=-KSAw+oKq9tXPM+w5z0GT Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit To repeat this issue install /usr/ports/www/sams , /usr/ports/www/apache22, configure apache. In web-browser enter address "http://[IP_address]/sams/install.php" and press [Create Database] button. My fix: remove "TYPE=MyISAM" in /usr/local/share/sams/data/sams_db.sql . --=-KSAw+oKq9tXPM+w5z0GT Content-Disposition: attachment; filename="patch.txt" Content-Type: text/plain; name="patch.txt"; charset="UTF-8" Content-Transfer-Encoding: 7bit --- sams_db.sql.old 2012-09-20 08:39:21.000000000 +0500 +++ sams_db.sql 2012-09-20 08:43:15.000000000 +0500 @@ -4,53 +4,53 @@ USE squidctrl; DROP TABLE IF EXISTS `groups`; - CREATE TABLE `groups` ( `count` int(11), `name` char(25), `nick` char(25), `value` char(10)) TYPE=MyISAM; + CREATE TABLE `groups` ( `count` int(11), `name` char(25), `nick` char(25), `value` char(10)); INSERT INTO groups VALUES('0','user','Users','open'); INSERT INTO groups VALUES('1','admin','Administrators','open'); DROP TABLE IF EXISTS `ipreplace`; - CREATE TABLE `ipreplace` ( `ip` char(15), `user` char(25), `domain` char(25)) TYPE=MyISAM; + CREATE TABLE `ipreplace` ( `ip` char(15), `user` char(25), `domain` char(25)); DROP TABLE IF EXISTS `log`; - CREATE TABLE `log` ( `user` char(25), `date` date, `time` time, `value` char(60), `code` char(2)) TYPE=MyISAM; + CREATE TABLE `log` ( `user` char(25), `date` date, `time` time, `value` char(60), `code` char(2)); DROP TABLE IF EXISTS `passwd`; - CREATE TABLE `passwd` ( `user` char(25), `pass` char(60), `access` int(11)) TYPE=MyISAM; + CREATE TABLE `passwd` ( `user` char(25), `pass` char(60), `access` int(11)); INSERT INTO passwd VALUES('Admin','00YfpO1MXDzqQ','1'); INSERT INTO passwd VALUES('Auditor','00MTbxknCTtNs','1'); DROP TABLE IF EXISTS `reconfig`; - CREATE TABLE `reconfig` ( `number` int(2),`service` varchar (15),`action` varchar(10), `value` varchar(110)) TYPE=MyISAM; + CREATE TABLE `reconfig` ( `number` int(2),`service` varchar (15),`action` varchar(10), `value` varchar(110)); INSERT INTO reconfig VALUES('1','sams','',''); DROP TABLE IF EXISTS `redirect`; - CREATE TABLE `redirect` ( `name` varchar(25), `filename` varchar(25), `type` varchar(25), `show` int(10) unsigned, `redirect_to` varchar(100)) TYPE=MyISAM; + CREATE TABLE `redirect` ( `name` varchar(25), `filename` varchar(25), `type` varchar(25), `show` int(10) unsigned, `redirect_to` varchar(100)); INSERT INTO redirect VALUES('Banners','banners','redir','0',''); INSERT INTO redirect VALUES('Counters','counters','redir','0',''); INSERT INTO redirect VALUES('Chats','chat','denied','0',''); INSERT INTO redirect VALUES('Porno','porno','denied','0',''); INSERT INTO redirect VALUES('Localdomains','localhosts','denied','0',''); DROP TABLE IF EXISTS `sams`; - CREATE TABLE `sams` ( `endvalue` bigint(20), `redirect_to` varchar(100), `denied_to` varchar(100), `redirector` varchar(25), `delaypool` char(1), `useraccess` char(1), `auth` varchar(4), `wbinfopath` varchar(100),`urlaccess` char(1),`separator` varchar(15) default '+',`ntlmdomain` char(1),`bigd` char(1),`bigu` char(1),`sleep` int(3),`parser_on` char(1),`parser` varchar(10),`parser_time` int(2),`count_clean` char(1),`nameencode` char(1),`iconset` varchar(25),`days` varchar(14),`shour` tinyint(2) UNSIGNED ZEROFILL,`smin` tinyint(2) UNSIGNED ZEROFILL,`ehour` tinyint(2) UNSIGNED ZEROFILL,`emin` tinyint(2) UNSIGNED ZEROFILL,`autherrorc` tinyint(1), `autherrort` varchar(16), `realsize` varchar(4), `checkdns` varchar(1), `loglevel` tinyint(1) NOT NULL default '0',`defaultdomain` char(25) NOT NULL default 'workgroup', `squidbase` tinyint(2) NOT NULL default '0', udscript char(25) NOT NULL default 'NONE', adminaddr char(60) default '' ) TYPE=MyISAM; + CREATE TABLE `sams` ( `endvalue` bigint(20), `redirect_to` varchar(100), `denied_to` varchar(100), `redirector` varchar(25), `delaypool` char(1), `useraccess` char(1), `auth` varchar(4), `wbinfopath` varchar(100),`urlaccess` char(1),`separator` varchar(15) default '+',`ntlmdomain` char(1),`bigd` char(1),`bigu` char(1),`sleep` int(3),`parser_on` char(1),`parser` varchar(10),`parser_time` int(2),`count_clean` char(1),`nameencode` char(1),`iconset` varchar(25),`days` varchar(14),`shour` tinyint(2) UNSIGNED ZEROFILL,`smin` tinyint(2) UNSIGNED ZEROFILL,`ehour` tinyint(2) UNSIGNED ZEROFILL,`emin` tinyint(2) UNSIGNED ZEROFILL,`autherrorc` tinyint(1), `autherrort` varchar(16), `realsize` varchar(4), `checkdns` varchar(1), `loglevel` tinyint(1) NOT NULL default '0',`defaultdomain` char(25) NOT NULL default 'workgroup', `squidbase` tinyint(2) NOT NULL default '0', udscript char(25) NOT NULL default 'NONE', adminaddr char(60) default '' ); INSERT INTO sams VALUES('0','http://your.ip.address/sams/icon/classic/blank.gif','http://your.ip.address/sams/messages','none','Y','Y','ntlm','/usr/bin','Y','+','Y','','','1','','','','Y','N','classic','MTWHFAS','0','0','24','0','0','0','real','N','0','workgroup','0','NONE',''); DROP TABLE IF EXISTS `sconfig`; - CREATE TABLE `sconfig` ( `sname` char(25), `set` char(25)) TYPE=MyISAM; + CREATE TABLE `sconfig` ( `sname` char(25), `set` char(25)); DROP TABLE IF EXISTS `sguard`; - CREATE TABLE `sguard` ( `sname` varchar(25), `name` varchar(100), `domain` char(1), `url` char(1), `expr` char(1)) TYPE=MyISAM; + CREATE TABLE `sguard` ( `sname` varchar(25), `name` varchar(100), `domain` char(1), `url` char(1), `expr` char(1)); DROP TABLE IF EXISTS `shablons`; - CREATE TABLE `shablons` ( `name` varchar(25), `nick` varchar(25), `shablonpool` bigint, `userpool` bigint, `redirect_to` varchar(100),`auth` varchar(4),`traffic` int(25) ,`days` varchar(14),`shour` tinyint(2) UNSIGNED ZEROFILL,`smin` tinyint(2) UNSIGNED ZEROFILL,`ehour` tinyint(2) UNSIGNED ZEROFILL,`emin` tinyint(2) UNSIGNED ZEROFILL, `period` char(3) NOT NULL default 'M', `clrdate` date NOT NULL default '0000-00-00',`alldenied` tinyint(1) NOT NULL default '0' ) TYPE=MyISAM; + CREATE TABLE `shablons` ( `name` varchar(25), `nick` varchar(25), `shablonpool` bigint, `userpool` bigint, `redirect_to` varchar(100),`auth` varchar(4),`traffic` int(25) ,`days` varchar(14),`shour` tinyint(2) UNSIGNED ZEROFILL,`smin` tinyint(2) UNSIGNED ZEROFILL,`ehour` tinyint(2) UNSIGNED ZEROFILL,`emin` tinyint(2) UNSIGNED ZEROFILL, `period` char(3) NOT NULL default 'M', `clrdate` date NOT NULL default '0000-00-00',`alldenied` tinyint(1) NOT NULL default '0' ); INSERT INTO shablons VALUES('default','Default','64000','64000','','','100','MTWHFAS','0','0','24','0','M','0000-00-00','0'); DROP TABLE IF EXISTS `squidusers`; - CREATE TABLE `squidusers` ( `id` char(25), `nick` char(25), `family` char(25), `name` char(25), `soname` char(25), `group` char(25), `domain` char(25), `shablon` char(25), `quotes` bigint(20), `size` bigint(20), `enabled` int(11), `ip` char(15), `ipmask` char(15), `passwd` char(20), `gauditor` int(1),`hit` bigint(20) NOT NULL default '0', `autherrorc` tinyint(1) default '0', `autherrort` varchar(16) default '0' ) TYPE=MyISAM; + CREATE TABLE `squidusers` ( `id` char(25), `nick` char(25), `family` char(25), `name` char(25), `soname` char(25), `group` char(25), `domain` char(25), `shablon` char(25), `quotes` bigint(20), `size` bigint(20), `enabled` int(11), `ip` char(15), `ipmask` char(15), `passwd` char(20), `gauditor` int(1),`hit` bigint(20) NOT NULL default '0', `autherrorc` tinyint(1) default '0', `autherrort` varchar(16) default '0' ); DROP TABLE IF EXISTS `tree`; - CREATE TABLE `tree` ( `name` char(25), `value` tinyint(4)) TYPE=MyISAM; + CREATE TABLE `tree` ( `name` char(25), `value` tinyint(4)); DROP TABLE IF EXISTS `urlreplace`; - CREATE TABLE `urlreplace` ( `user` char(25), `domain` char(25), `url` char(50), `newurl` char(50)) TYPE=MyISAM; + CREATE TABLE `urlreplace` ( `user` char(25), `domain` char(25), `url` char(50), `newurl` char(50)); DROP TABLE IF EXISTS `urls`; - CREATE TABLE `urls` ( `url` char(90), `type` char(25)) TYPE=MyISAM; + CREATE TABLE `urls` ( `url` char(90), `type` char(25)); DROP TABLE IF EXISTS `globalsettings`; - CREATE TABLE `globalsettings` (`lang` varchar(15) NOT NULL default 'EN', `iconset`varchar(25) NOT NULL default 'classic', `useraccess` char(1) NOT NULL default 'Y', `urlaccess` char(1) NOT NULL default 'Y', `showutree` char(1) NOT NULL default 'Y' , `showname` varchar(5) NOT NULL default 'nick', `kbsize` char(15) NOT NULL default '1024', `mbsize` char(15) NOT NULL default '1048576', `showgraph` char(1) NOT NULL default 'N', `createpdf` varchar(6) NOT NULL default 'none') TYPE=MyISAM; + CREATE TABLE `globalsettings` (`lang` varchar(15) NOT NULL default 'EN', `iconset`varchar(25) NOT NULL default 'classic', `useraccess` char(1) NOT NULL default 'Y', `urlaccess` char(1) NOT NULL default 'Y', `showutree` char(1) NOT NULL default 'Y' , `showname` varchar(5) NOT NULL default 'nick', `kbsize` char(15) NOT NULL default '1024', `mbsize` char(15) NOT NULL default '1048576', `showgraph` char(1) NOT NULL default 'N', `createpdf` varchar(6) NOT NULL default 'none'); INSERT INTO `globalsettings` VALUES('EN','classic','Y','Y','Y','nick','1024','1048576','N','none'); UPDATE squidctrl.passwd SET passwd.pass=ENCRYPT("qwerty","00") WHERE passwd.user='Admin'; ALTER TABLE squidusers ADD INDEX (`nick`); ALTER TABLE squidusers ADD INDEX (`group`); ALTER TABLE squidusers ADD INDEX (`family`); DROP TABLE IF EXISTS `proxyes`; - CREATE TABLE `proxyes` ( `id` tinyint(3) default '0', `description` varchar(50) default 'Proxy server', `endvalue` int(20) default '0') TYPE=MyISAM; + CREATE TABLE `proxyes` ( `id` tinyint(3) default '0', `description` varchar(50) default 'Proxy server', `endvalue` int(20) default '0'); --=-KSAw+oKq9tXPM+w5z0GT--