Firstly, where should this feedback go? Should there be an "APLAWS Documentation" mailing list?
Here are a few minor comments on "Creating a PostgreSQL account" on page 18:
1. Copy-paste of text is a bit dodgy. For example, when I copy "createuser -A -D -P ccm", the hyphens are replaced by newlines as follows:
createuser A
D
P
ccm
Is this a Windows-only issue? I am using Acrobat Reader 8.1.2.
2. "createuser –help" should be "createuser --help" i.e. double-hyphen not the long hyphen.
3. With Postgres 8+ you need to append "&protocolVersion=2" to the JDBC URL to avoid the following loader error:
2008-03-05 21:26:49,914 [19635] INFO packaging.Loader - Running data loader com.arsdigita.core.Loader
java.lang.Error: error fetching path (this.parent.id): Bad value for type BigDecimal :
at com.redhat.persistence.engine.rdbms.RDBMSRecordSet.get(RDBMSRecordSet.java:84)
at com.redhat.persistence.RecordSet.load(RecordSet.java:96)
at com.redhat.persistence.Cursor.next(Cursor.java:129)
at com.arsdigita.persistence.DataQueryImpl.next(DataQueryImpl.java:663)
at com.arsdigita.kernel.SiteNode.getRootSiteNode(SiteNode.java:331)
...
Regards,
Terry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
| Firstly, where should this feedback go? Should there be an
| "APLAWS Documentation" mailing list?
Currently there is no dedicated mailing list for documentation, and all the existent different mailing lists are rarely used. Devel is the list for everything.
| 1. Copy-paste of text is a bit dodgy.
works here (Fedora) without a problem. Maybe it is a windows problem or an incompatibility between OpenOffice pdf generator and windows. I'll check it as soon as possible.
| 2. "createuser –help" should be "createuser --help" i.e. double-hyphen not the long hyphen.
corrected
| 3. With Postgres 8+ you need to append "&protocolVersion=2" to the JDBC URL to avoid
| the following loader error: ....
Most interesting. We don't need that additional parameter, running APLAWS 1.0.4 and postgresql 8.1 on a RHEL 5.0 system.
Which versions are you using? Can you verify that you don't use an older version of the postgresql JDBC driver?
Nevertheless, I will add this to the troubleshooting section.
Thanks for the comments. I'll release a new version of the installation guide shortly.
The guide are currently in OpenOffice (until I can spend time to set up a docbook environment). I could send you the odt file so you can make additional corrections.
Peter
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
1. On page 19, Oracle needs two extra privileges to be granted. We used:
GRANT CONNECT, RESOURCE, QUERY REWRITE, CTXAPP, JAVASYSPRIV, CREATE PROCEDURE, CREATE TRIGGER TO ccm;
2. On Windoze, use "load-bundle ..." rather than "ccm load-bundle ..." and "hostinit-bundle ..." rather than "ccm hostinit-bundle ...".
3. On Windoze, the stored procedures don't validate with Oracle because of CR/LF problems. This is resolved by running the extra steps below before load-bundle. Since this is ZIP installation documentation, I guess we're buggered although I don't know why SVN contains files in Windows format :-(
Hi Peter,
Firstly, where should this feedback go? Should there be an "APLAWS Documentation" mailing list?
Here are a few minor comments on "Creating a PostgreSQL account" on page 18:
1. Copy-paste of text is a bit dodgy. For example, when I copy "createuser -A -D -P ccm", the hyphens are replaced by newlines as follows:
createuser A
D
P
ccm
Is this a Windows-only issue? I am using Acrobat Reader 8.1.2.
2. "createuser –help" should be "createuser --help" i.e. double-hyphen not the long hyphen.
3. With Postgres 8+ you need to append "&protocolVersion=2" to the JDBC URL to avoid the following loader error:
2008-03-05 21:26:49,914 [19635] INFO packaging.Loader - Running data loader com.arsdigita.core.Loader
java.lang.Error: error fetching path (this.parent.id): Bad value for type BigDecimal :
at com.redhat.persistence.engine.rdbms.RDBMSRecordSet.get(RDBMSRecordSet.java:84)
at com.redhat.persistence.RecordSet.load(RecordSet.java:96)
at com.redhat.persistence.Cursor.next(Cursor.java:129)
at com.arsdigita.persistence.DataQueryImpl.next(DataQueryImpl.java:663)
at com.arsdigita.kernel.SiteNode.getRootSiteNode(SiteNode.java:331)
...
Regards,
Terry
Hi Terry,
| Firstly, where should this feedback go? Should there be an
| "APLAWS Documentation" mailing list?
Currently there is no dedicated mailing list for documentation, and all the existent different mailing lists are rarely used. Devel is the list for everything.
| 1. Copy-paste of text is a bit dodgy.
works here (Fedora) without a problem. Maybe it is a windows problem or an incompatibility between OpenOffice pdf generator and windows. I'll check it as soon as possible.
| 2. "createuser –help" should be "createuser --help" i.e. double-hyphen not the long hyphen.
corrected
| 3. With Postgres 8+ you need to append "&protocolVersion=2" to the JDBC URL to avoid
| the following loader error: ....
Most interesting. We don't need that additional parameter, running APLAWS 1.0.4 and postgresql 8.1 on a RHEL 5.0 system.
Which versions are you using? Can you verify that you don't use an older version of the postgresql JDBC driver?
Nevertheless, I will add this to the troubleshooting section.
Thanks for the comments. I'll release a new version of the installation guide shortly.
The guide are currently in OpenOffice (until I can spend time to set up a docbook environment). I could send you the odt file so you can make additional corrections.
Peter
Some more corrections:
1. On page 19, Oracle needs two extra privileges to be granted. We used:
GRANT CONNECT, RESOURCE, QUERY REWRITE, CTXAPP, JAVASYSPRIV, CREATE PROCEDURE, CREATE TRIGGER TO ccm;
2. On Windoze, use "load-bundle ..." rather than "ccm load-bundle ..." and "hostinit-bundle ..." rather than "ccm hostinit-bundle ...".
3. On Windoze, the stored procedures don't validate with Oracle because of CR/LF problems. This is resolved by running the extra steps below before load-bundle. Since this is ZIP installation documentation, I guess we're buggered although I don't know why SVN contains files in Windows format :-(
prompt> cddev
prompt> find . -name "*.sql" -exec dos2unix {} ;
prompt> ant deploy
prompt> load-bundle --interactive --bundle aplaws-plus-complete
Yes, that is around the right way -- it's dos2unix not unix2dos!
Note: find.exe can be downloaded from http://unxutils.sourceforge.net/ and dos2unix.exe can be downloaded from http://www.bastet.com/.
Regards,
Terry