php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #54871 Don't work connect to interbase
Submitted: 2011-05-20 07:47 UTC Modified: 2011-05-24 09:46 UTC
From: mr dot efrem at gmail dot com Assigned:
Status: Closed Package: FPM related
PHP Version: 5.3.6 OS: FreeBSD 8.2
Private report: No CVE-ID: None
 [2011-05-20 07:47 UTC] mr dot efrem at gmail dot com
Description:
------------
Execute script with nginx + php-fpm and page don't show result.
If execute script with PHPCli then show "resource(4) of type (Firebird/InterBase 
link)".

Test script:
---------------
<?php 
        $link=ibase_connect('test.domen-test.ru:test','test','test','win1251', 0,1,'main'); 
        var_dump($link); 
?> 


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2011-05-20 07:58 UTC] mr dot efrem at gmail dot com
Nginx + php-fpm are adjusted truly, pages not containing instructions connect to 
firebird are displayed normally.
 [2011-05-20 08:09 UTC] fat@php.net
-Status: Open +Status: Feedback
 [2011-05-20 08:09 UTC] fat@php.net
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to "Open".

Thank you for your interest in PHP.


we need more information to help you.


can you please provide at least you FPM configuration ?
 [2011-05-20 08:22 UTC] mr dot efrem at gmail dot com
-Status: Feedback +Status: Open
 [2011-05-20 08:22 UTC] mr dot efrem at gmail dot com
php-fpm.conf: 
pid = run/php-fpm.pid 
error_log = log/nginx/php-fpm.log 
log_level = notice 
emergency_restart_threshold = 10 
emergency_restart_interval = 1m 
process_control_timeout = 5s 
daemonize = yes 
[www] 
listen = /tmp/php-fpm.sock 
listen.allowed_clients = 127.0.0.1 
user = 
www 
group = www 
pm = dynamic 
pm.max_children = 100 
pm.start_servers = 35 
pm.min_spare_servers = 20 
pm.max_spare_servers = 50 
pm.max_requests = 500 
pm.status_path = /status 
ping.path = /ping 
request_terminate_timeout = 31s 
request_slowlog_timeout = 10s 
slowlog = /var/log/nginx/$pool.log.slow 
catch_workers_output = yes 
php_admin_value[error_log]=/var/log/nginx/php-test-err.log
 [2011-05-20 08:23 UTC] fat@php.net
-Status: Open +Status: Feedback
 [2011-05-20 08:23 UTC] fat@php.net
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to "Open".

Thank you for your interest in PHP.


what do you have in your fpm log files ?

is the module interbase is loaded ?
 [2011-05-20 08:24 UTC] mr dot efrem at gmail dot com
nginx.conf:
-----------------------------------
user  www; 
worker_processes  1; 
timer_resolution 100ms; 
worker_rlimit_nofile 2048; 
pid        /var/run/nginx.pid; 
events { 
    worker_connections  1024; 
    use kqueue; 
} 

http { 
    include       mime.types; 
    default_type  application/octet-stream; 
    log_format  main  '$remote_addr - $remote_user [$time_local] 
"$request" ' 
                      '$status $body_bytes_sent "$http_referer" ' 
                      '"$http_user_agent" "$http_x_forwarded_for"'; 
    sendfile on; 
    tcp_nopush on; 
    keepalive_timeout  0; 
    reset_timedout_connection on; 
    server_tokens off; 
    server { 
        listen       80 default accept_filter=httpready; 
        server_name  main.domen-test.ru; 
        root /usr/local/www/nginx; 
        charset windows-1251; 
        client_max_body_size 1m; 
        access_log  /var/log/nginx/test.access.log main; 
        error_log   /var/log/nginx/test.error.log warn; 
        location / { 
            index  index.php index.html index.htm; 
        } 
        location = /stat { 
            stub_status on; 
            access_log  off; 
        } 
        location ~ \.php$ { 
            fastcgi_pass unix:/tmp/php-fpm.sock; 
            fastcgi_index index.php; 
            fastcgi_param SCRIPT_FILENAME /usr/local/www/nginx 
$fastcgi_script_name; 
            include fastcgi_params; 
        } 
        location ~ ^/(status|ping)$ { 
            fastcgi_pass unix:/tmp/php-fpm.sock; 
            fastcgi_param SCRIPT_FILENAME $fastcgi_script_name; 
            include fastcgi_params; 
            access_log off; 
        } 
    } 
    # HTTPS server 
    # 
    server { 
        listen       443; 
        server_name  main.domen-test.ru; 
        root /usr/local/www/nginx; 
        charset windows-1251; 
        client_max_body_size 
64m; 
        access_log  /var/log/nginx/ssl-test.access.log 
main; 
        error_log   /var/log/nginx/ssl-test.error.log warn; 
        ssl                  on; 
        ssl_certificate      ssl/main.domen-test.ru.crt; 
        ssl_certificate_key  ssl/main.domen-test.ru.key; 
        ssl_client_certificate  ssl/mainCA.crt; 
        ssl_session_timeout  5m; 
        ssl_protocols  SSLv3 TLSv1; 
        ssl_ciphers  ALL:!ADH:!EXPORT56:RC4+RSA:+HIGH:+MEDIUM:+LOW: 
+SSLv2:+EXP; 
        ssl_prefer_server_ciphers   on; 
        ssl_verify_client optional; 
        ssl_session_cache shared:SSL:10m; 
        index  index.php index.html 
index.htm; 
        location ~ \.php$ 
{ 
                    fastcgi_pass unix:/tmp/php- 
fpm.sock; 
                    fastcgi_index 
index.php; 
                    fastcgi_param SCRIPT_FILENAME /usr/local/www/nginx 
$fastcgi_script_name; 
                    fastcgi_param HTTPS on; 
                    fastcgi_param SSL_CLIENT_M_SERIAL $ssl_client_serial; 
                    fastcgi_param SSL_CLIENT_S_DN $ssl_client_s_dn; 
                    fastcgi_param SSL_CLIENT_I_DN $ssl_client_i_dn; 
                    include 
fastcgi_params; 
        } 
    } 
}
 [2011-05-20 08:30 UTC] mr dot efrem at gmail dot com
php-fpm.log:

[19-May-2011 19:22:16] NOTICE: [pool www] child 19398 exited with code 
0 after 37.014290 seconds from start 
[19-May-2011 19:22:16] NOTICE: [pool www] child 19421 started

[/usr/local/bin] # ldd php 
php: 
        libcrypt.so.5 => /lib/libcrypt.so.5 (0x8008b8000) 
        libfbclient.so.2 => /usr/local/lib/libfbclient.so.2 
(0x8009d1000) 
        libpcre.so.0 => /usr/local/lib/libpcre.so.0 (0x800b8f000) 
        libm.so.5 => /lib/libm.so.5 (0x800ccc000) 
        libxml2.so.5 => /usr/local/lib/libxml2.so.5 (0x800dec000) 
        libz.so.5 => /lib/libz.so.5 (0x80103c000) 
        libiconv.so.3 => /usr/local/lib/libiconv.so.3 (0x801151000) 
        libc.so.7 => /lib/libc.so.7 (0x80134c000) 
        libncurses.so.8 => /lib/libncurses.so.8 (0x80158e000) 
        libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x8016db000) 
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x8018eb000) 
        libthr.so.3 => /lib/libthr.so.3 (0x8019f9000)
 [2011-05-20 09:25 UTC] mr dot efrem at gmail dot com
-Status: Feedback +Status: Open
 [2011-05-20 09:25 UTC] mr dot efrem at gmail dot com
nginx-1.0.2
 [2011-05-24 09:46 UTC] mr dot efrem at gmail dot com
-Status: Open +Status: Closed
 [2011-05-24 09:46 UTC] mr dot efrem at gmail dot com
All it's work. I compile lang/php5 without option Link Threaded.
 
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Wed Oct 20 17:03:35 2021 UTC