Previous

TOC

Next

 

INSTALLATION (Version 1.41 and higher)

  1. UPLOADING

The program must me installed in cgi-bin directory and CHMODed properly.

If you are ready, point your browser to the program URL of  and run it. For example, type in the address bar:

http://www.yourname.com/cgi-bin/mdm131.cgi

Usually it works. If it does not, check the following:

If the login page does not appear:

  1. Check the very first line of the program. It should be the full path of PERL installation
  2. Be sure that you have the Perl is installed on your system.
  3. The Perl CGI.pm, CGI::Carp modules are installed.
  4. The program is CHMODed properly.
  5. Do other cgi scripts, located in the same directory work?

If only the login page appears and all the others do not:

  1. The Perl DBI.pm and DBD::mysql must be installed.
  2. The MySQL server must be running

Read carefully the error message that you received (if any). May be your login and/or host name and/or port number are incorrect.

2. SETTING UP

There are only two parameters, which must be corrected using text editor:

  • line #1 must reflect the path of Perl installation.
    For UNIX in most cases it looks like this
     #!/usr/bin/perl
    For Win32:
     
    #!c:/perl/bin/perl.exe
    If you are not sure, try this: #!perl
  • Second parameters is the path and name of configuration file. (See' INSTALLATION', right after License agreement).
     For example (for Linux):
    $configFile = "/home/myrootdir/web/cgi-bin/datamanconf/mdmSetup.conf"
    or
    $configFile = "./datamanconf/mdmSetup.conf" (the same as above, but using relative path)
    You should create a directory where this file will be placed. The file will be created by the program. This directory can be created anywhere on the server disk; it is recommended to place this directory out of your web root directory, so that the config file can not be fetched by web browser. You can also place this directory inside cgi-bin directory, since cgi-bin is not "world" readable (Be sure that your web server supports this feature before you rely on it).
    If your web server runs under Linux (or Unix) you must change permissions of this directory to 777 (world readible/writable/executible), so that CGI script will be able to write into it.

    NOTE: If you assign this variable blank value (
    $configFile = '') or delete or remark this line,  using of configuration file will be disabled. In this case you must set up hardcoded variables as it was done in Mysql Data Manager prior version 1.41. See Older versions below.

Also you must create user directory, where SQL scripts and backup files will be placed. This directory must be CHMODed to 755.

Then you are ready to upload the script into executable directory (cgi-bin). After uploading, set permissions of the script to 755.

Now run the script, typing its URL in the address bar of web browser, and hit Enter.

If the previous steps were OK, you will see "SETUP" link on the upper left corner:

 

Click on this link and the SETUP page will be opened.

First, you must create admin user, otherwise anybody can change your settings. Type user name and password, then check "CREATE ADMIN USER" check box. If you want, you can try how it works before proceeding further. Click SAVE AND EXIT button on the bottom of the page. If the directory you created before was found and config file was created successfully by the script, then the Login page of Mysql Data Manager will appear. Click on 'SETUP' link again, and you will be prompted to enter admin user name and password:

 Log into Setup page again.

1. Home Page URL
this is URL of your home web page. This URL is used to create a link 'HOME' on the pages of Mysql Data Manager.
If this value is left blank, the link 'HOME' will not appear on Mysql Data Manager pages.

2. HELP directory URL
is URL of the directory where help files are stored.
If this value is blank, HELP link will not appear on Mysql Data Manager pages.

3. MYSQL CONNECTION PARAMETERS
- default socket
- default host name
- default port number
These parameters are used to connect to Mysql server when the field HOST:PORT on the login page are blank. You can set this values just to simplify connection to the most frequently used server. For example, if your Mysql server is located at mydomain.com and its port number is 3315, then type in default host name field: mydomain.com,  and in default port number field: 3315.

4. mysql CLIENT PARAMETERS
are used to call binary mysql client. This client is called when you use the 'Restore' feature of Mysql Data Manager
- path to mysql client (binary) must be full name of mysql client. For example:
(Unix/Linux)
/usr/local/mysql/bin/mysql
(Windows) c:\mysql\bin\mysql.exe
- other parameters can also be used to call binary mysql client. For example -s -C (silent mode and compression)
For more options refer to Mysql online documentation (http://www.mysql.com).

5. Path to user directory
User directory must be created to store user SQL scripts, backup files etc.
For Unix/Linux it looks like:
/home/directoryname/data/usr
for Windows:
C:\MYDOCU~1\MYSQLDIR\DATA\USR

The script will create subdirectories under this directory, one for each user, identified by username and connected host name.
Each user subdirectory will be named user.hostname, in order to separate user data. Thus, if you were connected to localhost as root, your subdirectory will be root.localhost. All SQL scripts you created will be stored in .. root.localhost/sql subdirectory, and backup files will be stored in .. root.localhost/backup . If then, you disconnect from localhost and connect to edatanew.com as root, the script will create new user subdirectory: root.edatanew.com, your previously created SQL script and backup files become invisible until you connect to localhost as root again.

6. Maximum total size of backup files and Maximum total size of  SQL scripts.
Here you can define max. size of these files per user.hostname , in kilobytes. If you leave these fields blank, the size becomes unlimited

7. Administrator email address
This is an email address you want to appear in some critical error messages.

8 . Compressing method
ZIP or GZIP. This value defines, which compressing method will be used in command "COMPRESS". The defined method should be allowed (See Allow ZIP, Allow GZIP below), otherwise  Error message will be generated when you are going to execute 'COMPRESS' command

9. Checkboxes 'Allow ZIP', 'Allow GZIP'
Depending on whether you have or not the utilities ZIP and GZIP on your system you can allow or disallow the correspondent compressing method, by checking and unchecking their checkboxes.

10. ZIP call syntax.
Because the syntax used to call ZIP utility is different for different operating systems, you must specify the syntax  your particular ZIP utility will use.
For example, Unix zip command looks like this:
zip -qj
Windows command line ZIP program, Wzzip (from WinZIP.com):
Wzzip -Pr

11. Syntax used to suppress the output from ZIP utility.
If you use Windows online zip program Wzzip, you must use the following string:
1>NUL
to redirect useless information to NULL device

Now, when you finished, click SAVE AND EXIT button

Good luck!

 

 

 

Questions regarding installation and bug reports please forward to tech@edatanew.com .

 

 

Previous

TOC

Next