Hi Mark,
Yes, I was referring "./osafe_deployment/client-deployment.properties’ file. The error that you are seeing on ‘ant run-install-seed’ command is due to not configuring the *olap datasource. Since the ProductDimension entity is in ‘org.ofbiz.olap’ group and this group is not configured in enityengine.xml template. But those errors would not create any problem to run Bigfish and definitely we would be looking into this. I think this would help you. Please feel free to ask if any concern. Thanks, Praveen Agrawal [email protected] From: Mark Schneider [mailto:[email protected]] Sent: Sunday, December 23, 2012 10:28 PM To: [email protected] Subject: Re: Meaning of localderbyolap and localderbytenant in template files / Error loading XML Resource HI Praveen, Thanks a lot for your kind hints. There are two such files after installation of BigFish-eCommerce-v1.08.zip: :~/apache-ofbiz-10.04.04$ find ./ -name client-deployment.properties ./osafe_deployment/client-deployment.properties ./hot-deploy/osafe/config/client-deployment.properties ~/apache-ofbiz-10.04.04$ diff ./hot-deploy/osafe/config/client-deployment.properties ./osafe_deployment/client-deployment.properties 11,12c11,12 < jdbc.username=root < jdbc.password=root --- > jdbc.username=bigfish > jdbc.password=bigfish 53c53 < port.jndi=1095 --- > port.jndi=1092 I guess you mean "./osafe_deployment/client-deployment.properties" I used following commangs to create the MySQL database: MariaDB [(none)]> create database bigfishdemo; MariaDB [(none)]> CREATE USER 'bigfish'@'localhost' IDENTIFIED BY 'bigfish'; MariaDB [(none)]> GRANT ALL PRIVILEGES ON bigfishdemo.* TO bigfish @'%' IDENTIFIED BY 'bigfish'; MariaDB [(none)]> FLUSH PRIVILEGES; ~/apache-ofbiz-10.04.04$ mysql -u root -p MariaDB [(none)]> select Host,User,Password from mysql.user; +-----------+------------------+-------------------------------------------+ | Host | User | Password | +-----------+------------------+-------------------------------------------+ | localhost | root | | | wheezy | root | | | 127.0.0.1 | root | | | ::1 | root | | | localhost | debian-sys-maint | *9A3E21ACF2BEF1D3908CD1EBDC497ADC90FBF6EA | | localhost | bigfish | *F2AB1B6DA9A13BDF7E260CA4C847230F29134D47 | | % | bigfish | *F2AB1B6DA9A13BDF7E260CA4C847230F29134D47 | +-----------+------------------+-------------------------------------------+ ~$ mysql -u bigfish -p MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | bigfishdemo | +--------------------+ When I run "ant run-install-seed" there is the following error message: # --- . [java] 2012-12-23 16:16:10,683 (main) [EntityDataLoadContainer.java:397:INFO ] 00116 of 122131 from file:/home/ironm/apache-ofbiz-10.04.04/hot-deploy/osafeadmin/data/OsafeAdminSecurityData.xml <file:///\\home\ironm\apache-ofbiz-10.04.04\hot-deploy\osafeadmin\data\OsafeAdminSecurityData.xml> [java] 2012-12-23 16:16:10,683 (main) [EntityDataLoadContainer.java:397:INFO ] 00065 of 122196 from file:/home/ironm/apache-ofbiz-10.04.04/hot-deploy/osafeadmin/data/OsafeAdminHomePageSeedData.xml <file:///\\home\ironm\apache-ofbiz-10.04.04\hot-deploy\osafeadmin\data\OsafeAdminHomePageSeedData.xml> [java] 2012-12-23 16:16:10,684 (main) [EntityDataLoadContainer.java:402:INFO ] The following errors occured in the data load: [java] 2012-12-23 16:16:10,684 (main) [EntityDataLoadContainer.java:404:INFO ] [install.loadData]: Error loading XML Resource <file:///\\home\ironm\apache-ofbiz-10.04.04\framework\common\data\DimensionTypeData.xml> "file:/home/ironm/apache-ofbiz-10.04.04/framework/common/data/DimensionTypeData.xml"; Error was: A transaction error occurred reading data [java] 2012-12-23 16:16:10,684 (main) [EntityDataLoadContainer.java:404:INFO ] [install.loadData]: Error loading XML Resource <file:///\\home\ironm\apache-ofbiz-10.04.04\applications\product\data\DimensionTypeData.xml> "file:/home/ironm/apache-ofbiz-10.04.04/applications/product/data/DimensionTypeData.xml"; Error was: A transaction error occurred reading data [java] 2012-12-23 16:16:10,684 (main) [EntityDataLoadContainer.java:408:INFO ] =-=-=-=-=-=-= Finished the data load with 122196 rows changed. [java] 2012-12-23 16:16:10,684 (main) [ ContainerLoader.java:113:INFO ] Shutting down containers BUILD SUCCESSFUL Total time: 2 minutes 4 seconds # --- Tables are created: MariaDB [bigfishdemo]> show tables; . 829 rows in set (0.01 sec) I can't find any errors in mysql.log I am not sure it this issue is MariaDB/MySQL specific or something else. Is it possible (just for the test) to use localderby instead? .. or PostgreSQL? I have followed <http://bigfish.salmonllc.com/bfDownload.html> "http://bigfish.salmonllc.com/bfDownload.html"; and tested it on wheezy debian linux with JDK7u9 (amd64). ~/apache-ofbiz-10.04.04$ ./startofbiz.sh bash: ./startofbiz.sh: /bin/sh^M: Defekter Interpreter: Datei oder Verzeichnis nicht gefunden ~/apache-ofbiz-10.04.04$ dos2unix startofbiz.sh dos2unix: Datei startofbiz.sh wird ins Unix-Format umgewandelt ... ~/apache-ofbiz-10.04.04$ ./startofbiz.sh sreen_shots.zip Thank you in advance for any hints. regards, Mark Am 23.12.2012 08:59, schrieb Praveen Agrawal: Hi Mark, To run bigfish it's not required to modify localderbyolap and localderbytenant through entityengine.xml.template. You can set the following DB properties in client-deployment.properties file. main.datasource.name database.name database.server database.serverPort jdbc.driver jdbc.username jdbc.password after settings properties, the ant command will modify the entityengine.xml file using template. There is no need of multiple DB's to run bigfish. Only one Database is required. Thanks, Praveen Agrawal [email protected] -----Original Message----- From: Mark Schneider [mailto:[email protected]] Sent: Sunday, December 23, 2012 1:41 AM To: [email protected] Subject: Re: Meaning of localderbyolap and localderbytenant in template files Just small correction in the subject line Am 22.12.2012 21:05, schrieb Mark Schneider: Hello BigFish example use a template file for entityengine.xml. Is it required to modify localderbyolap and localderbytenant to let say localmysqlolap and localmysqltentant when using MySQL (or MariaDB) as database and define appriopriate sections for them in entityengine.xml? (see attachment) ./osafe_deployment/ofbiz/framework/entity/config/entityengine.xml.temp late . <!-- the connection factory class to use, one is needed for obtaining connections/pools for defined resources --> <connection-factory class="org.ofbiz.entity.connection.DBCPConnectionFactory"/> <delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false"> <group-map group-name="org.ofbiz" datasource-name="@main.datasource.name@"/> <group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/> <group-map group-name="org.ofbiz.tenant" datasource-name="localderbytenant"/> </delegator> <delegator name="default-no-eca" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" entity-eca-enabled="false" distributed-cache-clear-enabled="false"> <group-map group-name="org.ofbiz" datasource-name="@main.datasource.name@"/> <group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/> <group-map group-name="org.ofbiz.tenant" datasource-name="localderbytenant"/> </delegator> <!-- be sure that your default delegator (or the one you use) uses the same datasource for test. You must run "ant run-install" before running "ant run-tests" --> <delegator name="test" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main"> <group-map group-name="org.ofbiz" datasource-name="@main.datasource.name@"/> <group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/> <group-map group-name="org.ofbiz.tenant" datasource-name="localderbytenant"/> </delegator> Thank you in advance for any hints. regards, Mark -- [email protected] http://rsync.it-infrastrukturen.org -- [email protected] http://rsync.it-infrastrukturen.org
