Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Warning
titleEditing

There is a lot of stuff in this page (it was my error to put them all in one page, but there are also advantages to have it like that). So when you use the Rich Text mode, which is buggy in this free Confluence version we have, it breaks some parts that you will not be aware of if you are not used to edit with this Confluence version.

So please don't use the Rich Text mode but Wiki Markup, thanks

Tables of content  

Accounting

...

Selenium

...

...

FAQ - TIPS - Cookbook - How to to

Anchor
HTTPD
HTTPD

How to use mod_proxy_ajp

 You You need to use a 2.2+ version of HTTPD. I used 2.2.6.

In httpd.conf 

...

Uncomment (or compile with at least these modules using --enable)

...

Code Block
ProxyRequests Off

<Proxy \*>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;        AddDefaultCharset off
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;        Order deny,allow
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;        Allow from all
</Proxy>

\# Enable/disable the handling of HTTP/1.1 "Via:" headers.
\# ("Full" adds the server version; "Block" removes all outgoing Via: headers)
\# Set to one of: Off \| On \| Full \| Block
ProxyVia On

NameVirtualHost \*:80

<VirtualHost \*:80>
&nbsp;&nbsp;&nbsp; #&nbsp;&nbsp;    #   General setup for the virtual host
&nbsp;&nbsp;&nbsp;    DocumentRoot "/usr/local/apache2/htdocs"
&nbsp;&nbsp;&nbsp;    ErrorLog logs/error_log
&nbsp;&nbsp;&nbsp;    TransferLog logs/access_log

&nbsp;&nbsp;&nbsp;    ServerName lamouline.myvnc.com
&nbsp;&nbsp;&nbsp;    ServerAdmin webmaster@les7arts.com

&nbsp;&nbsp;&nbsp;    ProxyRequests Off
&nbsp;&nbsp;&nbsp;    ProxyPreserveHost On
&nbsp;&nbsp;&nbsp;    proxyPass / ajp://localhost:8009/
&nbsp;&nbsp; &nbsp;
&nbsp;&nbsp;&nbsp;    
    RewriteEngine On
&nbsp;&nbsp;&nbsp;    RewriteRule \^/(images/.+);jsessionid=\w+$ /$1&nbsp;&nbsp;&nbsp; &nbsp;
&nbsp;&nbsp; &nbsp;     
    
</VirtualHost>

include conf/httpd-ssl.conf

...

Code Block
<VirtualHost \_default_:443>

\#&nbsp;&nbsp;   General setup for the virtual host
DocumentRoot "/usr/local/apache2/htdocs"
ServerName www.example.com:443
ServerAdmin you@example.com
ErrorLog "/usr/local/apache2/logs/error_log"
TransferLog "/usr/local/apache2/logs/access_log"

...

Code Block
<VirtualHost \*:443>
&nbsp;&nbsp;&nbsp; #&nbsp;&nbsp;    #   General setup for the virtual host
&nbsp;&nbsp;&nbsp;    DocumentRoot "/usr/local/apache2/htdocs"
&nbsp;&nbsp;&nbsp;    ErrorLog "/usr/local/apache2/logs/error_log"
&nbsp;&nbsp;&nbsp;    TransferLog "/usr/local/apache2/logs/access_log"

&nbsp;&nbsp;&nbsp;    ServerName lamouline.myvnc.com
&nbsp;&nbsp;&nbsp;    ServerAdmin webmaster@les7arts.com

&nbsp;&nbsp;&nbsp;    ProxyRequests Off
&nbsp;&nbsp;&nbsp;    ProxyPreserveHost On
&nbsp;&nbsp;&nbsp;    proxyPass / ajp://localhost:8009/
&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;   
    RewriteEngine On
&nbsp;&nbsp;&nbsp;    RewriteRule \^/(images/.+);jsessionid=\w+$ /$1&nbsp;&nbsp;&nbsp;&nbsp;    

It should work. On Windows the configuration is the same. Don't forget to edit url.properties file (change 8080 to 80 and 8443 to 443).

...

Thanks to Raj Saini for this tip tip

Anchor
field type in Derby
field type in Derby

Change a field type in Derby

...

* *

  1. Export the table to xml
  2. Drop the table
  3. Start OFBiz - table recreated with new structure
  4. Import xml data from #1

...

where todos is and exe to download (search with Google). Of course you will have to deal with path. But at this stage I guess it's easy...

 I I just learned from https://sourceforge.net/project/shownotes.php?release_id=508633 that the "--binary" option may be used in that case, did no try yet...

...

  • Alternatively, the service can be started with the command:net start OFBiz
  • And the service can then be stopped with the command:net stop OFBiz

Advice from  from enki_ at users.sourceforge.net. There is an alternative to this solution : How to Run OFBiz as Windows Service with Java Service Wrapper

...

3) What is the difference between click and clickAndWait ? I would like to understand why I'm getting different behaviors from click and clickAndWait functions. Here is the scenario: I want to perform the login and then verify some text on the page (what should be pretty straight forward...) My first approach was  was using the clickfunction + pause function. Something like below:

...

I think the right solution is to use clickAndWait command instead of click+pause because it always success contrary to click+pause (we dont known the page response time). I see no reason why you don't observe the same behavior with clickAndWait. Maybe it's because your are testing the login page that can be a little tricky to test due to the session handling.
To be sure to always start a test in a clean session, my tests always do the same actions :
1. logoff
2. login
3. check error
Here, an example of my standard login procedure under selenium  selenium from (http://labs.libre-entreprise.org/plugins/scmcvs/cvsweb.php/ofbizNeogia/neogia/manufacturing/webapp/manufacturing/tests/TestProcessRouting.html?rev=1.2;content-type=text%2Fplain;cvsroot=neogia)

...

If you receive an SQL error in ofbiz, it doesn't show the error from the database itself.   Instead, it shows a general error which isn't neccessarily clear.   Run the SQL directly on the database get a more helpful error message.

...

How to Extend an existing component in customized application?

  Scenario : For any customized application under hot-deploy if it is needed to extend the existing component then changes in following files are required.

(For instance we are extending the Marketing component.)
1) Inside webapp of your customize application create a folder for component name. (marketing/WEB-INF)
2) Add controller.xml, web.xml
3) In controller.xml file include the  the <include location="component://marketing/webapp/marketing/WEB-INF/controller.xml"/>
4) In ofbiz-component.xml (hot-deploy/customize_project/)
add following code :
<webapp name="marketing" title="Marketing-Customized" server="default-server" location="webapp/marketing" base-permission="OFBTOOLS,MARKETING" mount-point="/marketing"/>
(extending marketing component here.)Now here the basic setup for extend the component is completed, now you can add component specific request and view in controller.xml here. And create screens in the extanded componint.  Note Note : Please add if some of the information is missing here.
 

What is considered the best practice in creating a custom web application with OFBIZ?

...