$Id: INSTALL,v 1.6 2004/03/31 02:12:02 ggw-ssl2 Exp $ The is a beta release but is being used in production by smaller ISPs as we speak. --- Intended Audience Linux system -via bash or tcsh shell- admins. Or people learning and with time to learn how to use bash as root and live with their mistakes. Must know how -or learn- to setup Apache httpd daemon and configure httpd.conf. Must understand the basics of iproute2 and iptables and tc. --- Prerequisites mySQL server and client libs installed and running on same server as the application. You must know the root password. (Paranoids: Check the install script in mainfunc.h) Must have a running Apache server on the same server with cgi capabilities. Should be SSL enabled if possible (see below for intranet or other just "testing" non-SSL setup) --- Example BASH Install Instructions (gmake required - FreeBSD make support must edit makefile) shell>tar xzf mysqlIPMn.mtar.gz (Where n.m is the latest release at openisp.net) shell>cd mysqlIPM shell>export CGIDIR=/apache/cgi-bin/ (Or whatever your Apache cgi-bin dir is) shell>make shell>make install shell>export ISMROOT=/home/joe (Or whatever dir the mysql application project dir is in) shell>chown mysql $ISMROOT/mysqlIPM/data shell>chmod o+x mysql $ISMROOT (These last two commands to insure mysql access to you initialize data. If this fails you will have to drop table mysqlipm via mysql and start over.) shell>/cgi-bin/mysqlIPM.cgi Initialize (This will setup application and allow you to login as user "Root" password "wsxedc") --- SSL Setup If you do have an SSL server handy edit local.h and comment out: //#define SSLONLY like so... #define SSLONLY Then shell>rm *.o shell>make --- Read More cp docs/tutorial.html to a browser accesible place or sym link to it if possible. Read it! Get new versions at openisp.net of tutorial as we are expanding it monthly if not weekly. --- Standard OpenISP setup backup operations (Loose instructions adjust to fit for your particular setup) shell>useradd -d openisp shell>mkdir -p ~openisp/mysqlIPM/data shell>chown mysql ~openisp/mysqlIPM/data shell>crontab -e Adding the following: Where mysqlpasswd is replaced by YOUR real mysql root passwd. # #mysqlIPM # ##backup 20 3 * * * ISMROOT=~openisp;export ISMROOT;/cgi-bin/mysqlIPM.cgi Backup mysqlpasswd > /dev/null --- Other backup ideas You should probably cross server backup all your OpenISP module data like so. Note that this involves using GRANT ALL mysql statements and a very secure internal ISP LAN. See mysql manual. Think about ISP organization with edge servers with 2 NICs and an ISP admin firewall zone with the mysql database server or replication cluster servers. All servers should have internal mirror backup drives or other cheap fast and reliable backup system (NFS and cpio in ISP admin firewall zone?) shell>crontab -e Add something like the following after setting up mysql for remote access from ONLY the IP in question in a VERY secure LAN (non routable IP's...switched hubs...behind firewall...etc) #Extra backup of mysqlIPM data only even days, using mysqldump from 192.168.100.23 20 4 * * */2 /usr/local/mysql/bin/mysqldump -e -h 192.168.0.43 -u mysqlipm -pwsxedc --all mysqlipm > ~openisp/mysqlIPM/data/dumpall.txt --- Loose your data and your fired Don't be lazy backup and rebackup and database warehouse your mission critical data ALWAYS! Need help contact us! --- Legalese This doc is GPL. Don't forget to give us credit when you quote this stuff. Copyright 2003 OpenISP and Gary Wallis --- Notes You will need at least mysql release 3.23.57 with development and client libs to compile this application. Also you will need a fairly recent linux kernel for tc/HTB QoS and somewhat less new kernel iptables. 2.4.20-X (see shell>uname -a) will work fine (Example: RH 9) More info in scripts dir.