Topic: MySQL

[Hazen Valliant-Saunders]

Has anyone had any success configureing MySQL to work via remote systems?

    I need public accis via the private interface to the MySQL DB, I've configured the grant's appropriately however I still get the same "pc-005.gateway" is not allowed to connect to this server.

   If anyone could shed a little light I would much appreciate it.

(FYI, Via ODBC for table editing and dynamic updates of a website.)


Thanks in advance.
Hazen.

[Gary Williams]

Hazen,

I can't help at all, however I'm interested to hear your solution (confidently assuming you will find one).

When you talk of ODBC, are you using ODBC on a Windows client, with a DSN set up to talk directly to the database? The norm would be to have the webserver update the database via html queries of some sort (PHP for example), wouldn't it?


Gary Williams

[Hazen Valliant-Saunders]

ell,
   Actually Keystone proved a bit of over kill to the task's we needed.
   The thing is we need to have a secure access point to track billable time to our clients and keystone provided a web client to do so.  However, my management has recently canned the project.

   On the note of using ODBC, I've seen it done before like this.  I used to work for a very small ISP, they had the problem of not thinking big they should because thier toolset is much larger than they imagine.

   They acutally set this up for about 30K cdn you too can do business online with trytel (www.trytel.com).

   They would design a website with PHP and templates, then use a MySQL backend.  However they would grant access to only the propriater of the business involved (www.guytel.ca)  <-example of a site constructed by the means I'm reffering to.

   Guy of Guytel is the owner of the business he likes to kayack in new-zealand on his vacations.  He also drives a lexus.  Now I sat with him and showed him how to update his site.  He will connect to the MySQL backend of his server remotely and add new table entries (MyODBC and DSN) Then he uploads a new picture via ftp to the "Images directory" and addes a file name to the table and the table is updated all the table editing occurs in Excell by importing and exporting data via Queries through ODBC and MySQL.  It is a very good infrastructre and if done properley yield's results like slashcode. (www.slashdot.org)  
   My goal was to edit the tables in keystone modifying the template architechure, however I've discovered for my purposes it may be easier to write an entire web application, and use odbc that way.  You can do so by changeing the grantss on the SQL table but I'm have security errors with e-smith so I may need to switch the server.

      The reason is that The wesite will contain hidden sensitive information about the nature of the work that is done that only administration needs to see, and that is why the odbc to windows connection will be made, also because the person involved is somewhat of an expert when it comes to Excel and VBA.
Thus makeing the application twice as efficent.  The users need only see the page, admin must manipulate raw data.  That is why i need to connect to the MySQL in E-smith remotely.