Hi, Version 1.4-M2 doesn't anymore archiva database :-). All has been moved to jcr (jackrabbit). Only users are still stored in database (users). See http://archiva.apache.org/docs/1.4-M2/adminguide/databases.html
The most important: does Archiva works ? :-) 2012/8/29 Harris, Christopher P <[email protected]>: > Hi. > > > > I’ve set up Archiva apache-archiva-1.4-M2.war on Windows XP using Tomcat > 7.0.26 (base separated from installation). > > > > I’ve set up a MySQL 5.5 database. The problem is that I see no tables or > data getting populated in just the archiva schema for the “archiva” user. > However, I am seeing tables and data populating the users schema for the > “users” user. > > > > I used this script: > > create database archiva; > > > > create database users; > > > > use mysql; > > GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX ON archiva.* TO > 'archiva'@'localhost' IDENTIFIED BY 'archiva'; > > GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX ON users.* TO > 'users'@'localhost' IDENTIFIED BY 'users'; > > > > I can successfully launch the Archiva .war in Tomcat. Upon my initial > launch of Archiva, I was prompted to create the admin. Once I created the > admin, the admin showed up in the jdouser table in the users schema. The > guest user is present as well. > > > > I’ve attached archiva.log. > > > > I see that the \path\to\tomcat_base_archiva\data\repositories\* directories > default internal and snapshots repositories are getting created within my > file system. That would indicate that Derby is getting used for the > repositories, correct? > > > > Here’s my archiva.xml from > \path\to\tomcat_base_archiva\conf\Catalina\localhost > > <Context path="/archiva" > > > docBase="C:/apache/tomcat_base_archiva/archiva/apache-archiva-1.4-M2.war" > > reloadable="true" > > antiJARLocking="true" > > antiResourceLocking="true"> > > > > <!-- docBase="${catalina.home}/archiva/apache-archiva-1.4-M2.war"> > --> > > <Resource name="jdbc/users" > > auth="Container" > > type="javax.sql.DataSource" > > username="users" > > password="users" > > driverClassName="com.mysql.jdbc.Driver" > > url="jdbc:mysql://localhost:3306/users?autoReconnect=true"/> > > > > <Resource name="jdbc/archiva" > > auth="Container" > > type="javax.sql.DataSource" > > username="archiva" > > password="archiva" > > driverClassName="com.mysql.jdbc.Driver" > > url="jdbc:mysql://localhost:3306/archiva?autoReconnect=true"/> > > > > <Resource name="mail/Session" > > auth="Container" > > type="javax.mail.Session" > > mail.smtp.host="localhost"/> > > </Context> > > > > I poked around in the Archiva code on SVN here : > > http://svn.apache.org/viewvc/archiva/tags/archiva-1.4-M2/archiva-modules/archiva-web/archiva-webapp/src/ > > I looked at the jetty config file jetty-env-mysql.xml and noticed that the > archiva user is given the password ‘sa’. > > I noticed that here too: > > http://svn.apache.org/viewvc/archiva/tags/archiva-1.4-M2/archiva-modules/archiva-web/archiva-webapp/src/sql/mysql/drop_archiva_tables.sql?view=markup > > So, I even tried changing the “archiva” user’s password to sa within MySQL > and in archiva.xml. > > > > That didn’t work. > > > > I’ve read about a bug where MySQL db’s shouldn’t be set to UTF-8, but that > bug appears to have affected older Archiva versions. Both my users and > archiva tables are set to UTF-8. > > > > It’s odd that the users db is being utilized, but the archiva db is not. > > > > What am I doing wrong? > > > > I’m tempted to try PostgreSQL, but I don’t want to open another potential > can of worms just yet. > > > > - Chris > > The information transmitted is intended only for the person(s)or entity to > which it is addressed and may contain confidential and/or legally privileged > material. Delivery of this message to any person other than the intended > recipient(s) is not intended in any way to waive privilege or > confidentiality. Any review, retransmission, dissemination or other use of , > or taking of any action in reliance upon, this information by entities other > than the intended recipient is prohibited. If you receive this in error, > please contact the sender and delete the material from any computer. > > For Translation: > > http://www.baxter.com/email_disclaimer -- Olivier Lamy Talend: http://coders.talend.com http://twitter.com/olamy | http://linkedin.com/in/olamy
