Re: [PHP-DB] Re: Is MySQL available from my host.

2003-01-06 Thread Robert Wagner 
At www.download.com I located PHP Triad, but I'm a bit nervous, although
the overall ratings for the package are high. Here are my concerns:
  1) Some people couldn't install it all.
  2) Apparently it MUST be installed on drive C. While I have over 500
MB in C:,
   it's merely my boot drive in a multi-boot installation. I
normally boot to my
   WinXP partition. I'd rather install it elsewhere.
  3) I do want to install it under Win XP.
  4) I already have MySQL installed, and I'm guessing that it's a later
version.

Do any of these represent serious barriers to installing PHP Triad?

Thanks to you, Richard and others for past and future help.
Robert
Matthew Moldvan [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]..
.
 Exactly what I was going to say ... go to www.download.com and search
for
 PHP Triad, which is PHP, Apache, and MySQL all in one for Windows, all
FREE.

 And yes, some web hosts are too cheap to give database access to their
 clients for their money.  If you want a good host, I can refer you to
one
 for a very reasonable price ...

 Regards,
 Matthew Moldvan

 ---
  System Administrator
  Trilogy International, Inc
  http://www.trilogyintl.com/ecommerce/
 ---

 -Original Message-
 From: Hutchins, Richard [mailto:[EMAIL PROTECTED]]
 Sent: Friday, January 03, 2003 4:50 PM
 To: 'Robert Wagner'; [EMAIL PROTECTED]
 Subject: RE: [PHP-DB] Re: Is MySQL available from my host.


 I'm pretty sure it is possible. Unless I'm wrong, PHP, by default, is
 compiled with MySQL support. So, what you're seeing could be a result
of
 that default condition. Just because it's compiled with support for
MySQL,
 doesn't necessarily mean that they will provide the database server.

 Please, other list members correct me if I'm wrong.

 On the other hand, you don't need a web host to try out dynamic web
pages.
 You can configure Apache, MySQL and PHP on your local machine and do
 everything locally that you would do remotely.

  -Original Message-
  From: Robert Wagner [mailto:[EMAIL PROTECTED]]
  Sent: Friday, January 03, 2003 4:48 PM
  To: [EMAIL PROTECTED]
  Subject: Re: [PHP-DB] Re: Is MySQL available from my host.
 
 
  Richard:
  Thanks for your rapid reply. What their tech support is saying is
   Sorry, we do not offer a database server. 
  Based on the results of the phpinfo output, is that possible?
  Thanks again,
  Robert
  --
  Richard Hutchins [EMAIL PROTECTED] wrote
  in message
  1EA7D3AE70ACD511BE6D006097A78C1E022BFC21@USROCEXC">news:1EA7D3AE70ACD511BE6D006097A78C1E022BFC21@USROCEXC...
   I know when I first started working with a host that provided
MySQL
  support,
   there was a very specific path I had to use in the connection
string
  because
   ...the MySQL server is behind a very strict firewall. If I
didn't
  use the
   path exactly as their prototype indicated, I'd get errors like you
  have
   posted.
  
   I'd suggest you check your host's self-help tech support pages,
drop
  them an
   e-mail or call them.
  
-Original Message-
From: Robert Wagner [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 4:27 PM
To: [EMAIL PROTECTED]
    Subject: [PHP-DB] Re: Is MySQL available from my host.
   
   
Robert Wagner [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 I recently signed up with a low-cost web server, in order
to do some
 web-page accessed database work. The server has PHP Version
4.0.6 and
 phpinfo() yields (in part):

   PHP Version 4.0.6

   System SunOS src 5.7 Generic_106541-12 sun4u sparc
 SUNW,UltraSPARC-IIi-cEngine
   Build Date Feb 28 2002
   Configure Command  './configure' '--disable-pear'
'--enable-ftp'
 '--with-sybase-ct=/usr/local/freetds' '--enable-trans-sid'
 '--enable-force-cgi-redirect'
   Server API CGI
   Virtual Directory Support disabled
   Configuration File (php.ini) Path
/usr/local/affinity/etc/php.ini
   ZEND_DEBUG disabled
   Thread Safety disabled

This program makes use of the Zend scripting language
  engine:
   Zend Engine v1.0.6, Copyright (c) 1998-2001 Zend
  Technologies



  |
 (Some output omitted here)
  |
 mysql
   MySQL Support enabled
   Active Persistent Links 0
   Active Links 0
   Client API version 3.23.32
   MYSQL_MODULE_TYPE builtin
   MYSQL_SOCKET /tmp/mysql.sock
   MYSQL_INCLUDE
   MYSQL_LIBS



   Directive Local Value Master Value
   mysql.allow_persistent
  On On
   mysql.default_host
  no value no value
   mysql.default_password
  no value no value

RE: [PHP-DB] Re: Is MySQL available from my host.

2003-01-06 Thread Matthew Moldvan 
Robert,

I've only played with the package, and had no trouble installing it on
Windows XP.  I did install it on my C: drive, but I see no reason (unless
there is something I missed in the documentation) why a simple edit of the
configuration files wouldn't change that ...

I would pretty much sum up the rest of the issues with user error.
Installing PHP Triad isn't a big deal, I'm not even sure if it makes any
registry changes ... and because (I'm assuming) you're not using it for a
production environment, it should not pose any kind of threat to your
system.  Basically all it does is start the Apache server and allow it to
interface with MySQL through configured parameters.

Like I said, I haven't played with it too much, because my web host does
support PHP and MySQL, but when I recently had a lapse in internet service,
I tinkered with it a tiny bit.

Regards,
Matthew Moldvan.
   System Administrator
Trilogy International
http://www.trilogyintl.com/ecommerce

-Original Message-
From: Robert Wagner [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 11:22 AM
To: Matthew Moldvan
Subject: Re: [PHP-DB] Re: Is MySQL available from my host.


At www.download.com I located PHP Triad, but I'm a bit nervous, although
the overall ratings for the package are high. Here are my concerns:
  1) Some people couldn't install it all.
  2) Apparently it MUST be installed on drive C. While I have over 500
MB in C:,
   it's merely my boot drive in a multi-boot installation. I
normally boot to my
   WinXP partition. I'd rather install it elsewhere.
  3) I do want to install it under Win XP.
  4) I already have MySQL installed, and I'm guessing that it's a later
version.

Do any of these represent serious barriers to installing PHP Triad?

Thanks to you, Richard and others for past and future help.
Robert
Matthew Moldvan [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]..
.
 Exactly what I was going to say ... go to www.download.com and search
for
 PHP Triad, which is PHP, Apache, and MySQL all in one for Windows, all
FREE.

 And yes, some web hosts are too cheap to give database access to their
 clients for their money.  If you want a good host, I can refer you to
one
 for a very reasonable price ...

 Regards,
 Matthew Moldvan

 ---
  System Administrator
  Trilogy International, Inc
  http://www.trilogyintl.com/ecommerce/
 ---

 -Original Message-
 From: Hutchins, Richard [mailto:[EMAIL PROTECTED]]
 Sent: Friday, January 03, 2003 4:50 PM
 To: 'Robert Wagner'; [EMAIL PROTECTED]
 Subject: RE: [PHP-DB] Re: Is MySQL available from my host.


 I'm pretty sure it is possible. Unless I'm wrong, PHP, by default, is
 compiled with MySQL support. So, what you're seeing could be a result
of
 that default condition. Just because it's compiled with support for
MySQL,
 doesn't necessarily mean that they will provide the database server.

 Please, other list members correct me if I'm wrong.

 On the other hand, you don't need a web host to try out dynamic web
pages.
 You can configure Apache, MySQL and PHP on your local machine and do
 everything locally that you would do remotely.

  -Original Message-
  From: Robert Wagner [mailto:[EMAIL PROTECTED]]
  Sent: Friday, January 03, 2003 4:48 PM
  To: [EMAIL PROTECTED]
  Subject: Re: [PHP-DB] Re: Is MySQL available from my host.
 
 
  Richard:
  Thanks for your rapid reply. What their tech support is saying is
   Sorry, we do not offer a database server. 
  Based on the results of the phpinfo output, is that possible?
  Thanks again,
  Robert
  --
  Richard Hutchins [EMAIL PROTECTED] wrote
  in message
  1EA7D3AE70ACD511BE6D006097A78C1E022BFC21@USROCEXC">news:1EA7D3AE70ACD511BE6D006097A78C1E022BFC21@USROCEXC...
   I know when I first started working with a host that provided
MySQL
  support,
   there was a very specific path I had to use in the connection
string
  because
   ...the MySQL server is behind a very strict firewall. If I
didn't
  use the
   path exactly as their prototype indicated, I'd get errors like you
  have
   posted.
  
   I'd suggest you check your host's self-help tech support pages,
drop
  them an
   e-mail or call them.
  
-Original Message-
From: Robert Wagner [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 4:27 PM
To: [EMAIL PROTECTED]
    Subject: [PHP-DB] Re: Is MySQL available from my host.
   
   
Robert Wagner [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 I recently signed up with a low-cost web server, in order
to do some
 web-page accessed database work. The server has PHP Version
4.0.6 and
 phpinfo() yields (in part):

   PHP Version 4.0.6

   System SunOS src 5.7 Generic_106541-12 sun4u sparc
 SUNW,UltraSPARC-IIi-cEngine

Re: [PHP-DB] Re: Is MySQL available from my host.

2003-01-06 Thread Leo G. Divingracia III 
Robert Wagner wrote:

At www.download.com I located PHP Triad, but I'm a bit nervous, although
the overall ratings for the package are high. Here are my concerns:
  1) Some people couldn't install it all.
  2) Apparently it MUST be installed on drive C. While I have over 500
MB in C:,
   it's merely my boot drive in a multi-boot installation. I
normally boot to my
   WinXP partition. I'd rather install it elsewhere.
  3) I do want to install it under Win XP.
  4) I already have MySQL installed, and I'm guessing that it's a later
version.

Do any of these represent serious barriers to installing PHP Triad?




another WAMP that i use is www.foxserv.net.  they use apache 2.0 and a 
4.2.x php.  forget the mysql version.

but why not install it yourself.

php requires about 3-4 lines added to apache's conf file.  php requires 
maybe 2-3 mods in the it's ini file.

mysql is a no brainer install...

i recently upgraded my foxserv install by doing each one manually. 
after a few hours of almost killing myself, i got it down to about 15 
minutes.  that's total for all 3.  i didnt want to go through foxserv 
since they install perl and a few others i didnt want.  (plus the first 
time, it nearly killed my programming machine...).


--
Leo G. Divinagracia III
[EMAIL PROTECTED]

z


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: Is MySQL available from my host.

2003-01-03 Thread Hutchins, Richard 
I know when I first started working with a host that provided MySQL support,
there was a very specific path I had to use in the connection string because
...the MySQL server is behind a very strict firewall. If I didn't use the
path exactly as their prototype indicated, I'd get errors like you have
posted.

I'd suggest you check your host's self-help tech support pages, drop them an
e-mail or call them.

 -Original Message-
 From: Robert Wagner [mailto:[EMAIL PROTECTED]]
 Sent: Friday, January 03, 2003 4:27 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] Re: Is MySQL available from my host.
 
 
 Robert Wagner [EMAIL PROTECTED] wrote in message
 [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
  I recently signed up with a low-cost web server, in order 
 to do some
  web-page accessed database work. The server has PHP Version 
 4.0.6 and
  phpinfo() yields (in part):
 
PHP Version 4.0.6
 
System SunOS src 5.7 Generic_106541-12 sun4u sparc
  SUNW,UltraSPARC-IIi-cEngine
Build Date Feb 28 2002
Configure Command  './configure' '--disable-pear' 
 '--enable-ftp'
  '--with-sybase-ct=/usr/local/freetds' '--enable-trans-sid'
  '--enable-force-cgi-redirect'
Server API CGI
Virtual Directory Support disabled
Configuration File (php.ini) Path
 /usr/local/affinity/etc/php.ini
ZEND_DEBUG disabled
Thread Safety disabled
 
 This program makes use of the Zend scripting language engine:
Zend Engine v1.0.6, Copyright (c) 1998-2001 Zend Technologies
 
 
 
   |
  (Some output omitted here)
   |
  mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.32
MYSQL_MODULE_TYPE builtin
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE
MYSQL_LIBS
 
 
 
Directive Local Value Master Value
mysql.allow_persistent
   On On
mysql.default_host
   no value no value
mysql.default_password
   no value no value
mysql.default_port
   no value no value
mysql.default_socket
   no value no value
mysql.default_user
   no value no value
mysql.max_links
   Unlimited Unlimited
mysql.max_persistent
   Unlimited Unlimited
 
 
  ftp
FTP support enabled
 
 
  Additional Modules
 
 
  Environment
Variable Value
TZ US/Pacific
DOCUMENT_ROOT /nfs/cust/9/36/06/260639/web
HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, 
 image/pjpeg,
  application/vnd.ms-excel, application/msword,
  application/vnd.ms-powerpoint, application/x-shockwave-flash, */*
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_ACCEPT_LANGUAGE en-us
HTTP_CONNECTION Keep-Alive
HTTP_HOST www.mymain.com  (Renamed for his message!)
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
 5.1)
PATH /usr/bin:/bin:/usr/local/bin
REDIRECT_DOCUMENT_ROOT /nfs/cust/9/36/06/260639/web
REDIRECT_STATUS 200
REDIRECT_URL /Experiments/PHP_Info.php
REMOTE_ADDR (Deleted for this message)
REMOTE_PORT 7016
SCRIPT_FILENAME /usr/local/apache/cgi-bin/php.cgi
SERVER_ADDR 10.3.1.126
SERVER_ADMIN [EMAIL PROTECTED]  (Renamed for his message!)
SERVER_NAME www.mymain.com  (Renamed for his message!)
SERVER_PORT 80
SERVER_SIGNATURE
SERVER_SOFTWARE Apache/1.3.26 (Unix) mod_mhp mod_mhp_log
  mod_virtcgi frontPage/5.0 mod_status_mhp
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING
REQUEST_URI /Experiments/PHP_Info.php
SCRIPT_NAME /bin/php.cgi
PATH_INFO /Experiments/PHP_Info.php
PATH_TRANSLATED
  /nfs/cust/9/36/06/260639/web/ET_Experiments/PHP_Info.php
REMOTE_HOST (Deleted for this message)
  (Moreoutput omitted after this)
 ---
 When I posted my original message, I forgot to include the result I'm
 getting from the script:
 ?php
mysql_connect() or
die(Could not connect (sob):  . mysql_error());
printf (MySQL host info: %s\n, mysql_get_host_info());
 ?
 --
 The result:
 --
 Warning: Can't connect to local MySQL server through socket
 '/tmp/mysql.sock' (2) in
 /nfs/cust/9/36/06/260639/web/ET_Experiments/MySQL_Info.php on line 7
 
 Warning: MySQL Connection Failed: Can't connect to local MySQL server
 through socket '/tmp/mysql.sock' (2) in
 /nfs/cust/9/36/06/260639/web/ET_Experiments/MySQL_Info.php on line 7
 Could not connect (sob): Can't connect to local MySQL server through
 socket '/tmp/mysql.sock' (2)
 ---
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Is MySQL available from my host.

2003-01-03 Thread Robert Wagner 
Richard:
Thanks for your rapid reply. What their tech support is saying is
 Sorry, we do not offer a database server. 
Based on the results of the phpinfo output, is that possible?
Thanks again,
Robert
--
Richard Hutchins [EMAIL PROTECTED] wrote in message
1EA7D3AE70ACD511BE6D006097A78C1E022BFC21@USROCEXC">news:1EA7D3AE70ACD511BE6D006097A78C1E022BFC21@USROCEXC...
 I know when I first started working with a host that provided MySQL
support,
 there was a very specific path I had to use in the connection string
because
 ...the MySQL server is behind a very strict firewall. If I didn't
use the
 path exactly as their prototype indicated, I'd get errors like you
have
 posted.

 I'd suggest you check your host's self-help tech support pages, drop
them an
 e-mail or call them.

  -Original Message-
  From: Robert Wagner [mailto:[EMAIL PROTECTED]]
  Sent: Friday, January 03, 2003 4:27 PM
  To: [EMAIL PROTECTED]
  Subject: [PHP-DB] Re: Is MySQL available from my host.
 
 
  Robert Wagner [EMAIL PROTECTED] wrote in message
  [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
   I recently signed up with a low-cost web server, in order
  to do some
   web-page accessed database work. The server has PHP Version
  4.0.6 and
   phpinfo() yields (in part):
  
 PHP Version 4.0.6
  
 System SunOS src 5.7 Generic_106541-12 sun4u sparc
   SUNW,UltraSPARC-IIi-cEngine
 Build Date Feb 28 2002
 Configure Command  './configure' '--disable-pear'
  '--enable-ftp'
   '--with-sybase-ct=/usr/local/freetds' '--enable-trans-sid'
   '--enable-force-cgi-redirect'
 Server API CGI
 Virtual Directory Support disabled
 Configuration File (php.ini) Path
  /usr/local/affinity/etc/php.ini
 ZEND_DEBUG disabled
 Thread Safety disabled
  
  This program makes use of the Zend scripting language
engine:
 Zend Engine v1.0.6, Copyright (c) 1998-2001 Zend
Technologies
  
  
  
|
   (Some output omitted here)
|
   mysql
 MySQL Support enabled
 Active Persistent Links 0
 Active Links 0
 Client API version 3.23.32
 MYSQL_MODULE_TYPE builtin
 MYSQL_SOCKET /tmp/mysql.sock
 MYSQL_INCLUDE
 MYSQL_LIBS
  
  
  
 Directive Local Value Master Value
 mysql.allow_persistent
On On
 mysql.default_host
no value no value
 mysql.default_password
no value no value
 mysql.default_port
no value no value
 mysql.default_socket
no value no value
 mysql.default_user
no value no value
 mysql.max_links
Unlimited Unlimited
 mysql.max_persistent
Unlimited Unlimited
  
  
   ftp
 FTP support enabled
  
  
   Additional Modules
  
  
   Environment
 Variable Value
 TZ US/Pacific
 DOCUMENT_ROOT /nfs/cust/9/36/06/260639/web
 HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg,
  image/pjpeg,
   application/vnd.ms-excel, application/msword,
   application/vnd.ms-powerpoint, application/x-shockwave-flash, */*
 HTTP_ACCEPT_ENCODING gzip, deflate
 HTTP_ACCEPT_LANGUAGE en-us
 HTTP_CONNECTION Keep-Alive
 HTTP_HOST www.mymain.com  (Renamed for his message!)
 HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows
NT
  5.1)
 PATH /usr/bin:/bin:/usr/local/bin
 REDIRECT_DOCUMENT_ROOT /nfs/cust/9/36/06/260639/web
 REDIRECT_STATUS 200
 REDIRECT_URL /Experiments/PHP_Info.php
 REMOTE_ADDR (Deleted for this message)
 REMOTE_PORT 7016
 SCRIPT_FILENAME /usr/local/apache/cgi-bin/php.cgi
 SERVER_ADDR 10.3.1.126
 SERVER_ADMIN [EMAIL PROTECTED]  (Renamed for his
message!)
 SERVER_NAME www.mymain.com  (Renamed for his message!)
 SERVER_PORT 80
 SERVER_SIGNATURE
 SERVER_SOFTWARE Apache/1.3.26 (Unix) mod_mhp mod_mhp_log
   mod_virtcgi frontPage/5.0 mod_status_mhp
 GATEWAY_INTERFACE CGI/1.1
 SERVER_PROTOCOL HTTP/1.1
 REQUEST_METHOD GET
 QUERY_STRING
 REQUEST_URI /Experiments/PHP_Info.php
 SCRIPT_NAME /bin/php.cgi
 PATH_INFO /Experiments/PHP_Info.php
 PATH_TRANSLATED
   /nfs/cust/9/36/06/260639/web/ET_Experiments/PHP_Info.php
 REMOTE_HOST (Deleted for this message)
   (Moreoutput omitted after this)
  ---
  When I posted my original message, I forgot to include the result
I'm
  getting from the script:
  ?php
 mysql_connect() or
 die(Could not connect (sob):  . mysql_error());
 printf (MySQL host info: %s\n, mysql_get_host_info());
  ?
  --
  The result:
  --
  Warning: Can't connect to local MySQL server through socket
  '/tmp/mysql.sock' (2) in
  /nfs/cust/9/36/06/260639/web/ET_Experiments/MySQL_Info.php on line 7
 
  Warning: MySQL Connection Faile

RE: [PHP-DB] Re: Is MySQL available from my host.

2003-01-03 Thread Hutchins, Richard 
I'm pretty sure it is possible. Unless I'm wrong, PHP, by default, is
compiled with MySQL support. So, what you're seeing could be a result of
that default condition. Just because it's compiled with support for MySQL,
doesn't necessarily mean that they will provide the database server.

Please, other list members correct me if I'm wrong.

On the other hand, you don't need a web host to try out dynamic web pages.
You can configure Apache, MySQL and PHP on your local machine and do
everything locally that you would do remotely.

 -Original Message-
 From: Robert Wagner [mailto:[EMAIL PROTECTED]]
 Sent: Friday, January 03, 2003 4:48 PM
 To: [EMAIL PROTECTED]
 Subject: Re: [PHP-DB] Re: Is MySQL available from my host.
 
 
 Richard:
 Thanks for your rapid reply. What their tech support is saying is
  Sorry, we do not offer a database server. 
 Based on the results of the phpinfo output, is that possible?
 Thanks again,
 Robert
 --
 Richard Hutchins [EMAIL PROTECTED] wrote 
 in message
 1EA7D3AE70ACD511BE6D006097A78C1E022BFC21@USROCEXC">news:1EA7D3AE70ACD511BE6D006097A78C1E022BFC21@USROCEXC...
  I know when I first started working with a host that provided MySQL
 support,
  there was a very specific path I had to use in the connection string
 because
  ...the MySQL server is behind a very strict firewall. If I didn't
 use the
  path exactly as their prototype indicated, I'd get errors like you
 have
  posted.
 
  I'd suggest you check your host's self-help tech support pages, drop
 them an
  e-mail or call them.
 
   -Original Message-
   From: Robert Wagner [mailto:[EMAIL PROTECTED]]
   Sent: Friday, January 03, 2003 4:27 PM
   To: [EMAIL PROTECTED]
   Subject: [PHP-DB] Re: Is MySQL available from my host.
  
  
   Robert Wagner [EMAIL PROTECTED] wrote in message
   [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I recently signed up with a low-cost web server, in order
   to do some
web-page accessed database work. The server has PHP Version
   4.0.6 and
phpinfo() yields (in part):
   
  PHP Version 4.0.6
   
  System SunOS src 5.7 Generic_106541-12 sun4u sparc
SUNW,UltraSPARC-IIi-cEngine
  Build Date Feb 28 2002
  Configure Command  './configure' '--disable-pear'
   '--enable-ftp'
'--with-sybase-ct=/usr/local/freetds' '--enable-trans-sid'
'--enable-force-cgi-redirect'
  Server API CGI
  Virtual Directory Support disabled
  Configuration File (php.ini) Path
   /usr/local/affinity/etc/php.ini
  ZEND_DEBUG disabled
  Thread Safety disabled
   
   This program makes use of the Zend scripting language
 engine:
  Zend Engine v1.0.6, Copyright (c) 1998-2001 Zend
 Technologies
   
   
   
 |
(Some output omitted here)
 |
mysql
  MySQL Support enabled
  Active Persistent Links 0
  Active Links 0
  Client API version 3.23.32
  MYSQL_MODULE_TYPE builtin
  MYSQL_SOCKET /tmp/mysql.sock
  MYSQL_INCLUDE
  MYSQL_LIBS
   
   
   
  Directive Local Value Master Value
  mysql.allow_persistent
 On On
  mysql.default_host
 no value no value
  mysql.default_password
 no value no value
  mysql.default_port
 no value no value
  mysql.default_socket
 no value no value
  mysql.default_user
 no value no value
  mysql.max_links
 Unlimited Unlimited
  mysql.max_persistent
 Unlimited Unlimited
   
   
ftp
  FTP support enabled
   
   
Additional Modules
   
   
Environment
  Variable Value
  TZ US/Pacific
  DOCUMENT_ROOT /nfs/cust/9/36/06/260639/web
  HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg,
   image/pjpeg,
application/vnd.ms-excel, application/msword,
application/vnd.ms-powerpoint, 
 application/x-shockwave-flash, */*
  HTTP_ACCEPT_ENCODING gzip, deflate
  HTTP_ACCEPT_LANGUAGE en-us
  HTTP_CONNECTION Keep-Alive
  HTTP_HOST www.mymain.com  (Renamed for his message!)
  HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows
 NT
   5.1)
  PATH /usr/bin:/bin:/usr/local/bin
  REDIRECT_DOCUMENT_ROOT /nfs/cust/9/36/06/260639/web
  REDIRECT_STATUS 200
  REDIRECT_URL /Experiments/PHP_Info.php
  REMOTE_ADDR (Deleted for this message)
  REMOTE_PORT 7016
  SCRIPT_FILENAME /usr/local/apache/cgi-bin/php.cgi
  SERVER_ADDR 10.3.1.126
  SERVER_ADMIN [EMAIL PROTECTED]  (Renamed for his
 message!)
  SERVER_NAME www.mymain.com  (Renamed for his message!)
  SERVER_PORT 80
  SERVER_SIGNATURE
  SERVER_SOFTWARE Apache/1.3.26 (Unix) mod_mhp mod_mhp_log
mod_virtcgi frontPage/5.0 mod_status_mhp
  GATEWAY_INTERFACE CGI/1.1

RE: [PHP-DB] Re: Is MySQL available from my host.

2003-01-03 Thread Matthew Moldvan 
Exactly what I was going to say ... go to www.download.com and search for
PHP Triad, which is PHP, Apache, and MySQL all in one for Windows, all FREE.

And yes, some web hosts are too cheap to give database access to their
clients for their money.  If you want a good host, I can refer you to one
for a very reasonable price ...

Regards,
Matthew Moldvan

---
 System Administrator
 Trilogy International, Inc
 http://www.trilogyintl.com/ecommerce/
---

-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 4:50 PM
To: 'Robert Wagner'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: Is MySQL available from my host.


I'm pretty sure it is possible. Unless I'm wrong, PHP, by default, is
compiled with MySQL support. So, what you're seeing could be a result of
that default condition. Just because it's compiled with support for MySQL,
doesn't necessarily mean that they will provide the database server.

Please, other list members correct me if I'm wrong.

On the other hand, you don't need a web host to try out dynamic web pages.
You can configure Apache, MySQL and PHP on your local machine and do
everything locally that you would do remotely.

 -Original Message-
 From: Robert Wagner [mailto:[EMAIL PROTECTED]]
 Sent: Friday, January 03, 2003 4:48 PM
 To: [EMAIL PROTECTED]
 Subject: Re: [PHP-DB] Re: Is MySQL available from my host.
 
 
 Richard:
 Thanks for your rapid reply. What their tech support is saying is
  Sorry, we do not offer a database server. 
 Based on the results of the phpinfo output, is that possible?
 Thanks again,
 Robert
 --
 Richard Hutchins [EMAIL PROTECTED] wrote 
 in message
 1EA7D3AE70ACD511BE6D006097A78C1E022BFC21@USROCEXC">news:1EA7D3AE70ACD511BE6D006097A78C1E022BFC21@USROCEXC...
  I know when I first started working with a host that provided MySQL
 support,
  there was a very specific path I had to use in the connection string
 because
  ...the MySQL server is behind a very strict firewall. If I didn't
 use the
  path exactly as their prototype indicated, I'd get errors like you
 have
  posted.
 
  I'd suggest you check your host's self-help tech support pages, drop
 them an
  e-mail or call them.
 
   -Original Message-
   From: Robert Wagner [mailto:[EMAIL PROTECTED]]
   Sent: Friday, January 03, 2003 4:27 PM
   To: [EMAIL PROTECTED]
   Subject: [PHP-DB] Re: Is MySQL available from my host.
  
  
   Robert Wagner [EMAIL PROTECTED] wrote in message
   [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I recently signed up with a low-cost web server, in order
   to do some
web-page accessed database work. The server has PHP Version
   4.0.6 and
phpinfo() yields (in part):
   
  PHP Version 4.0.6
   
  System SunOS src 5.7 Generic_106541-12 sun4u sparc
SUNW,UltraSPARC-IIi-cEngine
  Build Date Feb 28 2002
  Configure Command  './configure' '--disable-pear'
   '--enable-ftp'
'--with-sybase-ct=/usr/local/freetds' '--enable-trans-sid'
'--enable-force-cgi-redirect'
  Server API CGI
  Virtual Directory Support disabled
  Configuration File (php.ini) Path
   /usr/local/affinity/etc/php.ini
  ZEND_DEBUG disabled
  Thread Safety disabled
   
   This program makes use of the Zend scripting language
 engine:
  Zend Engine v1.0.6, Copyright (c) 1998-2001 Zend
 Technologies
   
   
   
 |
(Some output omitted here)
 |
mysql
  MySQL Support enabled
  Active Persistent Links 0
  Active Links 0
  Client API version 3.23.32
  MYSQL_MODULE_TYPE builtin
  MYSQL_SOCKET /tmp/mysql.sock
  MYSQL_INCLUDE
  MYSQL_LIBS
   
   
   
  Directive Local Value Master Value
  mysql.allow_persistent
 On On
  mysql.default_host
 no value no value
  mysql.default_password
 no value no value
  mysql.default_port
 no value no value
  mysql.default_socket
 no value no value
  mysql.default_user
 no value no value
  mysql.max_links
 Unlimited Unlimited
  mysql.max_persistent
 Unlimited Unlimited
   
   
ftp
  FTP support enabled
   
   
Additional Modules
   
   
Environment
  Variable Value
  TZ US/Pacific
  DOCUMENT_ROOT /nfs/cust/9/36/06/260639/web
  HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg,
   image/pjpeg,
application/vnd.ms-excel, application/msword,
application/vnd.ms-powerpoint, 
 application/x-shockwave-flash, */*
  HTTP_ACCEPT_ENCODING gzip, deflate
  HTTP_ACCEPT_LANGUAGE en-us
  HTTP_CONNECTION Keep-Alive
  HTTP_HOST www.mymain.com  (Renamed for his message!)
  HTTP_USER_AGENT Mozilla