I'm not see pgsql pdo_pgsql extendsion

aaP_chagy_x_ Hello, the php8.1 part of the panel extension has not been added, you can run the installation manually pgsql： version=81 echo $version cd /www/server/php/$version/src/ext/pgsql /www/server/php/$version/bin/phpize ./configure --with-php-config=/www/server/php/$version/bin/php-config --with-pgsql=/www/server/pgsql make && make install extFile='/www/server/php/$version/lib/php/extensions/no-debug-non-zts-20210902/pgsql.so' echo -e "extension = " ${extFile} >> /www/server/php/$version/etc/php.ini echo -e "extension = " ${extFile} >> /www/server/php/$version/etc/php-cli.ini /etc/init.d/php-fpm-$version reload if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } pdo_pgsql： version=81 echo $version cd /www/server/php/$version/src/ext/pdo_pgsql /www/server/php/$version/bin/phpize ./configure --with-php-config=/www/server/php/$version/bin/php-config --with-pdo-pgsql=/www/server/pgsql make && make install extFile='/www/server/php/$version/lib/php/extensions/no-debug-non-zts-20210902/pdo_pgsql.so' echo -e "extension = " ${extFile} >> /www/server/php/$version/etc/php.ini echo -e "extension = " ${extFile} >> /www/server/php/$version/etc/php-cli.ini /etc/init.d/php-fpm-$version reload if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); }

Hi, When you run this PGSQL: stretch, I have the error below. creating libtool appending configuration tag "CXX" to libtool configure: patching config.h.in configure: creating ./config.status config.status: creating config.h config.status: config.h is unchanged [root@cloud pgsql]# make && make install /bin/sh /www/server/php/81/src/ext/pgsql/libtool --mode=compile cc -I. -I/www/server/php/81/src/ext/pgsql -I/www/server/php/81/src/ext/pgsql/include -I/www/server/php/81/src/ext/pgsql/main -I/www/server/php/81/src/ext/pgsql -I/www/server/php/81/include/php -I/www/server/php/81/include/php/main -I/www/server/php/81/include/php/TSRM -I/www/server/php/81/include/php/Zend -I/www/server/php/81/include/php/ext -I/www/server/php/81/include/php/ext/date/lib -I/www/server/pgsql/include -DHAVE_CONFIG_H -g -O2 -DZEND_ENABLE_STATIC_TSRMLS_CACHE=1 -DZEND_COMPILE_DL_EXT=1 -c /www/server/php/81/src/ext/pgsql/pgsql.c -o pgsql.lo -MMD -MF pgsql.dep -MT pgsql.lo mkdir .libs cc -I. -I/www/server/php/81/src/ext/pgsql -I/www/server/php/81/src/ext/pgsql/include -I/www/server/php/81/src/ext/pgsql/main -I/www/server/php/81/src/ext/pgsql -I/www/server/php/81/include/php -I/www/server/php/81/include/php/main -I/www/server/php/81/include/php/TSRM -I/www/server/php/81/include/php/Zend -I/www/server/php/81/include/php/ext -I/www/server/php/81/include/php/ext/date/lib -I/www/server/pgsql/include -DHAVE_CONFIG_H -g -O2 -DZEND_ENABLE_STATIC_TSRMLS_CACHE=1 -DZEND_COMPILE_DL_EXT=1 -c /www/server/php/81/src/ext/pgsql/pgsql.c -MMD -MF pgsql.dep -MT pgsql.lo -fPIC -DPIC -o .libs/pgsql.o /www/server/php/81/src/ext/pgsql/pgsql.c: In function ‘get_field_name’: /www/server/php/81/src/ext/pgsql/pgsql.c:1568:2: error: ‘for’ loop initial declarations are only allowed in C99 mode for (int i = 0; i < num_rows; i++) { ^ /www/server/php/81/src/ext/pgsql/pgsql.c:1568:2: note: use option -std=c99 or -std=gnu99 to compile your code make: *** [pgsql.lo] Error 1 [root@cloud pgsql]# extFile='/www/server/php/$version/lib/php/extensions/no-debug-non-zts-20210902/pgsql.so' [root@cloud pgsql]# echo -e "extension = " ${extFile} >> /www/server/php/$version/etc/php.ini [root@cloud pgsql]# echo -e "extension = " ${extFile} >> /www/server/php/$version/etc/php-cli.ini [root@cloud pgsql]# /etc/init.d/php-fpm-$version reload

aaP_rogeriossilva1 Hello, what is your system, what version? What is the version of gcc? cp /www/server/php/81/src/ext/pgsql/pgsql.c /www/server/php/81/src/ext/pgsql/pgsql.c_bak vim /www/server/php/81/src/ext/pgsql/pgsql.c Try changing line 1568 from for (int i = 0; i < num_rows; i++) { to: int i; for (i = 0; i < num_rows; i++) { if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } save. Then execute the command after make && make install

aaPanel_Kern Worked for me, thanks.

what is this about, can somebody explain how to get working pgsql in 8.1. and why it's not already included in component install list?

aaPanel_Kern could elaborate how to install these commands? :

kloudboy Hello. Log in to the server using ssh and run commands to install the extension. Or wait for our support

aaPanel_Kern I'm using cent os 7, is this bash? i just copied and pasted on terminal nothing happened. if you help me i'll try or i'll wait for the next aapanel update. thanks advance 😃

kloudboy Hello, yes, check the execution process for errors

hello im try and, i found error like this

why php 8.1 don't have pgsql extendsion

aaP_shoeria7

aaPanel_Kern
sorry this is first time i deploy server with aa panel

aaP_shoeria7

aaPanel_Kern

aaP_shoeria7
use root user

danleles

I performed all the processes above, I'm still having problems installing the extension.
I performed the above procedures, even so the error persists,

aaPanel_Kern

danleles
Hello, please describe your problem in detail.

aaP_symentix_shubhamk

Hello aaPanel_Kern

I am facing issue with pgsql driver, encountered error
"message": "could not find driver (SQL: select count(*) as aggregate from \"users\" where \"email\" = user@gmail.com)",

I have installed pgsql extensions from app store but still not able to get it working also tried with this sudo apt install php-pgsql
still not working, My php version : 8.0

aaPanel_Kern

aaP_symentix_shubhamk
Hi, is there a relational database for pgsql? Is the configuration of the website correctly configured with pgsql?

aaP_symentix_shubhamk

Yes It is relational database for pgsql and the configuration in the website is done correctly

aaPanel_Kern

Hello, where did you install PostgreSQL from?

aaP_symentix_shubhamk

From app store

aaPanel_Kern

Hello, it is recommended to check whether the relevant database exists using the command
Log in:
su - postgres

enter the database
psql

Check out the database:
\l

View all database information
SELECT * FROM pg_database ORDER BY datname;

quit
\q

aaP_symentix_shubhamk

the Database i created is not listed here
DB created in PostgreSQL Manager and in DATABASE (sidebar menu) of aapnel

aaPanel_Kern

aaP_symentix_shubhamk
try
Database name and user name cannot start with numbers and cannot have special symbols
If the user name starts with a number, you will not be able to log in. \l View the Access privileges column without access rights.
The beginning of the database name is a number. You can see that it has been established on the interface. In fact, \l it seems that there is no database.

aaP_symentix_shubhamk

aaP_symentix_shubhamk
Also i tried connecting with different DB outside the aapanel from aws rds still facing this issue.
I have checked for pgsql or pdo-pgsql is installed or not please check in the below snap it is not installed and in the app store it is showing that these extension are installed.

aaPanel_Kern

It is recommended that you check whether the database other than aapanel can be successfully connected?
The php module shows that the installation is successful

aaP_symentix_shubhamk

Yes i have connected with Mysql other than aapanel it is working. But when i connect with postgresql it is not connecting.
encountering error "message": "could not find driver (SQL: select count(*) as aggregate from \"users\" where \"email\" = user@gmail.com)",
issue with php-pgsql drivers

aaPanel_Kern

It is recommended that you use mysql for use

aaP_symentix_shubhamk

Could you please provide me ssh command to install php-pgsql extension/driver

aaP_symentix_shubhamk

We have postgres DB and already using in production env cannot change back mysql

aaPanel_Kern

aaP_symentix_shubhamk
install file:
/www/server/panel/install/pgsql.sh

« Previous Page Next Page »