Hi, Could someone tell me how hard it is to install these features on the cobalt raq3?. We are getting one of tera-bytes servers and due to the fact where paying for the ram to be upgraded we won't have the funds for a few months to pay the installtion fee that tera-byte charge. So i was wondering if someone could tell me how hard it would be to install?.

It isn't hard @ all.
You can find an online tutorial @

http://teamcobalt.interliant.com//faqs/faq_scripting.shtml#php


http://teamcobalt.interliant.com//faqs/faq_scripting.shtml#mysql

The mysql one is for raq2 is it the same going up through them all?.

Ha!

I have the same problem - also getting Tera-Byte's $99 RAQ
and am looking for a way to put PHP+MySQL on it...

I have found some very useful resources already though.
(eh... at least I hope they will be useful ;))

For MySQL, try this page:
http://pkg.nl.cobalt.com/

For PHP, search the Cobalt mailing list archives:
http://list.cobalt.com/pipermail/cobalt-users/

i am too looking at a US$99/month terabyte special


These instructions refer to the RaQ3 ONLY!
Do not attempt to use these instructions with other products

QuestionNum: 726
Product: RaQ3
Category Software
Creation Date: Thu Jan 27 13:19:53 2000 PST

Question
What do I need to install MySQL or PHP on a RaQ2 and RaQ3?


Response
NOTE: UNSUPPORTED. Cobalt Networks currently does not offer support for third party software or modified systems. Please contact the appropriate software vendor for further assistance. Modifications through root shell access could potentially void your warranty. A fee will be assessed by Cobalt for fixes or rebuilds on systems with unsupported modifications.

Please note that if you want MySQL + PHP, please install MySQL FIRST

To install an rpm, telnet in to your box, su to root, ftp the file to your cobalt machine, then execute the command:

rpm -Uvh rpmfile

RaQ3
ftp://ftp.cobaltnet.com/pub/experimental/raq3/
mod_php3-3.0.7-4.i386.rpm

depends on libttf and libgd (see below). Same version that we have available for the RaQ2

OR

ftp://ftp.cobaltnet.com/pub/experimental/raq3/


php-3.0.14-2.i386.rpm

php-manual-3.0.14-2.i386.rpm

php-mysql-3.0.14-2.i386.rpm

php-pgsql-3.0.14-2.i386.rpm

newer version. Different from RaQ2. Works fine. Install the php-* other rpms in same dir for pgsql or mysql support depends on a bunch of other things, including freetype and gd.

In the same directory - grab and install:


freetype-1.2-7.i386.rpm

freetype-devel-1.2-7.i386.rpm

freetype-utils-1.2-7.i386.rpm

gd-1.3-5.i386.rpm

gd-devel-1.3-5.i386.rpm

> -MYSQL on Raq3i
ftp://ftp.cobaltnet.com/pub/experimental/raq3/

MySQL-3.22.30-1.i386.rpm

MySQL-client-3.22.30-1.i386.rpm

MySQL-devel-3.22.30-1.i386.rpm


> -MYSQL on Raq2
ftp://ftp.cobaltnet.com/pub/experimental/

MySQL-3.22.21-2C1.mips.rpm

MySQL-bench-3.22.21-2C1.mips.rpm

MySQL-client-3.22.21-2C1.mips.rpm

MySQL-devel-3.22.21-2C1.mips.rpm

Mysql-DBI-perl-bin-1.1825-rh50.1.mipsel.rpm



http://list.cobalt.com/mailman/listinfo/cobalt-users

Comments

Got my server Wednesday (Nov 29) and I've installed PHP and MySQL yesterday.

I can recommend to install MySQL with this package:
http://pkg.nl.cobalt.com/i386/RaQ3-RaQ4-MySQL-3.22.32-1.pkg

I just copy and pasted the URL into the Install Software section and it installed automatically.
After it is finished, just login through telnet, start mysql as:
mysql --user=root -p
The password is "cobalt-mysql" (without the quotes). Be sure to change it.

After this I installed PHP 4.0.3pl1 by downloading the tarball from:
http://www.php.net/
(you can do this from the server itself with the text browser lynx)

For instructions, look in the Cobalt archives (like I did).
After a reboot (just restarting httpd didn't work) PHP worked.

After that I installed phpMyAdmin to make MySQL administration easier.
(http://www.phpwizard.com/)

I'm surprised at how much even 32 Mb. server can handle -
PHP and MySQL run fine. Of course I haven't gotten any actual visitors
on my server yet (still waiting on the DNS to update), but still...

Obviously when I move my main site (650,000+ pageviews and 75+ Gb. traffic per month)
to the server, I'm sure to get some more RAM put into the thing :D

GHDpro,

Does 650000 pageviews consume 75GB? thats averages 115K per page. Would a RAQ 3 handle all that traffic?

My site is about 300000 pageviews & only consumes 400MB a days. Your site consumes 2GB a day.

Me too is looking at tera-byte new offer for RAQ 3 at US99.

aaron

GHDpro how did you order it ? from the 4webspace.com site the order form doesn't list the US$99/month special anywhere ?

he used the tera-byte order page and in the comments field he put 4webspace raq 3 99.00
that will get the job done. the actual order form will be up by monday.

Steve

if you care to get down and dirty (well not) you can "easily" install PHP4 + zend optimizer on a raq3.

I did mine with GD (jpeg, png & wbmp creation), zlib, imap & MySQL. It worked without any problems...

If you need instructions, mail me and I'll get you from where you are, to PHP4. (whic is much faster, btw)

I know where going to need 128mb ram for our server were at the $211 stage now for this first month and its christmas not bad going for this time of year.

aaronx88:
Well, it isn't the pageviews which are eating up all the
bandwidth. My site is a download site, and consumes loads
of bandwidth a day. One single file (of 1 Mb.) even uses up
to 400-600 Mb. of traffic per day (ouch!)...

My site has been on a dedicated server before at DI,
but that became just too expensive as ad income was dropping
fast. DI charged $225 for the server and usually $180 in
bandwidth overcharges, which is just to much to afford
if ad income is only in the range of $300...

That's why Tera-Byte's offer is absolutely great for me.

eva2000.com:
Like Keeg said. Just be sure not to use any quotes
in the "notes" section or your message will get cut off
(like mine did). Fortunately the most important part
("do not setup the package I selected, but") was still
there ;)

About installing PHP4:
Yes, it's indeed easy. Only took about 1 hour... no major
problems at all! MySQL is even easier if you use the link
in my previous post...

Does anybody who has bought into the 4webspace.com $99 RaQ3 special have any idea how long that price can be guaranteed for? (After signing up I mean)

Even with RAM upgrades this is a very cheap deal.

I asked steve and he said until you close your account.

Thanks Technics. Sounds good.

Quick question about getting MySQL installed. I followed GHDpro's instructions and got to the point where I typed in the password. What do I do after this? Or is it already installed? And could someone run through the steps of a PHP install as simple as possible?

[Edited by midhost on 12-05-2000 at 10:48 PM]

If you typed in the root password in MySQL, then it is installed.

Type:
mysql -u root -p

and you will connect to the MySQL server.... or use PHP or CGI/perl to connect to it.

Hi everyone,

Here's something that may be useful to you.

http://www.abriasoft.com/products.php

I don't take credit for that link - felix220 found it originally and couldn't find this thread again so he asked me to post it.

well there's also the free download of http://www.nusphere.com as well which i installed on my home windows pc... haven't used it much as i don't know a thing about php4/mysql yet :(

Speaking of knowing nothing about MySQL/PHP where is my MySQL database located? I'm trying to setup a forum, but don't know where to direct it.

The actual MySQL database files are located in:
/home/mysql

However, most of the time you won't need to access
the database files directly.

If have just installed MySQL and haven't changed anything
yet, you need to create a user account and a database for
the forum first.

You can create a database with (from the MySQL prompt):
CREATE DATABASE mydatabase;
(change mydatabase in whatever you want of course).

You can create a basic user with no access to anything with:
INSERT INTO user (host,user,password) VALUES ('localhost','username','password');
(Note: The user table is located in the mysql database,
which you can select by typing: USE mysql;)

The user you can create with the command above won't
have access to anything yet. You can give it access to
the database(s) you want by using the following command:
INSERT INTO db (host,user,db,select_priv,insert_priv,update_priv,delete_priv,create_priv,drop_priv) VALUES ('localhost','username','database','Y','Y','Y','Y','Y','Y');

Last but not least, after you have made these changes issue
the following command to prevent headaches:
FLUSH PRIVILEGES;
(This will make the username active)

This info is also available from http://www.mysql.com/
Unfortunately the documentation covers MySQL 3.23,
which has a different privileges system than MySQL 3.22,
which is included in the package from cobalt.

One more quick question relating to this. To get my domain active should I point the nameservers at ns1.tera-byte.com since I have one 1 IP address right now?

Originally posted by midhost
One more quick question relating to this. To get my domain active should I point the nameservers at ns1.tera-byte.com since I have one 1 IP address right now? yeah it's good if you need to get up and going quickly but for me i am doing the waiting game on nameservers of my own and dns changes since they aren't live sites yet

Do you need to do anything special to set up your own DNS servers? For example, if I set up a server with 4webspace.com, and my domain is whatever.com, then I would assume that tera-byte would have an entry in their dns server for whatever.com. Then I add ns1.whatever.com and ns2.whatever.com and make those my dns servers ( I realize that having both dns servers on one site compromises the reason for having two.) I am ok up to this point, but how do I let the rest of the internet know that my dns servers exist? Is it just a matter of registering a new domain name... e.g. johnathan.com and entering ns1.whatever.com and ns2.whatever.com into the registrars records? Then it is resolved because terabyte knows where whatever.com is?

Sorry if this is confusing. I looked on cobalts site, but couldn't find a document that explained it all. Is there a place that I can go that details the entire process from start to finish (relative to a Raq?)

Thanks,
Johnathan

GDHpro...When trying to add a basic user I keep getting error 1064. Probaly taking the instructions to literlly. Here's what I'm doing:

INSERT INTO user (host,user,password)

VALUES{replace with my info}('localhost','username','password');
so...
('midhost.com', 'jheiser', 'pass');

Is that incorrect and how do I fix it?

Another PHP question also. I seem to have installed it and was going to make the nessacasry chnages to the srm.conf file and the httpd.conf file, but it says I don't have permission to modify them. Don't know why, I'm logged in as admin... Any ideas.

sigsys

when you create ns.domain.com and ns2.domain.com you MUST ask your registrar to register those as domain Name Servers.

They have to be entered on NSI's database as name servers or else they won't work.

I have just done this and it seems to take a while, probably subject to the speed of BOTH your registrar AND Network Solutions.

Where can I find a registar, that allows me to create nameservers? Because I can't find one.

Where is your domain registered? I don't see how any registry can deny registering name servers for you.

Have you sent an email to the actual registry you're with, not just a reseller of the domain names?

Ask them and see what they say ;)

Originally posted by Starhost
Where can I find a registar, that allows me to create nameservers? Because I can't find one.

Do yourself a favor, and register your name servers at http://www.networksolutions.com

I registered two about 2 weeks ago for the old server and they were live the next morning.

I registered two more 2 days ago on the new server and they were live the next morning.

Dont bother fooling around with your personal registrar since it all has to go to networksolutions anyway, at least that is my understanding of name servers.

Besides, NetSol doesnt charge you anything to register a name server. Just make sure you pick the name you want, and try not to make a mistake.

We did make a mistake the first time, registering, ns1.mydomain.net and ns2.mydomain.com while both worked, we would have rather had both be .net's

In anyevent, doesn't matter since we changed our name servers complete for the new server.

Bbox

How do i setup more usernames and passwords for mysql?.

I can setup usernames using myphpadmin but no passwords.

I have looked all over the mysql site and that baffles me completly.