Can you please tell me how to create a SQL database without TelNet

Thanks for your help so far...

andy

Read 4 or 5 posts upwards!

I mentioned build.cgi

Paul Wilson.
(Dont blame me if I'm wrong!)

I ran that, but all i got was;

AdConfig.pm options (double check these)
Your AdCycle Login Name: admin
Your AdCycle Database Name: adcycle
MySQL User Name: mysql_user_name ("mysql_user_name" Must be set manually in MySQL)
URL of Adcycle Directory: http://www.your_site.com/cgi-bin/adcycle
URL of Adcycle Image Directory: http://www.your_site.com/adimages


>>>
>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>> START BUILDING ADCYCLE >>


Step 1 - Checking for Perl

>> Great! Perl was found


Step 2 - Checking for DBI.

>> Today must be a good one. DBI was found


Step 3 - mySQL driver check

>> Almost finished.... mySQL driver was found


Step 4 - Trying to connect to database.

** If you don't see the message "Database was found!", please check to see if you have
** created a database called "adcycle" and have the permissions properly set.



Any help you can offer will be much appreciated

Andy

You need to edit the variables in AdConfig.pm the run build.cgi



Paul Wilson.
(Dont blame me if I'm wrong!)

I have set up AdConfig.pm as far as i can, but i can't obviously put a username or password for the SQL database as it doesn't exist! Also, what does the following code mean?

####################################################################
### OPTIONS 8-16 CAN ONLY BE ADJUSTED BEFORE RUNNING build.cgi ###
####################################################################

#-- 11. MySQL DATABASE NAME (*** set only before build ***)
$self->{'_db_database'}="adcycle"; #<<<<-- MySQL database name (usually leave as-is)

#-- 12. DBI IP ADDRESS (necessary in some cases)
$self->{'_db_ip'}=""; #<<<<--optional IP(":IPADDRESS") or domain name(":DOMAINNAME") (usually leave as-is)

#-- 13. MAX NUMBER OF BANNERS IN EACH CAMPAIGN (*** set only before build ***)
$self->{'_banner_qty'}=10; #<<<<--the maximum number of banners per campaign (usually leave as-is, 50 MAX)

#-- 14. MAX NUMBER OF GROUPS USED
$self->{'_pool_qty'}=10; #<<<<--the maximum number of groups (usually leave as-is, 200 MAX)


}#END KEY VARS


The results i get for build.cgi is now a pop-up asking me to download the page, and when i do that i get the following;



AdConfig.pm options (double check these)
Your AdCycle Login Name: admin
Your AdCycle Database Name: adcycle
MySQL User Name: mysql_user_name ("mysql_user_name" Must be set manually in MySQL)
URL of Adcycle Directory: http://www.ads.ace-installer.com/cgi-bin/ads
URL of Adcycle Image Directory: http://www.ads.ace-installer.com/adimages


>>>
>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>> START BUILDING ADCYCLE >>


Step 1 - Checking for Perl

>> Great! Perl was found


Step 2 - Checking for DBI.

>> Today must be a good one. DBI was found


Step 3 - mySQL driver check

>> Almost finished.... mySQL driver was found


Step 4 - Trying to connect to database.

** If you don't see the message "Database was found!", please check to see if you have
** created a database called "adcycle" and have the permissions properly set.

Any ideas?

Well if you havent got a database then you need to get your webhost to create one for you otherwise you cant use adcycle.

Once they have set it up for you and given you your username and password, then you can fill in the rest of the information.

This will be replaced by the name of the database that your host gives you.

This can usually be left blank but is sometimes localhost.

MAX BANNERS is how many banners you want to allow each advertiser to use per campaign.
The number of groups is obviously how many groups you want.
A group is a collection of advertisers that have signed up for the same type of account. eg Keyword Targetting or ordinary banner advertising etc.

Paul Wilson.
(Dont blame me if I'm wrong!)

As i said earlie in this topic, i am on a mates server and he doesn't know how to make SQL databases. Does anyone know how i can make one via the net (i live in the UK and he lives in Sweden!)

Thanks

A.J.Newby
webmaster@ace-installer.com
http://www.ace-installer.com

Does he have MySQL installed on his server?

If not he can get it at http://www.mysql.org

He needs to install it (mysql -install)

If you dont know how to create a database then download phpMyAdmin. This is a web based client for MySQL allowing you to create databases and administer MySQL from your browser.

It is very easy to understand.

Download it here: http://www.phpwizard.net/projects/phpMyAdmin/



Paul Wilson.
(Dont blame me if I'm wrong!)

Great, i'll try that ASAP

Andy