Brett Porter wrote:

On 17/04/2009, at 6:19 PM, Todor Boev wrote:

There are no new databases. Also there are no new new files in the archiva-1.2 directory, nor in the /var/archiva directory.. I noticed however that there are two databases archiva_users and apache_archiva, which seem to contain *identical* lists of tables (28 tables in each). By the prefixes of the table names I would expect that archiva_users should contain only SECUTIRY_XXXX tables while apache_archiva should contain everything else.

That's right. You might need to double check that you don't have a typo in jetty.xml that is being used then.

- Brett



I'm thinking I should backup the databases and than try to drop all tables in apache_archiva and retain only the SECURITY tables in archiva_users? This seems to confirm to the migration guide:

Note that the users database must always be retained as it contains the permissions and user information across versions. However, in order to take advantage of the improvements in search in Archiva 1.1 (and higher versions), s.a. search by java class/package/method, the archiva database must be re-created. So you need to delete the data/databases/archiva directory, delete the .index directories of your respective repositories, and execute the repository and database scanners after starting Archiva.

I suppose this is tailored for Derby. The analog in my case would be to drop everything in apache_archiva and retain only the SECURITY_XXX tables from archiva_users right?

-Todor

Reply via email to