1  ///////////////////////////////////////////////////////////////////////////////////
2  // PCCS MySQL Database Admin Tool
3  // coder: Chauncey Thorn
4  // email: cthorn
5  // url 1: http://PCCS-Linux.COM/
6  // url 2: http://web.wt.net/~cthorn/
7  // url 3: http://www.hlug.org/cthorn/
8  ///////////////////////////////////////////////////////////////////////////////////
9  // Changelog
10  // Created: 01-09-2000
11  // Changes will be added based on Version
12  /////////////////////////////////////////////////////////////////////////////////////
13 
14  /////////////////////////////////////////////////////////////////////////////////////
15  // If you are interested in adding code snippets, or help extend this application
16  // send me a email
17  // As you can see my documentation is very limited. If you have skills writing
18  // help files and would like to write some for me. Please do so and send them to me...
19  //
20  /////////////////////////////////////////////////////////////////////////////////////
21 
22  Version 1.0:
23  Released
24  Applications first release
25  This is a PHP application that allow your to create database users and backup
26  database that you manage using Mysql.
27 
28        "You will need to chown root:nobody on the directory you untared this tool"
29          This application needs write permissions to the root dir
30          $ su
31          # chown -R root:nobody pccsmysqladm/
32   
33  //////////////////////////////////////////////////////////////////////////////////////
34 
35  Version 1.1:
36  Released
37  Added Drop DB support
38  Extended User Management (Modify User option)
39  Added Optimize as a option on table view
40  Added Kill Process
41 
42  //////////////////////////////////////////////////////////////////////////////
43 
44  Version 1.2:
45  Released
46  Moved global.vars.php and dbconnect.inc to incs directory
47  Added Webadmin FileManager for Web Hosting Admin. (Allows create dirs,upload files, etc..)
48  Added view data to table view
49  Added support to create web user's include files in the myuser_incs dir
50  Included patch (Interface)
51 
52  //////////////////////////////////////////////////////////////////////////////////////////
53 
54  Version 1.2.1
55  Released
56  Finished Query tool backend (working on interface)
57  Changed the way I was getting tablenames and fields
58  (was using SQL statements, now using mysql_list_tables and mysql_list_field functions)
59  Modifications to main menu
60  Added support for flushing internal tables
61  Added create database (results generates error even though db is created ?)
62  View Variables and Processes
63  Worked on navigation (not complete...)
64  Added support for changing passwords
65  Added to more global variables
66          mysqldbuser = the root user id
67          mysqldbpasswd = the password
68  These are needed to run mysqldump. ?
69 
70  //////////////////////////////////////////////////////////////////////////////////////////////
71 
72  Version 1.2.2
73  Released
74  fixed another missing require statement )+:
75  Added <> to SQL Query Tool select options Thanks to David Bandel..
76  Changed Interface again
77  Added Grant/Revoke module
78  Removed a couple of print statements from mysqldb_admin.php3 "dbschema"
79  Started back updating this file...
80 
81  ////////////////////////////////////////////////////////////////////////////////
82 
83  Version 1.2.3
84  Released
85  bug fixes
86  PHPgened the mysql: host,user,db tables
87  mysqldb_user.php3, mysqldb_db.php3,mysqldb_hosts.php3
88  Added a flush privileges qry to the update and insert queries in the above
89  scripts.
90  Started creating support for multiple languages.
91  worked on navigation (getting back to main page)
92  Made changes to the Web Admin portion.
93  now displaying userid_global.var.inc <-- file is written to myuser_incs
94 
95  //////////////////////////////////////////////////////////////////////////
96 
97  Version 1.2.4
98  Released
99  bug fixes
100  removed WebAdmin module
101  Added modified version of phpgen version, intergrated it into view tables columns
102  phpgen modifications; genform.php3 --> mysqldb_createapp.php3 ->
103  $numf was hacked to get is value from a select * and mysql_num_rows
104  ytgen.php3 --> mysqldb_genapp.php3
105  Creating include file in the genapp/include
106  Creating language file in the genapp/include
107  Minor code additions; mouseovers, class statements
108  Query tool updated; added support to write html file via a sql query.
109 
110  //////////////////////////////////////////////////////////////////////////
111 
112  Version 1.2.5
113  fixed a couple of bugs
114  fixed SecurityFocus SECURITY ALERT http://www.securityfocus.com/vdb/?id=1557
115  by changing dbconnect.inc -> dbconnect.php
116  changed ALL files extensions to .php
117  extended the QueryTool adding a free form for your SQL statements
118 
119  //////////////////////////////////////////////////////////////////////////
120 
121  Version 1.2.6
122  fixed a few more bugs
123  renamed the files in genapp from .php3 -> .php I missed these files in
124  the 1.2.5 version.
125  removed simple1 from the password field in mysqldb_backup.php
126  using incs/dbconnect.php to provide user id for mysqldb_backup.php
127  added a logging function
128  starting to log various actions, grant/revoke, flush commands
129  Make sure you give nobody access to write in the logs dir.
130  I included a index.php in the incs and logs directory.
131  You will need to modify these files... They generate false errors while
132  sending you an email of the infraction
133  wrote a small shscript to automate the backup of every database
134  nightly. backup.sh
135 
136  //////////////////////////////////////////////////////////////////////////
137  Version 1.2.7
138  fixed bugs in the genapp/mysqldb_genapp.php
139  In an effort to make this tool useful for the php developer also
140  I included my installscript and backup script, generating them
141  on the fly via a database select using fopen() fputs() fclose()
142  If you are using this application remotely you should install apache with
143  ssl support and create a apaches .htaccess
144 
145  Apache with mod_ssl
146 
147  Get the latest versions of mod_ssl andsl
148   # cd /usr/local/src
149   # tar -xvzf /path/to/sl-xx.tar.gz
150   # tar -xvzf /path/to/mod_ssl-xx.tar.gz
151   # cdsl-xx
152   # ./config -fPIC
153   # make
154   # make install
155   # cd ../mod_ssl-xxx
156   # ./configure -with-apache=../apache-1.3.xx
157   # cd ../apache-1.3.xx
158   # SSL_BASE=../sl-xx ./configure --prefix=/home/www
159                                  --enable-module=most --enable-shared=max
160                                  --enable-module=ssl --enable-shared=ssl
161   # make
162   # make certificate
163   # make install
164 
165  Test your Apache Setup
166 
167   # /etc/rc.d/init.d/httpd stop
168   # /etc/rc.d/init.d/httpd startssl
169   # enter phrase
170   # ps ax | grep httpd
171 
172  Goto my site a view
173  http://pccs-linux.com/phplinux/linux_php.html
174  for more details on installing Apache/MySQL/PHP
175 
176  //////////////////////////////////////////////////////////////////////////
177  // Version 1.2.8
178 
179  - Some bug fixes
180  - begin the process of commenting the code.
181  - added a fix_perm script, sets file/directory perms
182  - added support for restoring a database from a backup
183  - modified the location of database backups to dumpfiles/
184    in the bin/backup.sh
185  - new button RESTORE DB allows you to restore a database or
186    restore to a new database from dumpfiles/
187  - support for the 3.23.xx series of MySQL
188    fixed table_in_databasename
189  - redesigning the backup system to rely on the backup.sh
190    moving away from the mysqldb_backup.php for administrators
191  - added a robots.txt to keep indexers from indexing the application
192  - minor code changes...
193  - changed the location of where genapps are scripts are created.
194    using mkdir() function
195 
196  //////////////////////////////////////////////////////////////////////////
197  // Version 1.2.9
198  - Big Fix in login script. If login Failed. VERY Hard to relogin
199    commented out the code for now.
200  - modified dump database code
201  - included optimize script
202 
203  //////////////////////////////////////////////////////////////////////////
204  // Version 1.3.0
205  - Moved changelog from readme to here...
206  - New interface
207  - better login system
208  - included create database and table support
209  - move some SQL queries to PHP eq Function e.g mysql_list_tables()
210  - more 3.23.xx support
211  - minor code changes. (trying to make code base more friendly)
212  - generating a new install script (shell script)
213  - modified create database dump function
214  - move all global include files to a single file for includes
215    mysqldb_app_includes.php contains list of all include file
216  - minor windows support
217  - included a install.sh
218  - basic help system
219 
220  //////////////////////////////////////////////////////////////////////////
221  // Version 1.3.1
222  // Got real busy and allowed a few known bugs linger. Sorry !!!
223  - Bug Fixes
224  - Web Admin Module included
225  -- Create a number of PHP Scripts for a particular user (May benefit Web Hosting Admin)
226  --- NOTE: I tried to test all of the generated scripts (However, I may have missed a bug. Let me know)
227 
228  //////////////////////////////////////////////////////////////////////////
229  // Version 1.3.2
230  // added support for xml. Read an article on phpbuilder.com about
231  // the odbcsocketserver seeing the output and decided to see if I could
232  // generate the same output via a query
233 
234  //////////////////////////////////////////////////////////////////////////
235  // Version 1.3.3
236  // - fixed a bug in the mysqldb_qrytool.php. when viewing html file created
237  // by query, path to file was not pointing to tmp/
238  // - moved the database host, user, passwd to incs/dbuserpasswd.php
239  // this removed the need to edit dologin.php and dbconnect.php
240  // - Tried to test all the options everything seems to be working
241  // I've installed it numerous times and have always got it up and running.
242  // However, If you fail to get it running let me know...
243  // Thanks...
244 
245  //////////////////////////////////////////////////////////////////////////
246  // Version 1.3.4
247  // - interface altered
248  // - navigation updated (using function to make it easier)
249  // - minor code changes
250  // - bug fixes
251 
252 
253  //
254  //////////////////////////////////////////////////////////////////////////
255