Francesco,

Thanks. The postgres passwd fault was a trivial typo.

And, yes, I'm trying to evaluate Syncope on a headless ubuntu server. I prefer being able to wipe a server, set up a clean build from a USB stick in minutes. This does tend to bias the environment to the debian / ubuntu repositories. So I've probably traded convenience for headaches with version dependencies. I know I've got mismatches with the versions of glassfish and jboss. So I'll bump these up to the stated versions before posting further questions on errors and such. (I'd presumed that if the embedded demo works, the deployment path should as well.)

Also, the team might consider a "getting started" page focused on known dependences, per at least the stable versions. "Run Syncope in real environments" mentions:
Tomcat7
Glassfish 3.1
JBoss AS 7.1

"Create a new Syncope project" mentions:
Apache Maven (version 3.0.3 or higher)

If there's anything in the wiki about a preferred JDK, I've missed it.

Thanks for your good works,

Edward



On 02/24/2013 09:39 AM, Francesco Chicchiriccò wrote:
On 23/02/2013 14:56, Edward Siewick wrote:
OK, with fresh eyes, in the error messages is:

Feb 22, 2013 11:44:23 PM org.apache.catalina.core.NamingContextListener addResource WARNING: Failed to register in JMX: javax.naming.NamingException: Could not load resource factory class [Root exception is java.lang.ClassNotFoundException: org.apache.tomcat.jdbc.pool.DataSourceFactory]

This is more meaningful.

From:
http://stackoverflow.com/questions/12462842/org-apache-tomcat-jdbc-pool-datasource-is-no-longer-in-the-tomcat-7-dbcp-jar

"Class org.apache.tomcat.jdbc.pool.DataSource is included in tomcat-jdbc.jar, not tomcat-dbcp.jar. The Tomcat JDBC Connection Pool is a replacement for commons-dbcp, of which tomcat-dbcp is just a renamed version. The jar file tomcat-jdbc.jar is not included in the default Tomcat download. You can download it from Maven Central."

(http://search.maven.org/#search%7Cga%7C1%7Ctomcat-jdbc)

So, the "Run Syncope in real environments" documentation should note that for postgres we need both of
postgresql-9.2-1002.jdbc4.jar
tomcat-jdbc-7.0.37.jar
in $CATALINIA_HOME/lib/.

Hi Edward,
which Apache Tomcat 7 distribution have you downloaded?

We have been deploying Apache Syncope with Tomcat 7 and PostgreSQL in various environments and had no necessity to download anything but the standard Apache Tomcat 7 distribution (e.g. the "zip" or "tar.gz" right under Binary Distributions / core at [1])

As the comments of the StackOverflow answers mentioned above say, in fact:

It's included, at least, in 7.0.37 tar.gz -- Victor Sorokin 19 hours ago

You're right, I meant that it is not included in some installations, like the Debian/Ubuntu package for Linux. Edited my answer to make it more clear. -- David Levesque 19 hours ago

I guess this means that you installed Apache Tomcat 7 via apt-get. I have updated the wiki page at [2] with a warning about this.

I've put these in /usr/share/java/

cd /usr/share/tomcat7/lib

ln -s ../../java/postgresql-9.2-1002.jdbc4.jar ./postgresql.jar
ln -s ../../java/tomcat-jdbc-7.0.37.jar ./tomcat-jdbc.jar

And now,
/var/log/postgresql/postgresql-9.1-main.log
is full of:
FATAL:  password authentication failed for user

So this is good; at least we're hitting postgres....

One of the main issues with PostgreSQL is making a simple plain authentication working for JDBC, I know... :-S
I'd suggest you to take a look at [3] for this.

HTH

Regards.

[1] http://tomcat.apache.org/download-70.cgi
[2] https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+real+environments [3] http://stackoverflow.com/questions/4562471/connecting-to-local-instance-of-postgresql-with-jdbc
--
Francesco Chicchiriccò

ASF Member, Apache Syncope PMC chair, Apache Cocoon PMC Member
http://people.apache.org/~ilgrosso/

Reply via email to