checking for OpenSSL version >= 0.9.7… FAILED
configure: WARNING: OpenSSL version is too old
no
checking whether to enable mod_ssl… configure: error: mod_ssl has been requested but can not be built due to prerequisite failures
测试约定
MySQL: 版本 5.1.xx Community Server
数据库: dbTest
数据表: test_data
首先 登录
mysql -uroot -p
建立数据库和表
CREATE DATABASE dbTest;
USE dbTest;
CREATE TABLE test_data ( a INT(10) NULL, b INT(10) NULL, c INT(10) NULL
)
ENGINE=InnoDB;
生成10万条记录 单次随机插入1000条
DELIMITER //
CREATE PROCEDURE GenerateFakeData()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i <= 100000 DO
INSERT INTO tbl_data1 (a,b,c) VALUES ((SELECT floor(rand() * 1000) AS randNum), (SELECT floor(rand() * 1000) AS randNum),(SELECT floor(rand() * 1000) AS randNum));
SET i = i + 1;
END WHILE;
END //
DELIMITER ;
会提示平台问题
You appear to be installing packages on a platform different
than the platform for which they were built.
This platform is CentOS5_64
Packages found: RHEL5_64
This may or may not work.
Using packages for a platform in which they were not designed for
may result in an installation that is NOT usable. Your support
options may be limited if you choose to continue.
Install anyway? [N] y
The system will be modified. Continue? [N] y
都选择Y = YES的意思
最后
Main menu
1) Common Configuration:
2) zimbra-ldap: Enabled
3) zimbra-store: Enabled
+Create Admin User: yes
+Admin user to create: admin@mail.dndns.net
******* +Admin Password UNSET
+Anti-virus quarantine user: virus-quarantine.kzpbrsgbx7@mail.dndns.net
+Enable automated spam training: yes
+Spam training user: spam.sd5fsqtdzi@mail.dndns.net
+Non-spam(Ham) training user: ham.2qun60wc4@mail.dndns.net
+SMTP host: mail.dndns.net
+Web server HTTP port: 80
+Web server HTTPS port: 443
+Web server mode: http
+IMAP server port: 143
+IMAP server SSL port: 993
+POP server port: 110
+POP server SSL port: 995
+Use spell check server: yes
+Spell server URL: http://mail.dndns.net:7780/aspell.php
+Configure for use with mail proxy: FALSE
+Configure for use with web proxy: FALSE
+Enable version update checks: TRUE
+Enable version update notifications: TRUE
+Version update notification email: admin@mail.dndns.net
+Version update source email: admin@mail.dndns.net
4) zimbra-mta: Enabled
5) zimbra-snmp: Enabled
6) zimbra-logger: Enabled
7) zimbra-spell: Enabled
8) Default Class of Service Configuration:
r) Start servers after configuration yes
s) Save config to file
x) Expand menu
q) Quit
Address unconfigured (**) items (? – help) 3
输入4 设置下admin的密码.
Store configuration
1) Status: Enabled
2) Create Admin User: yes
3) Admin user to create: admin@mail.dndns.net
** 4) Admin Password UNSET
5) Anti-virus quarantine user: virus-quarantine.kzpbrsgbx7@mail.dndns.net
6) Enable automated spam training: yes
7) Spam training user: spam.sd5fsqtdzi@mail.dndns.net
8) Non-spam(Ham) training user: ham.2qun60wc4@mail.dndns.net
9) SMTP host: mail.dndns.net
10) Web server HTTP port: 80
11) Web server HTTPS port: 443
12) Web server mode: http
13) IMAP server port: 143
14) IMAP server SSL port: 993
15) POP server port: 110
16) POP server SSL port: 995
17) Use spell check server: yes
18) Spell server URL: http://mail.dndns.net:7780/aspell.php
19) Configure for use with mail proxy: FALSE
20) Configure for use with web proxy: FALSE
21) Enable version update checks: TRUE
22) Enable version update notifications: TRUE
23) Version update notification email: admin@mail.dndns.net
24) Version update source email: admin@mail.dndns.net
Select, or ‘r’ for previous menu [r] 4
Password for admin@mail.dndns.net (min 6 characters): [7M_lgfdx3B] secret
Then press r to return to the main menu.
Store configuration
1) Status: Enabled
2) Create Admin User: yes
3) Admin user to create: admin@mail.dndns.net
4) Admin Password set
5) Anti-virus quarantine user: virus-quarantine.kzpbrsgbx7@mail.dndns.net
6) Enable automated spam training: yes
7) Spam training user: spam.sd5fsqtdzi@mail.dndns.net
8) Non-spam(Ham) training user: ham.2qun60wc4@mail.dndns.net
9) SMTP host: mail.dndns.net
10) Web server HTTP port: 80
11) Web server HTTPS port: 443
12) Web server mode: http
13) IMAP server port: 143
14) IMAP server SSL port: 993
15) POP server port: 110
16) POP server SSL port: 995
17) Use spell check server: yes
18) Spell server URL: http://mail.dndns.net:7780/aspell.php
19) Configure for use with mail proxy: FALSE
20) Configure for use with web proxy: FALSE
21) Enable version update checks: TRUE
22) Enable version update notifications: TRUE
23) Version update notification email: admin@mail.dndns.net
24) Version update source email: admin@mail.dndns.net
Select, or ‘r’ for previous menu [r] r
And press a to apply the config. Afterwards, save the configuration data.
Main menu
1) Common Configuration:
2) zimbra-ldap: Enabled
3) zimbra-store: Enabled
4) zimbra-mta: Enabled
5) zimbra-snmp: Enabled
6) zimbra-logger: Enabled
7) zimbra-spell: Enabled
8) Default Class of Service Configuration:
r) Start servers after configuration yes
s) Save config to file
x) Expand menu
q) Quit
*** CONFIGURATION COMPLETE – press ‘a’ to apply
Select from menu, or press ‘a’ to apply config (? – help) a
Save configuration data to a file? [Yes]
Save config in file: [/opt/zimbra/config.11722]
Saving config in /opt/zimbra/config.11722…done.
The system will be modified – continue? [No] y
需要等待处理完成
Operations logged to /tmp/zmsetup.04042012-131235.log
Setting local config values…done.
Setting up CA…done.
Deploying CA to /opt/zimbra/conf/ca …done.
Creating SSL certificate…done.
Installing mailboxd SSL certificates…done.
Initializing ldap…done.
Setting replication password…done.
Setting Postfix password…done.
Setting amavis password…done.
Setting nginx password…done.
Creating server entry for mail.dndns.net…done.
Saving CA in ldap …done.
Saving SSL Certificate in ldap …done.
Setting spell check URL…done.
Setting service ports on mail.dndns.net…done.
Adding zimbratest.example.com to zimbraMailHostPool in default COS…done.
Installing webclient skins…
steel…done.
twilight…done.
pebble…done.
bare…done.
lemongrass…done.
beach…done.
sand…done.
sky…done.
carbon…done.
smoke…done.
lavender…done.
tree…done.
waves…done.
lake…done.
oasis…done.
bones…done.
hotrod…done.
Finished installing webclient skins.
Setting zimbraFeatureTasksEnabled=TRUE…done.
Setting zimbraFeatureBriefcasesEnabled=TRUE…done.
Setting MTA auth host…done.
Setting TimeZone Preference…done.
Initializing mta config…done.
Setting services on mail.dndns.net…done.
Creating domain mail.dndns.net…done.
Setting default domain name…done.
Creating domain mail.dndns.net…already exists.
Creating admin account admin@mail.dndns.net…done.
Creating root alias…done.
Creating postmaster alias…done.
Creating user spam.sd5fsqtdzi@mail.dndns.net…done.
Creating user ham.2qun60wc4@mail.dndns.net…done.
Creating user virus-quarantine.kzpbrsgbx7@mail.dndns.net…done.
Setting spam training and Anti-virus quarantine accounts…done.
Initializing store sql database…done.
Setting zimbraSmtpHostname for mail.dndns.net…done.
Configuring SNMP…done.
Checking for default IM conference room…not present.
Initializing default IM conference room…done.
Setting up syslog.conf…done.
You have the option of notifying Zimbra of your installation.
This helps us to track the uptake of the Zimbra Collaboration Suite.
The only information that will be transmitted is:
The VERSION of zcs installed (7.1.4_GA_3105_CentOS5_64)
The ADMIN EMAIL ADDRESS created (admin@mail.dndns.net)
Notify Zimbra of your installation? [Yes] no
Notification skipped
Starting servers…done.
Installing common zimlets…
com_zimbra_bulkprovision…done.
com_zimbra_phone…done.
com_zimbra_attachmail…done.
com_zimbra_linkedin…done.
com_zimbra_srchhighlighter…done.
com_zimbra_attachcontacts…done.
com_zimbra_adminversioncheck…done.
com_zimbra_url…done.
com_zimbra_cert_manager…done.
com_zimbra_date…done.
com_zimbra_email…done.
com_zimbra_webex…done.
com_zimbra_dnd…done.
com_zimbra_social…done.
Finished installing common zimlets.
Restarting mailboxd…done.
Setting up zimbra crontab…done.
Moving /tmp/zmsetup.04042012-131235.log to /opt/zimbra/log
Configuration complete – press return to exit
完成 确认回车即可
