Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: Snoopyski on September 11, 2007, 04:22:40 PM

Title: MySQL + ODBC connection from SME Server 7.2 in "ORANGE" DMZ of IPCop
Post by: Snoopyski on September 11, 2007, 04:22:40 PM
Hello Everyone,

I need to have access to my eGroupWare Database on my SME Server 7.2 with the ODBC driver... But I always get a error message like :

Quote
[MySQL][ODBC 3.51 Driver]Access denied for user 'dbadmin'@'10.0.10.100' (using password: YES)


All ports needed for MySQL was open and I do the script to open MySQL from network....

The only way I find is run PuTTY connection with "port transfert" to be able to access it !!!

There is another way, because I don't want to show how PuTTY works for my user's and open PuTTY each time I need to access the Database from Access or Excel !!!

Thanks,

Snoopyski
Title: Re: MySQL + ODBC connection from SME Server 7.2 in "ORANGE" DMZ of IPCop
Post by: Snoopyski on September 15, 2007, 02:59:38 AM
Hello Everyone,

Nobody have a answer ???
Nobody use MySQL ODBC Driver with SME Server ???

Thanks,

Snoopyski
Title: Re: MySQL + ODBC connection from SME Server 7.2 in "ORANGE" DMZ of IPCop
Post by: Normando on September 15, 2007, 05:42:06 AM
Very strange.
If you configure this:
http://wiki.contribs.org/MySQL#Access_MySQL_from_the_local_network
and this
http://wiki.contribs.org/MySQL#Access_MySQL_from_a_remote_network
you can access remotely your db.

If not, create a bug in bugzilla.
Title: Re: MySQL + ODBC connection from SME Server 7.2 in "ORANGE" DMZ of IPCop
Post by: Gaston94 on September 15, 2007, 11:02:01 AM
Hi,

did you configure your ODBC connection with @IP or with server name or with FQDN ?
did you have a look at your ipcop firewall log files ?
Which port have been transfert in ipcop ?
Did you make a try putting the server in the Green zone ?
I would guess IPCop guys should better know about the reasons
G.
(I was also surprised seeing "loading 10.0.10.1" in my browser before your Joomla page load, did you cross check your port transfert / dnsmasq configuration ?)
Title: Re: MySQL + ODBC connection from SME Server 7.2 in "ORANGE" DMZ of IPCop
Post by: Snoopyski on September 15, 2007, 01:07:39 PM
Hello Everyone,

Thanks for answer... See solution here "Mini HowTo"...

Code: [Select]
Step #1 (With SSH on your SME Server)

config set mysqld service access public status enabled TCPPort 3306
signal-event remoteaccess-update
signal-event reboot

Code: [Select]
Step #2 (With SSH on your SME Server)

mysql
GRANT ALL ON *.* to "root"@"ip adress remote computer" IDENTIFIED BY "your password";
\q

Code: [Select]
Step #3

Install and setup MySQL ODBC driver

That it !

Snoopyski