Netware Webserver - PHP/MySQL installation

Author

PHP/MySQL installation

greenly@leaningpost.com

2007-04-12, 1:16 pm

I developed a site for use on a school intranet written in both PHP4 and
PHP5 - both versions have the same mysql database. The site was written
for the Mac OS which has an Apache webserver and the database is in the
form of a text file (the Mac installer starts mysql and the database).

A school with Netware would like to use the product. I don't have access
to a Novell network, so would like to know what directions I need to give
to the school to make the installation as easy as possible. I'm also
wondering if the database needs to be transferred into some other format
for easy installation.

I appreciate any information you can share.

Anders Gustafsson

2007-04-12, 1:16 pm

,
> I appreciate any information you can share.
>
It would depend a lot on what expertise they have. Most php apps I have
installed on NW have just installed and ran right away. I suggest you
have them try and ask here if any gremlins show up.

- Anders Gustafsson, Engineer, CNE6, ASE
NSC Volunteer Sysop
Pedago, The Aaland Islands (N60 E20)

Novell does not monitor these forums officially.
Enhancement requests for all Novell products may be made at
http://support.novell.com/enhancement

Using VA 5.51 build 315 on Windows 2000 build 2600

greenly@leaningpost.com

2007-04-12, 1:16 pm

Thanks very much! I have written some directions from information found
on the Novell site. The product and database are both titled ArtSite.
Have I left anything out?

Copy the ArtSite folder into the folder where your other websites reside
on your server and manually create the database using the artsite.sql
script file.

To manually create a mysql database:

From the command prompt, start the mysql monitor by typing:
mysql

To create your database, type:
create database artsite;

You must grant access rights for this database to the mysql user through
which the application server will be connecting. Type: grant all on
database.* to username@localhost identified by 'password';

For example: grant all on artsite.* to appserver@localhost identified
by 'secretpw';

To exit from the mysql monitor, type:
quit

To run ArtSite
Open your web browser and enter http:// server_name/artsite/index.php
into the address line. (Replace server_name with the name of your server
or the IP address.)

Thanks again,
Laurie
www.artsitenet.com

> It would depend a lot on what expertise they have. Most php apps I have
> installed on NW have just installed and ran right away. I suggest you
> have them try and ask here if any gremlins show up.
>
> - Anders Gustafsson, Engineer, CNE6, ASE
> NSC Volunteer Sysop
> Pedago, The Aaland Islands (N60 E20)
>
> Novell does not monitor these forums officially.
> Enhancement requests for all Novell products may be made at
> http://support.novell.com/enhancement
>
> Using VA 5.51 build 315 on Windows 2000 build 2600
>

Anders Gustafsson

2007-04-12, 1:16 pm

You left out the step where you authenticate to MySQL.

Ie LOAD mysql -u root -p

- Anders Gustafsson, Engineer, CNE6, ASE
NSC Volunteer Sysop
Pedago, The Aaland Islands (N60 E20)

Novell does not monitor these forums officially.
Enhancement requests for all Novell products may be made at
http://support.novell.com/enhancement

Using VA 5.51 build 315 on Windows 2000 build 2600

greenly@leaningpost.com

2007-04-13, 1:11 am

I really appreciate your help Anders. Can you tell me specifically where
the Ie LOAD mysql -u root -p would go within my instructions? I don't
have any experience with Novell, so am searching in the dark. I'm trying
to cobble together a Linux install with information I found on the Novell
website.

Again, thank you,
Laurie

> You left out the step where you authenticate to MySQL.
>
> Ie LOAD mysql -u root -p
>
> - Anders Gustafsson, Engineer, CNE6, ASE
> NSC Volunteer Sysop
> Pedago, The Aaland Islands (N60 E20)
>
> Novell does not monitor these forums officially.
> Enhancement requests for all Novell products may be made at
> http://support.novell.com/enhancement
>
> Using VA 5.51 build 315 on Windows 2000 build 2600
>

Anders Gustafsson

2007-04-13, 7:11 am

,
> I really appreciate your help Anders. Can you tell me specifically where
> the Ie LOAD mysql -u root -p would go within my instructions? I don't
> have any experience with Novell, so am searching in the dark. I'm trying
> to cobble together a Linux install with information I found on the Novell
> website.
>
Change:"From the command prompt, start the mysql monitor by typing:
mysql"

to:

From the server command prompt (ie HOMER

, start the mysql monitor by
typing:
mysql -u root -p (enter)

This will ask for the root password you have defined when you installed
MySQL and then give you the mysql monitor prompt.

- Anders Gustafsson, Engineer, CNE6, ASE
NSC Volunteer Sysop
Pedago, The Aaland Islands (N60 E20)

Novell does not monitor these forums officially.
Enhancement requests for all Novell products may be made at
http://support.novell.com/enhancement

Using VA 5.51 build 315 on Windows 2000 build 2600

greenly@leaningpost.com

2007-04-13, 7:11 am

Again, thanks so much, you've been a big help...

> ,
where[vbcol=seagreen]
don't[vbcol=seagreen]
trying[vbcol=seagreen]
Novell[vbcol=seagreen]
> Change:"From the command prompt, start the mysql monitor by typing:
> mysql"
>
> to:
>
> From the server command prompt (ie HOMER

, start the mysql monitor by
> typing:
> mysql -u root -p (enter)
>
> This will ask for the root password you have defined when you installed
> mysql and then give you the mysql monitor prompt.
>
> - Anders Gustafsson, Engineer, CNE6, ASE
> NSC Volunteer Sysop
> Pedago, The Aaland Islands (N60 E20)
>
> Novell does not monitor these forums officially.
> Enhancement requests for all Novell products may be made at
> http://support.novell.com/enhancement
>
> Using VA 5.51 build 315 on Windows 2000 build 2600
>