Gossamer Forum
Home : Products : DBMan SQL : Discussion :

DBManSQL on Localhost

Quote Reply
DBManSQL on Localhost

I recently installed Apache2 (plus ActivePerl, MySQL, PHP) on my WinXP system. I then installed DBManSQL (little tricky but seems to work OK). Smile

I did this for two reasons -

1/ So I can use INNODB tables (my current host doesn't support them),

2/ So I can test everything offline.

I was just wondering if anyone else has tried it on a local sever and how it's running?


Quote Reply
Re: [jai] DBManSQL on Localhost In reply to
Can someone give detailed instructions on how to set this up on a local machine for offline testing purposes?

Quote Reply
Re: [donm] DBManSQL on Localhost In reply to
How far have you got so far?
Have you installed Apache, ActivePerl, MySQL, etc. or are you starting from scratch?
Quote Reply
Re: [jai] DBManSQL on Localhost In reply to
Starting from scratch

Quote Reply
Re: [donm] DBManSQL on Localhost In reply to
I did this sometime ago and got it to work but I'm not sure how relevant it will be now. Following are my own notes that should steer you in the right direction (although I don't know if all the links will still be valid).

Installing Local Server
My System:
Win XP Pro/Apache 2.0.47/Active Perl 5.8/MySQL 4.0/PHP 4.3.

Installed Files:

Reference 1: http://www.mattjacob.org/server/index.html
(Donft use the versions they say, get the latest ones)
Reference 2: http://www.devshed.com/...ySeamless/page1.html
(May not be 100% applicable but useful anyway).
Apache 2 Installation
Download - apache_2.0.47-win32-x86-no_ssl.msi

Install Apache 2 to H:/Apache (after installation it will end up as H:/Apache/Apache2)
Follow the propts -
Network Domain:
Server Name: localhost
Administratorfs Email:
Check for ALL users, on port 80, as a service (recommended)
Setup Type: Typical
Open Browser and call up or http://localhost/
If you can see the Apache test page then everything is ok.
If there is a copy of index.html in the H:\httpdocs then that page will be displayed.

If there is a problem with the service and itfs not installed or disabled.
First, check under Services and see if Apache Service is installed and running.
If it is not installed, manually install it from Command Prompt:
Adjust the address to suit
"C:\Program Files\Apache Group\Apache2\bin\apache" -k install -n "Apache2"
Restart computer.


Active Perl Installation
Download - ActivePerl-
Install into H:/usr directory
Make sure there is a copy of hello.cgi in the httpdocs directory and call it up using - or http://localhost/hello.cgi
If you see gHello, worldh everything is ok.

If you get a Forbiden Error add the following to httpd.conf after the ScriptAlias section below -
#ScriptAlias /cgi-bin/ "H:/Apache2/cgi-bin/"

# "H:/Apache2/cgi-bin" should be changed to whatever your ScriptAliased
# CGI directory exists, if you have that configured.
<Directory "H:/Apache2/cgi-bin">
AllowOverride None
Options None
Order allow,deny
Allow from all

Add this -
##Added the following so the script is accessable (DON"T KNOW WHY WE NEEDED TO DO THIS)
<Directory "H:/httpdocs">
Options +ExecCGI

Restart Apache and it should work.

MySQL Installation
Download - mysql-4.0.15-win.zip
Unzip to a temp directory (anywhere is ok)
Run the setup and do a Typical install into H:/mysql directory
For re-install - Copy - my.ini to C:\WINDOWS directory
At the Command Prompt type
H: (you should see h:\>)
cd mysql\bin (you should see h:\mysql\bin>
mysqladmin -u root (you should see a long list of details)
net start mysql (you should get a message saying it was started successfully)

Installing DBI and DBD::MySQL-

PHP Installation
Download - php-4.3.3-Win32.zip
For new-install - Copy php.ini to C:\WINDOWS directory
For re-install - Copy your version of php.ini to C:\WINDOWS directory
For new-install - Copy - php.ini-recommend to C:\WINDOWS directory and re-name it php.ini
For new/re-install - Copy - php5ts.dll to C:\WINDOWS\system32 directory

After installing php, you should see the following in the Apache monitor -
Apache/2.0.47(Win32) PHP 4.3.3
Call up or http://localhost/phpinfo.php
If you see the php info page then everything is ok.

DBManSQL Install
Copy install.cgi and install.dat to H:\httpdocs
Call up
Follow the prompts/set paths (note Perl path was set to H:\usr\bin as it would recognize \usr\bin\perl) NOTE:
Wait till everything unpacks.
Click on the admin link - get server error
Change the shebang line to -
in every .cgi file in the admin folder.
Click on the admin link and follow prompts.
Got an error saying Perl DBI was not installed so typed -
at the command line (h:\>)
then typed -
install DBI
You should see -
PPM interactive shell (2.1.2) - type 'help' for available commands

Next I installed the MySQL driver
At the PPM> prompt type -
search mysql
Doing so will return a list of available mysql-related modules. You should see something like
Packages available from http://[package repository url here]
ApacheMysql [0.3 ] Initiate a persistent database connection to Mysql
DBD-Mysql [1.2200] DBI driver for Mysql datasources
At the PPM> prompt type -
install DBD-Mysql

Reference: http://perl.about.com/...weekly/aa032701b.htm

Note: also installed the db_file perl module (needed for Ikonboard) using -
At the PPM> prompt type -
install db_file

Resubmit setup form.
Received error message to say the database didnft exist.
Created a database using database management software (Sqlyog).

Note: may need to change the path to perl in the Admin Setup to /usr/bin/perl.exe

cd mysql\bin
net start mysql
mysqladmin -u root
mysqladmin -u root -p status

Hope it works !!!!!!

Last edited by:

jai: Sep 1, 2005, 3:41 PM
Quote Reply
Re: [jai] DBManSQL on Localhost In reply to
Thanks - that worked!