Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to connect to remote mysql server

Status
Not open for further replies.

thirdparty

Programmer
May 14, 2010
3
US
I would like qmail to connect to a separate database server.

How would one achieve this task?

I am running qmail on centos4.

Thanks!
 
You mentioned MySQL in the topic, so I will assume you are using that. MySQL uses network based connections naturally. If you are working on the machine that hosts the server, the login becomes user@localhost. To login from a remote location you will need to create a user account for user@remotehost. If you have a LAN domain, the remote host will probably be the fully qualified domain name of the host. If are accessing remotely, from the internet, you will need to add port forwarding in addition to the user@host.

You can also use wild cards to mask out all or part of the host name. This degrades the security so you will need to think carefully about this.
 
Thanks for the reply.

The two servers are on a LAN domain, and the mysql server has an appropriate user account.

The email server is already accessed successfully by an older qmail server that works, but needs to be upgraded. I have no idea how this older server was set up to read from the remote mysql- all I know is that is works.

The part I am stuck on, is directing a new test version of qmail (and vpopmail specifically) to connect to the remote mysql server instead of its local mysql.

Can this be achieved through wildcards?
 
In my 3rd paragraph I meant 'Mysql server', not 'email server'..

The 'mysql' server is already accessed successfully by an older qmail server that works, but needs to be upgraded. I have no idea how this older server was set up to read from the remote mysql- all I know is that is works.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top