[PHP-DB] Re: Connect to Oracle DB
Frederico Madeia [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] ... How i connect one server running PHP(linux) to other server running Oracle(linux) ?? when i tryed to connect with ora_logon, the server return me: Call to undefined function: ora_logon(). 1) the oracle extension is not loaded. You need to compile php with it. BUT, you should use --with-oci8 and not --with-oracle. The oracle extension (ora_logon function and friends) is an old one, it can only connect to an oracle 7 database. With the oci extension (ocilogon function and friends), you can connect an oracle 7, 8 or 9 database (see http://fr.php.net/manual/en/ref.oci8.php) May be http://www.enderunix.org/documents/eng/php_oracle_en.html could help you too. 2) php compiled with oci extension is not enough. You need the oracle client. Unfortunately, for Linux, you can't download it alone. You need to download the entire oracle database : see http://otn.oracle.com/software/content.html or ask your DBA : he should be able to give you this oracle client for linux. In php.net describe some functions to connect to oracle,. but how i make to do work ??? I must install oracle on same server that runing php ?? no, you can have two servers. Tanks. Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] $PHP_SELF does not work with all browsers
I wrote a page browser that allows me to list different persons in a table according to the first alphabet-letter of their name Thus if I choose letter nr 65 (A): $chrLettre = chr(65); $chosenLettre = $chrLettre; echo a href=\$PHP_SELF?chosenLettre\.$chosenLettre./a\n; 1) Station Linux-RedHat-7.2 apache 1.3 php-4.0 mozilla 0.9 No problem with KDE Konqueror. I read the Url: http://localhost/~webpage/listPersons.php?chosenLettre=65 But with Mozilla: http://localhost/~webpage/?chosenLettre=65 /// where is $PHP_SELF It doesn't forward to the same page ($SELF_PHP) and I end up in http://localhost/~webpage/ 2) Station W2000 php 4.3.2 apache 1.3 mozilla ? No problems I can browse all the pages. Reason? Is there a incapability to interpret certain PHP instructions in Mozilla-0.9 ($PHP_SELF in this case) for Linux? -- Alain Barthélemy [EMAIL PROTECTED] http://bartydeux.be Linux User #315631 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] $PHP_SELF does not work with all browsers
on 15/9/03 1:46 pm, Alain Barthélemy at [EMAIL PROTECTED] wrote: http://localhost/~webpage/?chosenLettre=65 /// where is $PHP_SELF Try using $_SERVER['PHP_SELF'] -- Mike Karthauser Managing Director - Brightstorm Ltd Email[EMAIL PROTECTED] Web http://www.brightstorm.co.uk Tel 0117 9426653 (office) 07939 252144 (mobile) SnailmailUnit 8, 14 King Square, Bristol BS2 8JJ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Connect to Oracle DB
I just wanted to add my two cents ... I have compiled php with BOTH --with-oracle and --with-oci8. It is usually preferred to have your architectures/systems separate to prevent some performance issues. As a test/demo system then having them on the same box is perfectly acceptable and removes some of the setup issues. The standard oracle (--with-oracle) extension provides basic oracle connectivity for versions 7, 8, and 9. The oci8 (--with-oci8) allows for Oracle 8i (and up) specific functions (LOBs and others). Just a note ... watch what versions of the Oracle client that you install. From my experience the Oracle 9i client can NOT connect to a pre-Oracle 8.0 database. I am connecting to 100+ different Oracle instances from 7.3.x to 9.2.x on many different OS (Solaris, HP, Linux, Windows). My php server is Red Hat Linux 7.2 with Apache. Roy A. Jones Oracle DBA Email: [EMAIL PROTECTED] USPHARMA Database Site Philippe Saladin [EMAIL PROTECTED] 15-Sep-2003 02:49 To [EMAIL PROTECTED] cc Subject [PHP-DB] Re: Connect to Oracle DB Frederico Madeia [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] ... How i connect one server running PHP(linux) to other server running Oracle(linux) ?? when i tryed to connect with ora_logon, the server return me: Call to undefined function: ora_logon(). 1) the oracle extension is not loaded. You need to compile php with it. BUT, you should use --with-oci8 and not --with-oracle. The oracle extension (ora_logon function and friends) is an old one, it can only connect to an oracle 7 database. With the oci extension (ocilogon function and friends), you can connect an oracle 7, 8 or 9 database (see http://fr.php.net/manual/en/ref.oci8.php) May be http://www.enderunix.org/documents/eng/php_oracle_en.html could help you too. 2) php compiled with oci extension is not enough. You need the oracle client. Unfortunately, for Linux, you can't download it alone. You need to download the entire oracle database : see http://otn.oracle.com/software/content.html or ask your DBA : he should be able to give you this oracle client for linux. In php.net describe some functions to connect to oracle,. but how i make to do work ??? I must install oracle on same server that runing php ?? no, you can have two servers. Tanks. Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] $PHP_SELF does not work with all browsers
Le lundi 15 septembre 2003, 14:16:15 ou environ mike karthauser [EMAIL PROTECTED] a écrit: on 15/9/03 1:46 pm, Alain Barthélemy at [EMAIL PROTECTED] wrote: http://localhost/~webpage/?chosenLettre=65 /// where is $PHP_SELF Try using $_SERVER['PHP_SELF'] -- Mike Karthauser Managing Director - Brightstorm Ltd Thank you but I solved the problém differently. I read on Google that certain versions of Mozilla had some bug thus I got rid of the Redhat-7.3 version of Mozilla.I downloaded the last version of FireBird and it works now (even faster). Sorry, I forgot I was in a PHP-DB list. It was OT. -- Alain Barthélemy [EMAIL PROTECTED] http://bartydeux.be Linux User #315631 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Need to Run a PHP script using CRON or ?
I have an application which creates temporary tables. My plan is to remove them after a 24 hour period and only those which are have a created time greater than 24 hours. That part I can do, my question is how will I be able to run this script which is a 2 part script. First thing I do is pull the names of the temporary tables which are going to be deleted from another table. From this result set, I need to DROP tables as well as remove the reference to them from the first table. I understand that I can run PHP from the command line but this would require PHP to installed as a CGI which I prefer not to do. I was hoping I that I could use CRON to run this script once a day... Any ideas? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Need to Run a PHP script using CRON or ?
From: Jonathan Villa [EMAIL PROTECTED] I have an application which creates temporary tables. My plan is to remove them after a 24 hour period and only those which are have a created time greater than 24 hours. That part I can do, my question is how will I be able to run this script which is a 2 part script. First thing I do is pull the names of the temporary tables which are going to be deleted from another table. From this result set, I need to DROP tables as well as remove the reference to them from the first table. I understand that I can run PHP from the command line but this would require PHP to installed as a CGI which I prefer not to do. I was hoping I that I could use CRON to run this script once a day... You can. Create a php script that does what you want. It should not create any output, either log status/error messages or send an email. If you save it as cron.php, you can use a command such as the following in your crontab: wget -q -O - www.domain.com/cron.php /dev/null I'm assuming you know the specifics of cron or can google for it. :) ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
AW: [PHP-DB] Need to Run a PHP script using CRON or ?
I used to have the same problem and solved it as follows: I wrote my php script and created my crontab runing the script with the lynx-browser. The output is sent to me via eMail in crontab e.g.: MAILTO:[EMAIL PROTECTED] 15 15 * * * lynx -dump http://www.myDomain.com/myScript.php That works fine ;-) [my English isn't fine - i know :-( ] Lars Jedinski -Ursprüngliche Nachricht- Von: Jonathan Villa [mailto:[EMAIL PROTECTED] Gesendet: Montag, 15. September 2003 21:41 An: [EMAIL PROTECTED] Betreff: [PHP-DB] Need to Run a PHP script using CRON or ? I have an application which creates temporary tables. My plan is to remove them after a 24 hour period and only those which are have a created time greater than 24 hours. That part I can do, my question is how will I be able to run this script which is a 2 part script. First thing I do is pull the names of the temporary tables which are going to be deleted from another table. From this result set, I need to DROP tables as well as remove the reference to them from the first table. I understand that I can run PHP from the command line but this would require PHP to installed as a CGI which I prefer not to do. I was hoping I that I could use CRON to run this script once a day... Any ideas? -- 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] Need to Run a PHP script using CRON or ?
Interesting... how does this fair concerning security? So I'll have to have this file located in my document root, is this a good thing? My current directory structure consists of several files located outside the doc root. I guess I could always include it onto a page On Mon, 2003-09-15 at 14:49, CPT John W. Holmes wrote: From: Jonathan Villa [EMAIL PROTECTED] I have an application which creates temporary tables. My plan is to remove them after a 24 hour period and only those which are have a created time greater than 24 hours. That part I can do, my question is how will I be able to run this script which is a 2 part script. First thing I do is pull the names of the temporary tables which are going to be deleted from another table. From this result set, I need to DROP tables as well as remove the reference to them from the first table. I understand that I can run PHP from the command line but this would require PHP to installed as a CGI which I prefer not to do. I was hoping I that I could use CRON to run this script once a day... You can. Create a php script that does what you want. It should not create any output, either log status/error messages or send an email. If you save it as cron.php, you can use a command such as the following in your crontab: wget -q -O - www.domain.com/cron.php /dev/null I'm assuming you know the specifics of cron or can google for it. :) ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Weird MSSQL problem
Hi everyone. I have a Redhat 8 box with Apache 2.0.40, PHP 4.3.1, FreeTDS 0.61 set to work with an MS-SQL2000 server. It works fine and I have no problems but today i found this. When i call specific stored procedures it retrieve no rows, and if i paste this query on the Query Analizer it works fine. The function mssql_num_fields() shows correctly the number of fields. The strange thing is that it was working a day ago (the same code). Any thoughts? -- ### # Martin Greco
[PHP-DB] Weird MSSQL problem
Hi everyone. I have a Redhat 8 box with Apache 2.0.40, PHP 4.3.1, FreeTDS 0.61 set to work with an MS-SQL2000 server. It works fine and I have no problems but today i found this. When i call specific stored procedures it retrieve no rows, and if i paste this query on the Query Analizer it works fine. The function mssql_num_fields() shows correctly the number of fields. The strange thing is that it was working a day ago (the same code). Any thoughts? -- ### # Martin Greco
Re: [PHP-DB] Need to Run a PHP script using CRON or ?
From: Jonathan Villa [EMAIL PROTECTED] wget -q -O - www.domain.com/cron.php /dev/null Interesting... how does this fair concerning security? So I'll have to have this file located in my document root, is this a good thing? My current directory structure consists of several files located outside the doc root. I guess I could always include it onto a page Well, I guess it would depend upon what your cron.php does. You must be aware that anyone can just type in the URL and run the script at any time, not just when the cron process runs it. For example, my cron.php script creates a mysql backup file and erases any backup files older than 30 days. When it runs, it first checks if the backup for today was already made or not. If it's already there, it does nothing. So, you can call this script all you want and it's not going to mess up anything. Again, it depends on what your script is doing, though. Yes, it's safer to keep it outside of the webroot and call it via the command line. This way you know it's only being called by cron and only when you want it. It just depends on whether you can do that on your system or not. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Need to Run a PHP script using CRON or ?
Not necessarily. You can wget /path/to/file.php or my personal preference is not to use wget, but php directly /path/to/php/executable /path/to/file.php Just a thought, Ryan -Original Message- From: Jonathan Villa [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2003 3:28 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Need to Run a PHP script using CRON or ? Interesting... how does this fair concerning security? So I'll have to have this file located in my document root, is this a good thing? My current directory structure consists of several files located outside the doc root. I guess I could always include it onto a page On Mon, 2003-09-15 at 14:49, CPT John W. Holmes wrote: From: Jonathan Villa [EMAIL PROTECTED] I have an application which creates temporary tables. My plan is to remove them after a 24 hour period and only those which are have a created time greater than 24 hours. That part I can do, my question is how will I be able to run this script which is a 2 part script. First thing I do is pull the names of the temporary tables which are going to be deleted from another table. From this result set, I need to DROP tables as well as remove the reference to them from the first table. I understand that I can run PHP from the command line but this would require PHP to installed as a CGI which I prefer not to do. I was hoping I that I could use CRON to run this script once a day... You can. Create a php script that does what you want. It should not create any output, either log status/error messages or send an email. If you save it as cron.php, you can use a command such as the following in your crontab: wget -q -O - www.domain.com/cron.php /dev/null I'm assuming you know the specifics of cron or can google for it. :) ---John Holmes... -- 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] Need to Run a PHP script using CRON or ?
From: Ryan Marks [EMAIL PROTECTED] Not necessarily. You can wget /path/to/file.php or my personal preference is not to use wget, but php directly /path/to/php/executable /path/to/file.php Are you sure about that? I thought wget had to go through HTTP? This didn't work for me, am I doing it wrong? $ ls cpanel3-skelmailpublic_html tmp cpanelbranding public_ftp test.phpwww $ wget test.php --16:42:22-- http://test.php/ = `index.html' Resolving test.php... failed: No address associated with hostname. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Need to Run a PHP script using CRON or ?
I believe this would need php to installed as a cgi, which I prefer not to do... On Mon, 2003-09-15 at 15:31, Ryan Marks wrote: Not necessarily. You can wget /path/to/file.php or my personal preference is not to use wget, but php directly /path/to/php/executable /path/to/file.php Just a thought, Ryan -Original Message- From: Jonathan Villa [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2003 3:28 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Need to Run a PHP script using CRON or ? Interesting... how does this fair concerning security? So I'll have to have this file located in my document root, is this a good thing? My current directory structure consists of several files located outside the doc root. I guess I could always include it onto a page On Mon, 2003-09-15 at 14:49, CPT John W. Holmes wrote: From: Jonathan Villa [EMAIL PROTECTED] I have an application which creates temporary tables. My plan is to remove them after a 24 hour period and only those which are have a created time greater than 24 hours. That part I can do, my question is how will I be able to run this script which is a 2 part script. First thing I do is pull the names of the temporary tables which are going to be deleted from another table. From this result set, I need to DROP tables as well as remove the reference to them from the first table. I understand that I can run PHP from the command line but this would require PHP to installed as a CGI which I prefer not to do. I was hoping I that I could use CRON to run this script once a day... You can. Create a php script that does what you want. It should not create any output, either log status/error messages or send an email. If you save it as cron.php, you can use a command such as the following in your crontab: wget -q -O - www.domain.com/cron.php /dev/null I'm assuming you know the specifics of cron or can google for it. :) ---John Holmes... -- 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] Need to Run a PHP script using CRON or ?
My bad... wget does require http or ftp protocol and a hostname that can be resolved by the server. -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2003 3:47 PM To: Ryan Marks; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Need to Run a PHP script using CRON or ? From: Ryan Marks [EMAIL PROTECTED] Not necessarily. You can wget /path/to/file.php or my personal preference is not to use wget, but php directly /path/to/php/executable /path/to/file.php Are you sure about that? I thought wget had to go through HTTP? This didn't work for me, am I doing it wrong? $ ls cpanel3-skelmailpublic_html tmp cpanelbranding public_ftp test.phpwww $ wget test.php --16:42:22-- http://test.php/ = `index.html' Resolving test.php... failed: No address associated with hostname. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Need to Run a PHP script using CRON or ?
--On Monday, September 15, 2003 15:27:45 -0500 Jonathan Villa [EMAIL PROTECTED] wrote: Interesting... how does this fair concerning security? So I'll have to have this file located in my document root, is this a good thing? My current directory structure consists of several files located outside the doc root. I guess I could always include it onto a page Unfortunately command-line fetch programs seldom provide a clean method for providing authentication info; so you probably can't just restrict access to that script based on a userid/password. (You might be able to do something with SSL and client certificates; but then you need to either buy a client cert or figure out how to set up a private certificate authority...) So, put it in a separate directory under ServerRoot and set up a name based virtual host with an Alias to provide access to that dir. Set the virtual host to reject connections from anything except your local host. Or use the same hostname; but have your VirtualHost listen on a non-standard port. Then your firewall can help block outside access to that port. How much that improves security depends on how you have that machine set up. If you are the only one with shell access; it's probably acceptably good. If untrusted people have shell access; then it's not much better than just sticking it in your datadir and hoping that nobody figures out its URL. -Pat -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Need to Run a PHP script using CRON or ?
Goto your shell and type php -i w/o the quotes. You should see the phpinfo() output. You can pass the path to your script as a command line variable, and it will process it. Here, read about it, I think this is the right answer for you: http://us3.php.net/features.commandline Matt On Mon, 2003-09-15 at 15:41, Jonathan Villa wrote: I have an application which creates temporary tables. My plan is to remove them after a 24 hour period and only those which are have a created time greater than 24 hours. That part I can do, my question is how will I be able to run this script which is a 2 part script. First thing I do is pull the names of the temporary tables which are going to be deleted from another table. From this result set, I need to DROP tables as well as remove the reference to them from the first table. I understand that I can run PHP from the command line but this would require PHP to installed as a CGI which I prefer not to do. I was hoping I that I could use CRON to run this script once a day... Any ideas? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Need to Run a PHP script using CRON or ?
- Original Message - From: Pat Lashley [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 15, 2003 5:12 PM Subject: Re: [PHP-DB] Need to Run a PHP script using CRON or ? --On Monday, September 15, 2003 15:27:45 -0500 Jonathan Villa [EMAIL PROTECTED] wrote: Interesting... how does this fair concerning security? So I'll have to have this file located in my document root, is this a good thing? My current directory structure consists of several files located outside the doc root. I guess I could always include it onto a page Unfortunately command-line fetch programs seldom provide a clean method for providing authentication info; so you probably can't just restrict access to that script based on a userid/password. (You might be able to do something with SSL and client certificates; but then you need to either buy a client cert or figure out how to set up a private certificate authority...) Getting off topic here, but you can specify user and password for wget. So you could protect the file with .htaccess and provide the user/login to wget. The only problem is the user/password will be available when you run ps. For a way to get around that, see the man page of wget. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: MS-SQL 2000 weird problem
On Mon, 15 Sep 2003 15:21:41 -0300, Martin Greco [EMAIL PROTECTED] wrote: Hi everyone. I have a Redhat 8 box with Apache 2.0.40, PHP 4.3.1, FreeTDS 0.61 to work with an MS-SQL2000 server. It works fine and I have no problems but today i found this. When i call specific stored procedures it retrieve no rows, and if i paste this query on the Query Analizer it works fine. The function mssql_num_fields() shows correctly the number of fields. I'm just taking a wild stab at this but maybe somethings changed with the database structure.. try re-saving the storedprocedure so it will update its cache. Curt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: [PHP] MS-SQL 2000 weird problem
Any thoughts? Are you dying and outputting an error where something could happen to bodge up the server? I'm not familiar with MS SQL Server, but I know under mysql: ?php $link = mysql_connect($host,$username,$password) or die(); // I forget the next line off the top of my head /* returns null if $link didn't work and we didn't die */ $result = mysql_query(SELECT * FROM table); ? -Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php