Pages

Subscribe:

Ads 468x60px

Labels

顯示具有 PostgreSQL 標籤的文章。 顯示所有文章
顯示具有 PostgreSQL 標籤的文章。 顯示所有文章

2015年12月5日 星期六

centos 6.3 部署davical

資料來源
系統環境介紹:
Centos 6.3 IP:192.168.1.185/24
安裝必須源
#rpm -ivh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
安裝常用工具
#yum -y install vim wget make gcc automake yum-utils unzip
安裝LAPP(apache、postgreSQL、php)
#yum install httpd php php-pgsql
#yum install perl-YAML perl-DBD-Pg 
#yum install postgresql postgresql-server postgresql-libs postgresql-devel
創建下載目錄
#mkdir download
#cd download/
下載日曆軟件包
#wget debian.mcmillan.net.nz/packages/awl/libawl-php-0.53-1.noarch.rpm
#wget http://debian.mcmillan.net.nz/packages/davical/davical-1.1.1-2.noarch.rpm
安裝日曆包
#rpm -ivh davical-1.1.1-2.noarch.rpm 
#rpm -ivh libawl-php-0.53-1.noarch.rpm 
#perl -MCPAN -e 'install DBD::Pg'
初始化數據庫
#service postgresql initdb
[postgresql]修改配置文件
#vim /var/lib/pgsql/data/pg_hba.conf 
TYPE DATABASE USER CIDR-ADDRESS METHOD
local all all trust
host all all 127.0.0.1/32 trust
#service postgresql restart
#cd /usr/share/davical/dba/
#su postgres -c ./create-database.sh
Supported locales updated.
Updated view: dav_principal.sql applied.
CalDAV functions updated.
RRULE functions updated.
Database permissions updated.
NOTE
====
* You will need to edit the PostgreSQL pg_hba.conf to allow the
'davical_dba' database user access to the 'davical' database.
* You will need to edit the PostgreSQL pg_hba.conf to allow the
'davical_app' database user access to the 'davical' database.
* The password for the 'admin' user has been set to 'byBYxMNA' //使用浏覽器訪問日曆服務器的U&P
Thanks for trying DAViCal! Check in /usr/share/doc/davical/examples/ for
some configuration examples. For help, visit #davical on irc.oftc.net.
[Apache]連接日曆文件到網站根目錄下
#cd /var/www/html/
#ln -s /usr/share/davical/htdocs davical
創建日曆服務器的配置文件
#gunzip /usr/share/doc/davical/examples/davical-conf.php/example-config.php.gz -c > /etc/davical/192.168.1.185-conf.php
#vim /etc/httpd/conf/httpd.conf
ServerName 192.168.1.185:80
NameVirtualHost *:80
ServerName 192.168.1.184
DocumentRoot /var/www/html
DirectoryIndex index.php index.html
Alias /images/ /var/www/html/davical/images
AcceptPathInfo On
php_value include_path /usr/share/awl/inc
php_value magic_quotes_gpc 0
php_value register_globals 0
php_value error_reporting "E_ALL & ~E_NOTICE"
php_value default_charset "utf-8"
#service httpd restart
#service iptables stop
#chkconfig iptables off
#chkconfig httpd on
#chkconfig postgresql on
you can access through a browser davical server:
192.168.1.185/davical



          centos 6.3 部署davical
此服務器沒有自帶客戶端,需另外安裝客戶端工具.
具體步驟參考官方網站:http://davical.org/
祝一切好運!
本文出自 “西伯利亞·狼” 博客,請務必保留此出處http://kernal.blog.51cto.com/8136890/1540610

2015年4月4日 星期六

SQL Fiddle - 線上SQL 編輯服務

資料來源

SQL Fiddle - 線上SQL 編輯服務 http://www.sqlfiddle.com/

支援資料庫語法類型:MySQL、Oracle、PostgreSQL、SQLite、MS SQL。Screenshot_2