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); }

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

why php 8.1 don't have pgsql extendsion

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

sineld

aaPanel_Kern Worked for me, thanks.

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?

kloudboy

aaPanel_Kern could elaborate how to install these commands? :

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()