Re: Tomcat Unresponsive

2014-12-20 Thread Jacopo Cappellato 

On Dec 20, 2014, at 3:52 AM, darrell73s  wrote:

> Hi all,
> 
> Just as a follow up on this, I was ultimately able to get to the bottom of
> the issue. It turned out to be a product of my environment. I came to find
> out that in my environment, there is a stateful firewall which will
> terminate connections which are idle for a given period of time. By writing
> a test program which uses the driver directly (taking OFBiz out of the
> equation), I simulated the issue, and discovered that attempting to use the
> connection once it gets into the strange state after the firewall having
> killed it, the call to run the query hangs for about 15 minutes before
> returning and throwing an exception (if I remember correctly it was a socket
> read timeout). Even with the connection pooler attempting to run the test
> query would cause this hanging behavior, as it's attempting to execute the
> query on the bad connection. This means that when attempting to visit the
> application, the application retrieves a connection from the pool, attempts
> to log the Visit, but because the connection is in a bad state, the query
> hangs, without throwing an exception, and you see the original behavior I
> described. 
> 
> Because of my environmental constraints, I was not able to get the firewall
> modified, but was able to work around it by manipulating
> 'timeBetweenEvictionRunsMillis' and 'minEvictableIdleTimeMillis' such that
> connections are closed and re-established in the pool at a rate under the
> time at which the firewall will terminate them.

I agree that setting a proper value for the time-between-eviction-runs-millis 
is the right way to go.
With it, you can also enable:
test-while-idle="true"
and this should enable the validation of idle connections (by running the test 
query) at the frequency set by time-between-eviction-runs-millis

I hope it helps and congratulations for your progress.
Thanks for sharing these details, I am sure it will be valuable information for 
many users.

Jacopo 

> 
> I'm now working on tackling a different issue which I see every few days in
> my LIVE system where the status of a query in PostgreSQL will be "idle in
> transaction" and seems to cause other queries to begin piling up. So far, it
> has been queries on the Product, and ProductCalculatedInfo entities which
> are idle in transaction, but it appears to be at random times: one second
> the query works fine, the next it becomes idle in transaction. I've searched
> all of my hot deploy code to ensure that there are no transactions being
> manually controlled in the custom code (e.g. Maybe there was a begin
> transaction with no commit/rollback) but it all appears fine. Have any of
> you folks ever seen this problem with OFBiz and PostgreSQL?
> 
> Thanks!
> 
> 
> 
> --
> View this message in context: 
> http://ofbiz.135035.n4.nabble.com/Tomcat-Unresponsive-tp4659005p4659936.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: connection to external database: part 2

2014-12-20 Thread i...@agentur-m3.de 
Thank you all for your help with understanding the
datasource and delegator concepts!

There is one additional point to this topic in the
context of automatic importing the entities (it would
be great if this connection would work at the end!):

in ModelInduceFromDb there seems to be a problem
with with the field-names of the mysql definitions.

I work with mysql server version 5.6.20 (as part of xampp).
For some of the field definitions ofbiz does not seem
to have appropriate fieldtypes, so that some of the
results of calling the servlet:

https://localhost:8443/webtools/control/view/ModelInduceFromDb

are like this:


So they are invalid and of course they cause errors when using them as
entity-defintions.

Then I took a look at the fieldtype-definitions and to me it seems
that some of the valid mysql-fieldtypes  are not defined in
fieldtypemysql.xml.

Here are the complete fields for a table (wpposts form wordpress) I
would like to import for testing. The reference wordpress schema(1),
the ofbiz fieldtypes(2) and the ModelInduceFromDb-result (3):


(1) This is the reference field list from the mysql table:

  ID bigint(20) unsigned NOT NULL auto_increment,
  post_author bigint(20) unsigned NOT NULL default '0',
  post_date datetime NOT NULL default '-00-00 00:00:00',
  post_date_gmt datetime NOT NULL default '-00-00 00:00:00',
  post_content longtext NOT NULL,
  post_title text NOT NULL,
  post_excerpt text NOT NULL,
  post_status varchar(20) NOT NULL default 'publish',
  comment_status varchar(20) NOT NULL default 'open',
  ping_status varchar(20) NOT NULL default 'open',
  post_password varchar(20) NOT NULL default '',
  post_name varchar(200) NOT NULL default '',
  to_ping text NOT NULL,
  pinged text NOT NULL,
  post_modified datetime NOT NULL default '-00-00 00:00:00',
  post_modified_gmt datetime NOT NULL default '-00-00 00:00:00',
  post_content_filtered longtext NOT NULL,
  post_parent bigint(20) unsigned NOT NULL default '0',
  guid varchar(255) NOT NULL default '',
  menu_order int(11) NOT NULL default '0',
  post_type varchar(20) NOT NULL default 'post',
  post_mime_type varchar(100) NOT NULL default '',
  comment_count bigint(20) NOT NULL default '0',
  PRIMARY KEY  (ID),
  KEY post_name (post_name),
  KEY type_status_date (post_type,post_status,post_date,ID),
  KEY post_parent (post_parent),
  KEY post_author (post_author)


(2) This is ofbiz's framework/entity/fieldtype/fieldtypemysql.xml content:





http://www.w3.org/2001/XMLSchema-instance";

xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/fieldtypemodel.xsd";>
  










































(3) And this is the induced result (ModelInduceFromDb):

 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  


Would it solve the problem  to add the missing fieldtypes to
fieldtypedef.xml ?

Re: OFBiz/BigFish: Indian Retailer Religare Wellness goes live!

2014-12-20 Thread Jacques Le Roux 

I will also add a Books menu entry. It seems few new comers don't spot the wiki 
page. These are important information which should be at the top level.

Jacques

Le 05/11/2014 19:50, Nick Rosser a écrit :

+1

On 11/5/2014 1:47 PM, Jacques Le Roux wrote:


Le 31/10/2014 12:57, Nick Rosser a écrit :
Unfortunately this list is a little difficult to find for anyone new to OFBiz. After going to the main ofbiz.org, under "Documentation", it's a 
hard to find link "Users of Apache OFBiz".


I tried in the past to get this promoted to a main link within the Home Page. As we all know, almost all sites have a very prominent "Clients" or 
"Customers" link in order to provide viewers easy access to this information. I also feel that the "Service Providers" should also be more prominent.


At the time of my request it was felt that for an open-source project the 
current structure was appropriate.

Maybe this is the time to revisit this? I would like to see a main navbar link of "users" from the ofbiz.org home page. Failing that, perhaps we 
can have it more prominent within the "documentation" page? Suggest that we could have a heading (like "Introduction" or "wikis") that showcases 
"Users of OFBiz".


What about a references entry in the main menu. Then a wiki page with at least 
these 2 pages
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Users (maybe 
need to be rewritten to make the links to other pages more clear)
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Service+Providers

Jacques



Nick

On 10/31/2014 3:28 AM, Pierre Smits wrote:

Hi Pranay,

We have a page called 'Users list', see here:
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+User+List

Maybe just add a child page for the users in your country? And perhaps one
for the users per industry sector?

Regards,

Pierre Smits

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

On Fri, Oct 31, 2014 at 7:25 AM, Pranay Pandey<
pranay.pan...@hotwaxmedia.com>  wrote:


Its a great list Divesh, thanks for sharing.

I think it can be a good way for OFBiz in general if people come and share
their success stories with it. It surely helps increasing the adoption.
Community should encourage users/developers to do so.

I don’t know if we can do it or not but just an idea if we can also have
dedicated page in OFBiz wiki for this purpose. Surely we have Service
providers list but having a central place to put together some cool samples
can be a good thing.

Thanks
Pranay Pandey

On Oct 31, 2014, at 11:32 AM, Divesh Dutta
wrote:


Hi Nick,

Congratulations.

On Oct 29, 2014, at 2:40 AM, Nick Rosser  wrote:


We are particularly excited to see activity in India begin to ramp up,

has anyone else seen this?


I know some of the well known Indian sites which are on top of OFBiz.

They are:

http://shopping.indiatimes.com/

http://nokia.indiatimes.com/

http://titan.co.in/

http://www.univercell.in

http://mirchimart.com/


http://www.gitanjalishop.com


http://www.medplusbeauty.com

All above are E-commerce stores.


Other one is Muncipal Corporation of Delhi: (E-governance project)

http://111.93.49.24/myservice/control/main


Next is , National Informatics Centre, an initiative by Govt. of India

for their developing E-governance projects also mention use of OFBiz in
their ERP initiative.

Check #43 here:

https://portal.otc.nic.in/listofprojects





Thanks
—
Divesh Dutta

Re: connection to external database: part 2

2014-12-20 Thread Adrian Crum 
It would be best to create your own custom field type file, then 
reference it in your MySQL data source. Leave the original MySQL field 
type file as-is.


I too have noticed problems getting ModelInduceFromDb to work properly 
with MySQL. Maybe once you get this working you can create a Jira issue 
for it.


Adrian Crum
Sandglass Software
www.sandglass-software.com

On 12/20/2014 8:25 AM, i...@agentur-m3.de wrote:

Thank you all for your help with understanding the
datasource and delegator concepts!

There is one additional point to this topic in the
context of automatic importing the entities (it would
be great if this connection would work at the end!):

in ModelInduceFromDb there seems to be a problem
with with the field-names of the mysql definitions.

I work with mysql server version 5.6.20 (as part of xampp).
For some of the field definitions ofbiz does not seem
to have appropriate fieldtypes, so that some of the
results of calling the servlet:

https://localhost:8443/webtools/control/view/ModelInduceFromDb

are like this:


So they are invalid and of course they cause errors when using them as
entity-defintions.

Then I took a look at the fieldtype-definitions and to me it seems
that some of the valid mysql-fieldtypes  are not defined in
fieldtypemysql.xml.

Here are the complete fields for a table (wpposts form wordpress) I
would like to import for testing. The reference wordpress schema(1),
the ofbiz fieldtypes(2) and the ModelInduceFromDb-result (3):


(1) This is the reference field list from the mysql table:

   ID bigint(20) unsigned NOT NULL auto_increment,
   post_author bigint(20) unsigned NOT NULL default '0',
   post_date datetime NOT NULL default '-00-00 00:00:00',
   post_date_gmt datetime NOT NULL default '-00-00 00:00:00',
   post_content longtext NOT NULL,
   post_title text NOT NULL,
   post_excerpt text NOT NULL,
   post_status varchar(20) NOT NULL default 'publish',
   comment_status varchar(20) NOT NULL default 'open',
   ping_status varchar(20) NOT NULL default 'open',
   post_password varchar(20) NOT NULL default '',
   post_name varchar(200) NOT NULL default '',
   to_ping text NOT NULL,
   pinged text NOT NULL,
   post_modified datetime NOT NULL default '-00-00 00:00:00',
   post_modified_gmt datetime NOT NULL default '-00-00 00:00:00',
   post_content_filtered longtext NOT NULL,
   post_parent bigint(20) unsigned NOT NULL default '0',
   guid varchar(255) NOT NULL default '',
   menu_order int(11) NOT NULL default '0',
   post_type varchar(20) NOT NULL default 'post',
   post_mime_type varchar(100) NOT NULL default '',
   comment_count bigint(20) NOT NULL default '0',
   PRIMARY KEY  (ID),
   KEY post_name (post_name),
   KEY type_status_date (post_type,post_status,post_date,ID),
   KEY post_parent (post_parent),
   KEY post_author (post_author)


(2) This is ofbiz's framework/entity/fieldtype/fieldtypemysql.xml content:





http://www.w3.org/2001/XMLSchema-instance";

xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/fieldtypemodel.xsd";>
   
 
 
 
 

 
 
 

 
 
 
 
 

 
 
 

 
 
 
 
 

 
 
 
 

 
 
 
 
 
 
 
 
 



(3) And this is the induced result (ModelInduceFromDb):

  
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
 

Would it solve the problem  to add the missing fieldtypes to
fieldtypedef.xml ?

Cannot send eMail when not installing Demo Data

2014-12-20 Thread Gunnar Beushausen 
I've tried dozens of time to get sending emails in OFBiz to work. Somehow it 
just doesn't work. I've tried it with Version 11, 12 and now 13. I've tried 
using OSX and Ubuntu, JDK 6 and 7.

I've added my mailserver data under framework/common/general.properties. Then i 
started a new OFBiz install using load-extseed and create-admin-user-login.

Then i added a new party and tried to send an email to it. Somehow the Select 
Box named "From Email Addr" is totally empty and nothing is selectable. Using 
the demo data, there is the default email address. But with a clean install 
nothing shows up there, no matter what i configure in the admin or my own 
company account.

After sending the mail, nothing happens. What can i do?

Not able to compile sources from hot-deploy

2014-12-20 Thread Ashish Repal 
Hi All,
I am getting package not found error while building source files from
hot-deploy custom component.
Any idea on this ?

Regards,
Aashish Repal
09623381664

Re: Cannot send eMail when not installing Demo Data

2014-12-20 Thread Nicolas Malin 

Add an email address to your party with the purpose.

Nicolas


Le 21/12/2014 02:22, Gunnar Beushausen a écrit :

I've tried dozens of time to get sending emails in OFBiz to work. Somehow it 
just doesn't work. I've tried it with Version 11, 12 and now 13. I've tried 
using OSX and Ubuntu, JDK 6 and 7.

I've added my mailserver data under framework/common/general.properties. Then i 
started a new OFBiz install using load-extseed and create-admin-user-login.

Then i added a new party and tried to send an email to it. Somehow the Select Box named 
"From Email Addr" is totally empty and nothing is selectable. Using the demo 
data, there is the default email address. But with a clean install nothing shows up 
there, no matter what i configure in the admin or my own company account.

After sending the mail, nothing happens. What can i do?

Re: Not able to compile sources from hot-deploy

2014-12-20 Thread Jacques Le Roux 

You need to give us more details in order for us to help you

Jacques

Le 21/12/2014 06:59, Ashish Repal a écrit :

Hi All,
I am getting package not found error while building source files from
hot-deploy custom component.
Any idea on this ?

Regards,
Aashish Repal
09623381664