Closed CXY037 closed 4 years ago
@CXY037 首先感谢您的BUG反馈, 我是无情的自动回复机器人,请您快速确认以下几点来帮助我们定位您的问题:
如你是手动升级编译的而不是首次编译, 确保你在编译前运行make clean
清理了上次编译的内容
如你使用的是Linux系统, 使用以下命令运行你的程序, 以能够复现BUG的方式操作你的程序, 并在程序运行一定时间后, 将位于/tmp目录的valgrind.log日志内容贴在此issue中
USE_ZEND_ALLOC=0 valgrind --log-file=/tmp/valgrind.log php xxx.php
如你使用的是macOS系统,将无法使用valgrind, 请提供能够复现问题BUG的PHP代码
若以上需求都无法满足,请您在此表明, 我们将快速接入人工处理
补充测试文件 <?php $pg = new Swoole\Coroutine\PostgreSQL(); $conn = $pg->connect("host=172.17.0.1;port=5432;dbname=;user=postgres;password="); if (!$conn) { var_dump($pg->error); return; }
What did you expect to see?
What did you see instead?
你用官方的php扩展能联通吗 @CXY037
官方的pgsql扩展么?
吴振宇 notifications@github.com 于2019年11月28日周四 下午5:03写道:
你用官方的php扩展能联通吗 @CXY037 https://github.com/CXY037
— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/swoole/swoole-src/issues/2986?email_source=notifications&email_token=AATZUYZCOZMVVWHAQDS3EK3QV6CMNA5CNFSM4JSQRT22YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEFL47FQ#issuecomment-559402902, or unsubscribe https://github.com/notifications/unsubscribe-auth/AATZUY5WVPDVT35OKEOFCW3QV6CMNANCNFSM4JSQRT2Q .
我安装了pdo_pgsql原生php是可以联通的
Xiaoyu Chen xiaoyulaile@gmail.com 于2019年11月28日周四 下午5:34写道:
官方的pgsql扩展么?
吴振宇 notifications@github.com 于2019年11月28日周四 下午5:03写道:
你用官方的php扩展能联通吗 @CXY037 https://github.com/CXY037
— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/swoole/swoole-src/issues/2986?email_source=notifications&email_token=AATZUYZCOZMVVWHAQDS3EK3QV6CMNA5CNFSM4JSQRT22YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEFL47FQ#issuecomment-559402902, or unsubscribe https://github.com/notifications/unsubscribe-auth/AATZUY5WVPDVT35OKEOFCW3QV6CMNANCNFSM4JSQRT2Q .
新的dockerfile FROM php:alpine
ENV SWOOLE_VERSION=4.4.12
RUN sed -i 's/dl-cdn.alpinelinux.org/mirrors.aliyun.com/g' /etc/apk/repositories \ && apk upgrade --update \ && apk add --no-cache --virtual .build-deps linux-headers autoconf libc-dev gcc g++ libstdc++ postgresql-dev libpq make git \ && pecl install redis && docker-php-ext-enable redis \ && pecl install inotify && docker-php-ext-enable inotify \ && docker-php-ext-install bcmath pdo_pgsql pgsql\ && cd /tmp \ && curl -sSL "https://github.com/swoole/swoole-src/archive/v${SWOOLE_VERSION}.tar.gz" | tar xzf - \ && cd swoole-src-${SWOOLE_VERSION} \ && phpize \ && ./configure --enable-async-redis --enable-openssl --enable-http2\ && make -j$(nproc) && make install \ && docker-php-ext-enable swoole \ && cd ~ \ && git clone https://github.com/CXY037/ext-postgresql.git \ && cd ext-postgresql \ && phpize \ && ./configure \ && make && make install \ && docker-php-ext-enable swoole_postgresql \ && apk del .build-deps \ && apk add --no-cache libstdc++ postgresql-dev libc-dev \ && rm -r /tmp/swoole-src-${SWOOLE_VERSION} \ && rm -rf /tmp/ \ && rm -rf /var/cache/apk/
WORKDIR /var/www/project
我安装了pdo_pgsql原生php是可以联通的 Xiaoyu Chen xiaoyulaile@gmail.com 于2019年11月28日周四 下午5:34写道:
官方的你是在 容器内连的吗
@yunnian 对容器内连接用的172.17.0.1
@yunnian pg的服务应该是没问题的 pdo是可以连接的
我看你clone的是自己fork的,请用最新代码试下,前段时间有修复过bug
@yunnian 我是今天fork的,因为alphine里要用mac那个配置 就是#ifdef linux
这里需要改成libpq-fe.h 我看了issue里改的
pdo_pgsql pdo_sqlite pgsql Phar posix readline redis Reflection session SimpleXML sodium SPL sqlite3 standard swoole swoole_postgresql tokenizer xml xmlreader xmlwriter zlib
[Zend Modules]
扩展应该也是没有问题的
尝试了下还是没有找到问题出在哪里,麻烦了
尝试了下还是没有找到问题出在哪里,麻烦了
容器外尝试下是否能联通,看下和容器网络有关没
我qq 936321732 +下 方便沟通
已加
应该跟网络无关,容器内pdo可以连接成功
@yunnian 加了~86410307
您好 ,加了您几次qq都没有加上,你用下pgsql的 4.4.12版本试一下 : https://github.com/swoole/ext-postgresql/releases/tag/v4.4.12
@yunnian 我也加了您也没回复~加微信吧哈哈soapper
好的我试一下
@yunnian 已经解决,上午刚测试,非常感谢
@yunnian 就是希望能加一下判断alphine alphine 跟mac的配置是相同的
Please answer these questions before submitting your issue. Thanks!
What did you do? If possible, provide a simple script for reproducing the error. 不能连接pgsql 数据库 已经安装 ext-postgresql
What did you expect to see?
What did you see instead?
What version of Swoole are you using (show your
php --ri swoole
)? swooleSwoole => enabled Author => Swoole Team team@swoole.com Version => 4.4.12 Built => Nov 28 2019 07:33:08 coroutine => enabled epoll => enabled eventfd => enabled signalfd => enabled spinlock => enabled rwlock => enabled openssl => OpenSSL 1.1.1d 10 Sep 2019 http2 => enabled mutex_timedlock => enabled pthread_barrier => enabled futex => enabled async_redis => enabled
Directive => Local Value => Master Value swoole.display_errors => On => On swoole.enable_coroutine => On => On swoole.enable_library => On => On swoole.enable_preemptive_scheduler => Off => Off swoole.unixsock_buffer_size => 8388608 => 8388608 swoole.use_shortname => On => On
mac
ENV SWOOLE_VERSION=4.4.12
RUN sed -i 's/dl-cdn.alpinelinux.org/mirrors.aliyun.com/g' /etc/apk/repositories \ && apk upgrade --update \ && apk add --no-cache --virtual .build-deps linux-headers autoconf libc-dev gcc g++ libstdc++ postgresql-dev make git \ && pecl install redis && docker-php-ext-enable redis \ && pecl install inotify && docker-php-ext-enable inotify \ && docker-php-ext-install bcmath \ && cd /tmp \ && curl -sSL "https://github.com/swoole/swoole-src/archive/v${SWOOLE_VERSION}.tar.gz" | tar xzf - \ && cd swoole-src-${SWOOLE_VERSION} \ && phpize \ && ./configure --enable-coroutine-postgresql --enable-async-redis --enable-openssl --enable-http2\ && make -j$(nproc) && make install \ && docker-php-ext-enable swoole \ && cd ~ \ && git clone https://github.com/CXY037/ext-postgresql.git \ && cd ext-postgresql \ && phpize \ && ./configure \ && make && make install \ && docker-php-ext-enable swoole_postgresql \ && apk del .build-deps \ && apk add --no-cache libstdc++ postgresql-dev libc-dev \ && rm -r /tmp/swoole-src-${SWOOLE_VERSION} \ && rm -rf /tmp/ \ && rm -rf /var/cache/apk/
WORKDIR /var/www/project