Halo Fred,
when we install vpopmail-toaster from installation script, it created
the database and tables automatically. and the vpopmail has support to
use mysql (database) not flatfile
incase you miss the database creation, here mine:
ps: I am using mysql 5 and export it using heidisql 6
# --------------------------------------------------------
# Host: 10.10.64.40
# Server version: 5.0.27-standard-log
# Server OS: pc-linux-gnu
# HeidiSQL version: 6.0.0.3702
# Date/time: 2011-03-04 11:43:43
# --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
# Dumping structure for table vpopmail.dir_control
CREATE TABLE IF NOT EXISTS `dir_control` (
`domain` char(64) NOT NULL,
`cur_users` int(11) default NULL,
`level_cur` int(11) default NULL,
`level_max` int(11) default NULL,
`level_start0` int(11) default NULL,
`level_start1` int(11) default NULL,
`level_start2` int(11) default NULL,
`level_end0` int(11) default NULL,
`level_end1` int(11) default NULL,
`level_end2` int(11) default NULL,
`level_mod0` int(11) default NULL,
`level_mod1` int(11) default NULL,
`level_mod2` int(11) default NULL,
`level_index0` int(11) default NULL,
`level_index1` int(11) default NULL,
`level_index2` int(11) default NULL,
`the_dir` char(160) default NULL,
PRIMARY KEY (`domain`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table vpopmail.lastauth
CREATE TABLE IF NOT EXISTS `lastauth` (
`user` char(32) NOT NULL,
`domain` char(64) NOT NULL,
`remote_ip` char(18) NOT NULL,
`timestamp` bigint(20) NOT NULL default '0',
PRIMARY KEY (`user`,`domain`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table vpopmail.pala_bo_tak_info
CREATE TABLE IF NOT EXISTS `pala_bo_tak_info` (
`pw_name` char(32) NOT NULL,
`pw_passwd` char(40) default NULL,
`pw_uid` int(11) default NULL,
`pw_gid` int(11) default NULL,
`pw_gecos` char(48) default NULL,
`pw_dir` char(160) default NULL,
`pw_shell` char(20) default NULL,
`pw_clear_passwd` char(16) default NULL,
PRIMARY KEY (`pw_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Data exporting was unselected.
# Dumping structure for table vpopmail.valias
CREATE TABLE IF NOT EXISTS `valias` (
`alias` char(32) NOT NULL,
`domain` char(64) NOT NULL,
`valias_line` text NOT NULL,
KEY `alias` (`alias`,`domain`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Data exporting was unselected.
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
On 04-Mar-11 9:55, Fred Richards wrote:
Yup, did that, and if you look at the script, it sets a root password,
creates the database, and assigns privileges... but doesn't make any
tables or a schema for the vpopmail database.
On 03/03/2011 07:12 PM, Eric Broch wrote:
Don't forget to edit the file first and set your mysql password...
Here's the link:
http://www.qmailtoaster.com/distro/centos/cnt50/mysql-setup.sh
---------------------------------------------------------------------------------
Qmailtoaster is sponsored by Vickers Consulting Group
(www.vickersconsulting.com)
Vickers Consulting Group offers Qmailtoaster support and installations.
If you need professional help with your setup, contact them today!
---------------------------------------------------------------------------------
Please visit qmailtoaster.com for the latest news, updates, and packages.
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
