next »

[perkiset]

 

WOW I am complimented. I mean, I've learned a LOT of languages in my life - but they've all, for the most part been either Latin based or programming 

I'm afraid that I cannot help you with that request, my new friend. Please repost in English so that I can get my arms around what the trouble is.

Thanks!
 

[shenys]

10.gif is Correct
11.gif is wrong
thanks

[perkiset]

This looks like the phpMyAdmin record for the 172 connection is correct, but the database login information portion of the record is not. (that's what it appears anyway) - would you please run testinstall.php and post what response you receive?

[wingdog]

Dude, your the greatest! Thanks.

I have installed the stuff as said per your instructions and it all comes back as OK. Now how do I get this part to work?

I have been coding mysql Stored Procedures for quit some time and love them but this darn PHP stuff sucks. I really want to use your stuff. Will send money if need be. Thanks for any and all help.

v/r Bill

[perkiset]

What isn't working? What comes back from the test routine?

If all comes back OK, then you should be able to click on your database in the top panel, click the + button for a new script, name it "helloworld", then add the code to it:

SELECT 'Hello World!';

and click save. Then go to the command prompt, type "use [your database]" and then "call helloworld()" and you should see 'Hello World!' as the return. If this is all the case, then you're good to go and the next step is for you to learn how to actually implement the tool.

[skyfx]

@perkiset - I am having a problem similar to the one you helped solve on the 2nd page of this thread...my testinstall.php is returning:

Testing Prompt Handler
Testing: Connection                        Not Available

When I run the looptest.php that you asked for, it returned:

Dispatch Starts
Method: GET
Built GET String: ?testing=1
FinalURL: //apthread.php?testing=1
Outbound Header:
GET //apthread.php?testing=1 HTTP/1.1
Host: myURLhere
User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X; en) AppleWebKit/417.9 (KHTML, like Gecko) Safari/417.8
Accept: text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
Accept-Language: en-us,en;q=0.5
Accept-Encoding:
Accept-Charset: ISO-8859-1,utf-8:q=0.7,*;q=0.7
Connection: close

Content-Type: text/html
Content-Length: 0

Default beforeExecute()
Execute: Starts
Execute: HostStr=[myURLhere] Port:80
Execute: Cannot open socket
handleFailure()
Default afterExecute()

Any ideas ?

On a related note, once I have installed a procedure on my database, how do I execute the procedure from the command prompt? When I created a procedure called 'test', I tried running it via the cmd prompt and wrote 'execute test()', but that merely returns:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.test()' at line 1

Does that mean I have an error in line 1 of my procedure? Line 1 of my procedure just says:

PROCEDURE test()

[perkiset]

Hey SkyFX -

Execute: HostStr=[myURLhere] Port:80
Execute: Cannot open socket
handleFailure()
Default afterExecute()

That means that your PHP instance is not allowed to open up an HTTP session. I can't go look at the code write now, but I'm about 98% sure I use fopen - so either fopen is being blocked, or that type of transport is not available to fopen, or the machine that you're trying to access is not being addressed correctly. I don't recall immediately how you should be referencing the machine, but I notice that the "Final URL" parameter simply says, '//apthread.php' which I THINK means there's no host. That would fail, and also cause the symptom that you're seeing (meaning that you need to put host information in the configuration file).

On a related note, once I have installed a procedure on my database, how do I execute the procedure from the command prompt? When I created a procedure called 'test', I tried running it via the cmd prompt and wrote 'execute test()', but that merely returns:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.test()' at line 1

Does that mean I have an error in line 1 of my procedure? Line 1 of my procedure just says:

PROCEDURE test()

The actual syntax I use is "call myProc()" or, if you're writing a stored function it's "select myFunc()" The error is not in your stored procedure, it's that it doesn't understand "execute." I don't know if that is a MySQL command or not, but I'm pretty sure that my system wouldn't know how to handle it in any case.