Web Hosting Talk







View Full Version : Alabanza - Mysql/Allmanage.


-Edward-
08-30-2000, 02:41 PM
Ok since a lot of alabanza hosts hangout here ill ask for help here :p. I've been trying all day long to get allmanage working on my site. The MYSQL version but cant lol. as anyone attempted to install this before on an alabanza server?. I have copyed and pasted the mysql section of the script and really dunno how todo this i set it up fine on a tera-byte server but for the life of me cannot do it on alabanza. Once again sorry if this is off the topic. :).

##############################
#
# Full path to mysqladmin (if not set in the path.)
# N.B. if you get an error saying "...Cant call method prepare
# without a package object or reference...." it is because
# the script cant find the "MYSQLADMIN" command.
# on NT it the C:\mysql\bin\...path.
#

$mysqladmin = 'mysqladmin';


#############################
#
# This should be left to read mysql, as These commands
# probably wont wotk with any DB other than MySQL...
#

$driver = "mysql";

#############################
#
# The name of the database that will be (or already is) created
# to hold all the table information. N.B. This database CAN exist
# already. If it does exist, the tables will be created INSIDE this
# database. If your database is located on another server,
# enter the database in the following format:
# $database = "<DATABASE_NAME>:<SERVER_LOCATION>";
# i.e. $database = "allmanage:mysql2.someserver.com.au";

$database = "allmanage";

#############################
#
# The name of the table for the main data structure. DONT
# change this...it is referenced throughout the other scripts.
#

$main_data_table = "main_data";

#############################
#
# Same as above, but to hold the admin data
#

$admin_main_data_table = "admin_main_data";

#############################
#
# Ditto for the two above, except for default messages.
#

$messages_table = "messages";

#############################
#
# The username / password you use to connect to the database.
# If you dont usually use use a value, that is from the command prompt,
# you simply type: mysql ... or you have never used mysql before, leave
# the values as they are. three examples:
#
# username/password are mike/21trt6554w
# my $username="mike";
# my $password="21trt6554w";
#
# username/(NO PASSWORD) are root/(NONE)
# my $username="";
# my $password="";
#
# (NO USERNAME)/(NO PASSOWRD) - typically for a local machine...
# my $username="";
# my $password="";
#

$database_username = "";
$database_password = "";


my($sth,$dbh,@row);

#############################
#############################
#
# Now, heres where the fun starts!!!
#
# DONT WORRY ABOUT CHANGING ANYTHING
# BELOW HERE UNLESS YOU KNOW WHAT YOU
# ARE DOING.................
#
#############################

-Edward-
09-01-2000, 04:09 PM
I have finally got the script working. But with a lot of help from hostrocket technical support i.e John. he took nearly an hour of his time to create all the databases manually as the script wouldn't make them for some reason.

So both thumbs up for HostRocket :-).