[PHP] Problems with virtual() = request execution failed
Hi, I am having trouble porting an application to another server. I have to call an external Perl script through the use of the function 'virtual()' but on the new server I get the following error: Warning: Unable to include './cgi-bin/banners/ads_business.pl' - request execution failed in /usr/local/etc/httpd/vhosts/business/index.htm on line 61 This was the original code which ran perfectly, but not at the new server. I tried every kind of path with no success. Any hints? TIA, Paulo -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] PHP dll on NT - more reliable with Apache than IIS?
We have started using PHP on NT over Apache, but since our ISP used IIS we switched to it. Anyway, we just started having real problems after our application got really big, so that I cannot really compare Apache x IIS on NT very well (our errors started happening on IIS if I recall correctly). And you are right, CGI version is much more stable: our application has even crashed IIS on our ISP (and thus all other clients websites as well went down...) when running PHP as ISAPI. We asked the ISP to configure PHP as CGI for our virtual host only, did the same test and got an error but all the sites still were running fine, ours as well. I believe you should do some tests over apache, it is really easy to install. And relating to IIS, CGI is definetly more stable. You could anyway consider moving to Linux or UNIX. The developers of PHP seem also to be much more prolific in relation to this world, for obious reasons... But in my opinion, as a commercial product in a production environment I would say that PHP over Windows is definetly not the better choice. Paulo - Original Message - From: Greig, Euan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 07, 2001 6:44 AM Subject: [PHP] PHP dll on NT - more reliable with Apache than IIS? I have been having problems using the PHP 4 ISAPI module with IIS 4 on NT4 (The most common problem is HTTP 500 internal server error which disappears if page is refreshed). This is apparently not too surprising given the current status of the ISAPI module. So I have switched to using CGI, which seems absolutely fine, but is noticeably slower. I was wondering if it is worth trying the Apache module. Will it be more reliable? And are there any notable gotchas to watch out for in installing this combination? Euan Greig Technical Consultant BRANN DATA [EMAIL PROTECTED] 01285 645997 ** Any opinions expressed in this email are those of the individual and not necessarily the Company. This email and any files transmitted with it, including replies and forwarded copies (which may contain alterations) subsequently transmitted from the Company, are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited. ** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] RPMs for PHP accessing PostgreSQL via ODBC over RedHat
Hi, We are currently running the following configuration on our server: Linux Red Hat 7.0 PostgreSQL 7.1beta4-1 PHP 4.0.1pl2 I need to add some RPM package (or perhaps an apache module) to enable PHP to access PostgreSQL via ODBC. In order to have PostgreSQL native access support we installed package 'php-pgsql-4.0.1pl2-9.i386.rpm'. Is there some similar RPM package to enable ODBC access in PHP4.0.1pl2? If not, how should I procceed? TIA, Paulo -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] How to connect to PostgreSQL with phpPgAdmin
For the phpPgAdmin users, if you might help!!!
I am running PostgreSQL 7.1 over RedHat.
When trying to connect through the web everything goes right. A script that
is currently working:
?php
$link = pg_Connect("host=localhost port=5432 dbname=teste")
or die ("Could not connect");
$comando = "select * from teste";
$result = pg_exec($link,$comando);
$linhas_retornadas = pg_numrows($result);
echo "tabletdbnome/b/tdtdbsobrenome/b";
for ($i=0; $i $linhas_retornadas; $i++) {
$row=pg_fetch_array($result,$i);
echo "trtd" . $row["nome"] . "/td";
echo "td" . $row["sobrenome"] . "/td/tr";
}
echo "/table";
pg_close ($link);
?
All *my databases are owned by user 'postgres'* and I had to create another
PostgreSQL *user 'apache' and give ownership of table 'teste' in database
'teste' to this user* (apache) in order for this connection to work.
My 'pg_hba.conf' file reads:
localall
trust
host all 127.0.0.1 255.255.255.255 trust
With phpPgAdmin I configured file 'config.inc.php' as follows:
// The default database is used to connect to the database to check the
adv_auth
// This can actually be any database you currently have on your system.
It just
// needs _a_ database to connect and check the system tables.
$cfgDefaultDB = "teste";
// You should change the superuser if different from postgres
// This is just used to filter out the system functions when listing
$cfgSuperUser = "postgres";
// Set to true if you want to authenticate against the passwd as well as
the username
// In order to use adv_auth, you must update the passwords in the user
admin section.
// It is suggested that you leave this as false until you are able to
get in and update the passwords.
$cfgUsePass = false;
$cfgServers[1]['local'] = true;
$cfgServers[1]['host'] = 'localhost';
$cfgServers[1]['port'] = '5432';
$cfgServers[1]['adv_auth'] = false;
$cfgServers[1]['stduser'] = 'apache';
No matter if I set
$cfgServers[1]['host'] as 'localhost' or as '127.0.0.1'
$cfgServers[1]['stduser'] as 'apache' or as 'postgres' or as none
No matter what I always get a blank Web page with the following messages:
ERROR
The requested URL could not be retrieved
While trying to retrieve the URL: [no URL]
The following error was encountered:
Zero Sized Reply
Squid did not receive any data for this request.
Your cache administrator is webmaster.
Generated Sun, 04 Mar 2001 23:15:30 GMT by internet.gst.com.br
(Squid/2.3.STABLE3)
Please help!!! This shall most probably be some problem of permission, but
how do I manage to make phpPgAdmin to correctly connect and access my
databases?
TIA,
Paulo
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] En: [GENERAL] libpq.so.2.1 needed by php-pgsql-4.0.1pl2-9
Maybe somebody here might be able to help me so I am forwarding this. TIA, Paulo - Original Message - From: Paulo Parola To: [EMAIL PROTECTED] Sent: Thursday, March 01, 2001 4:31 PM Subject: [GENERAL] libpq.so.2.1 needed by php-pgsql-4.0.1pl2-9 Hi, I am running Redhat 7.0 with PHP 4.0.1pl2. I currently installed PostgreSQL 7.1beta, but now when trying to enable Postgres access to PHP (package php-pgsql-4.0.1pl2-9) I get the following error: [root@atlas PostgreSQL]# rpm -ivh php-pgsql-4.0.1pl2-9.i386.rpm error: failed dependencies: libpq.so.2.1 is needed by php-pgsql-4.0.1pl2-9 What are my options? 1) Force installation with rpm "nodependency" option? 2) Create some symlink? Currently I have at /usr/lib the following files: lrwxrwxrwx1 root root 12 Mar 1 11:17 libpq.so - libpq.so.2.1 lrwxrwxrwx1 root root 12 Mar 1 11:07 libpq.so.2 - libpq.so.2.1 lrwxrwxrwx1 root root 12 Mar 1 11:17 libpq.so.2.0 - libpq.so.2.1 -rwxr-xr-x1 root root70311 Jan 29 05:19 libpq.so.2.1 3) Some other tips? Thank you in advance, Paulo
[PHP] Help with Linux RPM install (ODBC access)
Hi, I have just installed RedHat 7 with support to PHP4 and MySQL. phpinfo() reports the following at the 'configure command' entry: './configure' '--target=i386-redhat-linux' '--prefix=/usr' '--with-config-file-path=/etc' '--disable-debug' '--enable-pic' '--enable-inline-optimization' '--with-apxs=/usr/sbin/apxs' '--disable-static' '--with-exec-dir=/usr/bin' '--with-regex=system' '--with-gettext' '--with-gd' '--with-jpeg-dir=/usr' '--with-png' '--with-zlib' '--with-db2' '--with-db3' '--with-gdbm' '--enable-debugger' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-yp' '--enable-ftp' '--without-mysql' '--with-xml' Although it shows option '--without-mysql' at the 'MySQL' section it reports that MySQL is enabled, and indeed we can connect to our MySQL database normally. We need though to have access to MySQL through ODBC and would like to configure PHP to run with 'unixODBC' compiled. I can see that ODBC support is currently not built in, because invoking function odbc_connect() I receive the following message: Fatal error: Call to undefined function: odbc_connect() in /var/www/html/odbc.php on line 6 RedHat reports that the RPM package for unixODBC is installed, but how do I make it to be built with PHP? And why does the compile options show that MySQL support was not built in and in fact it is? Is this because of the way RPMs function? That is, I believe I should really not rebuild PHP with commands './configure', 'make' and 'make install' but instead work with the RPM RedHat system. Any hints for a Linux RedHat newbie? TIA, Paulo
[PHP] PHP compile with ODBC support (iODBC x Openlinkx unixODBC...) and MyODBC
Hi, We are currently configuring PHP4.0.4 with MySQL and Apache. We *need* to access MySQL via ODBC as well. Which is the best thing to do? There are many options of different ODBC drivers that can be configured, like 'iodbc' or 'openlink' from Openlink or unixODBC. Which driver is best? Which has better administration tools? Which has GUI's? Any comments about pros and cons about each one, functionalities available, ease of installation ? When building PHP, I know I should choose among options like (I quote here from memory): --with-iodbc --with-openlink --with-unixODBC --with-customODBC I tried building it with iODBC support, but make failed because of some source header files needed that were missing. About MyODBC: it is just an API and not the proper driver I suppose. We are going to access the Linux server both locally as well as remotely from Windows98 workstations. So I believe we should install MyODBC only on our Windows clients machines and not on the server, right? What about MySQLGUI? Should I install it only at my windows machines or also on the server. Is it somewhat similar to what I have seen about a unixODBC grphical manager for KDE? Any tips would be greatly appreciated, TIA, Paulo
