> файл mysql.log создал ручками /usr/local/libexec/mysqld, Version: 5.0.92-log (FreeBSD port: mysql-server-5.0.92). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
111219 12:02:01 1 Connect Access denied for user 'root'@'localhost' (using password: NO)
111219 12:07:11 2 Connect KAV@192.168.1.30 on mysql
2 Query set autocommit=1
2 Query SET @@session.max_sp_recursion_depth = 32
2 Quit
111219 12:07:26 3 Connect KAV@192.168.1.30 on mysql
3 Query set autocommit=1
3 Query SET @@session.max_sp_recursion_depth = 32
3 Query SELECT SCHEMA_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = 'KAV'
3 Quit
111219 12:09:33 4 Connect KAV@192.168.1.30 on mysql
4 Query set autocommit=1
4 Query SET @@session.max_sp_recursion_depth = 32
4 Quit
111219 12:09:48 5 Connect KAV@192.168.1.30 on mysql
5 Query set autocommit=1
5 Query SET @@session.max_sp_recursion_depth = 32
5 Query DROP DATABASE IF EXISTS `KAV`
5 Query CREATE DATABASE IF NOT EXISTS `KAV` DEFAULT CHARACTER SET `ascii` COLLATE `ascii_general_ci`
5 Query USE `KAV`
5 Query CREATE FUNCTION AK_CAST2REAL(
nVal REAL)
RETURNS REAL
DETERMINISTIC
BEGIN
RETURN nVal;
END
5 Query CREATE FUNCTION AK_CAST2FLOAT(
nVal FLOAT)
RETURNS FLOAT
DETERMINISTIC
BEGIN
RETURN nVal;
END
5 Query CREATE FUNCTION AK_CAST2BIGINT(
nVal BIGINT)
RETURNS BIGINT
DETERMINISTIC
BEGIN
RETURN nVal;
END
5 Query CREATE FUNCTION AK_CAST2BIT(
bVal BOOL)
RETURNS BOOL
DETERMINISTIC
BEGIN
RETURN bVal;
END
5 Query CREATE FUNCTION AK_CAST2INT(
nVal INT)
RETURNS int
DETERMINISTIC
BEGIN
RETURN nVal;
END
5 Query CREATE PROCEDURE AK_TABLE_IFEXISTS_P(
IN strTableName varchar(64),
OUT nCount INT)
BEGIN
DECLARE CONTINUE HANDLER FOR SQLSTATE '42S02' SET nCount = NULL;
SET nCount = 0;
SET @s = CONCAT('SELECT COUNT(*) INTO @a FROM ', strTableName, ' WHERE 0');
PREPARE stmt1 FROM @s;
IF nCount IS NOT NULL THEN
EXECUTE stmt1;
END IF;
IF nCount IS NOT NULL THEN
DEALLOCATE PREPARE stmt1;
END IF;
END
5 Query CREATE FUNCTION AK_DATEDIFF_SEC(
startdate datetime,
enddate datetime)
RETURNS int
DETERMINISTIC
BEGIN
DECLARE diff int;
if startdate IS NULL OR enddate IS NULL THEN
RETURN NULL;
END IF;
SET diff = UNIX_TIMESTAMP(enddate) - UNIX_TIMESTAMP(startdate);
RETURN diff;
END
5 Query CREATE FUNCTION AK_DATEDIFF_MIN(
startdate datetime,
enddate datetime)
RETURNS int
DETERMINISTIC
BEGIN
RETURN AK_DATEDIFF_SEC(startdate, enddate)/60;
END
5 Query CREATE FUNCTION AK_DATEDIFF_HOUR(
startdate datetime,
enddate datetime)
RETURNS int
DETERMINISTIC
BEGIN
RETURN AK_DATEDIFF_SEC(startdate, enddate)/3600;
END
5 Query CREATE FUNCTION AK_DATEDIFF_DAY(
startdate datetime,
enddate datetime)
RETURNS int
DETERMINISTIC
BEGIN
RETURN AK_DATEDIFF_SEC(startdate, enddate)/86400;
END
5 Query CREATE PROCEDURE ak_fake_operator()
BEGIN
END
5 Query CREATE PROCEDURE AK_EXECUTE(
IN strSQL TEXT)
BEGIN
SET @s = strSQL;
PREPARE stmt1 FROM @s;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1;
END
5 Query CREATE FUNCTION `grp_get_unassigned` () RETURNS INT
DETERMINISTIC
BEGIN
RETURN 1 ;
END
5 Query CREATE FUNCTION `grp_get_root` () RETURNS INT
DETERMINISTIC
BEGIN
RETURN 0 ;
END
5 Query CREATE FUNCTION `grp_get_super` () RETURNS INT
READS SQL DATA
BEGIN
DECLARE __st_FETCH_STATUS INT;
DECLARE `__vtmp_nId` INT;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET __st_FETCH_STATUS = 1;
SELECT SQL_CALC_FOUND_ROWS `nId` INTO `__vtmp_nId` FROM `AdmGroups` WHERE `nParentId` IS NULL AND `bChildUnassigned` = 0 LIMIT 1;
RETURN `__vtmp_nId` ;
END
5 Query CREATE FUNCTION `hst_priv_get_rtp_state_avg` (
`__vtmp_host_id` INT) RETURNS INT
READS SQL DATA
BEGIN
DECLARE __st_FETCH_STATUS INT;
DECLARE `__vtmp_nRtpState` INT;
DECLARE `__vtmp_nRtpCount` INT;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET __st_FETCH_STATUS = 1;
SELECT SQL_CALC_FOUND_ROWS `nRtpState` , `nRtpCount` INTO `__vtmp_nRtpState` , `__vtmp_nRtpCount` FROM `hst_status_buffer` WHERE `nId` = `__vtmp_host_id` LIMIT 1;
IF (0 = 0 AND (`__vtmp_nRtpState` IS NOT NULL )AND `__vtmp_nRtpCount` >= 3 ) THEN
RETURN `__vtmp_nRtpState` ;
END IF;
RETURN NULL ;
END
5 Query CREATE FUNCTION `hst_priv_get_avs_inactive_avg` (
`__vtmp_host_id` INT) RETURNS INT
READS SQL DATA
BEGIN
DECLARE __st_FETCH_STATUS INT;
DECLARE `__vtmp_nAvsInactive` INT;
DECLARE `__vtmp_nAvsCount` INT;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET __st_FETCH_STATUS = 1;
SELECT SQL_CALC_FOUND_ROWS `nAVsInactive` , `nAVsCount` INTO `__vtmp_nAvsInactive` , `__vtmp_nAvsCount` FROM `hst_status_buffer` WHERE `nId` = `__vtmp_host_id` LIMIT 1;
IF (0 = 0 AND (`__vtmp_nAvsInactive` IS NOT NULL )AND `__vtmp_nAvsCount` >= 3 ) THEN
IF (`__vtmp_nAvsInactive` IS NOT NULL AND `__vtmp_nAvsInactive` <> 0 ) THEN
SELECT SQL_CALC_FOUND_ROWS COUNT( `nId` ) INTO `__vtmp_nAvsInactive` FROM `hst_prdstates` WHERE `tmAvbasesDate` IS NOT NULL AND `nState` = 0 AND `nHostId` = `__vtmp_host_id` LIMIT 1;
END IF;
RETURN `__vtmp_nAvsInactive` ;
END IF;
RETURN NULL ;
END
5 Query CREATE FUNCTION `hst_priv_get_rtp_state` (
`__vtmp_host_id` INT) RETURNS INT
READS SQL DATA
BEGIN
DECLARE __st_FETCH_STATUS INT;
DECLARE `__vtmp_nRtpState` INT;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET __st_FETCH_STATUS = 1;
SELECT SQL_CALC_FOUND_ROWS `hst_status_buffer`.`nRtpState` INTO `__vtmp_nRtpState` FROM `hst_status_buffer` INNER JOIN `Hosts` ON `hst_status_buffer`.`nId` = `Hosts`.`nId` AND (`Hosts`.`nStatus` & 1 )<> 0 WHERE `hst_status_buffer`.`nId` = `__vtmp_host_id` LIMIT 1;
IF (0 = 0 ) THEN
RETURN `__vtmp_nRtpState` ;
END IF;
RETURN NULL ;
END
5 Query CREATE FUNCTION `hst_priv_get_avs_inactive` (
`__vtmp_host_id` INT) RETURNS INT
READS SQL DATA
BEGIN
DECLARE __st_FETCH_STATUS INT;
DECLARE `__vtmp_nAvsInactive` INT;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET __st_FETCH_STATUS = 1;
SELECT SQL_CALC_FOUND_ROWS `nAVsInactive` INTO `__vtmp_nAvsInactive` FROM `hst_status_buffer` INNER JOIN `Hosts` ON `hst_status_buffer`.`nId` = `Hosts`.`nId` AND (`Hosts`.`nStatus` & 1 )<> 0 WHERE `hst_status_buffer`.`nId` = `__vtmp_host_id` LIMIT 1;
IF (0 = 0 AND (`__vtmp_nAvsInactive` IS NOT NULL )) THEN
IF (`__vtmp_nAvsInactive` IS NOT NULL AND `__vtmp_nAvsInactive` <> 0 ) THEN
SELECT SQL_CALC_FOUND_ROWS COUNT( `nId` ) INTO `__vtmp_nAvsInactive` FROM `hst_prdstates` WHERE `tmAvbasesDate` IS NOT NULL AND `nState` = 0 AND `nHostId` = `__vtmp_host_id` LIMIT 1;
END IF;
RETURN `__vtmp_nAvsInactive` ;
END IF;
RETURN NULL ;
END
5 Query CREATE FUNCTION `hst_ip_2_str` (
`__vtmp_ip_long` BIGINT) RETURNS VARCHAR(16)
DETERMINISTIC
BEGIN
DECLARE `__vtmp_strResult` VARCHAR(16);
IF (`__vtmp_ip_long` IS NOT NULL ) THEN
SET `__vtmp_strResult` = CONCAT( CAST(((`__vtmp_ip_long` DIV 16777216 )& 255 ) AS CHAR(4)) , '.' , CAST(((`__vtmp_ip_long` DIV 65536 )& 255 ) AS CHAR(4)) , '.' , CAST(((`__vtmp_ip_long` DIV 256 )& 255 ) AS CHAR(4)) , '.' , CAST(((`__vtmp_ip_long` )& 255 ) AS CHAR(4)) ) ;
END IF;
RETURN `__vtmp_strResult` ;
END
5 Query CREATE FUNCTION `hst_unconvert_ip` (
`__vtmp_ip_long` BIGINT) RETURNS INT
DETERMINISTIC
BEGIN
DECLARE `__vtmp_Temp` BIGINT;
IF (`__vtmp_ip_long` IS NULL ) THEN
RETURN NULL ;
END IF;
SET `__vtmp_Temp` = ((`__vtmp_ip_long` % 256 )* 16777216 )| (((`__vtmp_ip_long` DIV 256 )% 256 )* 65536 )| (((`__vtmp_ip_long` DIV 65536 )% 256 )* 256 )| (((`__vtmp_ip_long` DIV 16777216 )% 256 ));
IF (`__vtmp_Temp` > 2147483648 ) THEN
SET `__vtmp_Temp` = `__vtmp_Temp` - 4294967296 ;
END IF;
RETURN AK_CAST2INT(`__vtmp_Temp` ) ;
END
5 Query CREATE FUNCTION `hst_convert_ip` (
`__vtmp_ip` INT) RETURNS BIGINT
DETERMINISTIC
BEGIN
DECLARE `__vtmp_ip_long` BIGINT;
IF (`__vtmp_ip` IS NULL ) THEN
RETURN NULL ;
END IF;
IF (`__vtmp_ip` < 0 ) THEN
SET `__vtmp_ip_long` = CONVERT(`__vtmp_ip` , UNSIGNED) + CONVERT(4294967296 , UNSIGNED) ;
ELSE
SET `__vtmp_ip_long` = CONVERT(`__vtmp_ip` , UNSIGNED) ;
END IF;
RETURN (`__vtmp_ip_long` % 256 )* 16777216 + ((`__vtmp_ip_long` DIV 256 )% 256 )* 65536 + ((`__vtmp_ip_long` DIV 65536 )% 256 )* 256 + ((`__vtmp_ip_long` DIV 16777216 )% 256 );
END
5 Query CREATE FUNCTION `loc_getstring` (
`__vtmp_id` INT) RETURNS VARCHAR(256) UNICODE
READS SQL DATA
BEGIN
DECLARE __st_FETCH_STATUS INT;
DECLARE `__vtmp_result` VARCHAR(256) UNICODE;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET __st_FETCH_STATUS = 1;
SELECT SQL_CALC_FOUND_ROWS `wstrString` INTO `__vtmp_result` FROM `locstring` WHERE `nId` = `__vtmp_id` LIMIT 1;
IF (`__vtmp_result` IS NULL ) THEN
SET `__vtmp_result` = 'Cannot load localized string' ;
END IF;
RETURN (`__vtmp_result` );
END
5 Query SELECT @@session.autocommit
5 Quit
111219 12:10:06 6 Connect KAV@192.168.1.30 on mysql
6 Query set autocommit=1
6 Query SET @@session.max_sp_recursion_depth = 32
6 Quit
111219 12:10:21 7 Connect KAV@192.168.1.30 on mysql
7 Query set autocommit=1
7 Query SET @@session.max_sp_recursion_depth = 32
7 Query USE `mysql`
7 Query DROP DATABASE IF EXISTS `KAV`
7 Quit
Вариант для распечатки
on 19-Дек-11, 16:27 
