Well to be truthful I haven't set up MySQL on on-rev recently, but at
dreamhost (I am running my own copy of Livecode server) I have to use a
special subdomain for the SQL 'server' address - NOT localhost. I think
one can use 'localhost' at on-rev, but some other restrictions might be in
the way.
A test: does your desktop version work with the on-rev SQL as a remote
client ? you can add IPs or entire domains in the cPanel : Databases :
Remote SQL
(you can use a * for all domains, easier but not recommended)
Also MySQL allows for IP restrictions so make sure that is ok.
On 30 September 2011 11:43, John Patten <johnpat...@mac.com> wrote:
> Hi Stephen...
>
> I tried it both ways. Originally it was .rev, but then with all the
> changes I thought that may have been good for only existing code on the
> server so I switched it to .lc
>
> It didn't help though :-(
>
>
> In terms of the MySQl account and IP and cross-domain restrictions, that
> would be relevant if I'm using the MySQl on the on-rev server too?
>
> Thank you!
>
> John Patten
> SUSD
>
> On Sep 30, 2011, at 11:22 AM, stephen barncard wrote:
>
> > Also check your MySQL account for any IP or cross-domain restrictions.
> >
> > On 30 September 2011 11:20, stephen barncard <
> > stephenrevoluti...@barncard.com> wrote:
> >
> >> how did you name the file? with a .lc or .rev suffix?
> >>
> >>
> >> On 30 September 2011 11:12, John Patten <johnpat...@mac.com> wrote:
> >>
> >>> Hi All..
> >>>
> >>> I duplicated a script that is working to send data to on-rev mysql
> >>> database in another project. The new project keeps throwing up a server
> >>> connection error.
> >>>
> >>> I've tried to boil it down to the most basic components to trouble
> shoot,
> >>> but I still get errors. I 'have looked for typos over and over but
> don't see
> >>> anything. Here is what I have in its most basic form:
> >>>
> >>> <?lc
> >>>
> >>> put $_POST["mymessage"] into mymessage
> >>> set itemDel to tab
> >>>
> >>> put item 1 of mymessage into tTargetPerson
> >>> put item 2 of mymessage into tTargetNorm
> >>> put itemDel into tCurrentItemDel
> >>> set the itemDel to "|"
> >>> put item 1 of tTargetNorm into tNorm_heading
> >>> put item 2 of tTargetNorm into tNorm_topic
> >>> set the itemDel to tab
> >>> put item 3 of mymessage into tEventDescription
> >>>
> >>> put "localhost" into tDatabaseAddress
> >>> put "xxxxxx_norms" into tDatabaseName
> >>> put "xxxxxx_normuser" into tDatabaseuser
> >>> put "xxxxxxx" into tDatabasePassword
> >>>
> >>> put tDatabaseAddress & " " & tDatabaseName & " " & tDatabaseuser & " "
> &
> >>> tDatabasePassword into tResult
> >>> --put revOpenDatabase("mysql", tDatabaseAddress, tDatabaseName,
> >>> tDatabaseuser, tDatabasePassword) into tResult
> >>> --if tResult is not a number then
> >>> --put "Error: could not connect to database " & tResult
> >>> --else
> >>> --put "target_person, norm_heading, norm_topic, description" into
> tFields
> >>> --put "INSERT INTO norms " & "(" & tFields & ") & VALUES (:1, :2, :3,
> :4)"
> >>> into tSQL
> >>> answer tResult
> >>> --revExecuteSQL tResult, tSQL, "tTargetPerson", "tNorm_heading",
> >>> "tNorm_topic", "tEventDescription"
> >>> ?>
> >>>
> >>> I'm at the point now I'm just trying to see what the connection
> contents
> >>> is in tResult, and it still throws up the server error???
> >>>
> >>> Any advice?
> >>>
> >>> Thank you!
> >>>
> >>> John Patten
> >>> SUSD
> >>>
> >>> _______________________________________________
> >>> use-livecode mailing list
> >>> use-livecode@lists.runrev.com
> >>> Please visit this url to subscribe, unsubscribe and manage your
> >>> subscription preferences:
> >>> http://lists.runrev.com/mailman/listinfo/use-livecode
> >>>
> >>
> >>
> >>
> >> --
> >>
> >>
> >>
> >> Stephen Barncard
> >> San Francisco Ca. USA
> >>
> >> more about sqb <http://www.google.com/profiles/sbarncar>
> >>
> >>
> >
> >
> > --
> >
> >
> >
> > Stephen Barncard
> > San Francisco Ca. USA
> >
> > more about sqb <http://www.google.com/profiles/sbarncar>
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
--
Stephen Barncard
San Francisco Ca. USA
more about sqb <http://www.google.com/profiles/sbarncar>
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
