|
This is a step-by-step
document on how to create a MySQL DSN for use in a ASP page. Each step
will be accompanied by a screenshot to illustrate the procedure. There
are separate sections for the RaQ3 and RaQ4 in each step of the procedure.
Instructions for either the RaQ3 or RaQ4 will begin in BOLD
GREEN text.
A MySQL
package for the Cobalt Server Appliance is downloadable from
http://PkgMaster.com.
This package assumes no prior installation of MySQL and will install the
necessary RPM files. It will also install Perl DBI and the DBI MySQL module.
If you have made an attempt to install MySQL by other means, remove all
traces of it before installing this package. This will not upgrade a prior
installation of MySQL unless explicitly specified.
This HOW-TO has
been tested and verified to work with MySQL packages obtained here.
The MySQL Driver that
comes with Chili!ASP has a size limit of 8Kb for the SQL statements passed
to it. The latest patches have increased this limit. Contact Chilisoft
Technical Support at tech@chilisoft.com
if you have any issues.
Step
1
For
a RaQ3, log into the Web Interface and view the Install
Software menu. Click on the Chilisoft ASP link listed under
Software on the Cobalt Server.
For
the RaQ4,
log into the Web Interface and view the Services menu under Control Panel.
Click on Parameters of the ASP Administrative Server.
IMPORTANT
NOTE
If the Parameters option is not available, you need to enable the checkbox
(and don't forget to Save Changes) to start the ASP Administrative Server
first.
Step
2
For
a RaQ3, click on the link to the ASP Administration Console,
as shown below.
You will then be prompted
to log in (see screenshot below) - the default login name is
admin - the default password is root
For
the RaQ4,
you will be prompted to log in. The login user name is admin - the
password is the same as your Cobalt admin password.
Step
3
For
a RaQ3, click on the Manage a server link.
Next, click on the
properties link.
Step
4
For
a RaQ3, click on the Databases link.
For
a RaQ4, click on the Databases link.
Step
5
For
a RaQ3, click on Add New DSN.
For
a RaQ4, click on Add New DSN.
Step
6
For
a RaQ3, select MySQL and click Next.
For
a RaQ4, select MySQL and click Next.
Step
7
For
a RaQ3, enter a DSN name and description and click Next.
For
a RaQ4, enter a DSN name and description and click Next.
Step
7
For
a RaQ3, enter the details of the DSN and click Next.
For
a RaQ4, enter details of the DSN and click Next.
IMPORTANT
NOTE
Server - the IP address of the server running MySQL (or localhost if it's
the same machine)
Port - defaults to 3306 if not filled, which is the normal port that MySQL
runs on.
Database - the name of the MySQL Database that you wish to access, assuming
it's been created.
User - the MySQL username that is able to access the defined Database.
Password - the password for the defined User.
For more information, see http://www.mysql.com
under Documentation.
This will lead to
the following screen to complete the Add New DSN process.
Step
8
For
a RaQ3, test the DSN you just created by clicking on test.
For
a RaQ4, test the DSN you just created by clicking on test.
A successful test
will show:
A failed test will
show:
IMPORTANT
NOTE
On machines without the latest Chili!ASP patch, the Test DSN link will
give the Failed error every time after it fails once. Either install
the patch by clicking on this link (the patch is a standard PKG file
that you install via the RaQ's User Interface) or restart the ASP engine
each time this occurs.
It is
included in OS Update 1.0 for the RaQ4
and Chili!ASP
Interbase Fix for the RaQ3
Step
9
For
a RaQ3 and RaQ4, here is an example of the ASP code using a
DSN called COBALT.
<%
ConnString = "DSN=COBALT"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConnString
Conn.Execute .....
....
....
Conn.Close
Set Conn = Nothing
%>
A DSN-less
connection looks like this:
<%
ConnString = "Driver={MySQL};SERVER=localhost;DATABASE=mysql;UID=user;PASSWORD=password"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConnString
Conn.Execute .....
....
....
Conn.Close
Set Conn = Nothing
%>
Step
10
For
a RaQ3 and RaQ4, here's how you change the default MySQL root
password.
Telnet into your RaQ
as admin and type "su -" to login as root.
Next, issue the following
command to change the root password.
mysqladmin
-uroot -pcobalt-mysql password NEW-PASSWORD
If it works, you won't
get any message, it'll just return the prompt again. Type "exit"
and press Enter to log out completely (do it twice).
|
