OpenPKG CVS Repository
  http://cvs.openpkg.org/
  ____________________________________________________________________________

  Server: cvs.openpkg.org                  Name:   Ralf S. Engelschall
  Root:   /v/openpkg/cvs                   Email:  [EMAIL PROTECTED]
  Module: openpkg-src                      Date:   06-Sep-2007 15:30:27
  Branch: HEAD                             Handle: 2007090614302700

  Modified files:
    openpkg-src/dbmail      dbmail-setup.sh

  Log:
    I'm not 100% sure (because the DBMail vendor docs are unclear) but it
    really looks (dbmail.conf) that DBMail is expecting the database in
    UTF-8 format, so create the PostgreSQL database with this encoding,
    too

  Summary:
    Revision    Changes     Path
    1.12        +1  -1      openpkg-src/dbmail/dbmail-setup.sh
  ____________________________________________________________________________

  patch -p0 <<'@@ .'
  Index: openpkg-src/dbmail/dbmail-setup.sh
  ============================================================================
  $ cvs diff -u -r1.11 -r1.12 dbmail-setup.sh
  --- openpkg-src/dbmail/dbmail-setup.sh        6 Sep 2007 09:58:37 -0000       
1.11
  +++ openpkg-src/dbmail/dbmail-setup.sh        6 Sep 2007 13:30:27 -0000       
1.12
  @@ -68,7 +68,7 @@
           elif [ ".$db_type" = .pgsql ]; then
               ( echo "CREATE ROLE $db_user LOGIN ENCRYPTED PASSWORD '$db_pass' 
NOCREATEDB NOCREATEUSER;"
                 echo "CREATE TABLESPACE $db_name OWNER $db_user LOCATION 
'$db_dir';"
  -              echo "CREATE DATABASE $db_name OWNER $db_user TABLESPACE 
$db_name;"
  +              echo "CREATE DATABASE $db_name OWNER $db_user TABLESPACE 
$db_name ENCODING 'UTF8';"
               ) | PGPASSWORD="$db_spass" @l_prefix@/bin/psql -q -U "$db_suser" 
-d "$db_sname" -f-
               PGPASSWORD="$db_pass" @l_prefix@/bin/psql -q -U "$db_user" -d 
"$db_name" -f- <$db_script
           fi
  @@ .
______________________________________________________________________
OpenPKG                                             http://openpkg.org
CVS Repository Commit List                     [email protected]

Reply via email to