~ubuntu-branches/ubuntu/intrepid/otrs2/intrepid-updates

« back to all changes in this revision

Viewing changes to debian/postgresql-setup.sh

• browse files at revision 2
• compare with another revision
• download diff
• download tarball
• view history from revision 2

Show diffs side-by-side

added

removed

debian/postgresql-setup.sh

 

1

#!/bin/sh

 

2

# Adopted from Phil Endecott <spam-from-debian-bugs@chezphil.org>

 

3

# who suggested this script in http://bugs.debian.org/272113

 

4

 

 

5

echo "Please note: This is just an example how to setup OTRS with PostgreSQL."

 

6

echo "Do not execute it blindly."

 

7

exit

 

8

 

 

9

# Become postgres user

 

10

su postgres

 

11

# Create necessary user and Database

 

12

createuser -A -D -P otrs

 

13

createdb -O otrs -E latin1 otrs 

 

14

# Now become root again

 

15

exit

 

16

 

 

17

# allow otrs user to log in

 

18

# It is the best way to under Debian for authentication to PostgreSQL if the

 

19

# system user is equal to the PostgreSQL user

 

20

su -s /bin/sh otrs

 

21

 

 

22

# Initialize the necessary databases

 

23

psql -d otrs -f /usr/share/otrs/scripts/database/otrs-schema.postgresql.sql

 

24

psql -d otrs -f /usr/share/otrs/scripts/database/initial_insert.sql

 

25

exit

 

26

 

 

27

cat <<...

 

28

You should edit the database user and password in /etc/otrs/Kernel/Config.pm

 

29

...

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1