Where is db_setup.sql ?

[vertex]

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 advance
Vertex

[flopez]

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?

[stateless]

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;
‍‍‍‍‍

[flopez]

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!

[cjimenez2581]

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?

[mrogers]

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

[trupti_korde]

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;