forum.lissyara.su

Код: Выделить всё

-- phpMyAdmin SQL Dump
-- version 2.11.2.2
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Дек 03 2008 г., 08:39
-- Версия сервера: 5.0.45
-- Версия PHP: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- База данных: `exim`
--

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

--
-- Структура таблицы `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `username` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`username`),
  KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Exim and dovecot Admin - Virtual Admins';

--
-- Дамп данных таблицы `admin`
--


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

--
-- Структура таблицы `alias`
--

CREATE TABLE IF NOT EXISTS `alias` (
  `address` varchar(255) NOT NULL default '',
  `goto` text NOT NULL,
  `domain` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`address`),
  KEY `address` (`address`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Exim and dovecot Admin - Virtual Aliases';

--
-- Дамп данных таблицы `alias`
--


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

--
-- Структура таблицы `domain`
--

CREATE TABLE IF NOT EXISTS `domain` (
  `domain` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `aliases` int(10) NOT NULL default '0',
  `mailboxes` int(10) NOT NULL default '0',
  `maxquota` int(10) NOT NULL default '0',
  `transport` varchar(255) default NULL,
  `backupmx` tinyint(1) NOT NULL default '0',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`domain`),
  KEY `domain` (`domain`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Exim and dovecot Admin - Virtual Domains';

--
-- Дамп данных таблицы `domain`
--


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

--
-- Структура таблицы `domain_admins`
--

CREATE TABLE IF NOT EXISTS `domain_admins` (
  `username` varchar(255) NOT NULL default '',
  `domain` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `active` tinyint(1) NOT NULL default '1',
  KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Exim and dovecot Admin - Domain Admins';

--
-- Дамп данных таблицы `domain_admins`
--


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

--
-- Структура таблицы `log`
--

CREATE TABLE IF NOT EXISTS `log` (
  `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `username` varchar(255) NOT NULL default '',
  `domain` varchar(255) NOT NULL default '',
  `action` varchar(255) NOT NULL default '',
  `data` varchar(255) NOT NULL default '',
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Exim and dovecot Admin - Log';

--
-- Дамп данных таблицы `log`
--


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

--
-- Структура таблицы `mailbox`
--

CREATE TABLE IF NOT EXISTS `mailbox` (
  `username` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `maildir` varchar(255) NOT NULL default '',
  `quota` int(10) NOT NULL default '0',
  `domain` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`username`),
  KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Exim and dovecot Admin - Virtual Mailboxes';

--
-- Дамп данных таблицы `mailbox`
--


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

--
-- Структура таблицы `vacation`
--

CREATE TABLE IF NOT EXISTS `vacation` (
  `email` varchar(255) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `body` text NOT NULL,
  `cache` text NOT NULL,
  `domain` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`email`),
  KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Exim and dovecot Admin - Virtual Vacation';

--
-- Дамп данных таблицы `vacation`
--

Код: Выделить всё

http://site/postfixadmin/setup.php
Postfix Admin Setup Checker 1.0.0
Running software:

- PHP version 5.2.5

- Apache/2.2.6

Checking for dependencies:

# Warning: Magic Quotes: OFF (using internal function!)

- Depends on: presence config.inc.php - OK

- Depends on: MySQL 3.23, 4.0 - OK

- Depends on: MySQL 4.1 - OK (change the database_type in config.inc.php!!)

- Depends on: session - OK

- Depends on: pcre - OK

Everything seems fine... you are ready to rock & roll!
Make sure you delete this setup.php file!
Also check the config.inc.php file for any settings that you might need to change!
Click here to go to the admin section (make sure that your .htaccess is setup properly) 

Код: Выделить всё

site# cat ./config.inc.php
<?php
// File: config.inc.php
//
if (ereg ("config.inc.php", $_SERVER['PHP_SELF']))
{
   header ("Location: login.php");
   exit;
}

$CONF['postfix_admin_url'] = 'http://site/postfixadmin/admin';
$CONF['postfix_admin_path'] = '/usr/local/www/postfixadmin/admin';

$CONF['default_language'] = 'en';

$CONF['database_type'] = 'mysql';
$CONF['database_host'] = 'localhost';
$CONF['database_user'] = 'exim';
$CONF['database_password'] = 'exim';
$CONF['database_name'] = 'exim';
$CONF['database_prefix'] = '';

$CONF['admin_email'] = 'postmaster@change-this-to-your.domain.tld';

$CONF['smtp_server'] = 'localhost';
$CONF['smtp_port'] = '25';

$CONF['encrypt'] = 'md5crypt';

$CONF['generate_password'] = 'NO';

$CONF['page_size'] = '10';
$CONF['default_aliases'] = array (
        'abuse' => 'abuse@change-this-to-your.domain.tld',
        'hostmaster' => 'hostmaster@change-this-to-your.domain.tld',
        'postmaster' => 'postmaster@change-this-to-your.domain.tld',
        'webmaster' => 'webmaster@change-this-to-your.domain.tld'
);

$CONF['domain_path'] = 'NO';
$CONF['domain_in_mailbox'] = 'YES';
$CONF['aliases'] = '10';
$CONF['mailboxes'] = '10';
$CONF['maxquota'] = '10';

$CONF['quota'] = 'NO';
$CONF['quota_multiplier'] = '1024000';

$CONF['transport'] = 'NO';

$CONF['vacation'] = 'NO';
$CONF['vacation_domain'] = 'autoreply.change-this-to-your.domain.tld';
$CONF['alias_control'] = 'NO';

$CONF['special_alias_control'] = 'YES';
$CONF['logging'] = 'YES';

$CONF['show_header_text'] = 'NO';
$CONF['header_text'] = ':: Postfix Admin ::';

$CONF['show_footer_text'] = 'YES';
$CONF['footer_text'] = 'Return to site.ubcua.tv';
$CONF['footer_link'] = 'http://site.ubcua.tv/postfixadmin';
$CONF['welcome_text'] = <<<EOM
Hi,

Welcome to your new account.
EOM;

//
// END OF CONFIG FILE
//
?>

Код: Выделить всё

dovecot-1.0.10      Secure and compact IMAP and POP3 servers
exim-mysql-4.68     High performance MTA for Unix systems on the Internet
mysql-client-5.0.45_1 Multithreaded SQL database (client)
mysql-server-5.0.45_1 Multithreaded SQL database (server)
phpMyAdmin-2.11.2.2 A set of PHP-scripts to manage MySQL over the web
postfixadmin-2.1.0_7 PHP web-based management tool for Postfix virtual domains a

Код: Выделить всё

 uname -a
FreeBSD site 7.0-RELEASE FreeBSD 7.0-RELEASE #0: Sun Feb 24 19:59:52 UTC 2008     root@logan.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  i386

Код: Выделить всё

use БАЗА;
show tables;