Installing Alfresco Community Edition 5.1 with a MySQL database

[Brian McNew]

I am getting ready to install Alfresco Community Edition 5.1 on a Windows 2012 R2 Server using a MySQL database.  Is it best to install Alfresco with the Advanced option and just not select PostgreSQL or go ahead and install PostgreSQL and then change everything to point to MySQL instead?  If so, would I need to install MySQL prior to installing Alfresco?  Any information regarding this would be greatly appreciated.  Thanks!

[Craig Nelson]

I would do advanced and only install what you need. No point in have postgres installed. Also the way the services are set up you will have to have it running to start alfresco

On Aug 23, 2016 3:51 PM, "Brian McNew" <bcm...@gmail.com> wrote:

I am getting ready to install Alfresco Community Edition 5.1 on a Windows 2012 R2 Server using a MySQL database.  Is it best to install Alfresco with the Advanced option and just not select PostgreSQL or go ahead and install PostgreSQL and then change everything to point to MySQL instead?  If so, would I need to install MySQL prior to installing Alfresco?  Any information regarding this would be greatly appreciated.  Thanks!

--
You received this message because you are subscribed to the Google Groups "Alfresco Technical Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to alfresco-technical-discussion+unsub...@googlegroups.com.
To post to this group, send email to alfresco-technical-discussion@googlegroups.com.
Visit this group at https://groups.google.com/group/alfresco-technical-discussion.
For more options, visit https://groups.google.com/d/optout.

[Brian McNew]

Thanks for the info Craig!  I'm not sure now whether to just go with PostgreSQL or MySQL.  Have any thoughts about that?  

On Tuesday, August 23, 2016 at 3:55:28 PM UTC-5, Craig Nelson wrote:

I would do advanced and only install what you need. No point in have postgres installed. Also the way the services are set up you will have to have it running to start alfresco

On Aug 23, 2016 3:51 PM, "Brian McNew" <bcm...@gmail.com> wrote:

I am getting ready to install Alfresco Community Edition 5.1 on a Windows 2012 R2 Server using a MySQL database.  Is it best to install Alfresco with the Advanced option and just not select PostgreSQL or go ahead and install PostgreSQL and then change everything to point to MySQL instead?  If so, would I need to install MySQL prior to installing Alfresco?  Any information regarding this would be greatly appreciated.  Thanks!

--
You received this message because you are subscribed to the Google Groups "Alfresco Technical Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to alfresco-technical-discussion+unsub...@googlegroups.com.

To post to this group, send email to alfresco-techn...@googlegroups.com.

[Craig Nelson]

In my opinion that depends on what DB experience you have or your company has. I find there is more general help in mysql however Alfresco moved from mysql to postgres a long time ago so it is easier to get that setup. 

To post to this group, send email to alfresco-technical-discussion@googlegroups.com.

[Brian McNew]

Thanks!  We do not have a DBA on our staff.  I did install a test environment just allowing the default PostgreSQL installation and was able to get the site up and working with no issues.  I am sort of leaning toward installing with PostgreSQL by installing with the Advanced option and housing the DB, etc. on its own drive.  This is on a Windows 2012 Server.  Do you have a preference for a GUI-based tool to use with PostgreSQL?  I appreciate the info!

[Nisreen Qabbani]

I want to transfer data from the  ms sql database  the previous program to the alfresco community version 5

What a way

Please help me

[Craig Nelson]

That sounds more like a db migration issue where you will need to export the sql from ms sql and then modifying it to the database you want. That isn't something that I have ever done or would intend on doing. If I was currently using a db I would not recommend migrating to another type of DB unless you have a good reason for doing so.  

To post to this group, send email to alfresco-technical-discussion@googlegroups.com.

[Brian McNew]

Craig,

Do you know of preferred GUI-based tool to use with PostgreSQL?  Thanks!

[Craig Nelson]

Brian, 

I don't have a preference on any GUI-based PostgreSQL tool; however, pgAdmin is a tool i most commonly use thought for Postgres. 

To post to this group, send email to alfresco-technical-discussion@googlegroups.com.

[Brian McNew]

Cool, thanks!  I had installed pgAdmin III on my test server, but haven't been successful in connecting to the database.  I'm sure I just don't know what the default DB name is and the user/password in order to connect.  

--
You received this message because you are subscribed to a topic in the Google Groups "Alfresco Technical Discussion" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/alfresco-technical-discussion/TKH9-Y3n-s0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to alfresco-technical-discussion+unsub...@googlegroups.com.

[Boriss Mejias]

Hi Brian,

I have some experience with PostgreSQL, but no experience with windows servers. Being that said, I believe pgAdmin III is a good tool for your administration. To get the right credentials for the connection, have a look at the alfresco-global.properties file and search for the db.* properties.

Special attention to db.port. Default port is 5432, but it might be that alfresco installed postgresql with a different port.

It is possible that db.port is not defined, but that the port is written on the db.url property.

Note that the alfresco user will be the owner of the alfresco database, but not the super user of the postgresql engine. You might need to be able to connect with the 'postgres' user to perform some administration tasks.

I hope it helps

Cheers

Boriss

On 26 August 2016 at 21:47, Brian McNew <bcm...@gmail.com> wrote:

Cool, thanks!  I had installed pgAdmin III on my test server, but haven't been successful in connecting to the database.  I'm sure I just don't know what the default DB name is and the user/password in order to connect.