Share008資訊科技公司

我是資深的電腦資訊從業員,曾於 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 認證,能提供日常資訊運作之檢測及審查,以提高操作效率。 本人誠意為各類大中小型廠房提供資訊審計、支援及意見,歡迎聯絡,電郵為 au8788@gmail.com

「ERP資源管理系統」已是現今廠房管理必不可少的工具,提高它的效能,絕對能改善公司之盈利,請多多留意。

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

提供香港股票價位歷史數據

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

祝願各瀏覽者股壇威威!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2014年11月14日

Install odoo (OpenERP) on Fedora 20

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

source: https://www.rosehosting.com/blog/install-odoo-8-on-a-centos-7-vps/

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
psql
\password postgres
(Enter new password twice)
\q
exit
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 
wget http://nightly.openerp.com/8.0/nightly/src/odoo_8.0-latest.tar.gz
tar -xvzf /root/odoo_8.0-latest.tar.gz
mv openerp-8.* openerp
cd openerp
Install Odoo 8:
python setup.py 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:
[options]
; 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             127.0.0.1/32            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             0.0.0.0/0               md5
Check the PostgreSQL server encoding:
su - postgres
psql
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';
\q
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
[Unit]
Description=Advanced OpenSource ERP and CRM server
Requires=postgresql.service
After=postgresql.service
[Install]
Alias=openerp.service
[Service]
Type=simple
PermissionsStartOnly=true
EnvironmentFile=-/etc/conf.d/openerp-server
User=openerp
Group=openerp
SyslogIdentifier=openerp-server
PIDFile=/run/openerp/openerp-server.pid
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/openerp-server.pid --syslog $OPENERP_ARGS
ExecStop=/bin/kill $MAINPID
[Install]
WantedBy=multi-user.target
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 setup.py install" again, then, the problem solved.

Error: 1 during run "python setup.py 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
Reading http://download.gna.org/pychart/
Reading https://pypi.python.org/simple/pydot/
Reading http://code.google.com/p/pydot/
Reading http://dkbza.org/pydot.html
Download error on http://dkbza.org/pydot.html: [Errno 110] Connection timed out -- Some packages may not be found!
Best match: pydot 1.0.28
Downloading http://pydot.googlecode.com/files/pydot-1.0.28.zip
error: Download error for http://pydot.googlecode.com/files/pydot-1.0.28.zip: [Errno 101] Network is unreachable
Error 2: cannot run server

# /usr/local/bin/openerp-server -c /etc/openerp-server.conf --pid=/run/openerp/openerp-server.pid
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/__init__.py", line 77, in <module>
    import report
  File "/usr/lib/python2.7/site-packages/openerp-8.0_c7d8e97-py2.7.egg/openerp/report/__init__.py", line 27, in <module>
    import custom
  File "/usr/lib/python2.7/site-packages/openerp-8.0_c7d8e97-py2.7.egg/openerp/report/custom.py", line 34, in <module>
    from pychart import *
ImportError: No module named pychart



Another Installation.script can be found from official site -->  https://doc.odoo.com/5.0/install/linux/server/# ..


沒有留言:

張貼留言