Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

thirdparty (Programmer) (OP)
14 May 10 14:58
I would like qmail to connect to a separate database server.

How would one achieve this task?

I am running qmail on centos4.

Thanks!
Noway2 (Programmer)
14 May 10 16:13
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.
 
thirdparty (Programmer) (OP)
14 May 10 16:38
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?
thirdparty (Programmer) (OP)
14 May 10 16:41
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.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close