[Gambas-user] Mysql connection bug/problem ?

[Steven Lobbezoo]

Did you check the Mysql database in mysql ?
In the users records there is also reference to the host the user is
allow to use.
If it's marked localhost, that's your problem.

Regards,
Steven


Le jeudi 21 août 2008 à 13:39 +0300, Kamau Gatheru a écrit :

> As a matter of fact I have,
> 
> Here is a sample of the /etc/hosts, listing
> my database servers
> 
> 127.0.0.1	localhost
> 127.0.1.1	MvServer
> 192.168.1.200	Mvserver
> 192.168.1.100 	Server
> ....
> 
> surprisingly even on the local machine (MvServer)
> only .host = "localhost" works
> 
> 
> 
> On Thu, Aug 21, 2008 at 10:18 AM, Marcelo Confortino
> <mconfortino at ...1877...> wrote:
> > Kamau Gatheru escribió:
> >> Hi all,
> >>
> >> I have been trying to connect to a remote mysql server (within my network)
> >> and it seems all my local installations of Gambas cannot do that. Incidentally
> >> I discovered that the .Port element doesn't work. I can run the following code
> >> locally and it works fine.
> >>
> >> WITH Conn
> >>
> >>     .type = "mysql"
> >>     .host = "localhost"
> >>     .Port = "4444"          <------- I put the wrong port and it still
> >> works regardless
> >>     .login = "user"
> >>     .Password = ""
> >>     .Name = "control"
> >>
> >> END WITH
> >>
> >>
> >> but when trying to connect to a remote computer using the correct parameters
> >>
> >> WITH Conn
> >>
> >>     .type = "mysql"
> >>     .host = "remotehost"
> >>     .Port = "3306"             <------- Correct port
> >>     .login = "user"
> >>     .Password = ""
> >>     .Name = "control"
> >>
> >> END WITH
> >>
> >> I get an error ( Cannot open database: Unknown MySql server host 'The
> >> -remote-host' (1) )
> >> or another error ( Cannot open database: Can't connect to MySql server
> >> on 'My -remote-host' (111) )
> >>
> >> Could you please give me a work around or the proper procedure to connecting to
> >> a remote MySql database server.
> >>
> >> Thanks and best regards,
> >>
> >> Kamau Gatheru
> >>
> >> -------------------------------------------------------------------------
> >> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> >> Build the coolest Linux based applications with Moblin SDK & win great prizes
> >> Grand prize is a trip for two to an Open Source event anywhere in the world
> >> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> >> _______________________________________________
> >> Gambas-user mailing list
> >> Gambas-user at lists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/gambas-user
> >>
> >>
> > This may seem obvious, but do you have 'remotehost' listed in
> > /etc/hosts? Bye. M.
> > __________________________________________________
> > Correo Yahoo!
> > Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
> > ¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar
> >
> >
> > -------------------------------------------------------------------------
> > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> > Build the coolest Linux based applications with Moblin SDK & win great prizes
> > Grand prize is a trip for two to an Open Source event anywhere in the world
> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > _______________________________________________
> > Gambas-user mailing list
> > Gambas-user at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/gambas-user
> >
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>