Changeset 6173 for trunk/INSTALL/arquivos/gerar_dump.sh

Timestamp:

05/14/12 14:30:37 (12 years ago)

Author:

wmerlotto

Message:

Ticket #2557 - Correcoes para melhorar o instalador e para deixar o Expresso completamente funcional.

File:

• trunk/INSTALL/arquivos/gerar_dump.sh (moved) (moved from trunk/INSTALL/arquivos/gera_dump.sh) (1 diff)

trunk/INSTALL/arquivos/gerar_dump.sh

@@ -1 +1 @@
 #!/bin/bash
+
+# Script utilizado para gerar o dump da base de dados padrao do Expresso.
+# Este dump e utilizado na instalacao do Expresso via script.
 
 DUMP=expresso.dump
 
 # Variaveis que devem ser substituidas
+DOMAIN="prognus.com.br"
 LDAP_DN="dc=prognus,dc=com,dc=br"
 ORG="ou=prognus"
-DOMAIN="prognus.com.br"
-LDAP_PWD="prognus"
-LDAP_DC="$LDAP_DN"
+LDAP_PWD="123pass"
+LDAP_DC="dc=br"
+
+# Remove as informacoes temporarias do banco
+psql -U postgres expresso <<EOF
+DELETE FROM phpgw_access_log *;
+DELETE FROM phpgw_expressoadmin_log *;
+DELETE FROM phpgw_history_log *;
+DELETE FROM phpgw_log *;
+DELETE FROM phpgw_log_msg *;
+EOF
 
 # Gera o dump da base do Expresso
-pg_dump -U postgres -f /tmp/$DUMP expresso
+TDUMP="/tmp/$DUMP"
+pg_dump -U postgres -f $TDUMP expresso
 
 sed -e "s/$LDAP_DN/LDAP_DN/g" \
-        -e "s/$ORG/ORG/g" \
-        -e "s/$DOMAIN/DOMAIN/g" \
-        -e "s/$LDAP_PWD/LDAP_PWD/g" /tmp/$DUMP > $DUMP
+        -e "s/$ORG/ou=ORG/g" \
+        -e "s/$DOMAIN/DOMAIN/g" \
+        -e "s/$LDAP_PWD/LDAP_PWD/g" $TDUMP > $DUMP