I am trying from past two days to configure MySQL with alfresco community edition but the moment I changed that "alfresco.properties" file as per the given instruction, I get the following error on my Login screen : Your authentication details haven't bee
Edit : PLEASE use the text box for the question content, NOT the one for the title to provide your question. The title is limited to a certain number of characters and it looks like your question was truncated as a result.
What do you see in your alfresco console / logfile ? You will need to double-check the DB connection details & access to your DB.
Regards,
Jan
Hello,
Thank you so much for the reply. Actually I have made all required changes
in the alfresco.global.properties file as per the given instruction but
after the changes being made, I won't be able to login and got a error
message stating "Your authentication details have not been recognized or
Alfresco Content Services may not be available at this time."
I want to switch to MySQL from PostgreSQL.
Do you already have data in Alfresco? If so, did you dump the MySQL database, convert it to PostgreSQL format, and then load it into a new PostgreSQL database? If you already have data you cannot simply change the properties file and restart. You have to migrate the data.
Hello.
I know about an old discussion on the topic of database migration, but it was from MSSQL into PostgreSQL, but I believe it can give you some ideas on what needs to be done.
Migrating from MSSQL to Postgresql
It has some important tips you should read.
I don't have any data.
Okay, well that should make it very easy. How did you install Postgresql? Did you let the Alfresco installer install it or did you install it separately?
If you installed it separately were you able to connect to Postgres? Did you create the Alfresco database and make "alfresco" the owner? If so, were you able to connect to the database using the "alfresco" username and password? If all of that works, did you set the postgres credentials in alfresco-global.properties? Did you put the postgresql driver in the Tomcat lib directory?
If all of that is okay, then start up alfresco and look for exceptions in the log.
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.