[Top][All Lists]
[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