20130906安裝網路行事曆
(一)
[root@life htdocs]# wget http://prdownloads.sourceforge.net/webcalendar/WebCalendar-0.9.42.tar.gz?download
(二)
[root@life htdocs]# tar xvzf WebCalendar-0.9.42.tar.gz
:
WebCalendar-0.9.42/week_ssi.php
WebCalendar-0.9.42/year.php
[root@life htdocs]# mv WebCalendar-0.9.42 wcal
(三)
http://lfwiki.kmvs.km.edu.tw/wcal/INSTALL.html
(四)
[root@life wcal]# mysqladmin create intranet -p
Enter password:
[root@life wcal]#
[root@life wcal]# mysql --user=root mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 799
Server version: 5.0.27-log Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> GRANT ALL PRIVILEGES ON *.* TO webcalendar@"%" IDENTIFIED BY 'webcal01' WITH GRANT OPTION;
Query OK, 0 rows affected (0.07 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.04 sec)
mysql> exit
Bye
[root@life wcal]#
(五)
[root@life wcal]# mysql intranet < tables-mysql.sql -p
Enter password:
[root@life wcal]#
(六)
[root@life wcal]# more includes/config.php
<?php
// Site-specific settings.
// Configure these for your site.
// You shouldn't have to modify any files outside of this one.
// When you're done here, try accessing WebCalendar as an admin
// user and go to the System Settings page (admin.php) to change system
// settings.
//
// Note: if you enable LDAP support, you will also need to modify
// user-ldap.php.
//
/////////////////////////////////////////////////////////////////
$PROGRAM_NAME = "WebCalendar v0.9.42 (21 Jul 2003)";
$PROGRAM_URL = "http://webcalendar.sourceforge.net/";
// MySQL example
$db_type = "mysql";
$db_host = "localhost";
$db_login = "webcalendar";
$db_password = "webcal01";
$db_database = "intranet";
:
:
(七)
[root@life wcal]# mysql -p -uroot
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 813
Server version: 5.0.27-log Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| anndb |
| intranet |
| mysql |
| test |
| utf8_lf_db |
| utf8_lf_db2 |
+--------------------+
7 rows in set (0.06 sec)
mysql> use intranet
Database changed
mysql> show tables;
+--------------------------+
| Tables_in_intranet |
+--------------------------+
| webcal_asst |
| webcal_categories |
| webcal_config |
| webcal_entry |
| webcal_entry_ext_user |
| webcal_entry_log |
| webcal_entry_repeats |
| webcal_entry_repeats_not |
| webcal_entry_user |
| webcal_group |
| webcal_group_user |
| webcal_import_data |
| webcal_nonuser_cals |
| webcal_reminder_log |
| webcal_report |
| webcal_report_template |
| webcal_site_extras |
| webcal_user |
| webcal_user_layers |
| webcal_user_pref |
| webcal_view |
| webcal_view_user |
+--------------------------+
22 rows in set (0.00 sec)
mysql>
(八)
|