source: branches/2.4/INSTALL/arquivos/gerar_dump.sh @ 6173

Revision 6173, 781 bytes checked in by wmerlotto, 12 years ago (diff)

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

  • Property svn:executable set to *
Line 
1#!/bin/bash
2
3# Script utilizado para gerar o dump da base de dados padrao do Expresso.
4# Este dump e utilizado na instalacao do Expresso via script.
5
6DUMP=expresso.dump
7
8# Variaveis que devem ser substituidas
9DOMAIN="prognus.com.br"
10LDAP_DN="dc=prognus,dc=com,dc=br"
11ORG="ou=prognus"
12LDAP_PWD="123pass"
13LDAP_DC="dc=br"
14
15# Remove as informacoes temporarias do banco
16psql -U postgres expresso <<EOF
17DELETE FROM phpgw_access_log *;
18DELETE FROM phpgw_expressoadmin_log *;
19DELETE FROM phpgw_history_log *;
20DELETE FROM phpgw_log *;
21DELETE FROM phpgw_log_msg *;
22EOF
23
24# Gera o dump da base do Expresso
25TDUMP="/tmp/$DUMP"
26pg_dump -U postgres -f $TDUMP expresso
27
28sed -e "s/$LDAP_DN/LDAP_DN/g" \
29        -e "s/$ORG/ou=ORG/g" \
30        -e "s/$DOMAIN/DOMAIN/g" \
31        -e "s/$LDAP_PWD/LDAP_PWD/g" $TDUMP > $DUMP
32
Note: See TracBrowser for help on using the repository browser.