INSTALLATION

UPGRADING FROM AN OLDER VERSION:

Upload and uncompress new file into cgi-bin directory. CHMOD it 755. That's all.
Both new and old files may coexist.

NEW INSTALLATION:

1. Edit the script. The very first line must reflect the full  path of Perl installation. For UNIX / LINUX in most cases it looks like this #!/usr/bin/perl For Win32: #!c:/perl/bin/perl.exe
2. Upload the script (mdm.cgi - for example) into cgi-bin directory  of the server
3. CHMOD the script 755 (-rwxr-xr-x).
4. Using FTP client (or telnet) create a directory named mdmConfig  under cgi-bin directory.
5. CHMOD mdmConfig directory 777 (or drwxrwxrwx)
6. Create somewhere else a user directory (for example /mdm/data/usr).  This directory will be used to store user files: backups, SQL scripts,  exported ASCII files. This directory must be placed out of the document root. Otherwise  it can be fetched by web browser .
7. CHMOD this directory 777 (drwxrwxrwx)
8. Run the script by typing its URL in the address bar of web browser

Now you can proceed to set up the INITIAL SETTINGS using the online interface:

Home page URL Online Help URL Mysql connection parameters Mysql binary client Path to user directories Allowed size of files Admin email address Compressing methods ZIP syntax Print PopUp window Character set Banner customization

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

If you receive an error message please read it carefully. Please contact us if you can not fix the error by yourself

Questions regarding installation and bug reports please forward to support@cgiscriptshop.com

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

Click  on this link and SETUP  page will be opened.

You must create an 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 then.

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.

. 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.

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 is 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.

Mysql  Client Parameters (mandatory!)

These are used to call binary Mysql client. This client is called when you use the 'Restore'  function 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).

 Path to user directory (mandatory!)

User directory must be created to store user SQL scripts, backup files and imported/exported ASCII delimited files.
It can be placed wherever you wish. For example

For Unix/Linux it looks like:

/home/directoryname/data/usr

for Windows:

C:\MYDOCU~1\MYSQLDIR\DATA\USR

It is recommended to place this directory outside of the document root. Otherwise it can be fetched by web browser.

For each user Mysql Data Manager will create a subdirectory under this directory. Subdirectory names will be based on username and connected host name.
Each user subdirectory will be named as username.hostname, in order to separate user data. Thus, if you are connected to localhost as root, your subdirectory will be root.localhost. All SQL scripts you created will be stored in  root.localhost/sql subdirectory, backup files will be stored in root.localhost/backup. If then, you disconnect from localhost and connect to edatanew.com with username john, the script will create a new subdirectory: john.edatanew.com. Your previously created SQL script and backup files become invisible until you connect to localhost as root again.

 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

 Administrator email address

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

 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

 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.

 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

1. 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

Allow Print PopUp window

Select it if you want the Printer Dialog Box to appear each time you choose "Print the Result"

Character Set

Specify the character set to be used in the documents and forms. This  is useful when you read and write non-English content if the databases. The default value is ISO-8859-1.

Customization of the Banner:

There are the following parameters allowing you to change fonts and colors of the banner and set up an image.

The color of the upper part of the banner.
The color of the Status Bar.
Status Bar Font color.
URL of logo.
Logo Hyperlink and target.
Your company slogan.
Slogan font color.

All colors are expressed in RGB Hexadecimal values . For example
FF0000 - Red (R=FF, G=00, B=00);
003366 - dark blue (R=00, G=33, B=66);
6699AA - light blue (R=66, G=99, B=AA)

Logo URL should be a fully qualified URL (http://domain.com/images/picture.jpg)
or relative path (../images/picture.jpg)

The picture size is not limited. It's up to you how big it will be.

Now, when you finished, click SAVE AND EXIT button

Good luck!

Previous TOC Next

 

 [Home] [Products] [Screenshots] [Demo] [Manual] [Account] [Order] [Contact us]

Copyright © 2007 cgiscriptshop.com