PostgreSQL + phppgadmin

[alden]

PostgreSQL и phppgadmin устанавливаются через терминал

sudo systemctl status postgresql

Код: Выделить всё

● postgresql.service - PostgreSQL RDBMS
     Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; preset: enabled)
     Active: active (exited) since Wed 2024-01-03 12:24:42 EET; 34min ago
   Main PID: 1303 (code=exited, status=0/SUCCESS)
        CPU: 1ms

січ 03 12:24:42 zippo systemd[1]: Starting postgresql.service - PostgreSQL RDBMS...
січ 03 12:24:42 zippo systemd[1]: Finished postgresql.service - PostgreSQL RDBMS.

В /etc/apache2/conf-available/phppgadmin.conf такой конфиг

Код: Выделить всё

Alias /phppgadmin /usr/share/phppgadmin

<Directory /usr/share/phppgadmin>

<IfModule mod_dir.c>
DirectoryIndex index.php
</IfModule>
AllowOverride None

# Only allow connections from localhost:
Require all granted

<IfModule mod_php.c>
  php_flag magic_quotes_gpc Off
  php_flag track_vars On
  #php_value include_path .
</IfModule>
<IfModule !mod_php.c>
  <IfModule mod_actions.c>
    <IfModule mod_cgi.c>
      AddType application/x-httpd-php .php
      Action application/x-httpd-php /cgi-bin/php
    </IfModule>
    <IfModule mod_cgid.c>
      AddType application/x-httpd-php .php
      Action application/x-httpd-php /cgi-bin/php
    </IfModule>
  </IfModule>
</IfModule>

</Directory>

Конфиг добавлен sudo a2ensite phppgadmin.conf
Рестарт сделан sudo systemctl restart apache2
Почему http://IP/phppgadmin возвращает 404, а в brainycp в розделе PostgreSQL такое?
Как я понимаю brainycp блокирует мне доступ который должен быть у меня по линку http://IP/phppgadmin а в панели brainycp вообще баги с тем что brainy не воспринимает нормальное состояние сервиса PostgreSQL
https://drive.google.com/file/d/10Cyipk ... WHbVCafHtN
https://drive.google.com/file/d/1w_uG4X ... zcf6g-H4I0
https://drive.google.com/file/d/1h2IYWM ... TaMxbFtPGe

[alenka]

PostgreSQL и phppgadmin устанавливаются через терминал

Панель использует свои скрипты установки, и версия пакета которая совместима со всеми ос.

[alden]

Так в чем здесь проблемы?
https://drive.google.com/file/d/10Cyipk ... WHbVCafHtN
https://drive.google.com/file/d/1w_uG4X ... zcf6g-H4I0
https://drive.google.com/file/d/1h2IYWM ... TaMxbFtPGe
Я нажал в панели установку PostgreSQL. Лог такой

Код: Выделить всё

%5B%7B%22comm%22%3A%22%5C%2Fusr%5C%2Flocal%5C%2Fbrainycp%5C%2Fssh%5C%2Fpacket_manager%5C%2Fpostgresql%5C%2Fpostgresql.sh+install%22%2C%22array_succes%22%3A%7B%22status_postgresql%22%3A%22success%2C%23stream_id%23%22%2C%22postgresql%22%3A%221%22%7D%2C%22array_start%22%3A%7B%22status_postgresql%22%3A%22inprogress%2C%23stream_id%23%22%7D%2C%22array_unsucces%22%3A%7B%22status_postgresql%22%3A%22unsuccess%2C%23stream_id%23%22%7D%2C%22test%22%3A%22Complete%22%2C%22userowner%22%3A%22root%22%7D%2C%7B%22comm%22%3A%22%5C%2Fusr%5C%2Flocal%5C%2Fbrainycp%5C%2Fssh%5C%2Fpkg_manager_init.php+-a+update_file_config%22%7D%2C%7B%22comm%22%3A%22%5C%2Fusr%5C%2Flocal%5C%2Fbrainycp%5C%2Fsrc%5C%2Fcompiled%5C%2Fphp5%5C%2Fbin%5C%2Fphp+-q++%5C%2Fusr%5C%2Flocal%5C%2Fbrainycp%5C%2Fscripts%5C%2Fcluster.php+-a+sinhronisation_cluster+-f+%27packet%27%22%7D%5D/etc/brainy/conf/streams/packet_manager2_control_170427776246164
/usr/local/brainycp/ssh/packet_manager/postgresql/postgresql.sh install
Reading package lists...
Building dependency tree...
Reading state information...
postgresql is already the newest version (16+256.pgdg22.04+1).
postgresql-contrib is already the newest version (16+256.pgdg22.04+1).
The following packages were automatically installed and are no longer required:
  gir1.2-freedesktop gir1.2-gdkpixbuf-2.0 gir1.2-rsvg-2.0 icu-devtools
  libblkid-dev libbrotli-dev libbz2-dev libcairo-gobject2
  libcairo-script-interpreter2 libcairo2-dev libdeflate-dev libdjvulibre-dev
  libdpkg-perl libexif-dev libexif-doc libexif12 libexpat1-dev
  libfile-fcntllock-perl libfontconfig-dev libfontconfig1-dev libfreetype-dev
  libfreetype6-dev libgdk-pixbuf-2.0-0 libgdk-pixbuf-2.0-dev
  libgdk-pixbuf2.0-bin libgdk-pixbuf2.0-common libglib2.0-bin libglib2.0-dev
  libglib2.0-dev-bin libice-dev libicu-dev libilmbase-dev libjbig-dev
  libjpeg-dev libjpeg-turbo8-dev libjpeg8-dev liblcms2-dev liblqr-1-0-dev
  liblzma-dev liblzo2-2 libmagickcore-6-arch-config libmagickcore-6-headers
  libmagickcore-6.q16-dev libmagickwand-6-headers libmagickwand-6.q16-dev
  libmagickwand-dev libmount-dev libopenexr-dev libopenjp2-7-dev libpcre16-3
  libpcre2-16-0 libpcre2-32-0 libpcre2-dev libpcre2-posix3 libpcre3-dev
  libpcre32-3 libpcrecpp0v5 libpixman-1-dev libpng-dev libpng-tools
  libpthread-stubs0-dev librsvg2-2 librsvg2-common librsvg2-dev
  libselinux1-dev libsepol-dev libsm-dev libssl1.0.0 libtiff-dev libtiffxx5
  libwmf-0.2-7 libwmf-dev libx11-dev libxau-dev libxcb-render0-dev
  libxcb-shm0-dev libxcb1-dev libxdmcp-dev libxext-dev libxml2-dev
  libxrender-dev libxt-dev linux-image-5.4.0-105-generic
  linux-modules-5.4.0-105-generic pkg-config python3-distutils python3-lib2to3
  shtool uuid-dev x11proto-dev xorg-sgml-doctools xtrans-dev zlib1g-dev
Use 'apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 125 not upgraded.
Usage: /etc/init.d/postgresql {start|stop|restart|reload|force-reload|status} [version ..]
Complete
/usr/local/brainycp/ssh/pkg_manager_init.php -a update_file_config

Run process...

Process completed.
/usr/local/brainycp/src/compiled/php5/bin/php -q  /usr/local/brainycp/scripts/cluster.php -a sinhronisation_cluster -f 'packet'

Почему так? https://drive.google.com/file/d/1w_uG4X ... zcf6g-H4I0

[alenka]

dpkg -l | grep postgresql
Вы используете декстопную версию ubuntu?

[alden]

Нет, версия ubuntu серверная

dpkg -l | grep postgresql

Код: Выделить всё

ii  postgresql                                       15+253                                    all          object-relational SQL database (supported version)
ii  postgresql-15                                    15.5-0ubuntu0.23.10.1                     amd64        The World's Most Advanced Open Source Relational Database
ii  postgresql-client-15                             15.5-0ubuntu0.23.10.1                     amd64        front-end programs for PostgreSQL 15
ii  postgresql-client-common                         253                                       all          manager for multiple PostgreSQL client versions
ii  postgresql-common                                253                                       all          PostgreSQL database-cluster manager
ii  postgresql-contrib                               15+253                                    all          additional facilities for PostgreSQL (supported version)

[alenka]

cat /etc/os-release