Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

[REBOL] Re: MySQL scheme connection problem

From: chris::starforge::co::uk at: 22-Jul-2001 9:35

On 22-Jul-01, MCCUNI wrote:
> Or you can give your user a wildcard "*" access "from" and you can access > from anywhere.
Thanks to help from my hoster I got this fixed. Now for the weirdness: I have MySQL, Apache and other tools set up on my linux box so that it is practically a mirror of my website. 99% of the time, if it works on my home system I can upload it to the website and be sure it'll work. This is the case with my sql scripts - at home I could do db: open mysql://starforg_chris:[xxxxx--localhost]/starforg_siteserv and it worked fine. But when I uploaded the script to my website it failed? After a bit of investigation, I found a possible reason. When I used @localhost on my website mySQL was seeing "wolverine.uk.co" rather than "localhost". All I can think is that the mySQL scheme is resolving localhost as part of the open (I have no idea if this is true, half the code in the scheme is Greek to me..) So instead of logging in as starforge_chris:[xxx--localhost] I was actually logging in as starforg_chris:[xxxx--wolverine--uk--co] My hoster added an entry to mysql.user to allow me to connect from wolverine.uk.co and everything works fine now. What I can't understand is why localhost is being resolved or why mySQL can't work out that wolverine.uk.co IS localhost. But it works now anyway :) Chris -- New sig in the works Explorer2260, Designer and Coder http://www.starforge.co.uk -- Somebody ought to cross ball point pens with coat hangers so that the pens will multiply instead of disappear.