Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: roberto on October 21, 2003, 02:09:08 AM

Title: Acces Mysql
Post by: roberto on October 21, 2003, 02:09:08 AM

I can access Mysql from any windows computer inside my network, but connection is refused from my home computer...
How can i manage to do it?, I have SME 6.0b3

Title: Re: Acces Mysql
Post by: Arno on October 21, 2003, 11:03:25 AM

how u wanna acces it?
with phpmyadmin?

Did u tried

https://mydomain/phpmyadmin/

Title: Re: Acces Mysql
Post by: roberto on October 21, 2003, 01:10:26 PM

upps sorry maybe i didn't explain it...
What i need is giving MySql access to a partner website allocated outside my local intranet... inside our network we can access from one server to the e-smith mysql but if i put the server at the other office it fails

Title: Re: Acces Mysql
Post by: Arno on October 21, 2003, 06:11:39 PM

when u connectr 2 the mysql dbase
do u use the ip adres of ur server or ur domain?

Title: Re: Acces Mysql
Post by: roberto on October 21, 2003, 06:48:13 PM

it doesn't work neither with the ip nor the domain name. in the same network i connect using both local name or local ip

Title: Re: Acces Mysql
Post by: roberto on October 21, 2003, 06:48:56 PM

by the way arno, thanks for your help ;)

Title: Re: Acces Mysql
Post by: Arno on October 21, 2003, 07:49:48 PM

erm it still dont work right?

Title: Re: Acces Mysql
Post by: roberto on October 21, 2003, 08:34:59 PM

no, it doesn't work

Title: Re: Acces Mysql
Post by: Ray Mitchell on October 22, 2003, 12:51:35 PM

When you instal phpmyadmin (e-smith-phpmyadmin-2.5.0-5dmc.noarch.rpm from contribs.org) it quite clearly says

"To access the MySQL functions via a web interface
you will have to access it via SSL in your web browser.

For example: https://192.168.1.1/phpmyadmin"

I just did it and connected using https://mydomain/phpmyadmin

I also tried establishing a VPN connection, and then in a browser entered an IP style URL (as above) https://192.168.1.1/phpmyadmin

Then
Enter your admin username and password
Voila, you have phpmyadmin

Regs
Ray

Title: Re: Acces Mysql
Post by: roberto on October 22, 2003, 01:40:49 PM

Emm... I can Acess By PhpMyAdmin. But i need to connect a remote php server to my mysql server in e-smith
I really want to thank you for your help, but we are getting misunderstood...

Title: Re: Acces Mysql
Post by: andrej on October 22, 2003, 04:05:51 PM

Connect those two server using VPN. Remote server will threaten as local one.