ofbiz-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacques Le Roux <jacques.le.r...@les7arts.com>
Subject Re: Getting Started using MySQL
Date Thu, 05 Jun 2014 07:13:42 GMT

Le 04/06/2014 17:05, Ron Wheeler a écrit :
> I do get worked up over documentation!
>
> It is a bit like living in a house where everyone wants to cook but no one will wash
the pots and pans!
> The food is great for a while but eventually no one trusts the food after they see the
kitchen.

Good analogy :D

>
> Trying to get people to clean up the docs while they write the code is a challenge but
it is part of the project management process.
> Asking people to write docs in their second or third language is hard but perhaps might
be easier if they knew that an editor would fix the English.
> I can help smooth out phrasing, clean up grammar, etc. but if the software developers
don't provide the facts, I can not make them up.
>
> For example, the person who changed the Ant build has to fix the docs, no one else knows
what changed.

Yes, as often, it's a matter of human resources

>
> Does the project have a group in charge of documentation?

No, it's all benevolent work and it's hard to organise things because we have to earn a living
outside and the situation is continuously changing 
(most of active volunters are independent or working for companies who did a great effort
at some point but, I guess, have also to fight everyday to 
keep on their paths

> Does this group have the same control over releases as the coders?
>
> This is hard to do in an open source project but if the basic documentation being wrong
or incomplete is not a blocker on the release it will never 
> get fixed.

That's quite an idea, I'd love to see it applied. But it might be only a dream too few people
among committers and even PMC feel concerned nowadays. 
And this same PMC is reluctant to invite new people, afraid of the quality their help could
offer (there are already some experience about that)
https://cwiki.apache.org/confluence/display/OFBADMIN/Apache+OFBiz+PMC+%28Project+Management+Committee%29+Members+and+Committers

>
> OfBiz looks like a 0.6 release level from the outside.

Hold on, it looks at least like a 0.9 to me from this perspective :p

> Once you get into it, it is clearly a highly functional project but the apparent quality
is low.
> I am not sure what impact that this has on adoption but I suspect that it is a big deterrent.
>

I so much agree

> For some people, this is probably just more ranting but the state of the docs is important
and needs to be a bigger concern for all of the developers.

Could developers listen to you...

Jacques

>
> Ron
>
>
>
> On 04/06/2014 4:29 AM, Jacques Le Roux wrote:
>> You are welcome to help... Rants never do...
>>
>> Jacques
>>
>> Le 04/06/2014 07:01, Ron Wheeler a écrit :
>>> The screenshots would make a nice addition to the instructions that Adrian supplied.
>>> They worked very well and I am now trying to get my head around the actual functionality.
>>>
>>> It appears that everyone likes writing new documentation rather than fixing the
"official" docs.
>>>
>>> Ron
>>>
>>>
>>> On 03/06/2014 6:52 PM, Sergio G Barreros wrote:
>>>> This is what I always use and it's very easy to follow.
>>>>
>>>> http://lj4newbies.blogspot.com/2008/06/setup-mysql-with-ofbiz.html
>>>>
>>>>
>>>> Regards,
>>>> Sergio
>>>>
>>>>
>>>>
>>>> On Tue, Jun 3, 2014 at 3:54 AM, Ron Wheeler <rwheeler@artifact-software.com
<mailto:rwheeler@artifact-software.com>> wrote:
>>>>
>>>>     There is a description about how to add the database connector but
>>>>     it is different and more complicated.
>>>>
>>>>     If necessary, put the correct JDBC driver in:
>>>>     ${ofbiz install dir}/framework/entity/lib/jdbc
>>>>     replacing the old or incorrect version of the driver there (ie
>>>>     copy in with same name to avoid problems with update restoring the
>>>>     old driver later)
>>>>
>>>>
>>>>
>>>>     On 03/06/2014 12:31 AM, Deepak Dixit wrote:
>>>>
>>>>         One more step:
>>>>
>>>>         Don't forgot to put the mySql drive.
>>>>         Use "./ant download-mySQL-JDBC" to download the mysql driver.
>>>>
>>>>         Thanks & Regards
>>>>         ---
>>>>         Deepak Dixit
>>>>
>>>>         On Jun 3, 2014, at 3:10 AM, Adrian Crum
>>>>         <adrian.crum@sandglass-software.com
>>>> <mailto:adrian.crum@sandglass-software.com>> wrote:
>>>>
>>>>             Here is what I recommend:
>>>>
>>>>             1. Restore the original file.
>>>>
>>>>             2. Modify the "localmysql" datasource element to connect
>>>>             to your database.
>>>>
>>>>             3. Modify the "default" delegator element:
>>>>                 Change
>>>>                     <group-map group-name="org.ofbiz"
>>>>             datasource-name="localderby"/>
>>>>                 to
>>>>                     <group-map group-name="org.ofbiz"
>>>>             datasource-name="localmysql"/>
>>>>
>>>>             The OLAP and Tenant data sources will still use Derby. If
>>>>             you want to change those to use MySQL also, then:
>>>>
>>>>             1. Modify the "localmysqlolap" datasource element to
>>>>             connect to your OLAP database.
>>>>
>>>>             2. Modify the "localmysqltenant" datasource element to
>>>>             connect to your Tenant database.
>>>>
>>>>             3. Modify the "default" delegator element:
>>>>                 Change
>>>>                     <group-map group-name="org.ofbiz.olap"
>>>>             datasource-name="localderbyolap"/>
>>>>                 to
>>>>                     <group-map group-name="org.ofbiz.olap"
>>>>             datasource-name="localmysqlolap"/>
>>>>                 Change
>>>>                     <group-map group-name="org.ofbiz.tenant"
>>>>             datasource-name="localderbytenant"/>
>>>>                 to
>>>>                     <group-map group-name="org.ofbiz.tenant"
>>>>             datasource-name="localmysqltenant"/>
>>>>
>>>>             Finally, run:
>>>>
>>>>             ant load-demo
>>>>
>>>>             Adrian Crum
>>>>             Sandglass Software
>>>>             www.sandglass-software.com <http://www.sandglass-software.com>
>>>>
>>>>             On 6/2/2014 2:26 PM, Ron Wheeler wrote:
>>>>
>>>>                 In  entityengine.xml, I removed the databases that I
>>>>                 am not using just
>>>>                 to make it clearer.
>>>>                 As OfBiz is distributed there seems to be several
>>>>                 group-map entries that
>>>>                 are active and some commented out.
>>>>                 There seemed to be several different group-names in use.
>>>>                 Did I understand the instructions incorrectly or have
>>>>                 I screwed up
>>>>                 somewhere else?
>>>>                 The ofbiz database exists and the ofbiz user has all
>>>>                 privs on it.
>>>>                 A null pointer usually means that I promised to
>>>>                 provide an object and I
>>>>                 didn't rather than a database security error.
>>>>                 I have not touched any other configuration files.
>>>>
>>>>                      <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="localmysql"/>
>>>>                      </delegator>
>>>>                 .
>>>>                 .
>>>>                 .
>>>>
>>>>                    <datasource name="localmysql"
>>>> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>>>>                              field-type-name="mysql"
>>>>                              check-on-start="true"
>>>>                              add-missing-on-start="true"
>>>>                              check-pks-on-start="false"
>>>>                              use-foreign-keys="true"
>>>> join-style="ansi-no-parenthesis"
>>>>                              alias-view-columns="false"
>>>> drop-fk-use-foreign-key-keyword="true"
>>>>                              table-type="InnoDB"
>>>>                              character-set="latin1"
>>>>                              collate="latin1_general_cs">
>>>>                          <read-data reader-name="tenant"/>
>>>>                          <read-data reader-name="seed"/>
>>>>                          <read-data reader-name="seed-initial"/>
>>>>                          <read-data reader-name="demo"/>
>>>>                          <read-data reader-name="ext"/>
>>>>                          <inline-jdbc
>>>> jdbc-driver="com.mysql.jdbc.Driver"
>>>> jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true
>>>> <http://127.0.0.1/ofbiz?autoReconnect=true>"
>>>>                                  jdbc-username="ofbiz"
>>>> jdbc-password="mylittlesecret"
>>>> isolation-level="ReadCommitted"
>>>>                                  pool-minsize="2"
>>>>                                  pool-maxsize="250"
>>>> time-between-eviction-runs-millis="600000"/>
>>>>                      </datasource>
>>>>
>>>>                 Gives me:
>>>>                      [java] 2014-06-02 17:14:05,843 (main) [
>>>>                 ModelViewEntity.java:551:WARN ] [ExampleStatusDetail]:
>>>>                 Conversion for
>>>>                 complex-alias needs to be implemented for cache and
>>>>                 in-memory eval stuff
>>>>                 to work correctly, will not work for alias: statusDelay
>>>>                       [java] 2014-06-02 17:14:06,202 (main) [
>>>>                 ModelReader.java:436:INFO
>>>>                 ] FINISHED LOADING ENTITIES - ALL FILES; #Entities=863
>>>>                 #ViewEntities=300
>>>>                 #Fields=9049 #Relationships=2961 #AutoRelationships=2186
>>>>                       [java] 2014-06-02 17:14:06,297 (main) [
>>>>                 GenericDelegator.java:234:INFO ] Doing entity
>>>>                 definition check...
>>>>                       [java] 2014-06-02 17:14:06,317 (main) [
>>>>                 ModelEntityChecker.java:508:INFO ] [initReservedWords]
>>>>                 array length=1023
>>>>                       [java] java.lang.NullPointerException
>>>>                       [java]     at
>>>> org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:541)
>>>>
>>>>                       [java]     at
>>>> org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:107)
>>>>
>>>>                       [java]     at
>>>> org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:235)
>>>>                       [java]     at
>>>> org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:33)
>>>>
>>>>                       [java]     at
>>>> org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25)
>>>>
>>>>                       [java]     at
>>>> org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:202)
>>>>                       [java]     at
>>>> org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:51)
>>>>                       [java]     at
>>>> org.ofbiz.entityext.data.EntityDataLoadContainer.loadContainer(EntityDataLoadContainer.java:272)
>>>>
>>>>                       [java]     at
>>>> org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:236)
>>>>
>>>>                       [java]     at
>>>> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:230)
>>>>                       [java]     at
>>>> org.ofbiz.base.start.Start.startStartLoaders(Start.java:362)
>>>>                       [java]     at
>>>> org.ofbiz.base.start.Start.start(Start.java:337)
>>>>                       [java]     at
>>>> org.ofbiz.base.start.Start.main(Start.java:139)
>>>>                       [java] 2014-06-02 17:14:07,337 (Thread-0) [
>>>>                 ContainerLoader.java:246:INFO ] Shutting down containers
>>>>                       [java] Java Result: 99
>>>>
>>>>                 BUILD SUCCESSFUL
>>>>                 Total time: 31 seconds
>>>>
>>>>
>>>>
>>>>                 On 02/06/2014 4:26 PM, Adrian Crum wrote:
>>>>
>>>>                     The correct steps are there:
>>>>
>>>>                     Modify an existing datasource (near the bottom of
>>>>                     the file) or create
>>>>                     a new one by copying one of the sample datasources
>>>>                     already there and
>>>>                     giving it a new unique name
>>>>
>>>>                         If using the default OFBiz transaction manager
>>>>                     and connection
>>>>                     pool, update the data URI, username and password
>>>>                     in the inline-jdbc tag
>>>>                         If you want your OFBiz tables in a special
>>>>                     schema first create
>>>>                     that schema in your database, then set the
>>>>                     schema-name attribute on
>>>>                     the datasource tag
>>>>                         Find the "default" delegator near the top of
>>>>                     the file and change
>>>>                     the datasource-name attribute value in the
>>>>                     group-map tag under it to
>>>>                     the name of the data source you modified or created.
>>>>
>>>>
>>>>                     Adrian Crum
>>>>                     Sandglass Software
>>>>                     www.sandglass-software.com
>>>> <http://www.sandglass-software.com>
>>>>
>>>>                     On 6/2/2014 1:01 PM, Ron Wheeler wrote:
>>>>
>>>>                         It appears that there is a missing step in the
>>>>                         description about how to
>>>>                         run OfBiz with a database other than Derby.
>>>> https://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide
>>>>
>>>>
>>>>
>>>>                         talks about changing the "default" delegator
>>>>                         but it does not mention
>>>>                         anywhere that I can find, how you tell OfBiz
>>>>                         that  you want to use the
>>>>                         delegator associated with My SQL.
>>>>
>>>>                         I am getting a null pointer which I think is
>>>>                         caused by OfBiz still
>>>>                         trying to use Derby which no longer has a
>>>>                         delegator sice it is commented
>>>>                         out and the MySQL one is uncommented.
>>>>
>>>>                         What is the secret step tat I need to to to
>>>>                         make the instructions work?
>>>>
>>>>                         Ron
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>     --     Ron Wheeler
>>>>     President
>>>>     Artifact Software Inc
>>>>     email: rwheeler@artifact-software.com
>>>>     <mailto:rwheeler@artifact-software.com>
>>>>     skype: ronaldmwheeler
>>>>     phone: 866-970-2435, ext 102 <tel:866-970-2435%2C%20ext%20102>
>>>>
>>>>
>>>
>>>
>>
>
>

-- 

Mime
View raw message