why php 8.1 don't have pgsql extendsion

aaP_chagy_x_

I'm not see pgsql pdo_pgsql extendsion

aaPanel_Kern

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

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

sineld

aaPanel_Kern Worked for me, thanks.

kloudboy

aaPanel_Kern could elaborate how to install these commands? :

aaP_rogeriossilva1

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

aaPanel_Kern

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++) {

save.
Then execute the command after make && make install

aaP_dariausju

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

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

kloudboy

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 😃

aaPanel_Kern

kloudboy
Hello, yes, check the execution process for errors

aaP_shoeria7

hello im try and, i found error like this

aaPanel_Kern

aaP_shoeria7

Hello, it is recommended that you carefully check whether the entered command content is correct?
This is a variable with the php version that defines it

aaP_shoeria7

aaPanel_Kern Yes, I forgot to create a variable earlier, so is there a solution to my previous error?

aaPanel_Kern

aaP_shoeria7
Deleted the wrong configuration

aaP_shoeria7

aaPanel_Kern i found a new error

aaPanel_Kern

Continue to delete the wrong configuration

aaP_shoeria7

aaPanel_Kern I've changed it to this

but the error same like before,

aaP_shoeria7

aaP_shoeria7
and pgsql always no

aaPanel_Kern

aaP_shoeria7
What is the version of the command line using the command?
php -v

If it is not pointing to php8.1, cancel the alias first, and then change the PHP CLI version in websites
unalias-php

The information obtained by this interface may be inaccurate, please check view pipinfo()