我是資深的電腦資訊從業員,曾於 Motorola 及 Philips 等跨國大型公司管理層工作十多年,具各類ERP資源管理系統及其它應用系統經驗,如QAD之MFG/PRO、SAP、Ufida(用友)、Kingdee(金蝶)、Microsoft's Dynamic、Wonderware's In-Track (SFC)、Webplan (SCM)、Hyperion (business intelligence)、Informatics (Data Warehouse)...等等。另外,我精於廠房車間之電腦資訊運作,擁有 CISSP 及 ITIL 認證,能提供日常資訊運作之檢測及審查,以提高操作效率。 本人誠意為各類大中小型廠房提供資訊審計、支援及意見,歡迎聯絡,電郵為




我想很多人會對"香港股票價位的歷史數據"有興趣,我已下載成Microsoft Access database version 2000 的文檔,資料由2008/1/1至2009/12/2,zip壓縮後也有11M,若索取請留你的PM我 。




Install odoo (OpenERP) on Fedora 20

I tried the following Odoo version 8 installation script under Fedora 20, it works well.


Odoo is a suite of business applications, organized in 6 groups: front-end applications, sales management applications, business operations applications, marketing applications, human resources and productivity applications.
The installation of Odoo 8 on a Fedora20 should take about ten minutes if you follow the very easy steps described below.
Install PostgreSQL and PHP PostgreSQL extension:
yum install postgresql-libs postgresql-server postgresql php-pgsql php-gd
Install all prerequisite packages using the following command:
yum install babel python-devel libxslt-python pyparsing python-dateutil python-decorator python-imaging python-jinja2 python-ldap python-lxml python-mako python-psycopg2 python-reportlab python-requests python-werkzeug python-yaml python-docutils  python-matplotlib python-babel python-gevent pygtk2 glade3 pytz libxslt-devel bzr automake gcc gcc-c++ byacc
Restart the Apache web server:
systemctl restart httpd.service
Initialize the PostgreSQL database cluster:
postgresql-setup initdb
Configure the PostgreSQL service to start automatically on server boot:
systemctl enable postgresql.service
Start PostgreSQL service and set a password for the ‘postgres’ user:
systemctl start postgresql.service
su - postgres
\password postgres
(Enter new password twice)
Create new system user named ‘openerp':
adduser openerp
passwd openerp
Create ‘openerp’ user in PostgreSQL using the following command:
su - postgres -c "createuser --pwprompt --createdb --no-createrole --no-superuser openerp"
(Enter new 'openerp' user password twice)
Download the latest version of Odoo and extract it to the ‘/root/openerp’ directory on your virtual server:
cd /root 
tar -xvzf /root/odoo_8.0-latest.tar.gz
mv openerp-8.* openerp
cd openerp
Install Odoo 8:
python install
cp openerp-server /usr/local/bin/
mkdir -p /var/log/openerp/
touch /var/log/openerp/openerp-server.log
chown openerp /var/log/openerp/openerp-server.log
chmod 644 /var/log/openerp/openerp-server.log
Give the ‘openerp’ user permission to install new modules:
chown openerp -R /usr/lib/python2.7/site-packages/openerp-8*/openerp/addons/
Run the following commands:
vi ~openerp/.bashrc
export LD_LIBRARY_PATH; LD_LIBRARY_PATH=/usr/local/lib
source ~openerp/.bashrc
Edit the ‘/etc/openerp-server.conf’ configuration file and add the following lines:
; This is the password that allows database operations:
; admin_passwd = admin
db_host = localhost
db_port = 5432
db_user = openerp
db_password = False
addons_path = /usr/lib/python2.7/site-packages/openerp-8.0_911db9d-py2.7.egg/openerp/addons/
#do not forget to change 'openerp-8.0_911db9d-py2.7.egg' with the actual directory on your server
logfile = /var/log/openerp/openerp-server.log
log_level = error
Edit the ‘/var/lib/pgsql/data/pg_hba.conf’ configuration file and allow local access to PostgreSQL databases:
vi /var/lib/pgsql/data/pg_hba.conf
# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     trust # changed from 'peer'
# IPv4 local connections:
host    all             all               trust # changed from 'ident'
# IPv6 local connections:
host    all             all             ::1/128                 trust # changed from 'ident'
Optionally, if you want to allow remote access to PostgreSQL databases, add the following line to ‘/var/lib/pgsql/data/pg_hba.conf’ configuration file:
host    all             all                  md5
Check the PostgreSQL server encoding:
su - postgres
postgres=# \l
                             List of databases
   Name    |  Owner   | Encoding  | Collate | Ctype |   Access privileges
 postgres  | postgres | SQL_ASCII | C       | C     |
 template0 | postgres | SQL_ASCII | C       | C     | =c/postgres          +
           |          |           |         |       | postgres=CTc/postgres
 template1 | postgres | SQL_ASCII | C       | C     | =c/postgres          +
           |          |           |         |       | postgres=CTc/postgres
To change the template1 encoding to UTF8, run the following commands:
update pg_database set datallowconn = TRUE where datname = 'template0';
\c template0
update pg_database set datistemplate = FALSE where datname = 'template1';
drop database template1;
create database template1 with template = template0 encoding = 'UTF8';
update pg_database set datistemplate = TRUE where datname = 'template1';
\c template1
update pg_database set datallowconn = FALSE where datname = 'template0';
Restart the PostgreSQL server:
systemctl restart postgresql.service
To start Odoo automatically when the server is booted, add a systemd unit file with the following content:
vi /usr/lib/systemd/system/openerp.service
Description=Advanced OpenSource ERP and CRM server
ExecStartPre=/usr/bin/install -d -m755 -o openerp -g openerp /run/openerp
ExecStart=/usr/local/bin/openerp-server -c /etc/openerp-server.conf --pid=/run/openerp/ --syslog $OPENERP_ARGS
ExecStop=/bin/kill $MAINPID
The last thing left to do is enabling and starting up the service:
systemctl enable openerp.service
Start Odoo:
systemctl start openerp.service
Open http://your-server-IP:8069/web/database/manager and create a new database.
odoo vps
Then, you should be able to log in to the administrator back-end at http://server_IP:8069 using ‘admin’ as username and your newly created password. To reset your ‘admin’ password, navigate to:
Administrator -> Preferences -> Change password

Installation Note: 
During Installation, I met the following two errors which were caused by network problem. Make sure the network is stable and run the "python install" again, then, the problem solved.

Error: 1 during run "python install"
Installed /usr/lib/python2.7/site-packages/openerp-8.0_c7d8e97-py2.7.egg
Processing dependencies for openerp==8.0-c7d8e97
Searching for pydot
Download error on [Errno 110] Connection timed out -- Some packages may not be found!
Best match: pydot 1.0.28
error: Download error for [Errno 101] Network is unreachable
Error 2: cannot run server

# /usr/local/bin/openerp-server -c /etc/openerp-server.conf --pid=/run/openerp/
Traceback (most recent call last):
  File "/usr/local/bin/openerp-server", line 2, in <module>
    import openerp
  File "/usr/lib/python2.7/site-packages/openerp-8.0_c7d8e97-py2.7.egg/openerp/", line 77, in <module>
    import report
  File "/usr/lib/python2.7/site-packages/openerp-8.0_c7d8e97-py2.7.egg/openerp/report/", line 27, in <module>
    import custom
  File "/usr/lib/python2.7/site-packages/openerp-8.0_c7d8e97-py2.7.egg/openerp/report/", line 34, in <module>
    from pychart import *
ImportError: No module named pychart

Another Installation.script can be found from official site --> ..