gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] bootstrap error on Mandriva 2010 - solved


From: Sebastian Hilbert
Subject: Re: [Gnumed-devel] bootstrap error on Mandriva 2010 - solved
Date: Sun, 25 Jul 2010 17:14:08 +0200
User-agent: KMail/1.13.3 (Linux/2.6.33-6-desktop; KDE/4.4.5; i686; ; )

Am Sonntag 25 Juli 2010, 17:03:53 schrieb Michael Schütt:
> Am 25.07.2010 16:19, schrieb Sebastian Hilbert:
> >> address@hidden Gnumed]# ./gm-bootstrap_server
> >> psql: konnte nicht mit dem Server verbinden: Datei oder Verzeichnis
> >> nicht gefunden
> >> 
> >>    Läuft der Server lokal und akzeptiert er Verbindungen
> >>    auf dem Unix-Domain-Socket »/tmp/.s.PGSQL.5432«?
> > 
> > gm-bootstrap is still tryin port 5432.
> > 
> > You have a few options.
> > 
> > Go to bootstrap-latest.sh
> > uncomment the line #export GM_DB_PORT="5433"
> 
> I set the port before and I'm confused about the errormessage.
>

It is using port 5433 as per the log. Karsten can hopefully comment on that.
 
> 
> ....
> 
> > See above. Ah. Your log indicated you already set the port to 5433.
> 
> yes.
> 
> > Can your provide the output of
> > 
> > psql -l
> > 
> > (as user postgres)
> > 
> > This will show us what encoding the clusters have I guess.
> 
> here it is:
> address@hidden server]# su postgres
> address@hidden server]$ psql -l
>                               List of databases
>    Name    |  Owner   | Encoding  | Collation | Ctype |   Access
> privileges
> -----------+----------+-----------+-----------+-------+--------------------
> --- postgres  | postgres | SQL_ASCII | C         | C     |
>  template0 | postgres | SQL_ASCII | C         | C     | =c/postgres
> 
> postgres=CTc/postgres
>  template1 | postgres | SQL_ASCII | C         | C     | =c/postgres
> 
> postgres=CTc/postgres
> (3 rows)
> 

This basically show that all clusters are SQL_ASCII.

Here is what is my output of psql -l

                                  Liste der Datenbanken
    Name    | Eigentümer | Kodierung | Sortierfolge | Zeichentyp  |    
Zugriffsrechte     
------------+------------+-----------+--------------+-------------+-----------------------
 gnumed_v12 | gm-dbo     | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 | 
 gnumed_v13 | gm-dbo     | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 | 
 gnumed_v14 | gm-dbo     | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 | 
 gnumed_v2  | gm-dbo     | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 | 
 postgres   | postgres   | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 | 
 template0  | postgres   | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 | 
=c/postgres
                                                                  : 
postgres=CTc/postgres
 template1  | postgres   | UTF8      | de_DE.UTF-8  | de_DE.UTF-8 | 
=c/postgres
                                                                  : 
postgres=CTc/postgres
(8 Zeilen)

Unless you get encoding utf8 bootstraping will fail.

> address@hidden server]$
> 
> > This is in the log
> > 
> >> password not defined, assuming connect via IDENT/TRUST
> > 
> > Please supply the file pg_hba.conf (in private if you have sensitive
> > information in there)
> 
> And the pg_hba.conf:
> address@hidden data1]# cat /var/lib/pgsql/data1/pg_hba.conf
> 
> # PostgreSQL Client Authentication Configuration File
> # ===================================================
> #
> ...
> ##### only a lot of comments
> ...
> #
> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
> 
> # "local" is for Unix domain socket connections only
> local   all         all                               trust
> # IPv4 local connections:
> host    all         all         127.0.0.1/32          trust
> # IPv6 local connections:
> host    all         all         ::1/128               trust
> address@hidden data1]#

Karsten will have to comment on that section.

I recommend you try to go through the instructions one more time and see if 
you can create an utf8 cluster.

Sebastian



reply via email to

[Prev in Thread] Current Thread [Next in Thread]