Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
[HOWTO] Openbravo ERP
View unanswered posts
View posts from last 24 hours

Goto page Previous  1, 2  
Reply to topic    Gentoo Forums Forum Index Documentation, Tips & Tricks
View previous topic :: View next topic  
Author Message
iarwain
Apprentice
Apprentice


Joined: 25 Sep 2003
Posts: 253

PostPosted: Fri May 04, 2007 6:47 pm    Post subject: Reply with quote

concord wrote:
The Apache Tomcat Native library which allows optimal performance in production environments was not found.

I wouldn't worry about this. It means you don't have apr installed.

Hey guys, good new: the new PostgreSQL-8.2.4 just released in portage is an incredible performance boost, at least for Openbravo. Now I can compile the whole application (ant compile.complete) in 15 minutes, and before this (8.1.8) it used to take 45min. So I really recommend you to install this version (it's keyworded in portage).
Back to top
View user's profile Send private message
ycUygB1
Apprentice
Apprentice


Joined: 27 Jul 2005
Posts: 276
Location: Portland, Oregon

PostPosted: Sat Sep 01, 2007 9:46 pm    Post subject: Blank login page Reply with quote

I seem to be almost there, but when I try to display

http://10.62.0.1:8080/openbravo/security/Login_FS.html

I just get a blank page with the message "connecting to 10.62.0.1" at the bottom
of the page. The main tomcat page http://10.62.0.1:8080/ shows up correctly.

The page http://10.62.0.1:8080/manager/html lists openbravo as having 4 sessions running.

# printenv | grep HOME
TOMCAT_HOME=/var/lib/tomcat-6
CATALINA_HOME=/var/lib/tomcat-6
JBOSS_HOME=/usr/share/jboss
ANT_HOME=/usr/share/ant-core
JAVA_HOME=/etc/java-config-2/current-system-vm
JDK_HOME=/etc/java-config-2/current-system-vm
Back to top
View user's profile Send private message
ycUygB1
Apprentice
Apprentice


Joined: 27 Jul 2005
Posts: 276
Location: Portland, Oregon

PostPosted: Sun Sep 02, 2007 5:57 am    Post subject: Reply with quote

My humble opinion is that this product is very hard to install.
I have tried the VMWare appliance (in Spanish), then
tried installing it on Ubuntu and Gentoo (using the wiki),
with both Oracle and Postgres. The end result was a wasted weekend.

My impression is that the authors have relied many independent
pieces (java, ant, tomcat, postgres, Oracle) that are in their own rights obscure and
difficult to install and configure. Then, they haven't documented
how to get these pieces working either separately or together
with Openbravo.

I think the idea of an appliance is a good one. However, the
Openbravo company clearly has not put any effort into creating
an appliance. The two appliances they offer are community-developed.
The VMWare appliance, as I said, is in large part in Spanish.
I think that Xen as a product is immature for the same reasons
as Openbravo, and so I didn't try that appliance.

The install documentation is very weak. For instance, there is no help
describing how you should answer the installer's questions about
Oracle installation, which is their default database. As is typical
of bad documentation, it starts out good, describing with pretty pictures
how you need to accept the license conditions, then it deteriorates when
you get to the critical parts. In the end, you are just relegated to the
forums where most people can't even write complete sentences.

My suggestion is that you should use webERP instead.
It doesn't have a company behind it and the development community
is lacking, but it relies on LAMP only, rather than complex pieces.

The reason I wanted to try Openbravo was because it integrates
CRM and ERP, so we could have avoided entering customer data twice.
My current solution is webERP and SugarCRM for the time being.
Back to top
View user's profile Send private message
iarwain
Apprentice
Apprentice


Joined: 25 Sep 2003
Posts: 253

PostPosted: Fri Nov 30, 2007 12:05 pm    Post subject: Reply with quote

hnaparst wrote:
I think the idea of an appliance is a good one. However, the
Openbravo company clearly has not put any effort into creating
an appliance. The two appliances they offer are community-developed.
The VMWare appliance, as I said, is in large part in Spanish.
I think that Xen as a product is immature for the same reasons
as Openbravo, and so I didn't try that appliance.


There are new appliances for R2.35 (VMware and Xen). Their size is ~220MB and have nothing to do with previous ones. Absolutely minimized for Openbravo, including only the base packages and Tomcat 5.5.25, Apache httpd 2.0.61, Ant 1.7.0, sun jdk 1.5.0_13 and PostgreSQL 8.2.5. If you don't these it would be nice if you could point out specifically what.

By the way, if you think Xen is immature it means you really should try it again.

Quote:
The install documentation is very weak. For instance, there is no help
describing how you should answer the installer's questions about
Oracle installation, which is their default database. As is typical
of bad documentation, it starts out good, describing with pretty pictures
how you need to accept the license conditions, then it deteriorates when
you get to the critical parts. In the end, you are just relegated to the
forums where most people can't even write complete sentences.

Maybe you haven't searched enough. Documentation is indeed something Openbravo has to improve, but the wiki gets better everyday.

Quote:
The reason I wanted to try Openbravo was because it integrates
CRM and ERP, so we could have avoided entering customer data twice.
My current solution is webERP and SugarCRM for the time being.

Openbravo's CRM module is very basic. If I recall correctly there are plans to integrate with another CRM (Sugar or Centric).
Back to top
View user's profile Send private message
Snaketails
Tux's lil' helper
Tux's lil' helper


Joined: 01 Jul 2003
Posts: 78
Location: Boronia.Vic.Oz.Au

PostPosted: Mon Sep 01, 2008 1:32 pm    Post subject: Reply with quote

Has anyone tried openbravo 4.0Beta?

I followed the Gentoo installation, but I found I have a problem that the Menu.html file cannot be found.

I have actually found on a google search others have had the same issue, and they get told to follow the instructions from another specific source, well, ok, I followed them too, and recompiled the WAR file `ant war` and moved it into /var/lib/tomcat-6/webapps/ subdir, but still file not found.

The path to the file doesn't exist, the file "Menu.html" is referanced, but the file itself doesn't exist, either in the tomcat-6 tree or the home dir that you can compile the WAR file from.

Once I figgure out my Sourceforge.net login details, I'll post on the openbravo list too.

type Status report

message /openbravo/security/Menu.html

description The requested resource (/openbravo/security/Menu.html) is not available.
Back to top
View user's profile Send private message
Snaketails
Tux's lil' helper
Tux's lil' helper


Joined: 01 Jul 2003
Posts: 78
Location: Boronia.Vic.Oz.Au

PostPosted: Fri Sep 05, 2008 5:15 am    Post subject: Reply with quote

Please help with the above, its really frustrating whatever is stopping it..

I have followed the wiki, checked the context is correct.

I'm running Tomcat-6
Openbravo-2.3.5 also -2.4.0 (both have the same issue with Menu.html)

I have turned on "Debug" in Tomcat to see if there are any errors.

for OB-2.3.5
Sep 5, 2008 1:45:46 PM org.apache.catalina.core.ApplicationContext log
INFO: default: DefaultServlet.serveResource: Serving resource '/index.html' headers and data
Sep 5, 2008 1:45:46 PM org.apache.catalina.core.ApplicationContext log
INFO: default: DefaultServlet.serveResource: Serving resource '/security/Menu.html' headers and data

for OB-2.4.0
Sep 5, 2008 1:45:54 PM org.apache.catalina.core.ApplicationContext log
INFO: default: DefaultServlet.serveResource: Serving resource '/index.html' headers and data
Sep 5, 2008 1:45:54 PM org.apache.catalina.core.ApplicationContext log
INFO: default: DefaultServlet.serveResource: Serving resource '/security/Menu.html' headers and data

So, these both are having the correct effect, the system is serving the required files (AFAIK)

I have tried (without success) in Firefox 3.0.1 (Windows) Windows IE, Lynx (localhost), Firefox 3.?? (another machine under Linux)

I have followed Tomcat-6 guide http://www.gentoo.org/proj/en/java/tomcat6-guide.xml
Also the guide HOWTO Install Openbravo ERP http://gentoo-wiki.com/HOWTO_Install_Openbravo_ERP
I have installed both PostgreSQL-8.2 & -8.3 (only 1 running at a time to verify that its not the DB thats the problem.

My make.profile is as here
/etc/make.profile -> /usr/portage/profiles/default-linux/x86/2007.0/server

I just keep getting the
type Status report
message /obravo235/security/Menu.html
description The requested resource (/obravo235/security/Menu.html) is not available.

the web address I'm running is http://www2.rods.id.au:8080/obravo235 (replace 235 with 240 for the beta version)

I just cannot figgure out if its a problem in Tomcat or in OB, I know the pgsql db isworking and is being accessed.
Back to top
View user's profile Send private message
iarwain
Apprentice
Apprentice


Joined: 25 Sep 2003
Posts: 253

PostPosted: Fri Sep 05, 2008 6:07 am    Post subject: Reply with quote

Please have a look at the installation logs in OpenbravoERP/installation_logs. Look for errors there.
Back to top
View user's profile Send private message
Snaketails
Tux's lil' helper
Tux's lil' helper


Joined: 01 Jul 2003
Posts: 78
Location: Boronia.Vic.Oz.Au

PostPosted: Fri Sep 05, 2008 7:04 am    Post subject: Reply with quote

OB-235 has the following.
Code:

cat 01database.log
CREATE ROLE
UPDATE 1
CREATE DATABASE
pg_restore: [archiver] WARNING: archive is compressed, but this installation does not support compression -- no data will be available
pg_restore: [archiver] cannot restore from compressed archive (compression not supported in this installation)
UPDATE 0
UPDATE 0
psql:/home/obravo235/OpenbravoERP/tmp/pgsql-create-2.sql:5: ERROR:  null value in column "currentnext" violates not-null constraint
CONTEXT:  SQL statement "UPDATE AD_SEQUENCE SET CURRENTNEXT=(SELECT AD_SEQUENCE.INCREMENTNO + (CASE SIGN(COALESCE((SELECT MAX(t.AD_Sequence_ID) FROM AD_Sequence t WHERE t.AD_Sequence_ID<TO_NUMBER( $1 )),0)-TO_NUMBER( $2 )) WHEN -1 THEN TO_NUMBER( $2 )-AD_SEQUENCE.INCREMENTNO ELSE (SELECT MAX(t.AD_Sequence_ID) FROM AD_Sequence t WHERE t.AD_Sequence_ID<TO_NUMBER( $1 )) END) AS SEQUENCE FROM AD_SEQUENCE WHERE UPPER(NAME) = 'AD_SEQUENCE') WHERE UPPER(NAME) = 'AD_SEQUENCE'"
PL/pgSQL function "ad_update_sequence" line 51 at SQL statement
VACUUM


OB-240 has a heck of a lot of these... db was dropped before I ran the install again.
Code:

     [java] 20283 [main] ERROR org.openbravo.translate.TranslateData - SQL error in query:       insert into ad_textinterfaces        (AD_TEXTINTERFACES_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CR
EATED, CREATEDBY, UPDATED, UPDATEDBY, TEXT, FILENAME, ISUSED)      values        (Ad_Get_Next_Sequence('AD_TextInterfaces',1),0 ,0, 'Y', now(), 0, now(), 0, ?, ?, 'Y')Exception:org.postgresql.ut
il.PSQLException: ERROR: null value in column "ad_textinterfaces_id" violates not-null constraint
     [java] javax.servlet.ServletException: @CODE=0@ERROR: null value in column "ad_textinterfaces_id" violates not-null constraint
     [java]     at org.openbravo.translate.TranslateData.insert(Unknown Source)
Back to top
View user's profile Send private message
Snaketails
Tux's lil' helper
Tux's lil' helper


Joined: 01 Jul 2003
Posts: 78
Location: Boronia.Vic.Oz.Au

PostPosted: Mon Sep 08, 2008 3:48 am    Post subject: Reply with quote

Ok, update.

Database creation had *HEAPS* of errors ;o(

Installed OB240 on another system, worked 1st go, decided to do a install from the 2nd computer after figuring out how to get the installer and the DB to talk friendly over the network, installed the database, then reconfig'd the server to use connections (non-localhost) to the DB

All working happily now ;o)

Thanks ;o)
Back to top
View user's profile Send private message
NightMonkey
Guru
Guru


Joined: 21 Mar 2003
Posts: 355
Location: Philadelphia, PA

PostPosted: Sat Aug 22, 2009 9:48 pm    Post subject: Wiki page gone now Reply with quote

FYI, the gentoo-wiki.com link is 404'd, so the topic for this post should be "[Howto] OpenBravo ERP [missing]" or similar.
_________________
:D
Back to top
View user's profile Send private message
PM17E5
Apprentice
Apprentice


Joined: 10 Feb 2009
Posts: 241

PostPosted: Thu Oct 04, 2012 12:49 pm    Post subject: Reply with quote

Is this still being maintained?
Back to top
View user's profile Send private message
iarwain
Apprentice
Apprentice


Joined: 25 Sep 2003
Posts: 253

PostPosted: Thu Oct 04, 2012 1:59 pm    Post subject: Reply with quote

No, sorry. I'd recommend you to follow the official custom installation guide, using the Gentoo way of doing things were it applies. Some Openbravo developers use Gentoo, so they'll probably be able to give you assistance through the forums or the IRC channel.
Back to top
View user's profile Send private message
PM17E5
Apprentice
Apprentice


Joined: 10 Feb 2009
Posts: 241

PostPosted: Thu Oct 04, 2012 2:46 pm    Post subject: Reply with quote

I'm sorry to post an irrelevant question on here, but seeing how you responded pretty quickly I would really appreciate it if you could share your experience with openbravo and help me figure one thing out. Do you know if it supports printing to dot matrix printers? Or thermal receipt printers? I'm still a newbie just diving head into the POS field of computers, and there's so many choices and (what seems to be) crappy software, incomplete documentation, scattered info etc. I know it's a web application and I plan to have typical windows machines use it, but I'm stuck dealing with Oki Microline dot matrix printers, or in the worst case scenario possibly upgrading to some thermal receipt printers. I'm not sure if Firefox or whatever browser is used to access this can print to these things or how the tickets/receipts are made?
Back to top
View user's profile Send private message
iarwain
Apprentice
Apprentice


Joined: 25 Sep 2003
Posts: 253

PostPosted: Fri Apr 05, 2013 6:06 pm    Post subject: Reply with quote

Hey, sorry for the ridiculously late response. Openbravo has both an ERP and a POS (they're connectable), and I have no experience with the POS part. I'd recommend you to go to the forums or to their IRC channels, if this issue is still of your interest.
Back to top
View user's profile Send private message
Ruaa
n00b
n00b


Joined: 29 May 2013
Posts: 1

PostPosted: Wed May 29, 2013 7:24 pm    Post subject: Reply with quote

hii everyone
i have a similar Openbravo problem to bravecobra's one i get this error in the browser


HTTP status 404
the requested resource () is not available .

i followed the Openbravo wiki's steps for launching Openbravo from eclipse

iarwain you said "make sure the openbravo context is there ..."
can you please explain more for me ,, sorry i'm just new in all of this .

thanx in advance and regards.
Back to top
View user's profile Send private message
iarwain
Apprentice
Apprentice


Joined: 25 Sep 2003
Posts: 253

PostPosted: Fri May 31, 2013 7:16 am    Post subject: Reply with quote

Hi Ruaa. It's been a long time since I've used Openbravo ERP, so I'm afraid I cannot be helpful. I'd advise you to start looking at the logs. And if you fail to find a solution, you could open a thread in their forums or join the #openbravo IRC channel in Freenode. Good luck.
Back to top
View user's profile Send private message
_______0
Guru
Guru


Joined: 15 Oct 2012
Posts: 521

PostPosted: Wed Oct 30, 2013 5:29 pm    Post subject: Reply with quote

for POS, may I reccomend:

unicenta

or

posper

openbravo closed their source long time ago and made the POS part fully commercial.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Documentation, Tips & Tricks All times are GMT
Goto page Previous  1, 2
Page 2 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum