topic Re: Where is db_setup.sql ? in Alfresco Archive

Where is db_setup.sql ?

vertex — Tue, 02 Nov 2010 21:59:48 GMT

I can't find "db_setup.sql" it is not enclosed "alfresco-community-3.4.a.zip" - so where can I find it ?btw, in the install manual files are mentioned which no longer exists e.g. alfresco-community-war-3.3.tar.gz or Alfresco-Community-3.3-Linux-x86-Install.Thanks in advanceVertex

Re: Where is db_setup.sql ?

flopez — Thu, 25 Nov 2010 22:50:07 GMT

I am also looking for this, to install Alfresco on Linux (Ubuntu) I have tomcat, java and mysql installed, and need that scprit before deploying the alfresco war, does anyone know where this file is or what it does?

Re: Where is db_setup.sql ?

stateless — Thu, 25 Nov 2010 23:41:08 GMT

setup_db.sql can be manually replaced by:


create database alfresco default character set utf8 collate utf8_bin;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;
‍‍‍‍‍

Re: Where is db_setup.sql ?

flopez — Fri, 26 Nov 2010 16:11:28 GMT

setup_db.sql can be manually replaced by:


create database alfresco default character set utf8 collate utf8_bin;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;
‍‍‍‍‍

Thank You!

Re: Where is db_setup.sql ?

cjimenez2581 — Tue, 09 Aug 2011 22:46:08 GMT

setup_db.sql can be manually replaced by:


create database alfresco default character set utf8 collate utf8_bin;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;
‍‍‍‍‍

Thank You!

how can I dot in Postgresql?

Re: Where is db_setup.sql ?

mrogers — Wed, 10 Aug 2011 09:45:31 GMT

AFAIK there is no setup script for postgresql. I created a database and login through the pgAdmin console and it worked.

Re: Where is db_setup.sql ?

trupti_korde — Wed, 10 Aug 2011 11:41:38 GMT

setup_db.sql can be manually replaced by:


create database alfresco default character set utf8 collate utf8_bin;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;
‍‍‍‍‍

Thank You!

how can I dot in Postgresql?

Here is the script for creating alfresco database in postgreSQL -

CREATE DATABASE alfresco
WITH OWNER = alfresco
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       LC_COLLATE = 'English_United States.1252'
       LC_CTYPE = 'English_United States.1252'
       CONNECTION LIMIT = -1;