Connecting Ofbiz to Apache2 with AJP

[Adrian Stern-2]

Hi

Since my Setup is still not anywhere usable, I decided to install a demo
server. With this, discussions should become easier.

I did the configuration with what little information i found, and my
request does reach Ofbiz. There is output generated when accessing
<ip>/webtools - in the stdout.
But I do not receive any HTTP-response at all. Accessing the IP directly
will return a white screen (not one tag in the source), but only if ofbiz
is running. If Ofbiz is not running, I get "Service Unavailable" from
Apache.

Console output form Ofbiz (ant start): http://pastebin.com/UJnMZZ9r
Source of my configuration:
https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-HTTPD

When Accessing the <IP> without sub directory i get:
...[17/Oct/2014:15:31:33 +0200] "GET / HTTP/1.1" 404 - "-" "Mozilla/5....

When Accessing a sub directory:
...[17/Oct/2014:15:33:15 +0200] "GET /webtools/ HTTP/1.1" 302 - "-"
"Mozilla/5....
...[17/Oct/2014:15:33:15 +0200] "GET /webtools/control/main HTTP/1.1" 303 -
"-" "Mozilla/5....

So I'm not sure where the configuration error lies. Since my request
reaches Ofbiz, it would make sense that i forgot something.

For Example: The Cookbook says: Don't forget to edit ofbiz-containers.xml
and url.properties file (change 8080 to 80 and 8443 to 443) but there is
nothing to change inside ofbiz-containers.xml. No Port-Number at all. Any
Idea?

Configuration:
Server :Opensuse 13.1
I used the template vhost.template to create
/etc/apache2/vhosts.d/httpd.conf. And i used vhost-ssl.template to create
/etc/apache2/vhosts.d/config/httpd-ssl.conf. I was not sure where to put
the code from the cookbook.

.../vhosts.d/httpd.conf: http://pastebin.com/TNnkYVGt
.../vhosts.d/conf/httpd-ssl.conf: http://pastebin.com/y4cD08Th

Also, this link from the cookbook does no longer work:
http://www.viithiisys.com/web/raj/blog/-/blogs/apache-proxypassreverse-directive?_33_redirect=%252Findex.html

Thanks in advance.

Regards,

Adrian Stern
unchained - web solutions

[hidden email]
[phone]

[Jacques Le Roux]

Did you read https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-HTTPD ?

Jacques

Le 17/10/2014 16:14, Adrian Stern a écrit :

> Hi
>
> Since my Setup is still not anywhere usable, I decided to install a demo
> server. With this, discussions should become easier.
>
> I did the configuration with what little information i found, and my
> request does reach Ofbiz. There is output generated when accessing
> <ip>/webtools - in the stdout.
> But I do not receive any HTTP-response at all. Accessing the IP directly
> will return a white screen (not one tag in the source), but only if ofbiz
> is running. If Ofbiz is not running, I get "Service Unavailable" from
> Apache.
>
> Console output form Ofbiz (ant start): http://pastebin.com/UJnMZZ9r
> Source of my configuration:
> https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-HTTPD
>
> When Accessing the <IP> without sub directory i get:
> ...[17/Oct/2014:15:31:33 +0200] "GET / HTTP/1.1" 404 - "-" "Mozilla/5....
>
> When Accessing a sub directory:
> ...[17/Oct/2014:15:33:15 +0200] "GET /webtools/ HTTP/1.1" 302 - "-"
> "Mozilla/5....
> ...[17/Oct/2014:15:33:15 +0200] "GET /webtools/control/main HTTP/1.1" 303 -
> "-" "Mozilla/5....
>
> So I'm not sure where the configuration error lies. Since my request
> reaches Ofbiz, it would make sense that i forgot something.
>
> For Example: The Cookbook says: Don't forget to edit ofbiz-containers.xml
> and url.properties file (change 8080 to 80 and 8443 to 443) but there is
> nothing to change inside ofbiz-containers.xml. No Port-Number at all. Any
> Idea?
>
> Configuration:
> Server :Opensuse 13.1
> I used the template vhost.template to create
> /etc/apache2/vhosts.d/httpd.conf. And i used vhost-ssl.template to create
> /etc/apache2/vhosts.d/config/httpd-ssl.conf. I was not sure where to put
> the code from the cookbook.
>
> .../vhosts.d/httpd.conf: http://pastebin.com/TNnkYVGt
> .../vhosts.d/conf/httpd-ssl.conf: http://pastebin.com/y4cD08Th
>
> Also, this link from the cookbook does no longer work:
> http://www.viithiisys.com/web/raj/blog/-/blogs/apache-proxypassreverse-directive?_33_redirect=%252Findex.html
>
> Thanks in advance.
>
> Regards,
>
> Adrian Stern
> unchained - web solutions
>
> [hidden email]
> [phone]
>

[Adrian Stern-2]

Yes. I also have a link to it in my post under "Source of my configuration".

Freundliche Grüsse

Adrian Stern
unchained - web solutions

[hidden email]
[phone]

On Fri, Oct 17, 2014 at 7:43 PM, Jacques Le Roux <
[hidden email]> wrote:

> Did you read https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-
> +Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-HTTPD ?
>
> Jacques
>
> Le 17/10/2014 16:14, Adrian Stern a écrit :
>
>  Hi
>>
>> Since my Setup is still not anywhere usable, I decided to install a demo
>> server. With this, discussions should become easier.
>>
>> I did the configuration with what little information i found, and my
>> request does reach Ofbiz. There is output generated when accessing
>> <ip>/webtools - in the stdout.
>> But I do not receive any HTTP-response at all. Accessing the IP directly
>> will return a white screen (not one tag in the source), but only if ofbiz
>> is running. If Ofbiz is not running, I get "Service Unavailable" from
>> Apache.
>>
>> Console output form Ofbiz (ant start): http://pastebin.com/UJnMZZ9r
>> Source of my configuration:
>> https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-
>> +Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-HTTPD
>>
>> When Accessing the <IP> without sub directory i get:
>> ...[17/Oct/2014:15:31:33 +0200] "GET / HTTP/1.1" 404 - "-" "Mozilla/5....
>>
>> When Accessing a sub directory:
>> ...[17/Oct/2014:15:33:15 +0200] "GET /webtools/ HTTP/1.1" 302 - "-"
>> "Mozilla/5....
>> ...[17/Oct/2014:15:33:15 +0200] "GET /webtools/control/main HTTP/1.1" 303
>> -
>> "-" "Mozilla/5....
>>
>> So I'm not sure where the configuration error lies. Since my request
>> reaches Ofbiz, it would make sense that i forgot something.
>>
>> For Example: The Cookbook says: Don't forget to edit ofbiz-containers.xml
>> and url.properties file (change 8080 to 80 and 8443 to 443) but there is
>> nothing to change inside ofbiz-containers.xml. No Port-Number at all. Any
>> Idea?
>>
>> Configuration:
>> Server :Opensuse 13.1
>> I used the template vhost.template to create
>> /etc/apache2/vhosts.d/httpd.conf. And i used vhost-ssl.template to create
>> /etc/apache2/vhosts.d/config/httpd-ssl.conf. I was not sure where to put
>> the code from the cookbook.
>>
>> .../vhosts.d/httpd.conf: http://pastebin.com/TNnkYVGt
>> .../vhosts.d/conf/httpd-ssl.conf: http://pastebin.com/y4cD08Th
>>
>> Also, this link from the cookbook does no longer work:
>> http://www.viithiisys.com/web/raj/blog/-/blogs/apache-
>> proxypassreverse-directive?_33_redirect=%252Findex.html
>>
>> Thanks in advance.
>>
>> Regards,
>>
>> Adrian Stern
>> unchained - web solutions
>>
>> [hidden email]
>> [phone]
>>
>>

[Nicolas Malin-2]

Le 17/10/2014 16:14, Adrian Stern a écrit :
> Accessing the IP directly
> will return a white screen
try https://${yourIP|DnsName}/catalog

Nicolas

[Adrian Stern-2]

Hi Nicolas

I did: "There is output generated when accessing <ip>/webtools - in the
stdout" - which means ofbiz does receive the request (or at least a part of
it) but there is no response. Blank Page.


Freundliche Grüsse

Adrian Stern
unchained - web solutions

[hidden email]
[phone]

On Mon, Oct 20, 2014 at 10:37 AM, Nicolas Malin <[hidden email]>
wrote:

> Le 17/10/2014 16:14, Adrian Stern a écrit :
>
>> Accessing the IP directly
>> will return a white screen
>>
> try https://${yourIP|DnsName}/catalog
>
> Nicolas
>

[Adrian Stern-2]

I just verified:

Opening URL: http://<ip>/catalog

will redirect to: https://<ip>/catalog/control/main

which contains no content (site not available) because
of ERR_CONNECTION_REFUSED

Freundliche Grüsse

Adrian Stern
unchained - web solutions

[hidden email]
[phone]

On Thu, Oct 23, 2014 at 11:03 AM, Adrian Stern <[hidden email]>
wrote:

> Hi Nicolas
>
> I did: "There is output generated when accessing <ip>/webtools - in the
> stdout" - which means ofbiz does receive the request (or at least a part of
> it) but there is no response. Blank Page.
>
>
> Freundliche Grüsse
>
> Adrian Stern
> unchained - web solutions
>
> [hidden email]
> [phone]
>
> On Mon, Oct 20, 2014 at 10:37 AM, Nicolas Malin <[hidden email]>
> wrote:
>
>> Le 17/10/2014 16:14, Adrian Stern a écrit :
>>
>>> Accessing the IP directly
>>> will return a white screen
>>>
>> try https://${yourIP|DnsName}/catalog
>>
>> Nicolas
>>
>
>

[Pierre Smits]

Adrian,

Setting up a demo implementation to test your connection from http through
ajp should be that difficult.

Follow this example and you'll have something to work with:

   1. download and unzip your preferred version into a new directory
   2. in the directory you unzipped your version execute:
      1. ./ant build (or the windows equivalent)
      2. ./ant load-demo (gets data from the files in the data folder in
      the components into the rdbms )
   3. now run ./ant start to see OFBiz start without errors
   4. access your implementation with your web browser through
http://<YourOFBizIpAddress>:8443/catalog
   (you should see the log-in screen)

When this works, you can start connecting your http server to the OFBiz App
Server

   1. Open or create a/the configuration file for your virtual host
   2. include ' ProxyPass / ajp://<YourOFBizIpAddress>:8009/ '
   3. include ' ProxyPassReverse / ajp://<YourOFBizIpAddress>:8009 '
   4. Restart your web server

Now you're good to go to access http://<IpAddressOfWebServer>/catalog

The above should do the trick.

Regards,


Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com

On Thu, Oct 23, 2014 at 11:20 AM, Adrian Stern <[hidden email]>
wrote:

> I just verified:
>
> Opening URL: http://<ip>/catalog
>
> will redirect to: https://<ip>/catalog/control/main
>
> which contains no content (site not available) because
> of ERR_CONNECTION_REFUSED
>
> Freundliche Grüsse
>
> Adrian Stern
> unchained - web solutions
>
> [hidden email]
> [phone]
>
> On Thu, Oct 23, 2014 at 11:03 AM, Adrian Stern <[hidden email]>
> wrote:
>
> > Hi Nicolas
> >
> > I did: "There is output generated when accessing <ip>/webtools - in the
> > stdout" - which means ofbiz does receive the request (or at least a part
> of
> > it) but there is no response. Blank Page.
> >
> >
> > Freundliche Grüsse
> >
> > Adrian Stern
> > unchained - web solutions
> >
> > [hidden email]
> > [phone]
> >
> > On Mon, Oct 20, 2014 at 10:37 AM, Nicolas Malin <
> [hidden email]>
> > wrote:
> >
> >> Le 17/10/2014 16:14, Adrian Stern a écrit :
> >>
> >>> Accessing the IP directly
> >>> will return a white screen
> >>>
> >> try https://${yourIP|DnsName}/catalog
> >>
> >> Nicolas
> >>
> >
> >
>

[Adrian Stern-2]

Ok. I did find out something.

The following process i did locally as well as on the server. Locally i
could connect with Link (Terminal Browser) with https. On the server i got
an ssl error. (no more information but only "SSL error".

So i guess i'm facing a system problem.

Freundliche Grüsse

Adrian Stern
unchained - web solutions

[hidden email]
[phone]

On Thu, Oct 23, 2014 at 11:57 AM, Pierre Smits <[hidden email]>
wrote:

> Adrian,
>
> Setting up a demo implementation to test your connection from http through
> ajp should be that difficult.
>
> Follow this example and you'll have something to work with:
>
>    1. download and unzip your preferred version into a new directory
>    2. in the directory you unzipped your version execute:
>       1. ./ant build (or the windows equivalent)
>       2. ./ant load-demo (gets data from the files in the data folder in
>       the components into the rdbms )
>    3. now run ./ant start to see OFBiz start without errors
>    4. access your implementation with your web browser through
> http://<YourOFBizIpAddress>:8443/catalog
>    (you should see the log-in screen)
>
> When this works, you can start connecting your http server to the OFBiz App
> Server
>
>    1. Open or create a/the configuration file for your virtual host
>    2. include ' ProxyPass / ajp://<YourOFBizIpAddress>:8009/ '
>    3. include ' ProxyPassReverse / ajp://<YourOFBizIpAddress>:8009 '
>    4. Restart your web server
>
> Now you're good to go to access http://<IpAddressOfWebServer>/catalog
>
> The above should do the trick.
>
> Regards,
>
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Thu, Oct 23, 2014 at 11:20 AM, Adrian Stern <[hidden email]>
> wrote:
>
> > I just verified:
> >
> > Opening URL: http://<ip>/catalog
> >
> > will redirect to: https://<ip>/catalog/control/main
> >
> > which contains no content (site not available) because
> > of ERR_CONNECTION_REFUSED
> >
> > Freundliche Grüsse
> >
> > Adrian Stern
> > unchained - web solutions
> >
> > [hidden email]
> > [phone]
> >
> > On Thu, Oct 23, 2014 at 11:03 AM, Adrian Stern <
> [hidden email]>
> > wrote:
> >
> > > Hi Nicolas
> > >
> > > I did: "There is output generated when accessing <ip>/webtools - in the
> > > stdout" - which means ofbiz does receive the request (or at least a
> part
> > of
> > > it) but there is no response. Blank Page.
> > >
> > >
> > > Freundliche Grüsse
> > >
> > > Adrian Stern
> > > unchained - web solutions
> > >
> > > [hidden email]
> > > [phone]
> > >
> > > On Mon, Oct 20, 2014 at 10:37 AM, Nicolas Malin <
> > [hidden email]>
> > > wrote:
> > >
> > >> Le 17/10/2014 16:14, Adrian Stern a écrit :
> > >>
> > >>> Accessing the IP directly
> > >>> will return a white screen
> > >>>
> > >> try https://${yourIP|DnsName}/catalog
> > >>
> > >> Nicolas
> > >>
> > >
> > >
> >
>

[Adrian Stern-2]

Yea. Sorry i got disturbed.

Process: Checkout Ofbiz13.07 - build - load-demo - start
Connect with: links http://localhost:8443/webtools

Local: Working
Server: SSL error

Freundliche Grüsse

Adrian Stern
unchained - web solutions

[hidden email]
[phone]

On Thu, Oct 23, 2014 at 2:04 PM, Adrian Stern <[hidden email]>
wrote:

> Ok. I did find out something.
>
> The following process i did locally as well as on the server. Locally i
> could connect with Link (Terminal Browser) with https. On the server i got
> an ssl error. (no more information but only "SSL error".
>
> So i guess i'm facing a system problem.
>
> Freundliche Grüsse
>
> Adrian Stern
> unchained - web solutions
>
> [hidden email]
> [phone]
>
> On Thu, Oct 23, 2014 at 11:57 AM, Pierre Smits <[hidden email]>
> wrote:
>
>> Adrian,
>>
>> Setting up a demo implementation to test your connection from http through
>> ajp should be that difficult.
>>
>> Follow this example and you'll have something to work with:
>>
>>    1. download and unzip your preferred version into a new directory
>>    2. in the directory you unzipped your version execute:
>>       1. ./ant build (or the windows equivalent)
>>       2. ./ant load-demo (gets data from the files in the data folder in
>>       the components into the rdbms )
>>    3. now run ./ant start to see OFBiz start without errors
>>    4. access your implementation with your web browser through
>> http://<YourOFBizIpAddress>:8443/catalog
>>    (you should see the log-in screen)
>>
>> When this works, you can start connecting your http server to the OFBiz
>> App
>> Server
>>
>>    1. Open or create a/the configuration file for your virtual host
>>    2. include ' ProxyPass / ajp://<YourOFBizIpAddress>:8009/ '
>>    3. include ' ProxyPassReverse / ajp://<YourOFBizIpAddress>:8009 '
>>    4. Restart your web server
>>
>> Now you're good to go to access http://<IpAddressOfWebServer>/catalog
>>
>> The above should do the trick.
>>
>> Regards,
>>
>>
>> Pierre Smits
>>
>> *ORRTIZ.COM <http://www.orrtiz.com>*
>> Services & Solutions for Cloud-
>> Based Manufacturing, Professional
>> Services and Retail & Trade
>> http://www.orrtiz.com
>>
>> On Thu, Oct 23, 2014 at 11:20 AM, Adrian Stern <[hidden email]
>> >
>> wrote:
>>
>> > I just verified:
>> >
>> > Opening URL: http://<ip>/catalog
>> >
>> > will redirect to: https://<ip>/catalog/control/main
>> >
>> > which contains no content (site not available) because
>> > of ERR_CONNECTION_REFUSED
>> >
>> > Freundliche Grüsse
>> >
>> > Adrian Stern
>> > unchained - web solutions
>> >
>> > [hidden email]
>> > [phone]
>> >
>> > On Thu, Oct 23, 2014 at 11:03 AM, Adrian Stern <
>> [hidden email]>
>> > wrote:
>> >
>> > > Hi Nicolas
>> > >
>> > > I did: "There is output generated when accessing <ip>/webtools - in
>> the
>> > > stdout" - which means ofbiz does receive the request (or at least a
>> part
>> > of
>> > > it) but there is no response. Blank Page.
>> > >
>> > >
>> > > Freundliche Grüsse
>> > >
>> > > Adrian Stern
>> > > unchained - web solutions
>> > >
>> > > [hidden email]
>> > > [phone]
>> > >
>> > > On Mon, Oct 20, 2014 at 10:37 AM, Nicolas Malin <
>> > [hidden email]>
>> > > wrote:
>> > >
>> > >> Le 17/10/2014 16:14, Adrian Stern a écrit :
>> > >>
>> > >>> Accessing the IP directly
>> > >>> will return a white screen
>> > >>>
>> > >> try https://${yourIP|DnsName}/catalog
>> > >>
>> > >> Nicolas
>> > >>
>> > >
>> > >
>> >
>>
>
>

[Adrian Stern-2]

Ofbiz does not start without errors. There are 2, which do not seem to be
related to my problem:

2014-10-23 14:26:25,308 |OFBiz-config-0       |DatabaseUtil
 |E| WARNING: Column [META_DATA_VALUE] of table [OFBIZ.CONTENT_META_DATA]
of entity [ContentMetaData] IS a primary key in the database, but IS NOT a
primary key in the entity definition. The primary key for this table needs
to be re-created or modified so that this column is NOT part of the primary
key.

2014-10-23 14:26:25,310 |OFBiz-config-0       |DatabaseUtil
 |E| WARNING: Column [META_DATA_VALUE] of table
[OFBIZ.DATA_RESOURCE_META_DATA] of entity [DataResourceMetaData] IS a
primary key in the database, but IS NOT a primary key in the entity
definition. The primary key for this table needs to be re-created or
modified so that this column is NOT part of the primary key.

Also on the server, after running "ant start", when connecting to
http://localhost:8080/webtools i get redirected to a 8443 url and console
output is generated. On the 8443 URL i get the SSL error. There are no new
log entries dough.

Maybe it's the java version:
1.7.0_51: SSL error (Opensuse13.1, tried on vServer and VM)
1.7.0_71: Working (Archlinux)

Freundliche Grüsse

Adrian Stern
unchained - web solutions

[hidden email]
[phone]

On Thu, Oct 23, 2014 at 2:11 PM, Adrian Stern <[hidden email]>
wrote:

> Yea. Sorry i got disturbed.
>
> Process: Checkout Ofbiz13.07 - build - load-demo - start
> Connect with: links http://localhost:8443/webtools
>
> Local: Working
> Server: SSL error
>
> Freundliche Grüsse
>
> Adrian Stern
> unchained - web solutions
>
> [hidden email]
> [phone]
>
> On Thu, Oct 23, 2014 at 2:04 PM, Adrian Stern <[hidden email]>
> wrote:
>
>> Ok. I did find out something.
>>
>> The following process i did locally as well as on the server. Locally i
>> could connect with Link (Terminal Browser) with https. On the server i got
>> an ssl error. (no more information but only "SSL error".
>>
>> So i guess i'm facing a system problem.
>>
>> Freundliche Grüsse
>>
>> Adrian Stern
>> unchained - web solutions
>>
>> [hidden email]
>> [phone]
>>
>> On Thu, Oct 23, 2014 at 11:57 AM, Pierre Smits <[hidden email]>
>> wrote:
>>
>>> Adrian,
>>>
>>> Setting up a demo implementation to test your connection from http
>>> through
>>> ajp should be that difficult.
>>>
>>> Follow this example and you'll have something to work with:
>>>
>>>    1. download and unzip your preferred version into a new directory
>>>    2. in the directory you unzipped your version execute:
>>>       1. ./ant build (or the windows equivalent)
>>>       2. ./ant load-demo (gets data from the files in the data folder in
>>>       the components into the rdbms )
>>>    3. now run ./ant start to see OFBiz start without errors
>>>    4. access your implementation with your web browser through
>>> http://<YourOFBizIpAddress>:8443/catalog
>>>    (you should see the log-in screen)
>>>
>>> When this works, you can start connecting your http server to the OFBiz
>>> App
>>> Server
>>>
>>>    1. Open or create a/the configuration file for your virtual host
>>>    2. include ' ProxyPass / ajp://<YourOFBizIpAddress>:8009/ '
>>>    3. include ' ProxyPassReverse / ajp://<YourOFBizIpAddress>:8009 '
>>>    4. Restart your web server
>>>
>>> Now you're good to go to access http://<IpAddressOfWebServer>/catalog
>>>
>>> The above should do the trick.
>>>
>>> Regards,
>>>
>>>
>>> Pierre Smits
>>>
>>> *ORRTIZ.COM <http://www.orrtiz.com>*
>>> Services & Solutions for Cloud-
>>> Based Manufacturing, Professional
>>> Services and Retail & Trade
>>> http://www.orrtiz.com
>>>
>>> On Thu, Oct 23, 2014 at 11:20 AM, Adrian Stern <
>>> [hidden email]>
>>> wrote:
>>>
>>> > I just verified:
>>> >
>>> > Opening URL: http://<ip>/catalog
>>> >
>>> > will redirect to: https://<ip>/catalog/control/main
>>> >
>>> > which contains no content (site not available) because
>>> > of ERR_CONNECTION_REFUSED
>>> >
>>> > Freundliche Grüsse
>>> >
>>> > Adrian Stern
>>> > unchained - web solutions
>>> >
>>> > [hidden email]
>>> > [phone]
>>> >
>>> > On Thu, Oct 23, 2014 at 11:03 AM, Adrian Stern <
>>> [hidden email]>
>>> > wrote:
>>> >
>>> > > Hi Nicolas
>>> > >
>>> > > I did: "There is output generated when accessing <ip>/webtools - in
>>> the
>>> > > stdout" - which means ofbiz does receive the request (or at least a
>>> part
>>> > of
>>> > > it) but there is no response. Blank Page.
>>> > >
>>> > >
>>> > > Freundliche Grüsse
>>> > >
>>> > > Adrian Stern
>>> > > unchained - web solutions
>>> > >
>>> > > [hidden email]
>>> > > [phone]
>>> > >
>>> > > On Mon, Oct 20, 2014 at 10:37 AM, Nicolas Malin <
>>> > [hidden email]>
>>> > > wrote:
>>> > >
>>> > >> Le 17/10/2014 16:14, Adrian Stern a écrit :
>>> > >>
>>> > >>> Accessing the IP directly
>>> > >>> will return a white screen
>>> > >>>
>>> > >> try https://${yourIP|DnsName}/catalog
>>> > >>
>>> > >> Nicolas
>>> > >>
>>> > >
>>> > >
>>> >
>>>
>>
>>
>

[Pierre Smits]

Adrian,

Are you perhaps using OFBiz with an external RDBMS? If so, rebuilding it is
not automatically done by OFBiz.

Your second issue could indeed be the result of your combination of OS,
Java and ssl functionality.

Regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com

On Thu, Oct 23, 2014 at 4:06 PM, Adrian Stern <[hidden email]>
wrote:

> Ofbiz does not start without errors. There are 2, which do not seem to be
> related to my problem:
>
> 2014-10-23 14:26:25,308 |OFBiz-config-0       |DatabaseUtil
>  |E| WARNING: Column [META_DATA_VALUE] of table [OFBIZ.CONTENT_META_DATA]
> of entity [ContentMetaData] IS a primary key in the database, but IS NOT a
> primary key in the entity definition. The primary key for this table needs
> to be re-created or modified so that this column is NOT part of the primary
> key.
>
> 2014-10-23 14:26:25,310 |OFBiz-config-0       |DatabaseUtil
>  |E| WARNING: Column [META_DATA_VALUE] of table
> [OFBIZ.DATA_RESOURCE_META_DATA] of entity [DataResourceMetaData] IS a
> primary key in the database, but IS NOT a primary key in the entity
> definition. The primary key for this table needs to be re-created or
> modified so that this column is NOT part of the primary key.
>
> Also on the server, after running "ant start", when connecting to
> http://localhost:8080/webtools i get redirected to a 8443 url and console
> output is generated. On the 8443 URL i get the SSL error. There are no new
> log entries dough.
>
> Maybe it's the java version:
> 1.7.0_51: SSL error (Opensuse13.1, tried on vServer and VM)
> 1.7.0_71: Working (Archlinux)
>
> Freundliche Grüsse
>
> Adrian Stern
> unchained - web solutions
>
> [hidden email]
> [phone]
>
> On Thu, Oct 23, 2014 at 2:11 PM, Adrian Stern <[hidden email]>
> wrote:
>
> > Yea. Sorry i got disturbed.
> >
> > Process: Checkout Ofbiz13.07 - build - load-demo - start
> > Connect with: links http://localhost:8443/webtools
> >
> > Local: Working
> > Server: SSL error
> >
> > Freundliche Grüsse
> >
> > Adrian Stern
> > unchained - web solutions
> >
> > [hidden email]
> > [phone]
> >
> > On Thu, Oct 23, 2014 at 2:04 PM, Adrian Stern <[hidden email]
> >
> > wrote:
> >
> >> Ok. I did find out something.
> >>
> >> The following process i did locally as well as on the server. Locally i
> >> could connect with Link (Terminal Browser) with https. On the server i
> got
> >> an ssl error. (no more information but only "SSL error".
> >>
> >> So i guess i'm facing a system problem.
> >>
> >> Freundliche Grüsse
> >>
> >> Adrian Stern
> >> unchained - web solutions
> >>
> >> [hidden email]
> >> [phone]
> >>
> >> On Thu, Oct 23, 2014 at 11:57 AM, Pierre Smits <[hidden email]>
> >> wrote:
> >>
> >>> Adrian,
> >>>
> >>> Setting up a demo implementation to test your connection from http
> >>> through
> >>> ajp should be that difficult.
> >>>
> >>> Follow this example and you'll have something to work with:
> >>>
> >>>    1. download and unzip your preferred version into a new directory
> >>>    2. in the directory you unzipped your version execute:
> >>>       1. ./ant build (or the windows equivalent)
> >>>       2. ./ant load-demo (gets data from the files in the data folder
> in
> >>>       the components into the rdbms )
> >>>    3. now run ./ant start to see OFBiz start without errors
> >>>    4. access your implementation with your web browser through
> >>> http://<YourOFBizIpAddress>:8443/catalog
> >>>    (you should see the log-in screen)
> >>>
> >>> When this works, you can start connecting your http server to the OFBiz
> >>> App
> >>> Server
> >>>
> >>>    1. Open or create a/the configuration file for your virtual host
> >>>    2. include ' ProxyPass / ajp://<YourOFBizIpAddress>:8009/ '
> >>>    3. include ' ProxyPassReverse / ajp://<YourOFBizIpAddress>:8009 '
> >>>    4. Restart your web server
> >>>
> >>> Now you're good to go to access http://<IpAddressOfWebServer>/catalog
> >>>
> >>> The above should do the trick.
> >>>
> >>> Regards,
> >>>
> >>>
> >>> Pierre Smits
> >>>
> >>> *ORRTIZ.COM <http://www.orrtiz.com>*
> >>> Services & Solutions for Cloud-
> >>> Based Manufacturing, Professional
> >>> Services and Retail & Trade
> >>> http://www.orrtiz.com
> >>>
> >>> On Thu, Oct 23, 2014 at 11:20 AM, Adrian Stern <
> >>> [hidden email]>
> >>> wrote:
> >>>
> >>> > I just verified:
> >>> >
> >>> > Opening URL: http://<ip>/catalog
> >>> >
> >>> > will redirect to: https://<ip>/catalog/control/main
> >>> >
> >>> > which contains no content (site not available) because
> >>> > of ERR_CONNECTION_REFUSED
> >>> >
> >>> > Freundliche Grüsse
> >>> >
> >>> > Adrian Stern
> >>> > unchained - web solutions
> >>> >
> >>> > [hidden email]
> >>> > [phone]
> >>> >
> >>> > On Thu, Oct 23, 2014 at 11:03 AM, Adrian Stern <
> >>> [hidden email]>
> >>> > wrote:
> >>> >
> >>> > > Hi Nicolas
> >>> > >
> >>> > > I did: "There is output generated when accessing <ip>/webtools - in
> >>> the
> >>> > > stdout" - which means ofbiz does receive the request (or at least a
> >>> part
> >>> > of
> >>> > > it) but there is no response. Blank Page.
> >>> > >
> >>> > >
> >>> > > Freundliche Grüsse
> >>> > >
> >>> > > Adrian Stern
> >>> > > unchained - web solutions
> >>> > >
> >>> > > [hidden email]
> >>> > > [phone]
> >>> > >
> >>> > > On Mon, Oct 20, 2014 at 10:37 AM, Nicolas Malin <
> >>> > [hidden email]>
> >>> > > wrote:
> >>> > >
> >>> > >> Le 17/10/2014 16:14, Adrian Stern a écrit :
> >>> > >>
> >>> > >>> Accessing the IP directly
> >>> > >>> will return a white screen
> >>> > >>>
> >>> > >> try https://${yourIP|DnsName}/catalog
> >>> > >>
> >>> > >> Nicolas
> >>> > >>
> >>> > >
> >>> > >
> >>> >
> >>>
> >>
> >>
> >
>

[Adrian Stern-2]

It is working with ubuntu server.

Thanks for your inputs.

Freundliche Grüsse

Adrian Stern
unchained - web solutions

[hidden email]
[phone]

On Thu, Oct 23, 2014 at 4:49 PM, Pierre Smits <[hidden email]>
wrote:

> Adrian,
>
> Are you perhaps using OFBiz with an external RDBMS? If so, rebuilding it is
> not automatically done by OFBiz.
>
> Your second issue could indeed be the result of your combination of OS,
> Java and ssl functionality.
>
> Regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Thu, Oct 23, 2014 at 4:06 PM, Adrian Stern <[hidden email]>
> wrote:
>
> > Ofbiz does not start without errors. There are 2, which do not seem to be
> > related to my problem:
> >
> > 2014-10-23 14:26:25,308 |OFBiz-config-0       |DatabaseUtil
> >  |E| WARNING: Column [META_DATA_VALUE] of table [OFBIZ.CONTENT_META_DATA]
> > of entity [ContentMetaData] IS a primary key in the database, but IS NOT
> a
> > primary key in the entity definition. The primary key for this table
> needs
> > to be re-created or modified so that this column is NOT part of the
> primary
> > key.
> >
> > 2014-10-23 14:26:25,310 |OFBiz-config-0       |DatabaseUtil
> >  |E| WARNING: Column [META_DATA_VALUE] of table
> > [OFBIZ.DATA_RESOURCE_META_DATA] of entity [DataResourceMetaData] IS a
> > primary key in the database, but IS NOT a primary key in the entity
> > definition. The primary key for this table needs to be re-created or
> > modified so that this column is NOT part of the primary key.
> >
> > Also on the server, after running "ant start", when connecting to
> > http://localhost:8080/webtools i get redirected to a 8443 url and
> console
> > output is generated. On the 8443 URL i get the SSL error. There are no
> new
> > log entries dough.
> >
> > Maybe it's the java version:
> > 1.7.0_51: SSL error (Opensuse13.1, tried on vServer and VM)
> > 1.7.0_71: Working (Archlinux)
> >
> > Freundliche Grüsse
> >
> > Adrian Stern
> > unchained - web solutions
> >
> > [hidden email]
> > [phone]
> >
> > On Thu, Oct 23, 2014 at 2:11 PM, Adrian Stern <[hidden email]
> >
> > wrote:
> >
> > > Yea. Sorry i got disturbed.
> > >
> > > Process: Checkout Ofbiz13.07 - build - load-demo - start
> > > Connect with: links http://localhost:8443/webtools
> > >
> > > Local: Working
> > > Server: SSL error
> > >
> > > Freundliche Grüsse
> > >
> > > Adrian Stern
> > > unchained - web solutions
> > >
> > > [hidden email]
> > > [phone]
> > >
> > > On Thu, Oct 23, 2014 at 2:04 PM, Adrian Stern <
> [hidden email]
> > >
> > > wrote:
> > >
> > >> Ok. I did find out something.
> > >>
> > >> The following process i did locally as well as on the server. Locally
> i
> > >> could connect with Link (Terminal Browser) with https. On the server i
> > got
> > >> an ssl error. (no more information but only "SSL error".
> > >>
> > >> So i guess i'm facing a system problem.
> > >>
> > >> Freundliche Grüsse
> > >>
> > >> Adrian Stern
> > >> unchained - web solutions
> > >>
> > >> [hidden email]
> > >> [phone]
> > >>
> > >> On Thu, Oct 23, 2014 at 11:57 AM, Pierre Smits <
> [hidden email]>
> > >> wrote:
> > >>
> > >>> Adrian,
> > >>>
> > >>> Setting up a demo implementation to test your connection from http
> > >>> through
> > >>> ajp should be that difficult.
> > >>>
> > >>> Follow this example and you'll have something to work with:
> > >>>
> > >>>    1. download and unzip your preferred version into a new directory
> > >>>    2. in the directory you unzipped your version execute:
> > >>>       1. ./ant build (or the windows equivalent)
> > >>>       2. ./ant load-demo (gets data from the files in the data folder
> > in
> > >>>       the components into the rdbms )
> > >>>    3. now run ./ant start to see OFBiz start without errors
> > >>>    4. access your implementation with your web browser through
> > >>> http://<YourOFBizIpAddress>:8443/catalog
> > >>>    (you should see the log-in screen)
> > >>>
> > >>> When this works, you can start connecting your http server to the
> OFBiz
> > >>> App
> > >>> Server
> > >>>
> > >>>    1. Open or create a/the configuration file for your virtual host
> > >>>    2. include ' ProxyPass / ajp://<YourOFBizIpAddress>:8009/ '
> > >>>    3. include ' ProxyPassReverse / ajp://<YourOFBizIpAddress>:8009 '
> > >>>    4. Restart your web server
> > >>>
> > >>> Now you're good to go to access http://
> <IpAddressOfWebServer>/catalog
> > >>>
> > >>> The above should do the trick.
> > >>>
> > >>> Regards,
> > >>>
> > >>>
> > >>> Pierre Smits
> > >>>
> > >>> *ORRTIZ.COM <http://www.orrtiz.com>*
> > >>> Services & Solutions for Cloud-
> > >>> Based Manufacturing, Professional
> > >>> Services and Retail & Trade
> > >>> http://www.orrtiz.com
> > >>>
> > >>> On Thu, Oct 23, 2014 at 11:20 AM, Adrian Stern <
> > >>> [hidden email]>
> > >>> wrote:
> > >>>
> > >>> > I just verified:
> > >>> >
> > >>> > Opening URL: http://<ip>/catalog
> > >>> >
> > >>> > will redirect to: https://<ip>/catalog/control/main
> > >>> >
> > >>> > which contains no content (site not available) because
> > >>> > of ERR_CONNECTION_REFUSED
> > >>> >
> > >>> > Freundliche Grüsse
> > >>> >
> > >>> > Adrian Stern
> > >>> > unchained - web solutions
> > >>> >
> > >>> > [hidden email]
> > >>> > [phone]
> > >>> >
> > >>> > On Thu, Oct 23, 2014 at 11:03 AM, Adrian Stern <
> > >>> [hidden email]>
> > >>> > wrote:
> > >>> >
> > >>> > > Hi Nicolas
> > >>> > >
> > >>> > > I did: "There is output generated when accessing <ip>/webtools -
> in
> > >>> the
> > >>> > > stdout" - which means ofbiz does receive the request (or at
> least a
> > >>> part
> > >>> > of
> > >>> > > it) but there is no response. Blank Page.
> > >>> > >
> > >>> > >
> > >>> > > Freundliche Grüsse
> > >>> > >
> > >>> > > Adrian Stern
> > >>> > > unchained - web solutions
> > >>> > >
> > >>> > > [hidden email]
> > >>> > > [phone]
> > >>> > >
> > >>> > > On Mon, Oct 20, 2014 at 10:37 AM, Nicolas Malin <
> > >>> > [hidden email]>
> > >>> > > wrote:
> > >>> > >
> > >>> > >> Le 17/10/2014 16:14, Adrian Stern a écrit :
> > >>> > >>
> > >>> > >>> Accessing the IP directly
> > >>> > >>> will return a white screen
> > >>> > >>>
> > >>> > >> try https://${yourIP|DnsName}/catalog
> > >>> > >>
> > >>> > >> Nicolas
> > >>> > >>
> > >>> > >
> > >>> > >
> > >>> >
> > >>>
> > >>
> > >>
> > >
> >
>