Ad Widget

Collapse

Zabbix + CentOS + PostgreSQL не коннектится Веб к БД.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Dev_LC
    Member
    • Feb 2011
    • 64

    #1

    Zabbix + CentOS + PostgreSQL не коннектится Веб к БД.

    Доброго времени суток.

    Не получается соединиться с базой данных Postgress во время настройки Вэб интерфейса. Error connecting to database.

    Please create database manually,
    and set the configuration parameters for connection to this database.

    Press "Test connection" button when done.


    Type PostgreSQL
    Host localhost
    Port 5432
    Name zabbix
    User zabuser
    Password *****


    Test = fail.


    хотя телнетом я соединяюсь по порту без проблем. сам сервер в логах вроде тоже проблем не пишет.
    psql -U zabuser zabbix - после ввода пароля в базу попадаю.
    также пробовал в настройках веба прописать пользователя рута БД (postgres) и его пароль - также fail.
    В чем может быть дело ?
  • dima_dm
    Senior Member
    • Dec 2009
    • 2697

    #2
    базу создали?
    http://www.zabbix.com/documentation/...on_from_source
    Для PostgreSQL:
    shell> psql -U <username>
    psql> create database zabbix;
    psql> \q
    shell> cd create/schema
    shell> cat postgresql.sql | psql -U <username> zabbix
    shell> cd ../data
    shell> cat data.sql | psql -U <username> zabbix
    shell> cat images_pgsql.sql | psql -U <username> zabbix

    Comment

    • Dev_LC
      Member
      • Feb 2011
      • 64

      #3
      Originally posted by dima_dm
      базу создали?
      http://www.zabbix.com/documentation/...on_from_source
      Для PostgreSQL:
      shell> psql -U <username>
      psql> create database zabbix;
      psql> \q
      shell> cd create/schema
      shell> cat postgresql.sql | psql -U <username> zabbix
      shell> cd ../data
      shell> cat data.sql | psql -U <username> zabbix
      shell> cat images_pgsql.sql | psql -U <username> zabbix
      да, базу сделал. все вроде без ошибок прошло. в случае с FreeBSD + MySQL проблем совсем не возникало.
      Из-за предполагаемых больших размеров базы решили выбрать centos+postgres
      Last edited by Dev_LC; 11-02-2011, 20:24.

      Comment

      • Dev_LC
        Member
        • Feb 2011
        • 64

        #4

        ....
        WARNING: nonstandard use of \\ in a string literal at character 64
        HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
        WARNING: nonstandard use of \\ in a string literal at character 68
        HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
        WARNING: nonstandard use of \\ in a string literal at character 68
        HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
        WARNING: nonstandard use of \\ in a string literal at character 71
        HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
        WARNING: nonstandard use of \\ in a string literal at character 80
        HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
        WARNING: nonstandard use of \\ in a string literal at character 81
        HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
        WARNING: nonstandard use of \\ in a string literal at character 84
        HINT: Use the escape string syntax for backslashes, e.g., E'\\'.


        вот это в логе /var/lib/pgsql/data/pg_log/postgresql-Fri.log
        после добавления базы скриптами. Насколько нормально - незнаю.

        Comment

        • ugh
          Senior Member
          • Jun 2009
          • 296

          #5
          Originally posted by Dev_LC
          Из-за предполагаемых больших размеров базы решили выбрать centos+postgres
          если не секрет, какой ожидаете эффект по сравнению фря+mysql, и почему?

          Comment

          • Dev_LC
            Member
            • Feb 2011
            • 64

            #6
            Originally posted by ugh
            если не секрет, какой ожидаете эффект по сравнению фря+mysql, и почему?
            postgres может держать в себе больший объем данных по сравнению с сикуэлом и не захлебываться. на счет линукса - вычитал на форумах что фря+забикс бывает беспричинно вываливается, так что заодно и линукс переставил.

            Comment

            • Dev_LC
              Member
              • Feb 2011
              • 64

              #7
              Вот список всех проинсталленых пакетов

              Installed Packages
              Deployment_Guide-ru-RU.noarch 5.2-11.el5.centos installed
              GConf2.i386 2.14.0-9.el5 installed
              MAKEDEV.i386 3.23-1.2 installed
              NetworkManager.i386 1:0.7.0-10.el5_5.2 installed
              NetworkManager-glib.i386 1:0.7.0-10.el5_5.2 installed
              ORBit2.i386 2.14.3-5.el5 installed
              OpenIPMI-libs.i386 2.0.16-7.el5 installed
              SysVinit.i386 2.86-15.el5 installed
              acl.i386 2.2.39-6.el5 installed
              acpid.i386 1.0.4-9.el5_4.2 installed
              amtu.i386 1.0.6-1.el5 installed
              anacron.i386 2.3-45.el5.centos installed
              apmd.i386 1:3.2.2-5 installed
              apr.i386 1.2.7-11.el5_5.3 installed
              apr-util.i386 1.2.7-11.el5_5.2 installed
              aspell.i386 12:0.60.3-7.1 installed
              aspell-en.i386 50:6.0-2.1 installed
              aspell-ru.i386 50:0.99f7-2.2.2 installed
              at.i386 3.1.8-84.el5 installed
              atk.i386 1.12.2-1.fc6 installed
              attr.i386 2.4.32-1.1 installed
              audit.i386 1.7.17-3.el5 installed
              audit-libs.i386 1.7.17-3.el5 installed
              audit-libs-python.i386 1.7.17-3.el5 installed
              authconfig.i386 5.3.21-6.el5 installed
              autofs.i386 1:5.0.1-0.rc2.143.el5_5.6 installed
              avahi.i386 0.6.16-9.el5_5 installed
              avahi-compat-libdns_sd.i386 0.6.16-9.el5_5 installed
              basesystem.noarch 8.0-5.1.1.el5.centos installed
              bash.i386 3.2-24.el5 installed
              bc.i386 1.06-21 installed
              bind-libs.i386 30:9.3.6-4.P1.el5_5.3 installed
              bind-utils.i386 30:9.3.6-4.P1.el5_5.3 installed
              binutils.i386 2.17.50.0.6-14.el5 installed
              bitstream-vera-fonts.noarch 1.10-7 installed
              bluez-gnome.i386 0.5-5.fc6 installed
              bluez-libs.i386 3.7-1.1 installed
              bluez-utils.i386 3.7-2.2.el5.centos installed
              bzip2.i386 1.0.3-6.el5_5 installed
              bzip2-libs.i386 1.0.3-6.el5_5 installed
              cadaver.i386 0.22.3-4.el5 installed
              cairo.i386 1.2.4-5.el5 installed
              ccid.i386 1.3.8-1.el5 installed
              centnixtime-release.noarch 5-5.el5 installed
              centos-release.i386 10:5-5.el5.centos installed
              centos-release-notes.i386 5.5-0 installed
              checkpolicy.i386 1.33.1-6.el5 installed
              chkconfig.i386 1.3.30.2-2.el5 installed
              chkfontpath.i386 1.10.1-1.1 installed
              conman.i386 0.1.9.2-8.el5 installed
              coolkey.i386 1.1.0-14.el5 installed
              coreutils.i386 5.97-23.el5_4.2 installed
              cpio.i386 2.6-23.el5_4.1 installed
              cpuspeed.i386 1:1.2.1-9.el5 installed
              cracklib.i386 2.8.9-3.3 installed
              cracklib-dicts.i386 2.8.9-3.3 installed
              crash.i386 4.1.2-4.el5.centos.1 installed
              crontabs.noarch 1.10-8 installed
              cryptsetup-luks.i386 1.0.3-5.el5 installed
              cups.i386 1:1.3.7-18.el5_5.8 installed
              cups-libs.i386 1:1.3.7-18.el5_5.8 installed
              curl.i386 7.15.5-9.el5 installed
              cyrus-sasl.i386 2.1.22-5.el5_4.3 installed
              cyrus-sasl-lib.i386 2.1.22-5.el5_4.3 installed
              cyrus-sasl-plain.i386 2.1.22-5.el5_4.3 installed
              db4.i386 4.3.29-10.el5_5.2 installed
              dbus.i386 1.1.2-14.el5 installed
              dbus-glib.i386 0.73-10.el5_5 installed
              dbus-libs.i386 1.1.2-14.el5 installed
              dbus-python.i386 0.70-9.el5_4 installed
              desktop-file-utils.i386 0.10-7 installed
              device-mapper.i386 1.02.39-1.el5_5.2 installed
              device-mapper-event.i386 1.02.39-1.el5_5.2 installed
              device-mapper-multipath.i386 0.4.7-34.el5_5.6 installed
              dhclient.i386 12:3.0.5-23.el5_5.2 installed
              dhcpv6-client.i386 1.0.10-18.el5 installed
              diffutils.i386 2.8.1-15.2.3.el5 installed
              dmidecode.i386 1:2.10-3.el5 installed
              dmraid.i386 1.0.0.rc13-63.el5 installed
              dmraid-events.i386 1.0.0.rc13-63.el5 installed
              dnsmasq.i386 2.45-1.1.el5_3 installed
              dos2unix.i386 3.1-27.2.el5 installed
              dosfstools.i386 2.11-9.el5 installed
              dump.i386 0.4b41-4.el5 installed
              e2fsprogs.i386 1.39-23.el5_5.1 installed
              e2fsprogs-libs.i386 1.39-23.el5_5.1 installed
              ecryptfs-utils.i386 75-5.el5 installed
              ed.i386 0.2-39.el5_2 installed
              eject.i386 2.1.5-4.2.el5 installed
              elfutils-libelf.i386 0.137-3.el5 installed
              elinks.i386 0.11.1-6.el5_4.1 installed
              epel-release.noarch 5-4 installed
              ethtool.i386 6-4.el5 installed
              expat.i386 1.95.8-8.3.el5_5.3 installed
              fbset.i386 2.1-22 installed
              fetchmail.i386 6.3.6-1.1.el5_3.1 installed
              file.i386 4.17-15.el5_3.1 installed
              filesystem.i386 2.4.0-3.el5 installed
              findutils.i386 1:4.2.27-6.el5 installed
              finger.i386 0.17-32.2.1.1 installed
              fipscheck.i386 1.2.0-1.el5 installed
              fipscheck-lib.i386 1.2.0-1.el5 installed
              firstboot-tui.i386 1.4.27.8-1.el5.centos installed
              fontconfig.i386 2.4.1-7.el5 installed
              fonts-KOI8-R.noarch 1.0-9.1.1 installed
              fonts-KOI8-R-100dpi.noarch 1.0-9.1.1 installed
              fonts-KOI8-R-75dpi.noarch 1.0-9.1.1 installed
              fping.i386 2.4-1.b2.2.el5.rf installed
              freetype.i386 2.2.1-28.el5_5.1 installed
              ftp.i386 0.17-35.el5 installed
              gamin.i386 0.1.7-8.el5 installed
              gamin-python.i386 0.1.7-8.el5 installed
              gawk.i386 3.1.5-14.el5 installed
              gdbm.i386 1.8.0-26.2.1 installed
              gettext.i386 0.14.6-4.el5 installed
              glib2.i386 2.12.3-4.el5_3.1 installed
              glibc.i686 2.5-49.el5_5.7 installed
              glibc-common.i386 2.5-49.el5_5.7 installed
              gmp.i386 4.1.4-10.el5 installed
              gnu-efi.i386 3.0c-1.1 installed
              gnupg.i386 1.4.5-14.el5_5.1 installed
              gnutls.i386 1.4.1-3.el5_4.8 installed
              gpm.i386 1.20.1-74.1 installed
              grep.i386 2.5.1-55.el5 installed
              groff.i386 1.18.1.1-11.1 installed
              grub.i386 0.97-13.5 installed
              gtk2.i386 2.10.4-21.el5_5.6 installed
              gzip.i386 1.3.5-11.el5.centos.1 installed
              hal.i386 0.5.8.1-59.el5 installed
              hdparm.i386 6.6-2 installed
              hesiod.i386 3.1.0-8 installed
              hicolor-icon-theme.noarch 0.9-2.1 installed
              hmaccalc.i386 0.9.6-3.el5 installed
              htmlview.noarch 4.0.0-2.el5 installed
              httpd.i386 2.2.3-43.el5.centos.3 installed
              hwdata.noarch 0.213.18-1.el5.1 installed
              ibmasm.i386 3.0-9 installed
              ifd-egate.i386 0.05-15 installed
              iksemel.i386 1.2-14.el5 installed
              info.i386 4.8-14.el5 installed
              initscripts.i386 8.45.30-3.el5.centos installed
              iproute.i386 2.6.18-11.el5 installed
              ipsec-tools.i386 0.6.5-14.el5_5.5 installed
              iptables.i386 1.3.5-5.3.el5_4.1 installed
              iptables-ipv6.i386 1.3.5-5.3.el5_4.1 installed
              iptstate.i386 1.4-2.el5 installed
              iputils.i386 20020927-46.el5 installed
              irda-utils.i386 0.9.17-2.fc6 installed
              irqbalance.i386 2:0.55-15.el5 installed
              isdn4k-utils.i386 3.2-56.el5 installed
              jwhois.i386 3.2.3-8.el5 installed
              kbd.i386 1.12-21.el5 installed
              kernel.i686 2.6.18-194.el5 installed
              kernel.i686 2.6.18-194.32.1.el5 installed
              keyutils.i386 1.2-1.el5 installed
              keyutils-libs.i386 1.2-1.el5 installed
              kpartx.i386 0.4.7-34.el5_5.6 installed
              krb5-libs.i386 1.6.1-36.el5_5.6 installed
              krb5-workstation.i386 1.6.1-36.el5_5.6 installed
              ksh.i386 20100202-1.el5_5.1 installed
              kudzu.i386 1.2.57.1.24-1.el5.centos installed
              less.i386 436-2.el5 installed
              lftp.i386 3.7.11-4.el5_5.3 installed
              libFS.i386 1.0.0-3.1 installed
              libICE.i386 1.0.1-2.1 installed
              libIDL.i386 0.8.7-1.fc6 installed
              libSM.i386 1.0.1-3.1 installed
              libX11.i386 1.0.3-11.el5 installed
              libXau.i386 1.0.1-3.1 installed
              libXaw.i386 1.0.2-8.1 installed
              libXcursor.i386 1.1.7-1.1 installed
              libXdmcp.i386 1.0.1-2.1 installed
              libXext.i386 1.0.1-2.1 installed
              libXfixes.i386 4.0.1-2.1 installed
              libXfont.i386 1.2.2-1.0.3.el5_1 installed
              libXft.i386 2.1.10-1.1 installed
              libXi.i386 1.0.1-4.el5_4 installed
              libXinerama.i386 1.0.1-2.1 installed
              libXmu.i386 1.0.2-5 installed
              libXpm.i386 3.5.5-3 installed
              libXrandr.i386 1.1.1-3.3 installed
              libXrender.i386 0.9.1-3.1 installed
              libXres.i386 1.0.1-3.1 installed
              libXt.i386 1.0.2-3.2.el5 installed
              libXxf86vm.i386 1.0.1-3.1 installed
              libacl.i386 2.2.39-6.el5 installed
              libaio.i386 0.3.106-5 installed
              libattr.i386 2.4.32-1.1 installed
              libcap.i386 1.10-26 installed
              libdaemon.i386 0.10-5.el5 installed
              libdrm.i386 2.0.2-1.1 installed
              libedit.i386 2.11-2.20080712cvs.el5 installed
              libevent.i386 1.4.13-1 installed
              libfontenc.i386 1.0.2-2.2.el5 installed
              libgcc.i386 4.1.2-48.el5 installed
              libgcrypt.i386 1.4.4-5.el5 installed
              libgpg-error.i386 1.4-2 installed
              libgssapi.i386 0.10-2 installed
              libhugetlbfs.i386 1.3-7.el5 installed
              libidn.i386 0.6.5-1.1 installed
              libjpeg.i386 6b-37 installed
              libnotify.i386 0.4.2-6.el5 installed
              libpcap.i386 14:0.9.4-15.el5 installed
              libpng.i386 2:1.2.10-7.1.el5_5.3 installed
              libselinux.i386 1.33.4-5.5.el5 installed
              libselinux-python.i386 1.33.4-5.5.el5 installed
              libselinux-utils.i386 1.33.4-5.5.el5 installed
              libsemanage.i386 1.9.1-4.4.el5 installed
              libsepol.i386 1.15.2-3.el5 installed
              libstdc++.i386 4.1.2-48.el5 installed
              libsysfs.i386 2.0.0-6 installed
              libtermcap.i386 2.0.8-46.1 installed
              libtiff.i386 3.8.2-7.el5_5.5 installed
              libusb.i386 0.1.12-5.1 installed
              libuser.i386 0.54.7-2.1.el5_4.1 installed
              libutempter.i386 1.1.4-4.el5 installed
              libvolume_id.i386 095-14.21.el5_5.1 installed
              libwnck.i386 2.16.0-4.fc6 installed
              libwvstreams.i386 4.2.2-2.1 installed
              libxml2.i386 2.6.26-2.1.2.8.el5_5.1 installed
              libxml2-python.i386 2.6.26-2.1.2.8.el5_5.1 installed
              libxslt.i386 1.1.17-2.el5_2.2 installed
              lm_sensors.i386 2.10.7-9.el5 installed
              lockdev.i386 1.0.1-10 installed
              logrotate.i386 3.7.4-9.el5_5.2 installed
              logwatch.noarch 7.3-8.el5 installed
              lrzsz.i386 0.12.20-22.1 installed
              lsof.i386 4.78-3 installed
              lvm2.i386 2.02.56-8.el5_5.6 installed
              m2crypto.i386 0.16-6.el5.6 installed
              m4.i386 1.4.5-3.el5.1 installed
              mailcap.noarch 2.1.23-1.fc6 installed
              mailx.i386 8.1.1-44.2.2 installed
              make.i386 1:3.81-3.el5 installed
              man.i386 1.6d-1.1 installed
              man-pages.noarch 2.39-15.el5_4 installed
              man-pages-ru.noarch 0.97-1.1.1 installed
              mcstrans.i386 0.2.11-3.el5 installed
              mdadm.i386 2.6.9-3.el5 installed
              mesa-libGL.i386 6.5.1-7.8.el5 installed
              mgetty.i386 1.1.33-9.fc6 installed
              microcode_ctl.i386 1:1.17-1.50.el5 installed
              mingetty.i386 1.07-5.2.2 installed
              minicom.i386 2.1-3 installed
              mkbootdisk.i386 1.5.3-2.1 installed
              mkinitrd.i386 5.1.19.6-61.el5_5.2 installed
              mktemp.i386 3:1.5-23.2.2 installed
              mlocate.i386 0.15-1.el5.2 installed
              module-init-tools.i386 3.3-0.pre3.1.60.el5_5.1 installed
              mtools.i386 3.9.10-2.fc6 installed
              mtr.i386 2:0.71-3.1 installed
              mutt.i386 5:1.4.2.2-3.0.2.el5 installed
              nano.i386 1.3.12-1.1 installed
              nash.i386 5.1.19.6-61.el5_5.2 installed
              nc.i386 1.84-10.fc6 installed
              ncurses.i386 5.5-24.20060715 installed
              neon.i386 0.25.5-10.el5_4.1 installed
              net-snmp.i386 1:5.3.2.2-9.el5_5.1 installed
              net-snmp-libs.i386 1:5.3.2.2-9.el5_5.1 installed
              net-tools.i386 1.60-81.el5 installed
              newt.i386 0.52.2-15.el5 installed
              nfs-utils.i386 1:1.0.9-47.el5_5 installed
              nfs-utils-lib.i386 1.0.8-7.6.el5 installed
              notification-daemon.i386 0.3.5-9.el5 installed
              nscd.i386 2.5-49.el5_5.7 installed
              nspr.i386 4.8.6-1.el5_5 installed
              nss.i386 3.12.8-1.el5.centos installed
              nss-tools.i386 3.12.8-1.el5.centos installed
              nss_db.i386 2.2-35.4.el5_5 installed
              nss_ldap.i386 253-25.el5 installed
              ntsysv.i386 1.3.30.2-2.el5 installed
              numactl.i386 0.9.8-11.el5 installed
              oddjob.i386 0.27-9.el5 installed
              oddjob-libs.i386 0.27-9.el5 installed
              openldap.i386 2.3.43-12.el5_5.3 installed
              openssh.i386 4.3p2-41.el5_5.1 installed
              openssh-clients.i386 4.3p2-41.el5_5.1 installed
              openssh-server.i386 4.3p2-41.el5_5.1 installed
              openssl.i686 0.9.8e-12.el5_5.7 installed
              pam.i386 0.99.6.2-6.el5_5.2 installed
              pam_ccreds.i386 3-5 installed
              pam_krb5.i386 2.2.14-15 installed
              pam_passwdqc.i386 1.0.2-1.2.2 installed
              pam_pkcs11.i386 0.5.3-23 installed
              pam_smb.i386 1.1.7-7.2.1 installed
              pango.i386 1.14.9-8.el5.centos installed
              paps.i386 0.6.6-19.el5 installed
              parted.i386 1.8.1-27.el5 installed
              passwd.i386 0.73-1 installed
              patch.i386 2.5.4-29.2.3.el5 installed
              pax.i386 3.4-2.el5_4 installed
              pciutils.i386 2.2.3-8.el5_4 installed
              pcmciautils.i386 014-5 installed
              pcre.i386 6.6-2.el5_1.7 installed
              pcsc-lite.i386 1.4.4-4.el5_5 installed
              pcsc-lite-libs.i386 1.4.4-4.el5_5 installed
              perl.i386 4:5.8.8-32.el5_5.2 installed
              perl-String-CRC32.i386 1.4-2.fc6 installed
              php.i386 5.3.5-1.el5.remi.1 installed
              php-bcmath.i386 5.3.5-1.el5.remi.1 installed
              php-cli.i386 5.3.5-1.el5.remi.1 installed
              php-common.i386 5.3.5-1.el5.remi.1 installed
              php-gd.i386 5.3.5-1.el5.remi.1 installed
              php-mbstring.i386 5.3.5-1.el5.remi.1 installed
              php-pdo.i386 5.3.5-1.el5.remi.1 installed
              php-pgsql.i386 5.3.5-1.el5.remi.1 installed
              php-xml.i386 5.3.5-1.el5.remi.1 installed
              pinfo.i386 0.6.9-1.fc6 installed
              pkinit-nss.i386 0.7.6-1.el5 installed
              pm-utils.i386 0.99.3-10.el5.centos installed
              policycoreutils.i386 1.33.12-14.8.el5 installed
              poppler.i386 0.5.4-4.4.el5_5.14 installed
              poppler-utils.i386 0.5.4-4.4.el5_5.14 installed
              popt.i386 1.10.2.3-20.el5_5.1 installed
              portmap.i386 4.0-65.2.2.1 installed
              postgresql-libs.i386 8.1.22-1.el5_5.1 installed
              postgresql84.i386 8.4.5-1.el5_5.1 installed
              postgresql84-contrib.i386 8.4.5-1.el5_5.1 installed
              postgresql84-devel.i386 8.4.5-1.el5_5.1 installed
              postgresql84-libs.i386 8.4.5-1.el5_5.1 installed
              postgresql84-server.i386 8.4.5-1.el5_5.1 installed
              ppp.i386 2.4.4-2.el5 installed
              prelink.i386 0.4.0-2.el5 installed
              procmail.i386 3.22-17.1.el5.centos installed
              procps.i386 3.2.7-16.el5 installed
              psacct.i386 6.3.2-44.el5 installed
              psmisc.i386 22.2-7 installed
              pygobject2.i386 2.12.1-5.el5 installed
              python.i386 2.4.3-27.el5_5.3 installed
              python-elementtree.i386 1.2.6-5 installed
              python-iniparse.noarch 0.2.3-4.el5 installed
              python-sqlite.i386 1.1.7-1.2.1 installed
              python-urlgrabber.noarch 3.1.0-5.el5 installed
              quota.i386 1:3.13-1.2.5.el5 installed
              rdate.i386 1.4-8.el5 installed
              rdist.i386 1:6.1.5-44 installed
              readahead.i386 1:1.3-8.el5 installed
              readline.i386 5.1-3.el5 installed
              redhat-logos.noarch 4.9.99-11.el5.centos installed
              redhat-lsb.i386 3.1-12.3.EL.el5.centos installed
              redhat-menus.noarch 6.7.8-3.el5 installed
              remi-release.noarch 5-8.el5.remi installed
              rhpl.i386 0.194.1-1 installed
              rmt.i386 0.4b41-4.el5 installed
              rng-utils.i386 1:2.0-1.14.1.fc6 installed
              rootfiles.noarch 8.1-1.1.1 installed
              rp-pppoe.i386 3.5-32.1 installed
              rpm.i386 4.4.2.3-20.el5_5.1 installed
              rpm-libs.i386 4.4.2.3-20.el5_5.1 installed
              rpm-python.i386 4.4.2.3-20.el5_5.1 installed
              rsh.i386 0.17-40.el5 installed
              rsync.i386 2.6.8-3.1 installed
              sed.i386 4.1.5-5.fc6 installed
              selinux-policy.noarch 2.4.6-279.el5_5.2 installed
              selinux-policy-targeted.noarch 2.4.6-279.el5_5.2 installed
              sendmail.i386 8.13.8-8.el5 installed
              setarch.i386 2.0-1.1 installed
              setools.i386 3.0-3.el5 installed
              setserial.i386 2.17-19.2.2 installed
              setup.noarch 2.5.58-7.el5 installed
              setuptool.i386 1.19.2-1.el5.centos installed
              sgpio.i386 1.2.0_10-2.el5 installed
              shadow-utils.i386 2:4.0.17-15.el5 installed
              slang.i386 2.0.6-4.el5 installed
              slrn.i386 0.9.8.1pl1-1.2.2 installed
              smartmontools.i386 1:5.38-2.el5 installed
              sos.noarch 1.7-9.49.el5 installed
              specspo.noarch 13-1.el5.centos installed
              sqlite.i386 3.3.6-5 installed
              startup-notification.i386 0.8-4.1 installed
              stunnel.i386 4.15-2.el5.1 installed
              sudo.i386 1.7.2p1-9.el5_5 installed
              symlinks.i386 1.2-24.2.2 installed
              sysfsutils.i386 2.0.0-6 installed
              sysklogd.i386 1.4.1-46.el5 installed
              syslinux.i386 3.11-4 installed
              system-config-network-tui.noarch 1.3.99.18-1.el5 installed
              system-config-securitylevel-tui.i386 1.6.29.1-5.el5 installed
              t1lib.i386 5.1.1-7.el5 installed
              talk.i386 0.17-29.2.2 installed
              tar.i386 2:1.15.1-30.el5 installed
              tcl.i386 8.4.13-4.el5 installed
              tcp_wrappers.i386 7.6-40.7.el5 installed
              tcpdump.i386 14:3.9.4-15.el5 installed
              tcsh.i386 6.14-17.el5_5.2 installed
              telnet.i386 1:0.17-39.el5 installed
              termcap.noarch 1:5.5-1.20060701.1 installed
              time.i386 1.7-27.2.2 installed
              tmpwatch.i386 2.9.7-1.1.el5.2 installed
              traceroute.i386 3:2.0.1-5.el5 installed
              tree.i386 1.5.0-4 installed
              trousers.i386 0.3.1-4.el5 installed
              ttmkfdir.i386 3.0.9-23.el5 installed
              tzdata.i386 2010l-1.el5 installed
              udev.i386 095-14.21.el5_5.1 installed
              udftools.i386 1.0.0b3-0.1.el5 installed
              unix2dos.i386 2.2-26.2.3.el5 installed
              unixODBC.i386 2.2.11-7.1 installed
              unzip.i386 5.52-3.el5 installed
              usbutils.i386 0.71-2.1 installed
              usermode.i386 1.88-3.el5.2 installed
              util-linux.i386 2.13-0.52.el5_4.1 installed
              vconfig.i386 1.9-3 installed
              vim-common.i386 2:7.0.109-6.el5 installed
              vim-enhanced.i386 2:7.0.109-6.el5 installed
              vim-minimal.i386 2:7.0.109-6.el5 installed
              vixie-cron.i386 4:4.1-77.el5_4.1 installed
              wget.i386 1.11.4-2.el5_4.1 installed
              which.i386 2.16-7 installed
              wireless-tools.i386 1:28-2.el5 installed
              words.noarch 3.0-9.1 installed
              wpa_supplicant.i386 1:0.5.10-9.el5 installed
              wvdial.i386 1.54.0-5.2.2.1 installed
              xorg-x11-filesystem.noarch 7.1-2.fc6 installed
              xorg-x11-font-utils.i386 1:7.1-2 installed
              xorg-x11-xfs.i386 1:1.0.2-4 installed
              yp-tools.i386 2.9-1.el5 installed
              ypbind.i386 3:1.19-12.el5 installed
              yum.noarch 3.2.22-26.el5.centos installed
              yum-fastestmirror.noarch 1.1.16-14.el5.centos.1 installed
              yum-metadata-parser.i386 1.1.2-3.el5.centos installed
              yum-updatesd.noarch 1:0.9-2.el5 installed
              zabbix.i386 1.8.3-1.el5 installed
              zabbix-agent.i386 1.8.3-1.el5 installed
              zabbix-server-pgsql.i386 1.8.3-1.el5 installed
              zabbix-web.i386 1.8.3-1.el5 installed
              zip.i386 2.31-2.el5 installed
              zlib.i386 1.2.3-3 installed
              zsh.i386 4.2.6-3.el5 installed

              Comment

              • costas
                Senior Member
                • Aug 2009
                • 201

                #8
                Originally posted by ugh
                если не секрет, какой ожидаете эффект по сравнению фря+mysql, и почему?
                mysql vs postgresql - для zabbix скорее всего эффект однозначный - там где mysql не справляется с нагрузкой postgresql спокойно работает, ну а если на mysql работает то разницы никакой нет, по части ОСь (*BSD или linux) - это регламентировано либо инфраструктурой компании либо скилами админа, для больших компаний обычно не характерно держать зоопарк из ОСь.

                З.Ы. для провайдерского уровня *BSD стандарт де факто, на практике - кто во что горазд
                CentOS-5.5 i386, Zabbix 1.8.4 (stable), MySQL 5.0.92, PHP 5.2.17 (cli)

                ...эта проверка бесполезная, вредная, и она зло.

                Comment

                • ugh
                  Senior Member
                  • Jun 2009
                  • 296

                  #9
                  хех)
                  читаю интернеты и прям все так хорошо у постргеса )))
                  буду пробовать чтоле )

                  пысы: 2,2 миллиарда строк в хистори_уинт )

                  Comment

                  • mkolomiets
                    Senior Member
                    • Jul 2009
                    • 134

                    #10
                    Привет!
                    Originally posted by Dev_LC

                    ....
                    WARNING: nonstandard use of \\ in a string literal at character 64
                    HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
                    WARNING: nonstandard use of \\ in a string literal at character 68
                    HINT: Use the escape string syntax for backslashes, e.g., E'\\'.


                    вот это в логе /var/lib/pgsql/data/pg_log/postgresql-Fri.log
                    после добавления базы скриптами. Насколько нормально - незнаю.
                    На эти сообщения можно не обращать внимания.

                    А относительно ошибки подключения к БД из ВЕБ-морды проверьте: наличие пакета php-pgsql, что бы было разрешение на подключение в pg_hba.conf и что бы правильно резолвилось имя хоста БД если задаете именем.

                    Тестируете не "psql -U zabuser zabbix" а "psql -h localhost -U zabuser zabbix" что бы точно знать что подключаетесь через TCP.

                    ЗЫ. В логах постгреса должны быть ошибки подключения.

                    Comment

                    • Dev_LC
                      Member
                      • Feb 2011
                      • 64

                      #11
                      Originally posted by mkolomiets
                      Привет!

                      На эти сообщения можно не обращать внимания.

                      А относительно ошибки подключения к БД из ВЕБ-морды проверьте: наличие пакета php-pgsql, что бы было разрешение на подключение в pg_hba.conf и что бы правильно резолвилось имя хоста БД если задаете именем.

                      Тестируете не "psql -U zabuser zabbix" а "psql -h localhost -U zabuser zabbix" что бы точно знать что подключаетесь через TCP.

                      ЗЫ. В логах постгреса должны быть ошибки подключения.
                      Спасибо за ответ.
                      Попробовать не могу - переставил уже все на Debian. Разнес на два сервера Debian+Zabbix+PosgreSQL на один и FreeBSD-Web-Frontend на другой.
                      Все завелось без особых проблем. Что-то на центосе пошло не так

                      Comment

                      Working...