Can't connect to MySQL server using revOpenDatabase

Hershel Fisch hershrev at realtorsgroup.us
Mon Oct 18 16:46:29 EDT 2004


if you want you could contact me direct  . hershrev at realtorsgroup.us
Hershel
On Monday, October 18, 2004, at 04:41 PM, jbv wrote:

>
>
> Hershel,
>
> I actually tried every possible combination,
> but nothing works... I still get that error 61
> (or 10061 on Windows)...
>
> My problem is that I can't decide if it's a
> configuration problem on my server, or a Rev
> problem... Here's why : I was also trying to get
> a connection to MySQL with Rev-cgi linux (on the
> same server). And the right spelling (according to
> Rev documentation) for a DB that is listening on
> port 5432 is : localhost:5432 (instead of
> www.example.com:5432). But that doesn't work
> (same error).
> I finally managed to get that connection to MySQL with
> Rev-cgi by using : localhost (and dropping :5432).
>
> It works, but I really don't understand why...
>
> JB
>
>> What happens when you spell it out ?
>> on handler
>>    put
>> revOpenDatabase("MySQL","www.example.com:5432","myDB","myUSR","myPWD", 
>> (m
>> ake sure the last comma)) into tR
>>    answer tR
>> end handler
>> Hershel Fisch
>>
>> On Monday, October 18, 2004, at 07:05 AM, jbv wrote:
>>
>>> Hi list,
>>>
>>> Still fighting with databases connections...
>>>
>>> I'm trying to open a connection to MySQL using
>>> revOpenDatabase in the IDE and I get this error :
>>>
>>> Can't connect to MySQL server on 'www.example.com:5432' (61)
>>>
>>> ALTHOUGH IT WORKS WITH the DB Query
>>> Builder (connection status : connected) !!!!
>>>
>>> MySQL is configured on port 5432, which is open in
>>> the firewall.
>>> Here's the script I'm using :
>>>
>>> on mouseUp
>>>   put "root" into myUSR
>>>   put "******" into myPWD
>>>   revSetDatabaseDriverPath "/Macintosh HD/Desktop Folder/Revolution
>>> 2.5/components/global
>>> environment/database_drivers/MacOSX/dbmysql/Contents/MacOS/dbmysql"
>>>   get
>>> revOpenDatabase("MySQL","www.example.com:5432","myDB",myUSR,myPWD)
>>>
>>>   put it
>>> end mouseUp
>>>
>>> In the archives, I found a msg from someone saying
>>> that "root" isn't accepted by MySQL as user on a
>>> distant machine, but in that case why does it work
>>> in the DB Quary Builder ?
>>>
>>> What am I missing or doing wrong ?
>>>
>>> Thanks,
>>> JB
>>>
>>>
>>> _______________________________________________
>>> use-revolution mailing list
>>> use-revolution at lists.runrev.com
>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>>
>>
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>



More information about the Use-livecode mailing list