[CB-lug] configurare postgres

angelo morrone angelomorr@gmail.com
Dom 14 Ott 2007 20:25:09 CEST


ciao ho avuto problema con l'invio dell'email di prima ho provato a spedirla
intera un paio di volte dopo di che lo spezzettata in più parti. Perché il
vostro server non accettava la mia email?

comunque:
ifconfig
dsl0      Link encap:Point-to-Point Protocol
          inet addr:87.11.176.21  P-t-P:192.168.100.1  Mask:255.255.255.255
          UP POINTOPOINT RUNNING NOARP MULTICAST  MTU:1492  Metric:1
          RX packets:530 errors:0 dropped:0 overruns:0 frame:0
          TX packets:452 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:3
          RX bytes:344574 (336.4 Kb)  TX bytes:143804 (140.4 Kb)

eth0      Link encap:Ethernet  HWaddr 00:19:21:4B:CF:5D
          inet addr:192.168.1.14  Bcast:255.255.255.255  Mask:
255.255.255.224
          inet6 addr: fe80::219:21ff:fe4b:cf5d/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:2244 errors:0 dropped:0 overruns:0 frame:0
          TX packets:1451 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:2426293 (2.3 Mb)  TX bytes:234174 (228.6 Kb)
          Interrupt:16

lo        Link encap:Local Loopback
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:50 errors:0 dropped:0 overruns:0 frame:0
          TX packets:50 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:3116 (3.0 Kb)  TX bytes:3116 (3.0 Kb)
hostname
linux-suse

Riguardo al server postgrsql lo avvio normalmente /etc/init.d/postgresql
start
Starting PostgreSQLcould not start server
                                                                      failed
[1]+  Done                    gedit /var/lib/pgsql/data/pg_hba.conf

mi da errore provo con /etc/init.d/postgresql status
Checking for PostgreSQL:
running

bo è strano


2007/10/14, Francesco Steno < overdrive@linux.it>:
>
>
> Il giorno 14/ott/07, alle ore 14:46, angelo morrone ha scritto:
>
> > avvio su postgres /install_db.sh
> >
> > psql: impossibile connettersi al server: Connessione rifiutata
> >         Controllare che il server all'indirizzo "linux-suse" sia in
> > funzione
> >         e che accetti connessioni TCP/IP sulla porta 5432?
>
>
> [cut]
>
> mi mandi l'output di:
>
> ifconfig
>
> e del comando:
>
> hostname
>
> ??
> grazie
>
> > dopo un po di prove ho scoperto che posgresql è sempre in esecuzione
>
> puoi essere piu' preciso ?
> cosa ti fa pensare che sia sempre in esecuzione?
> se stoppi il server, non ottieni il risultato voluto ???
>
> >
> > cosi ho continuato a provare e riprovare per far funzionare promogest
> > cosi apro gedit conf.sh
> > #!/bin/sh
> >
> > # Temporary directory
> > TMP=/tmp
> > CAT=/bin/cat
> > # Postgres createlang command
> > CREATELANG=/usr/bin/createlang
> > # Postgres client sql
> > PSQL=/usr/bin/psql
> > # Default database user
> > DB_USER=promoadmin
> > # Default user password
> > DB_PASS=admin
> > # user "postgres" password
> > ADMIN_PASSWORD=
> > # Database server address
> > DB_HOST=linux-suse
> > # Database name
> > DB_NAME=promogest_nightly
> >
> > poi apro gedit /var/lib/pgsql/data/pg_hba.conf
> >
> > # PostgreSQL Client Authentication Configuration File
> > # ===================================================
> > #
> > # Refer to the "Client Authentication" section in the
> > # PostgreSQL documentation for a complete description
> > # of this file.  A short synopsis follows.
> > #
> > # This file controls: which hosts are allowed to connect, how clients
> > # are authenticated, which PostgreSQL user names they can use, which
> > # databases they can access.  Records take one of these forms:
>
>
> [cut]
>
> inserisci in questo file, la seguente riga:
>
> linux-suse promogest_nightly promoadmin 192.168.1.14/32 trust
>
> > #
> > # local      DATABASE  USER  METHOD  [OPTION]
> >
> >  linux-suse promogest_nightly promoadmin 192.168.1.14
> > 255.255.255.254 trust
>
> cancella questa riga (questa sopra :)  )
>
>
> >
> > # host       DATABASE  USER  CIDR-ADDRESS  METHOD  [OPTION]
> > # hostssl    DATABASE  USER  CIDR-ADDRESS  METHOD  [OPTION]
> > # hostnossl  DATABASE  USER  CIDR-ADDRESS  METHOD  [OPTION]
> > #
> > # (The uppercase items must be replaced by actual values.)
> > #
> > # The first field is the connection type: "local" is a Unix-domain
> > socket,
> > # "host" is either a plain or SSL-encrypted TCP/IP socket,
> > "hostssl" is an
> > # SSL-encrypted TCP/IP socket, and "hostnossl" is a plain TCP/IP
> > socket.
> > #
> > # DATABASE can be "all", "sameuser", "samerole", a database name, or
> > # a comma-separated list thereof.
> > #
> > # USER can be "all", a user name, a group name prefixed with "+", or
> > # a comma-separated list thereof.  In both the DATABASE and USER
> > fields
> > # you can also write a file name prefixed with "@" to include names
> > from
> > # a separate file.
> > #
> > # CIDR-ADDRESS specifies the set of hosts the record matches.
> > # It is made up of an IP address and a CIDR mask that is an integer
> > # (between 0 and 32 (IPv4) or 128 (IPv6) inclusive) that specifies
> > # the number of significant bits in the mask.  Alternatively, you
> > can write
> > # an IP address and netmask in separate columns to specify the set
> > of hosts.
> > #
> > # METHOD can be "trust", "reject", "md5", "crypt", "password",
> > # "krb5", "ident", "pam" or "ldap".  Note that "password" sends
> > passwords
> > # in clear text; "md5" is preferred since it sends encrypted
> > passwords.
> > #
> > # OPTION is the ident map or the name of the PAM service, depending
> > on METHOD.
> > #
> > # Database and user names containing spaces, commas, quotes and
> > other special
> > # characters must be quoted. Quoting one of the keywords "all",
> > "sameuser" or
> > # "samerole" makes the name lose its special character, and just
> > match a
> > # database or username with that name.
> > #
> > # This file is read on server startup and when the postmaster receives
> > # a SIGHUP signal.  If you edit the file on a running system, you have
> > # to SIGHUP the postmaster for the changes to take effect.  You can
> > use
> > # "pg_ctl reload" to do that.
> >
> > # Put your actual configuration here
> > # ----------------------------------
> > #
> > # If you want to allow non-local connections, you need to add more
> > # "host" records. In that case you will also need to make
> > PostgreSQL listen
> > # on a non-local interface via the listen_addresses configuration
> > parameter,
> > # or via the -i or -h command line switches.
> > #
> >
> >
> >
> > # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
> >
> > # "local" is for Unix domain socket connections only
> > local   all         all                               ident sameuser
>
> queta riga commentala (aggiungendo un # )
>
> > # IPv4 local connections:
> > host    all         all         127.0.0.1/32          ident sameuser
>
> commenta anche questa
>
> > # IPv6 local connections:
> > host    all         all         ::1/128               ident sameuser
>
> e questa
>
> >
> >  # PostgreSQL Client Authentication Configuration File
> > # ===================================================
>
> questo cose' ? un altro file ???
> oppure la continua? del precedente ???
>
>
> > # Refer to the "Client Authentication" section in the
> > # PostgreSQL documentation for a complete description
> > # of this file.  A short synopsis follows.
>
> [cut]
> ....
>
>
> sostituisci la riga che ti ho detto.
>
> riavvia il server
> e lancia l'installer.
>
>
> Saluti
>         Francesco Steno aka "oVERDRIVE"
>
>
>
>
> --
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-generated by /dev/over-=-=-=-=-=-=-=-=-=-=
>                                   oVERDRIVE
> <overdrive@OpenGeeks.it>< overdrive@BitchX.it><overdrive@Linux.it>
>               GnuPG Public Key: http://cb.linux.it/lug/key/overdrive.asc
>   Key Fingerprint: 146A E13D 9E68 3B96 40FB  11F5 9A10 2D1F 3973 C203
>
>
>
> --
> Mailing list info: http://lists.linux.it/listinfo/lugcb
>
-------------- parte successiva --------------
Un allegato HTML è stato rimosso...
URL: http://lists.linux.it/pipermail/lugcb/attachments/20071014/e57dab22/attachment-0001.htm 


Maggiori informazioni sulla lista Lugcb