topic Re: Database issue during installation of alfresco3.4.d in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/database-issue-during-installation-of-alfresco3-4-d/m-p/266913#M220043 <HTML><HEAD></HEAD><BODY><SPAN>I suspect the problem is that the MySQL connection string in alfresco-global.properties is set to use "alfresco" as the database name by default. I don't know why, but the connection string defaults to:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>db.url=jdbc:mysql://localhost/alfresco?useUnicode=yes&amp;characterEncoding=UTF-8<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>When I think a better default would be:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>db.url=jdbc:mysql://localhost/${db.name}?useUnicode=yes&amp;characterEncoding=UTF-8<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>So if you have set db.name in alfresco-global.properties, check that connection string and make the change as above.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Fri, 24 Feb 2012 22:56:57 GMT jpotts 2012-02-24T22:56:57Z Database issue during installation of alfresco3.4.d https://connect.hyland.com/t5/alfresco-archive/database-issue-during-installation-of-alfresco3-4-d/m-p/266912#M220042 Hi All,I was installing alfresco3.4.d in linux operating system by executing binary file.During installation I choose for existing database .I gave the database name as alfresco1,user name as alfresco1.I also gave all privileges to the user on the database.After completing installation when I starte Thu, 23 Feb 2012 08:43:09 GMT https://connect.hyland.com/t5/alfresco-archive/database-issue-during-installation-of-alfresco3-4-d/m-p/266912#M220042 abhashree 2012-02-23T08:43:09Z Re: Database issue during installation of alfresco3.4.d https://connect.hyland.com/t5/alfresco-archive/database-issue-during-installation-of-alfresco3-4-d/m-p/266913#M220043 <HTML><HEAD></HEAD><BODY><SPAN>I suspect the problem is that the MySQL connection string in alfresco-global.properties is set to use "alfresco" as the database name by default. I don't know why, but the connection string defaults to:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>db.url=jdbc:mysql://localhost/alfresco?useUnicode=yes&amp;characterEncoding=UTF-8<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>When I think a better default would be:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>db.url=jdbc:mysql://localhost/${db.name}?useUnicode=yes&amp;characterEncoding=UTF-8<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>So if you have set db.name in alfresco-global.properties, check that connection string and make the change as above.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Fri, 24 Feb 2012 22:56:57 GMT https://connect.hyland.com/t5/alfresco-archive/database-issue-during-installation-of-alfresco3-4-d/m-p/266913#M220043 jpotts 2012-02-24T22:56:57Z