Sunday, June 28, 2009

OpenERP Server Configuration

When any one want to install server client and postgresql seperately on windows,then one should have to be update Openerp-server.conf file to connection among openerp-server,client & postgresql..

How updated Openerp-server.conf file looks

[options]
without_demo = False
netport = 8070
secure = False
demo = {}
syslog = False
cache_timeout = 100000
port = 8069
smtp_password = False
secure_pkey_file = server.pkey
netinterface =
log_level = info
admin_passwd = admin
smtp_port = 25
smtp_server = localhost
db_user = postgres
price_accuracy = 2
import_partial =
soap = False
pidfile = False
db_maxconn = 64
reportgz = False
xmlrpc = True
db_port = 5432
debug_mode = False
netrpc = True
secure_cert_file = server.cert
interface =
logfile = C:\Program Files\ERPPlus Server\openerp-server.log
csv_internal_sep = ,
pg_path = C:\Program Files\PostgreSQL\8.3\bin
translate_modules = ['all']
stop_after_init = True
root_path = C:\Program Files\ERPPlus Server
smtp_user = False
db_password = postgres
db_name = False
db_host = 127.0.0.1
assert_exit_level =30
email_from = False
addons_path = C:\Program Files\ERPPlus Server\addons

postgresql installation path till bin in my case[default]
C:\Program Files\PostgreSQL\8.3\bin
and here is my addons path[default],one can any where else but he has to mention that path
addons_path = C:\Program Files\ERPPlus Server\addons
Host is localhost

Wednesday, June 24, 2009

Openfire Screenshots


Configure openfire On Ubuntu

Installing openfire http://www.igniterealtime.org/projec...fire/index.jsp

Step-1
For Java 6 you will need to edit your SOURCES.LIST to enable this repository.
Code:
$ sudo vi /etc/apt/sources.list
Uncomment the following line(s):
Default source.list.
Code:
# deb http://us.archive.ubuntu.com/ubuntu/ dapper-backports main restricted universe multiverse
# deb-src http://us.archive.ubuntu.com/ubuntu/ dapper-backports main restricted universe multiverse
Uncommented.
Code:
deb http://us.archive.ubuntu.com/ubuntu/ dapper-backports main restricted universe multiverse
deb-src http://us.archive.ubuntu.com/ubuntu/ dapper-backports main restricted universe multiverse

Optional
Update system.
Code:
$ sudo apt-get update

Step-2

Check java versions on your system.
Code:
$ java -version

Step-3
Install java6 If you don't have java already installed.
Code:
$ sudo apt-get install sun-java6-bin

Step-4
Configure Java.
Code:
$ sudo update-alternatives --config java
Select java6 for your default.
select /usr/lib/jvm/java-6-sun/jre/bin/java
To create a database for openfire MySQL, Oracle, Microsoft SQLServer, PostgreSQL, IBM DB2, or HSQLDB can be used. I chose MySQL since it was installed with my LAMP setup.



Step-5
Download Openfire to a directory. I chose the /opt/ directory.
Code:
# cd /opt

Step-6
Download File or go here to get the most recent: http://www.igniterealtime.org/downlo...x.jsp#openfire
Code:
# wget http://www.igniterealtime.org/downloadServlet?filename=openfire/openfire_3_3_2.tar.gz

Step-7
Extract the files.
Code:
# tar -zxvf openfire_3_3_2.tar.gz

Step -8
Create a symlink
Code:
# ln -s /opt/openfire/bin/openfire /etc/init.d/

Step-9
Make the symlink executible
Code:
# chmod +x /etc/init.d/openfire

Step-10
Add openfire to our startup.
Code:
# update-rc.d openfire defaults

Step-11
Fix the nohup output.
Code:
# vim /opt/openfire/bin/openfire
Modify openfire script with the following: >../logs/SDTOUT.log 2>../logs/SDTERR.log into /opt/openfire/bin/openfire

ORIGINAL:
Code:
nohup "$app_java_home/bin/java" -server -Dinstall4j.jvmDir="$app_java_home"
-Dexe4j.moduleName="$prg_dir/$progname" $INSTALL4J_ADD_VM_PARAMS
-classpath "$local_classpath" com.install4j.runtime.Launcher start
org.jivesoftware.openfire.starter.ServerStarter false false "$prg_dir/../logs/stderror.log"
"$prg_dir/../logs/stdoutt.log" true true false "" true true 0 0 "" 20 20 "Arial" "0,0,0" 8 500
"version 3.3.2" 20 40 "Arial" "0,0,0" 8 500 -1 -DopenfireHome=$app_home
-Dopenfire.lib.dir=$app_home/lib &
Goto line 262 of /opt/openfire/bin/openfire and insert the following at the end of nohup .... with >../logs/STDOUT.log 2>../logs/STDERR.log

MODIFIED:
Code:
nohup "$app_java_home/bin/java" -server -Dinstall4j.jvmDir="$app_java_home"
-Dexe4j.moduleName="$prg_dir/$progname" $INSTALL4J_ADD_VM_PARAMS
-classpath "$local_classpath" com.install4j.runtime.Launcher start
org.jivesoftware.openfire.starter.ServerStarter false false "$prg_dir/../logs/stderror.log"
"$prg_dir/../logs/stdoutt.log" true true false "" true true 0 0 "" 20 20 "Arial" "0,0,0" 8 500
"version 3.3.2" 20 40 "Arial" "0,0,0" 8 500 -1 -DopenfireHome=$app_home
-Dopenfire.lib.dir=$app_home/lib >../logs/STDOUT.log 2>../logs/STDERR.log &

Step-12
Now lets start Openfire (xmpp-server). Restart or run the following command to start Openfire:
Code:
# sudo /opt/openfire/bin/openfire start
Now setup the rest of Openfire through your browser.
http://localhost:9090

Note:-For reference one can use this link

http://ubuntuforums.org/showthread.php?t=525670

Create OpenERP Setup

OpenERP Make exe from sources Guide
================================
1. Install theses packages
­­­­­­­­­­­­­­­­­­­­­­­­­­
nsis­2.40­setup.exe
graphviz­2.20.2.exe

python­2.5.2.msi
egenix­mx­base­3.1.1.win32­py2.5.msi
PyXML­0.8.4.win32­py2.5.exe
libxml2­python­2.7.1.win32­py2.5.exe
lxml­2.1.2.win32­py2.5.exe
matplotlib­0.98.3.win32­py2.5.exe
numpy­1.1.1­win32­superpack­python2.5.exe
PIL­1.1.6.win32­py2.5.exe
PyChart­1.39.win32.exe ( created by Stephane Wirtel )
ReportLab­2.2.win32­py2.5.exe
vobject­0.7.1.win32.exe ( created by Stephane Wirtel )

pygobject­2.14.1­1.win32­py2.5.exe
pygtk­2.12.1­2.win32­py2.5.exe
pycairo­1.4.12­1.win32­py2.5.exe
gtk­2.12.9­win32­2.exe
gtk­dev­2.12.9­win32­2.exe

pydot­1.0.2.win32.exe ( created by Stephane Wirtel ) pyparsing­1.5.0.win32.exe
pytz­2008i.win32.exe ( created by Stephane Wirtel )
pywin32­212.win32­py2.5.exe

py2exe­0.6.8.win32­py2.5.exe

hippo­canvas­0.3.0­win32.zip ­ Uncompess this archive, and copy/paste the files
"libhippocanvas­1­0.dll" and "hippo.pyd" into C:\Python25\DLLs\

msvcp71.zip ­ Uncompress this archive and copy the msvcp71.dll into c:\WINDOWS\SYSTEM32

psycopg2­2.0.8.win32­py2.5­pg8.3.4­release.exe
you can install the setuptools package:
setuptools­0.6c9.win32­py2.5.exe
2. How to get the sources
­­­­­­­­­­­­­­­­­­­­­­­­­
Firstly, create a directory to store the files
c:> mkdir c:\openerp
c:> trunkcd openerp
c:\openerp> mkdir
c:\openerp> cd trunk
c:\openerp\trunk> bzr clone lp:~openerp/openobject­server/trunk server
c:\openerp\trunk> bzr clone lp:~openerp/openobject­client/trunk client
c:\openerp\trunk> bzr clone lp:~openerp/openobject­addons/trunk addons
3. Prepare the ground­­­­­­­­­­­­­­­­­­­­­
Copy all addons into the addons directory of the server, to include these addons in the archive
c:\openerp\trunk> xcopy addons\* server\bin\addons ­E
4. Package the server
­­­­­­­­­­­­­­­­­­­­­
c:\openerp\trunk> cd server
c:\openerp\trunk\server> python setup.py py2exe
c:\openerp\trunk\server> cd win32
c:\openerp\trunk\server\win32> python setup.py py2exe
c:\openerp\trunk\server\win32> cd ..
c:\openerp\trunk\server> makensis /DVERSION=5.0.0­alpha setup.nsi
After this instruction, you will get a new file openerp­server­setup­5.0.0­alpha.exe
5. Package the client
­­­­­­­­­­­­­­­­­­­­­
c:\openerp\trunk> cd client
c:\openerp\trunk\client> python setup.py py2exe
c:\openerp\trunk\client> makensis /DVERSION=5.0.0­alpha setup.nsi
After this instruction, you will get a new file openerp­client­setup­5.0.0­alpha.exe

References:­
http://www.openobject.com/forum/post36414.html?sid=4d7ea2ffc20cd97f761ea43fe2d7840b
http://www.openobject.com/forum/post37242.html?sid=33943b300ab3436dc7e6f347e640c0ef