Installation Instructions for Database Administration for Ad Server Solution on Unix/Linux/Others

What databases does Ad Server Solutions work with on Unix/Linux/Others platform?

Most popular free database on these platforms is MySQL (http://www.mysql.com).  Other options, although expensive are Oracle and Sybase.

Ad Server Solutions system has been designed flexibly and can work with any database, provided appropriate database driver has been loaded.

What specifically needs to be done?

Ad Server Solutions application will require an instance of database to be available. Database name will be advert, but any name may be chosen.

/setup directory under advert contains database scripts for setting  MySQL database. 

For MySQL installation, two types of scripts have been provided. One is a perl script (adserver_mysql_perl.cgi) that may be run if Perl is intalled on the system. The other script (adserver_mysql_sqls.txt) may be used directly on MySQL command line or other online facility like WebAdmin to create required tables.

If you wish to use any other database, please contact Ad Server Solutions for installation scripts pertaining to your database selection.

What about database driver?

There are over 160 JDBC database drivers for MySQL. Most popular ones are MM and Resin. Both drivers are available at http://www.mysql.com along with detailed installation instructions.

MM driver has been supplied with Ad Server Solutions software package but separate installation could be useful.

For Oracle, visit http://www.oracle.com. There are numerous third party driver products available. Click here for a list of vendors and drivers they supply.

What about DSN?

With MySQL, DSN is not required. Java programs will load the driver and connected with specified database name. You may however use DSN for MySQL but it will need drivers like MyODBC to be installed.

For Oracle and other databases, create a DSN name called advert and specify database specific information like server name, port number & authentication information. This DSN will be used by the application to connect to the database.

What about database user authentication?

Create an id called advert for the application. This id must have CREATE/DROP table authority, in addition to regular SQL statements. Also ensure that this id has sufficient user permissions on the database to be able to perform database operations.

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.