Having successfully installed a Webalizer PKG I am getting confident now! I would like to install a MySQL PKG. How risky is this (bearing in mind I am a novice!)? I am fine while I am in the control panel following instructions but once it gets to linux command line stuff I get worried.

My RaQ has OS2 update. Will this be OK?

The pkgmaster.com site has two versions of MySQL (3.23.37 and 3.23.36) Does anyone know which I should use? I can't understand why 3.23.36 is still there if it is superceded by 3.23.37 unless there is a good reason!

Will these versions of MySQL work with the default version of PHP that comes with my RAQ? Because I am trying to learn database driven websites

Any help (and your tolerance) appreciated

Alan

i think the 3.23.37 version from the pkgmaster site would be okay and install without any problems.
I have had that installed without any problems

Installing MySQL as a .pkg is as easy as installing Webalizer except it takes longer!

It would probably be a good idea to ensure you have all the RAQ updates installed before installing MySQL (I would use the .37 version). It will work with the default version of PHP, but again it may be an idea to upgrade PHP to ensure everything is fairly new versions.

Don't forget that after you have installed MySQL you need to telnet/SSH to your server and set the root password or your installation will be insecure. If you need help on that let me know.

Thanks for the help.

Here is a list of software updates I have got, does anyone know if these will be ok for MySQL 4.23.37?

Relational Database Server and Client tools by InterBase. Release V6.0
Cobalt OS Release 6.0
RaQ4-All-Security Release 1.0.1-10749
RaQ4-All-Security Release 1.0.1-9353
RaQ4-All-Security Release 1.0.2-8762
RaQ4-en-OSUpdateRelease 2.0
Third Party Disaster Recovery Release 1.0.2-9198
OS Restore PGSQL On-Start Fix Release 1.0
Webalizer Release 1.30-04-7GIF-4

I get quite nervous installing pkgs because a while ago while installing around 20 cobalt packages (in order) one crashed half way through and messed up my server. In the end it needed a rebuild by the company I lease it off (hence why its got OS release 2.0) Thats why I tend not to install any more than I have to and would prefer to leave php as it is.

When I install official cobalt packages I telnet them to my raq using > ftp ftp.cobalt.com Is there an equivalent site for the pkgmaster site because at the moment I am ftp ing the files to my windows machine and the ftping them up to the RAQ. I would prefer to download them straight to the RAQ.

I may call on the help for telneting the security changes. I know the principle of telnetting but I am not aware of all the linux command line syntax.

Thanks again for the help so far. This is a great forum.

log into ur raq by telnet/ssh
and then follow the instruction for installing mysql from here

http://www.raqhowto.com/kbase/index.php?id=8&bt=info :)

there are also many good how-tos on this ite follow them and your raq would be secured :)

OK, you have a few updates to do. Go to http://emea.cobalt.com/support/download/raq4.eng.html for these. IMPORTANT: Make sure you install them in order, from the bottom up.

But you can install MySQL without these and then install these updates later, so let's concentrate on one thing at a time!

It's probably a good idea just to install one .pkg then reboot before installing the next one. Not always necessary, but certainly a precautious approach can't do any harm!

You don't have to FTP the package to your server, as you can select the Browse option in your RAQ CP and pick it up from your pc. With a large pkg like MySQL though it is probably better to FTP it.

For your MySQL root password:

Because your installation is initially wide open, one of the first things you should do is specify a password for the MySQL root user. You can do this as follows (note that you specify the password using the PASSWORD() function):

shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password')
WHERE user='root';
mysql> FLUSH PRIVILEGES;

Obviously replace new_password with the new password!

Me again.

Thanks to everyone for your contributions.

I am nearing completion of a FTP transfer of MySQL pkg 3.23.37 from my PC to my RAQ packages directory. In about 20 minutes I will be installing.

I do not need to use ASP. Do I still need to go through the chillisoft routine or can I leave it and just do the security change?

Alan

I have gone for it and installed the MySQL 3.23.37 pkg to my RAQ. I then went through the routine suggested by SixthSense in http://pkgmaster.com/howto/casp_mysql_howto.shtml

I got to stage 7 when I run into problems.

For server I put my IP address aaa.bbb.ccc.ddd
For port I left it at 3306
For database I was stumped I did not know the name of a database so I left it blank
For user I said root
For password I said cobalt-mysql

Then I went to stage 8 to test the DSN.

First I ran into a problem because the database was stopped. I went back to the main ASP control panel and started it.

Then when I tested it I got the following error:

"Test connecton failed

Error: -2147418113
Description: Chili!ASP ADO control - build 3.4.1 Open call failed"

HellPPP!!!!

Now what do I do?

Originally posted by nolittle
I have gone for it and installed the MySQL 3.23.37 pkg to my RAQ. I then went through the routine suggested by SixthSense in http://pkgmaster.com/howto/casp_mysql_howto.shtml



I never suggested you that pkgmaster howto :mad: .
All i sugested is the how-to written at www.raqhowto.com to install mysql , and other security related stuff for a raq.

I personally feel that raqs are not meant to run ASP , you better get a windows box for it and i myself have never turned on the ASp server on my raq.
Sorry can't help you on this

SixthSense

I followed the link you suggested shown below:

http://emea.cobalt.com/support/download/raq4.eng.html

At the bottom of the page it provided another link called "setup site on pkgmaster" (this goes to http://pkgmaster.com/howto/casp_mysql_howto.shtml)

I am fairly new to all this and I assumed I had to do this as well.

The pckmaster help was simple "janet and john" instructions with pretty pictures that looked easy to follow so I was happy to do so.

The upshot is.

MySQL seams to work (well I've created a simple database via telnet anyway and read back the data input). But the final test to check out chillisoft asp failed (as shown above).

I am not massively concerned about this because I want to use php with mysql not asp. My bigger concern is I don't like things that don't work unless I know why because there may be other side effects that I don't know about.

If anyone could help me resolve the test failure mentioning in an above posted I would be very grateful. Failing that If anyone knows if I need not worry about it that would also be good.

Thanks for your help.

Alan :)

:rolleyes:
you are again mistaken my dear it was grb123 who gave you this link not me.
Clear the dust off your PC monitor :o

SixthSense

Your right I picked up the link from the wrong place. The last posting should have read:

"I followed the link you suggested shown below:

http://www.raqhowto.com/kbase/index.php?id=8&bt=info

At the bottom of the page it provided another link called "setup site on pkgmaster" (this goes to http://pkgmaster.com/howto/casp_mysql_howto.shtml)

I am fairly new to all....."

NOT

"I followed the link you suggested shown below:

http://emea.cobalt.com/support/download/raq4.eng.html

At the bottom of the page it provided another link called "setup site on pkgmaster" (this goes to http://pkgmaster.com/howto/casp_mysql_howto.shtml)

I am fairly new to all ....."

Which you are right refers to the link GRB123 suggested, which is entirerly different.

Apologies for any confusion.

Confusions do happen
Anyways i have myself tried the ASP DSN but been never successful.
It has no after affects as such.
Just turn ASP off if you dont need it as it consumes a lot of resources. :cool:

Thanks for you help

I have stopped the ASP server by clicking the stopped option in the "ASP server administration" window.

Should I also uncheck the "ASP server administration" in the server management control panel as well?

Alan

:)

Uncheck it? Yes you should do that asap as there is no reason whatsoever to keep that checked :)

wildo, thanks, bye :)