[Sqlrelay-discussion] MySQL proxy

[Bertrand L. <ber...@li...>]

Hello,

I'm just trying to set up a simple MySQL proxy: all the request to  
the local machine is to be forwarded to a remote one,  
authentification should be done on the remote MySQL server.


The configuration i'm trying to set up is the following (0.38):
----8<----8<----8<----8<----
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>
     <instance id="mysqltest" port="3306" socket="/var/run/mysqld/ 
mysqld.sock" dbase="mysql" connections="3" maxconnections="5"  
maxqueuelength="0" growby="1" ttl="60" endofsession="commit"  
sessiontimeout="600" runasuser="" runasgroup="" cursors="5"  
authtier="database" handoff="pass">
           <router>
             <route host="my.remote.mysql.server" port="3306">
               <query pattern=".*"/>
             </route>
           </router>
         </instance>
</instances>
---->8---->8---->8---->8----

That's not correct, since users and connections elements are required  
by the dtd.

I'd just like to forward all the local connections to a remote host,  
without dealing with users (i don't know all the login/passwords for  
all users). Is that possible?

Greetings,

-- 
Bertrand LUPART
                   Linkeo.com | http://www.linkeo.com/
            +33 1 72 71 71 84 | 17, rue de la Banque - F75002 Paris
         http://www.linkeo.com/signatures/bertrand-lupart/