PHP timeout when connecting to mssql under apache

Question

PHP Version 5.4, Apache Version 2.4, CentOS 7.3

Trying to connect to mssql db using the following php code which works fine when I run it from the command line. However, when I place code under apache (on same server) and call through browser I get a timeout error.

Error: Connection failed: SQLSTATE[HYT00] SQLConnect: 0 [unixODBC][Microsoft][ODBC Driver 13 for SQL Server]Login timeout expired+

set_time_limit(30);
echo "+ Connection\n";
try {
    $pdo = new PDO("odbc:sqlsrv_msodbc", "username", "password");
    } catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
    }

Please use set_time_limit(0);

Rana Ghosh
– Rana Ghosh

2017-02-07 10:48:08 +00:00
Commented Feb 7, 2017 at 10:48 — Rana Ghosh
– Rana Ghosh, Commented Feb 7, 2017 at 10:48
Hi - tried that but got same error result.

MikeG
– MikeG

2017-02-07 10:53:30 +00:00
Commented Feb 7, 2017 at 10:53 — MikeG
– MikeG, Commented Feb 7, 2017 at 10:53

Community · Accepted Answer · 2017-04-13 12:13:38Z

2

I just had the same issue. I am using CentOS 7.3 in vagrant and solved it by disabling SELinux.

If you're on a dev environment and disabling SELinux is cool you can do it by:

sudo vi /etc/sysconfig/selinux

Set

SELINUX=disabled

I found this over at serverfault: https://serverfault.com/questions/240015/how-do-i-allow-mysql-connections-through-selinux

edited Apr 13, 2017 at 12:13

CommunityBot

11 silver badge

answered Feb 15, 2017 at 21:34

Sean256

3,1194 gold badges34 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

MikeG Over a year ago

Thanks Sean256! That worked. Wow - never thought of it.

Sean256 Over a year ago

No problem! Mind giving a brother a correct answer mark?

MikeG Over a year ago

Trying! Don't have the reputations yet!

Collectives™ on Stack Overflow

PHP timeout when connecting to mssql under apache

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related