I know, I know. It's not really fair to use Gossamer Threads generouse bandwidth and space for this post, but i have tried the AdCycle forum with no avail, so i thought i would try here :) The problem i am getting is when i run build.cgi (the script i am trying to install is AdCycle at http://www.adcycle.com). I get as far as shown below, but i keep getting the error in stage 3. I know i have mySQL on my server, and my host seems to think i have all of the required modules etc installed (i sent them a list from the Readme). Can anyone help me??? PLEASE!!!

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

mySQL driver was not found. Please download it from the URL in the README file.



http://www.ace-installer.com
webmaster@Ace-installer.com

Nope, this really should be in the Discussion topic. But just as a guess, you probably don't have DBD::mysql. If you're on a host that has MySQL installed but not DBD::mysql, it might be time to find another host.

Good Luck!

Thanks. I've contacted them to ask if they have it. But when using PerlDiver it doesn't look like they have it!!! Can't they just install it on their server???

Andy

http://www.ace-installer.com
webmaster@Ace-installer.com

Sure, its really simple to install. I just can't believe they have MySQL installed and not the driver. Thats like having a hot sports car but no tires.

Well, they may have it, but it just doesn't show up on perldiver.cgi (they even admit their script won't find every module installed on servers). Who knows!!!

Andy

http://www.ace-installer.com
webmaster@Ace-installer.com

Are you sure you have a webhost there and not a teenager with a fast connection..

LOL.......

Our server is up 'n' running again if interested but I can't give you such a cheap offer because upgrades etc have made a dent in our funds

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

Yes, they ARE a proper web host. Their support is great, and now they said they are going to add the module for me.
And yes, i know you were joking!!!

Andy


http://www.ace-installer.com
webmaster@Ace-installer.com

lol...

For those interested in hosting please go to http://www.wiredon.net

This isnt spam....it is kinda relevant to the thread as it is to do with hosting.

If you wish to sign up for one of the deals please email paul@audio-grabber.com because we haven't had time to add the shopping cart yet the site is so new.

We use mod_perl, speedycgi, php4 with zend optimizer, asp and loads more cool stuff.

Oh...also we will install any perl, cgi, or php script for you.

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

As you can tell, i'm not really very used to mySQL. What does this error mean (called the build.cgi script from telnet);

DBI->connect failed: Access denied for user: 'aceinst_youradds@localhost' to dat
abase 'aceinst_a' at AdConfig.pm line 162
Can't call method "prepare" on an undefined value at build.cgi line 108.

Thanks

Andy

http://www.ace-installer.com
webmaster@Ace-installer.com

Andy,

I had the same error as your last error when installing adcycle. I had my web host reset the database and everything installed perfectly.


Jimmy Crow
http://www.homewithgod.com/

Access Denied means that in AdConfig.pm you either entered incorrect values for you mysql username, password, host or database name

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

I actually installed adcycle from my browser by adding #!/usr/bin/perl and print "Content-type: text/html\n\n"; to the top of build.cgi

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

Have you seen the new shareware version of adcycle?...Its pretty nifty.

Its got TONS of features and has a 30 day trial limit and has pretty good security preventing you from killing the limit but there is a way :) (not that I did it of course)



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

Hello all,

You received this error messages because your database in mysql doesn't have the correct permissions.

You need to add this permissions:

GRANT ALL PRIVILEGES ON *.* TO login@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO login@"%" IDENTIFIED BY
'password' WITH GRANT OPTION;

The password is the same that's you choose in AdConfig.pm

Thanks a lot!
Luchini
http://www.buscasite.com/

What, fastAdcycle?

Andy


http://www.ace-installer.com
webmaster@Ace-installer.com

What?

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

Don't worry I just looked at their site and saw what you mean!!! But, can i ask one question, what is the usual format to connect to a database? I am using;

mysql aceinst_a -uaceinst_ads -pads
ERROR 1044: Access denied for user: 'aceinst_ads@localhost' to database 'aceinst_a'.

Is this the correct format? Cos i keep getting errors even when everything seems to be correct!!!

Thanks

Andy



http://www.ace-installer.com
webmaster@Ace-installer.com

mysql -uUSERNAME -pPASSWORD

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

Check that they are the correct login details for your database

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

Thanks, but i worked it out anyway! I didn't realise that you had to actually add the user to the database once you had made the user in the mySQL command lol....

Andy

http://www.ace-installer.com
webmaster@Ace-installer.com

Hi. I have now got the admin page working at http://216.74.111.73/cgi-bin/adcenter.cgi, but the password and username i set in the AdConfig.pm file ($self->{'_admin_user_name'} and $self->{'_admin_password'}). Am i doing this wrong?

Andy

http://www.ace-installer.com
webmaster@Ace-installer.com