I'd like to thank everybody for the help they've given so far, and alas I still don't have this working. So, a couple questions.
I do have my own version of php compiled, so I pointed it to my version and I get an error, but more on that later.
If I use /usr/local/bin/php, and php isn't installed on the mail server, how does it know that
/PATH/TO/myphp/ is on my server and not the mail server? Just curious.
I'm not very familiar with linux, so, when you suggest using perl or python, I assume perl comes standard with most distros so I could run my script from the mail server?
The error I get after changing the script and rc file to be running my version of php is:
/home/PATH/TO/cgi-bin/php.cgi: error while loading shared libraries: libmysqlclient.so.14: cannot open shared object file: No such file or directory
Funny thing is, my script so far is just a skeleton and isn't doing anything mysql related. I installed using dreamhosts wiki
and it looks like there's mysql support in there, the end of the configure line is
and php, as far as I knew, came with mysql support. My site, through htaccess files, is pointed at my compiled version of php, and does all sorts of sql stuff just fine, so now I'm wondering if there is something I seriously overlooked.
Maybe its time to learn perl, though this stuff is really bothering me, and I'd like to get down to the bottom of it.