I am trying to install jUDDI v2.0 rc7 and need some help. I am having trouble connecting to the datasource through jUDDI. I would appreciate any help in this regard.
The happyjuddi page displays the following - ----- jUDDI Dependencies: Resource & Properties Files jUDDI DataSource Validation - No JNDI Context (null) - No 'null' DataSource Located(null) - DB connection was not acquired. (null) - SELECT COUNT(*) FROM PUBLISHER failed (null) ----- My current configuration is - Java JDK 1.6.0_13 MySQL Server 5.1 jUDDI v2.0 rc7 + Tomcat install package (juddi-tomcat-2.0rc7.zip) I tried the following things using the instructions in the Getting-Started.pdf in the docs folder of the jUDDI distribution package (juddi-distribution-2.0rc7-bin.zip) 1. Installed MySQL successfully 2. created a database "juddi" (Note - I did not create any tables, etc. as mentioned in the Getting-Started.pdf document) 3. created a user "juddi" with password "juddi" and granted all privileges on the database "juddi" 4. Put the mysql connector jar file (mysql-connector-java-5.1.7-bin.jar) in the $CATALINA_HOME\common\lib folder 5. Edited juddi.properties and made the following change juddi.operatorEmailAddress = [email protected] Note - I don't quite understand the specific reason behind this and I decided to follow the Getting-Started.pdf document, which says the following :- Amend the file juddi.properties at which is located at $CATALINA_HOME\webapps\juddi\WEB-INF\juddi.properties match the email address you used within insert_publishers.sql. This should match the domain name used for the email address within JUDDI’s insert_publisher.sql script. # The UDDI Operator Contact Email Address juddi.operatorEmailAddress = [email protected] 6. Following the Getting-Started.pdf directions, I edited the server.xml file which is located at $CATALINA_HOME\conf\server.xml and appended the following to the file, immediately above the </Host> tag. <Context path="/juddi" docBase="juddi" debug="5" reloadable="true" crossContext="true"> <Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_juddiDB_log" suffix=".txt" timestamp="true"/> <Resource name="jdbc/juddiDB" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="juddi" password="juddi" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/juddi?autoReconnect=true"/> </Context> 7. Further following the Getting-Started.pdf directions, I edited the juddi-user.xml located at $CATALINA_HOME\webapps\juddi\WEB-INF\juddi-users.xml and changed the password for user juddi to 123456. <user userid=”juddi” password=123456”> Can someone please help me getting jUDDI up and running? If you can specifically tell me if each of my steps were okay or not, and if not, what should be the correct alternative step. Thanks much. Best regards, Amit
