Search found 30 matches

by rf
Wed Aug 16, 2006 12:30 am
Forum: Off Topic
Topic: date conversion for MySQL
Replies: 9
Views: 46140

Followup: :D Thanks for listening and responding. In FSR this program worked perfectly! :file named date.fsr :program to change date from mm/dd/yyyy format to yyyy-mm-dd format "{[0-9][0-9]}/{[0-9][0-9]}/{[0-9][0-9][0-9][0-9]}" "{3}-{1}-{2}" -c It is a DOS program! I am glad we still have DOS! Thank...
by rf
Tue Aug 15, 2006 6:51 pm
Forum: Off Topic
Topic: date conversion for MySQL
Replies: 9
Views: 46140

It looks like that should work. This is my experience: The first line in the text file is: "Some Name 1023 01/13/2005 BHHEC 58 0 1 64 140 NULLI NULLI NULLI NULLI NULLI NULLI NULLI NULLI NULLI NULLI NULLI NULLI NULLI NULLI NULLI NULLI 3 3 NULLI NULLI NULLI NULLI NULLI NULLI NULLI NULLI 0.444 -1.3 -0....
by rf
Tue Aug 15, 2006 5:23 pm
Forum: Off Topic
Topic: date conversion for MySQL
Replies: 9
Views: 46140

In a text file there is a date in each line in the form mm/dd/yyyy. This date form needs to be converted into the form yyyy-mm-dd. I am working in Linux. I tried from a terminal control line # date+%y-%m-%d and get the response "command not found" I tried it in a text editor replacing "08/20/1996" w...
by rf
Tue Aug 15, 2006 4:08 pm
Forum: Off Topic
Topic: date conversion for MySQL
Replies: 9
Views: 46140

Thanks for the response. :)

Give me an example of how to use:
You can use date...
date +%Y-%m-%d
rf :D
by rf
Tue Aug 15, 2006 1:06 pm
Forum: Off Topic
Topic: date conversion for MySQL
Replies: 9
Views: 46140

date conversion for MySQL

I need a grep or FSR or AWK or some miniprogram/statement that will convert 08/16/2006 date format into 2006-08-16 format in a text file. I am sure this would take an expert 30 seconds to do!

Thanks much :D

rf
by rf
Sun Aug 13, 2006 4:36 pm
Forum: Off Topic
Topic: Apache php MySQL phpMyAdmin
Replies: 3
Views: 32504

:( I don't understand the question is php compiled static into apache? or is it compiled using DSO? Further research reveals that I installed it using DSO (as a module during the ./configure stage). Re-installing (following Gilmore pg16 Beginning PHP 5 and MySQL) made no difference. I installed http...
by rf
Fri Aug 11, 2006 11:45 pm
Forum: Off Topic
Topic: Apache php MySQL phpMyAdmin
Replies: 3
Views: 32504

Apache php MySQL phpMyAdmin

Hi: On two identicle computers - one has MySQL, php, Apache, phpMyAdmin that works fine. On the other computer I have upgraded httpd-2.2.2 to httpd-2.2.3 MySQL from 5.0.20 to 5.0.24 and phpMyAdmin from 2.8.2 to 2.8.2.1 php-5.1.4 has stayed the same. :D But even though: httpd.conf config.inc.php and ...
by rf
Tue May 23, 2006 12:54 am
Forum: Off Topic
Topic: php - MySQL Authentication
Replies: 5
Views: 16879

:D Thanks much! Not knowing how to make sure that my php is compiled with the mysql client library that is compatible with the version of mysql server you are running - I did the following: cd /usr/src rm -r php-4.4.2 and php-5.1.2 and everything I could find that looked older then php-5.1.4 then re...
by rf
Mon May 22, 2006 12:25 am
Forum: Off Topic
Topic: php - MySQL Authentication
Replies: 5
Views: 16879

I do not know how to tell :( phpinfo() tells me: php version 5.1.4 ./configure --with-mysql --with etc. [mysql] client API version 3.23.56 mysql>status tells me: bin/mysql ver 14.12 Distrib 5.0.20 for pc-linus-gnu (i686) using readline 5.0 2 Questions: 1. How to tell if your php is complied with mys...
by rf
Sun May 21, 2006 7:18 pm
Forum: Off Topic
Topic: php - MySQL Authentication
Replies: 5
Views: 16879

php - MySQL Authentication

Hi, When I run this script (with the correct password) : <php> $host="localhost"; $user="rf"; $password="correct"; if ($mysql_conn=mysql_connect($host, $user, '$password')) { $message = mysql_error(); echo "$message\n"; die("cannot connect to server\n"); print $mysql_conn; } <?> I get this error mes...
by rf
Wed May 17, 2006 10:32 pm
Forum: Off Topic
Topic: PHP-5 fastcgi
Replies: 8
Views: 22183

Follow Up: I have gotten the browser to recognize and run php file well now doing two things: a) remove the two lines that referenced fast-cgi from httpd.conf: "AddType application/x-httpd-fastphp .php Action application/x-httpd-fastphp /php-fastcgi/php5-fcgi" b) made this change in php.ini: open_ba...
by rf
Fri May 12, 2006 12:13 am
Forum: Off Topic
Topic: PHP-5 fastcgi
Replies: 8
Views: 22183

munky, Thanks for the advice: updatedb locate php-fastcgi finds nothing # grep -i scriptalias /usr/local/apache2/conf/httpd.conf returns: # ScriptAlias: This controls which directories contain server scripts. # ScriptAliases are essentially the same as Aliases, except that # client. The same rules a...
by rf
Thu May 11, 2006 11:09 pm
Forum: Off Topic
Topic: gpg verify download
Replies: 4
Views: 14803

munkey, Thank you. Your help is much appreciated. I have been able to verify the two downloaded files I needed to. This is much appreciated. My system is not quite as friendly as your is. When I md5sum -c file.tar.bz2.md5 I get nothing in response. However if I compare the cat file.tar.bz2 number wi...
by rf
Wed May 10, 2006 10:42 pm
Forum: Off Topic
Topic: gpg verify download
Replies: 4
Views: 14803

Thanks for the reply. Below is what I did and the responses: rf@P4-3200RF:~$ md5sum -c httpd-2.2.2.tar.bz2.asc md5sum: no files checked rf@P4-3200RF:~$ gpg httpd-2.2.2.tar.bz2.asc gpg: keyring `/home/rf/.gnupg/secring.gpg' created Detached signature. Please enter name of data file: httpd-2.2.2.tar.b...
by rf
Wed May 10, 2006 5:24 pm
Forum: Off Topic
Topic: gpg verify download
Replies: 4
Views: 14803

gpg verify download

Hi, It is my understanding that the [gpg] and [md5] next to a binary file to download a program such as Apache is for the purpose of verifying the integrity of the download. My question is how do you do that? gpg httpd-2.2.2..tar.gz returns an error message: "No valid Open PGP data found. processing...