--- Bill Vlahos <[EMAIL PROTECTED]> wrote: > I don't know much about SQL access so sorry about > this basic question. > > We use A1 Support Pro HelpDesk style ticket tracking > system where I > work. It consists of MySQL database running on a Mac > OS X computer, > PERL scripts, and Apache web server. The system > works really well for > us and is very inexpensive. (It would make a great > Revolution app. but > that is another story). > > We have someone who is tasked to run our own queries > to the data base > to generate our own reports. I'm going to suggest he > use Revolution for > this but I need to know what needs to be set up on > the server side for > this. I'm thinking that the reports would be run on > a computer other > than the MySQL server. > > What are the requirements for the MySQL server? Here > is what I think I > need so far. Please let me know if this is wrong or > incomplete. > Name of data base > Database admin login > Database admin password > Network port number > > Do I need to set up an account for the user on the > Mac OS X computer? > > Thanks, > Bill Vlahos >
Hi Bill, To connect, you'll need : - IP address of the server - Network port (only if it deviates from the standard port) - Name of the database You could take apart the PERL code to figure out the user name and password that it uses to connect to the database. Or you could add a new user to the MySQL database (this doesn't have to be a new user on the server machine!) and GRANT that user permission to SELECT data from that database. That way you can rest assure no changes are made by the Revolution front-end; and if you don't need to add data you could always use the Automated Database Queries to quickly develop a working application. Hope this helped, Jan Schenkel. ===== "As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
