 |
 |
I want to put mysql database on a different box...
|
|
|
|
|
Mac Elite
Join Date: Feb 2002
Location: Hilton Head, SC
Status:
Offline
|
|
I'm running apache on my main server and I want to run a mysqlserver as my backend database on a different box... what do I have to do in order to get this running... in other words what string handles this in what config file? thx!
|
|
|
| |
|
|
|
|
|
|
|
Mac Elite
Join Date: Mar 2001
Location: CO
Status:
Offline
|
|
Use something like (free) CocoaMySQL or PHPMyAdmin to "dump" your DB into a text file (MyDatabase.sql).
Take that file to the box you want it to appear on; make sure MySQL is running. Use CocoaMySQL or PHPMyAdmin on the other box to MyDatabase.sql
|
|
TOMBSTONE: "He's trashed his last preferences"
|
| |
|
|
|
|
|
|
|
Mac Elite
Join Date: Oct 1999
Location: San Jose, Ca
Status:
Offline
|
|
Are you looking at logging Apache to MySQL? Or just using the database from a web app (as in PHP, etc..)? If it is the former.. then I can't really help.
However if it is the latter all you have to do is modify your open statements to point at the new server, and make sure that your permissions in the MySQL database allow that user to come in from the box the app is on (% means all other addresses in the mysql table). If you don't know what I am talking about , then it is time to go look up granting privileges in the MySQL manual...
|
|
|
| |
|
|
|
|
|
|
|
Mac Elite
Join Date: Feb 2002
Location: Hilton Head, SC
Status:
Offline
|
|
Originally posted by larkost:
Are you looking at logging Apache to MySQL? Or just using the database from a web app (as in PHP, etc..)? If it is the former.. then I can't really help.
However if it is the latter all you have to do is modify your open statements to point at the new server, and make sure that your permissions in the MySQL database allow that user to come in from the box the app is on (% means all other addresses in the mysql table). If you don't know what I am talking about , then it is time to go look up granting privileges in the MySQL manual...
What I really want to do is use the MySQL database as means of logging the output from my IDS, HenWen (snort). The IDS runs on the Apache server... the SQL database will have a private connection to the server and I'll use this to log the output. Using Apache to veiw the output is secondary, but I would like to get it going. But is not reeeaalllly need... but would nice to get going. As that Cernel Sanders fellow said in the 2nd Matrix: "There are levels of surivaly we are willing to accept..." 
|
|
|
| |
|
|
|
|
|
|
|
Mac Elite
Join Date: Oct 1999
Location: San Jose, Ca
Status:
Offline
|
|
For what you want Apache is not going to have anything to do with it. You will simply need to setup snort properly. Never having done it, I can't really be of any assistance. I also don't know if the Henwen (gotta love Lloyd Alexander references) does this for you, or if you have to dive into the config files yourself.
A couple of notes: you will have to setup the MySQL grant tables like I mentioned before, and make sure that you can connect from one box to the other (ie there are no interfering firewalls between them), and you might have to have the MySQL client libraries installed on the box you are monitoring.
Oh.. and shouldn't that be Kernel Sanders, or Colonel Sanders? I would prefer the first.
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
 
|
|
|
Forum Rules
|
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|
Top
