interbase like old "services" gds_db problem

rcpku

I have just upgraded server to apache 2.x and php to 4.x, the strange problem I've got is that if I run 'php page.php' from command-line all works well but througth apache I am getting old well know error stating that gds_db service is unknown.

"
Warning: ibase_connect(): Unable to complete network request to host "X". Failed to locate host machine. Undefined service gds_db/tcp.
"

Any ideas?

Paul

Sxooter

Are you sure that apache and the command line are running the same version of PHP with the same options? use phpinfo to see what the --configure switches were at build time.

rcpku

it's showing only new 4.x version information as well as ibase module info!

Paul

Sxooter

Yeah, looking at this again, it would seem that you DO have the interbase libs compiled in, but the connect string may be malformed.

Can we see a sanitized version (i.e. no passwords or servernames, replace them with xxx or something.)

rcpku

<%
$host="host:/opt/webshoptest.gdb";
$username="user";
$password="pass";
$lang="win1250";
$dbh = ibase_connect ($host, $username, $password, $lang);
$dbh2 = ibase_connect ($host, $username, $password, $lang);
ibase_timefmt("%d/%m/%Y %H:%M:%S", IBASE_TIMESTAMP);
%>

rcpku

For me it's a problem with php 4.x on Apache 2.x it seems there are some inetd services problem /it's working from command-line!/ but I can not find any posts about problem like that.
May be any user rights ? Commad-line version is started as root while Apache code is being executed as nobody. /But services should work for all users 🙂/

Paul

Sxooter

Originally posted by rcpku
Commad-line version is started as root while Apache code is being executed as nobody. /But services should work for all users 🙂/

Paul

You may need to create a real account with paths and what not to run apache under. I create one called httpd on my machines and run apache as that user.

rcpku

Originally posted by Sxooter
with paths and what not to run apache under.

Sorry I do not understand that part 🙁

Paul

Sxooter

the problem might be that nobody has no path or initial permissions. i.e. the account nobody doesn't really exist.

If, as the root user, you do:

useradd httpd

and then edit the httpd.conf file or equivalent file, you can change apache to execute as somebody other than nobody.

That might help, but no bets.

Note that this may well also be some small buglet in PHP / apache versions you're using, in which case you may have to try running the older apache. If you're running Linux or BSD, the old apache is about as fast as the new one, so no huge loss.

rcpku

I have and account I use for storing pages named let's say xxx
I tried to start Apache on it last night but error still come up.

But now, after your advise, I have just log on on it and tried to use standard interbase command-line tools for database connection and have GOT the same error as on Apache!

[xxx@dns bin]$ ./isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect localhost:/opt/webshoptest.gdb user XXX password XXX;
Statement failed, SQLCODE = -902

Unable to complete network request to host "localhost".
-Failed to locate host machine.
-Undefined service gds_db/tcp.

so interbase connection is not running for users other than root.
BUT WHAT NOW?
I will do some test ....
give me 15 min. 🙂

Paul

Sxooter

check your settings in inetd.d (or xinetd.d if you're running that) it's a directory in /etc like:

/etc/xinetd.d

and there should be a file there for interbase, see if it has some setting that would only let root use it.

rcpku

that's for xxx user:

]$ telnet localhost gds_db
gds_db: bad port number

that's for root:

$telnet localhost gds_db
Trying 127.0.0.1...
Connected to localhost.localdomain.
Escape character is '^]'.
a
ssss
Connection closed by foreign host.

Is inetd job user dependent ?????
.
.
.
.
.

After some next test answer came !!!!!!!

/etc/services was only readable by root, after changing to "others read" all STARTED!!!!!

THANKS for ideas !!!!!
Paul

.....

but know some part are not working it seem's there are some argument passing problems

please look at:

this after cliking on any link there are problems with parameters passed to next script.

Paul again,

rcpku

Originally posted by Sxooter
check your settings in inetd.d (or xinetd.d if you're running that) it's a directory in /etc like:

/etc/xinetd.d

and there should be a file there for interbase, see if it has some setting that would only let root use it.

I am not using xinetd 🙁
Linux on that machine come from Redhat 6.2 and was build be me for last few years and now it should be named Paul 234.23.3.3 🙂

That's why nobody else wants to touch problems on it!

Sxooter

It almost sounds like the /etc/services file is set to not be world readable or something. What port does interbase run on? Try

telnet 127.0.0.1 <port_number>

instead of the alias for it and see it that helps.