topic Re: cant Upgrade from .4d to 4.0e Ubu10.4 MySQL, reindex failed in Alfresco Archive

cant Upgrade from .4d to 4.0e Ubu10.4 MySQL, reindex failed

stegbth — Sun, 28 Oct 2012 21:41:40 GMT

Hi,i am trying to upgrade my Alfresco 3.4d to 4.0e on Ubuntu 10.04 with mysql database.After reading the forum i was able to fix some trouble's, but currently it still doesn't work.what i have done:dump alfresco34d mysql database and converted to UTF8.stopped MySQLinstalled Ubuntu Mysql and modiefi

Re: cant Upgrade from .4d to 4.0e Ubu10.4 MySQL, reindex failed

abarisone — Mon, 29 Oct 2012 13:07:19 GMT

Hi,
In order to perform a full reindex you have to

stop Alfresco

modify alfresco-global.properties adding the property index.recovery.mode=FULL

restart Alfresco in order to let the index being rebuilt

stop Alfresco again

modify alfresco-global.properties modifying the property index.recovery.mode=AUTO

start Alfresco

Regards,
Andrea

Re: cant Upgrade from .4d to 4.0e Ubu10.4 MySQL, reindex failed

stegbth — Fri, 02 Nov 2012 00:22:35 GMT

Hi,

i found one error.
i coverted the database from defaultlocation latin1 to utf8.

no i imported the 3.4d mysql database with latin1 and left in alfresco-global.properties:
db.url=jdbc:mysql://localhost:3306/${db.name}?useUnicode=yes&characterEncoding=UTF-8

Now the Umlauts are visible.

After the reindex of lucene the search queries worked.

Then i switched to solr, delete in the archive the index and spellchecker ( http://deepak-keswani.blogspot.de/2012/07/how-to-rebuild-solr-indexes-in-alfresco.html )
After starting alfresco it working a long time (high load of java), but the index doesn't find anything?

When following this guide (http://docs.alfresco.com/4.0/index.jsp?topic=%2Fcom.alfresco.enterprise.doc%2Ftasks%2Flucene-solr-migration.html )
i can't connect the ip, cause i get
192.168.50.59:8443 aufgetreten.

the remote-end cant verify your ssl-certificate
(Fehlercode: ssl_error_bad_cert_alert)

so how can i switch correctly to solr?
doesn't it matter if database is on latin1 collation?

best regards
thomas