Ad Server Solutions provides automated self serve ad management software applications and remotely hosted ad serving services for online advertising. Buy and sell advertising space, manage, track and report all advertising.


Installation Instructions for Ad Server Solutions Software Applications

Thank you for choosing Ad Server Solutions software technology solutions.

We encourage you to read this guide which will provide you step by step instructions for installing the new version. Should you wish to utilize our professional services, please visit our Ad Server Solutions homepage at http://www.adserversolutions.com for details and price list. This document is about the complete installation instruction the product to be ready in running form. There are two major parts of the instructions. One is Database installation & configuration and other is program (the product) installation/configuration.

Java today has emerged as a leading technology and has been adopted worldwide for the important advantages it offers over other CGI technologies.

Java operates on a "write once, run everywhere" philosophy and this flexibility, in conjunction with open standards, is evident from the fact that our system can run on the following systems:

Operating Systems Databases
Windows based MySQL
Unix based MSACESS
Linux based SQL Server
Oracle
DB2

Database

Before you can continue with setup, you have to choose a database installed with correct authorities.

Tips when installation is complete, before setup configuration:

When using SQL Server, Oracle or other databases

1. Execute script sql , this will create tables and populate with data.
2. In your registry by ODBC Panel you have to input a name for datasource , make sure it is the same name in the DSN System (dont forget)
3. Go to file Db.conf ("YourApp"/Config/)
3. For parameter DBDNAME change the value for this : <use the same name of datasource registry in ODBC Panel>
4. Change value for username, password likewise.
5. Value of DBDPORT is blank, for this connection is not necessary.
6. For parameter DBDRIVER change the value for this : sun.jdbc.odbc.JdbcOdbcDriver
7. For parameter DSN by default is Y

When using MySQL

1. Execute script file to generate tables and populate with data
2. Go to file Db.conf ("YourApp"/Config/)
3. For parameter DBDNAME change the value for this : <use the same name of datasource created in MySQL>
4. Change value for username, password likewise.
5. Value of DBDPORT by default in MySQL is 3306
6. For parameter DBDRIVER change the value for this : org.gjt.mm.mysql.Driver
7. For parameter DSN by default is N


Installation

You can leave this section if all of mySql database components are already installed to your system. Otherwise you should follow the instructions and install your desired component:

MySql Server

  1. Download mySql 4.1.x or higher from http://www.mysql.com website if it is not installed in your system.
  2. After downloading the setup double click in it begin installation.
  3. After installation complete the setup will show you a configuration wizard.
  4. Click Next and Next.. until you reach in the window of security settings.
  5. Uncheck "Modify Security Settings" option and the again click next .. next until it is finished.
    6.

 

MySql Editor (SQLYog)

  1. Download mySql editor from http://www.webyog.com/en/downloads.php and install it.
    2.

 

Configuration

  1. /setup folder under admanagement folder contains database scripts for setting SQL Server /MySQL and other databases. Copy the database script file adserver_mysql_v_4_0.sql
  2. Now open SQLYog (MYSQL Editor) on your desktop and from tools menu choose "Import From SQL Statement"
  3. Browse the file "adserver_mysql_v_4_0.sql" as you have copied in previous step and click on execute. That's it. The Database has been created. 
    4.

 

 MySQL ODBC Driver Installation (for DSN mode of database)

  1. This component is required when you choose DSN for Database connection, otherwise you can ignore it. Download ODBC driver for java from http://dev.mysql.com/downloads/connector/odbc/3.51.html  and install it.
  2. Go to ‘Control Panel’ to the system, go ‘Administrative Tools’ and then ‘Data Sources (ODBC)’.
  3. Under ‘User DSN’ tab click Add button if you are creating new DSN otherwise select the DSN name from the list and click configure.
  4. If DSN is newly created then select ‘MySQL Driver 3.5’
  5. Provide the information about the database that you have set during installing and configuring the database server and script respectively. 
    6.

 

Program Installation

  1. Download tomcat 5.5.17 from http://tomcat.apache.org/download-55.cgi  and extract it to your specified drive/directory.
  2. Copy the Admanagement folder in /webapps folder of tomcat.
  3.  Make sure you should have write and execute permission to the files/directories given bellow:
    4.

Admanagement/config/db.cfg
Admanagement/subscribers/1/images
Admanagement/logs/Error.log

Application Setup

  1. Restart the server and open the website http://www.website.com/Admanagement/setup.jsp
  2. At this page you should enter your default admin account at the top two fields, your system configuration settings and database configuration.
  3. You should be careful to provide the information about database and the system.
  4. For example if you choose DSN mode of database then you should follow the optional instructions mentioned above (10 through 14).
  5. It will put you on the login page of the Admanagement.
  6. You can provide the user name and password that you have set on /setup.jsp screen as an admin publisher.
  7. If there is some error then you should contact your system administrator. The problem may unsuccessful installation of Database component(s) or incompatibility of your provided with your created parameters like database name, database user name, database password etc.
    8.


Those are the correct parameters for the configuration.

admin user: user
admin password: password
admin email: your@email.com
admin email password: mypassword
Current Installed HTTP Dir: /admanagement  (not http://www.website.com/admanagement )
Domain: www.website.com   (not http://www.website.com )
IP: 251.196.430.822
EMAIL host: smtp.woa.com

DB Host: www.website.com
DB Port: 3306
DB Driver: org.gjt.mm.mysql.Driver
DB Name: mysql
DB User: root
DB Passw: root
Key: 2001609002-3570


Here are some FAQ: Frequently Asked Questions:

I run Perl version from Ad Server Solution? Can I immediately install Java version?

No. Java applications require Java Servlet Engine and Java Run time Environment to run. Java Servlet engine is also called web container. These two components enable Java to run on any operating system.

Who do I talk to about these technologies?

Our recommendation is that you talk to your web hosting company if your applications are hosted. If your systems are in-house, then speak with your system administrator.

Does it mean I have to pay extra for these new technologies?

No. Java based technologies are FREE. But system administration comes at a cost. If you host your website with external company, check your hosting features for these technologies. If these technologies are available, you can jump to installation of Ad Server Solutions section of this FAQ. If not, then talk to your hosting company about providing these technologies so that you can run Java based applications.

My hosting provider is not willing to provide these technologies to me.

Usually, they will because this gives them an opportunity to make their systems Java enabled, thereby attracting more customers. But some hosting companies might just refuse. In such cases, consider changing your hosting provider or contact Ad Server Solutions for hosting options or subscription.

What different options does Ad Server Solutions offer to get me up and running?

Ad Server Solutions provides the ad solution under the models given below. Please visit our pricing section for price details.

Hosted Services We run hosted services where customers can be hosted on our servers. Everything is our responsibility. This is the fastest way to get you started. Once you complete the subscription form and payment is processed, we can get you started within 15 minutes.
Ad Management Under this option, customer can install the software on their server and manage their advertising on their web sites.
Ad Network Add On
(to Ad Management)		 Under this option, customers can themselves run a complete ad network and sign up Companies, Publishers and Advertisers. You can buy and sell ad space for all of your web sites. includes billing, automation, payment service integration and much more.
*This is an add on module for the ad management software and will not run on it's own. (Both the ad management and ad network software must be purchased).
Affiliate Under this option, customers can install the software on their server and manage their own affiliate systems on their web sites.
Banner Exchange Under this option, customers can install the software on their server and manage their own banner exchange.

I have decided to install the software on my server. Are there any installation differences between the different software applications?

No. Java run time environment and web container installation is same for both. System setup instructions for these will be the same as you will find out later when you configure Java system after system administrators give you a go ahead.

So, what do I tell system administrator about web container and Java run time engine?

You may consider directing your system administrator to this section of the FAQ that provides detailed information on Java system administration. At this point, furnish the following information to the administrator:

"A base directory will be needed where application will be installed. Preferred base directory name is advert. This directory must be web enabled so that HTML/JSP/Servlet requests can be processed. Effectively, what this means is that web requests with path http://www.website.com/advert should be processed & served to the browsers"


Installation Instructions for Java Runtime Environment & Java Servlet Engine for All Platforms

**System Administration Instructions** Click Link

My system administrator tells me that installation is complete. What do I do next?

You will still need services of your system administrator for database set up, mail server information and other miscellaneous activities. Next is software installation. Based on your submission of details like operating system and Ad Server Solutions product option,

After installing system directories, you must make sure that file write permissions to files/directories given below are there. If proper permissions are not in place, features like initial setup and banner upload will not work.

advert/config/db.cfg
advert/subscribers/1/images
advert/logs/Error.log

Unzip successful. Can I use the system now?

Not yet.  You will now be taken through a process of Ad Server Solution system setup. Once this is complete, you will be ready to use the system.

How do I perform setup then?

Visit the following website: http://www.mydomain.com/advert/setup.jsp. If you do not see a page with form to enter system parameters, there is a problem. Contact your system administrator and report the problem. Most likely problem is that web container and java run time environment installation has not been successful. Until you see this page, you cannot move forward with system setup.

I see the setup page now. What next? Database setup?

Yes. Before you can continue with set up page, you will have to work with your system administrator (more specifically database administrator, DBA) to get a database of your choice installed with correct authorities. At this point, furnish the following information to the DBA:

"Create a database called advert (you may call give your database any other name) and provide userid and password for authentication. This id must have CREATE/DROP TABLE authority in addition to regular SQL statements. Also install appropriate JDBC/ODBC driver. In case of Windows platform, create a DSN name called advert. Please supply MSACCESS database present in /advert/setup/ directory for Windows version or .sql file for SQL server database setup. For MySQL database, supply .cgi file to your database administrator."

Installation Instructions for Database Administration

**Database Administration Instructions for Windows** Click Link

**Database Administration Instructions for Unix/Linux/Others** Click Link

Database is set by the DBA. Can I continue with system setup?

Yes, now you can. Go to website.com/advert/setup.jsp to continue with ad server solutions setup parameters.

Setup seems to have completed. Where do I go from here?

At the end of system setup, you will be taken to a logon screen. This logon screen will be the one point of entry for ad network administrator, ad manager and advertiser.

1. Ad Network Administrator: admin/temp
2. Publisher Administrator: userid/password that you choose on setup screen.
3. Advertisers can sign on only after Ad Managers create accounts for their advertisers.

What about support?

You can contact us for support issues. You may also utilize our professional fee based services for system implementation.

Ad Server Solutions 1996-2007. Any reproduction or editing by any means mechanical or electronic without the express written permission of the copyright holder is strictly prohibited.