using mysql & php on a W2K SP2 server

[Ric_]

you tried typing 'startx'? - you mayu need to do some config first with 'xf86config' or similar since the installer didn't do it for you.

[beeswax]

it's not working for me. I'll search some forums in the meantime.

[ChrisH]

You dont need a GUI Just use a decent SSH and SFTP client and a decent text editor. That way you can get the remote console for restarting services and SFTP you configs off to edit then back on. I would recommend Bitvise Tunnelier allows easy setup of reverse tunnels and all that jazz.

[beeswax]

I need a gui so that I can get a decent picture in my mind of how things are laid out. It's just how I work. Managed to get Ubuntu installed and working and can now see where everything goes, however, I don't have permission to put the files in the /var/www. how do I log on as admin?

[CyberNerd]

[/code]sudo su

[Ric_]

or just type 'sudo cp -r /directory /var/www/directory'

[Geoff]

sudo su

 

No! Never do that! It breaks stuff. Plus you don't get warnings anymore.

[beeswax]

so how does that apply when you're using a gui (ubuntu)?

[webman]

You can run the apps from a terminal using sudo; or for Ubuntu: you can use the Run Program menu and type gksu your-app-here.

[CyberNerd]

No! Never do that! It breaks stuff. Plus you don't get warnings anymore.

 

can you give more detail please, I am unaware sudo su caused problems on ubuntu/macs

[beeswax]

You can run the apps from a terminal using sudo; or for Ubuntu: you can use the Run Program menu and type gksu your-app-here.

 

I don't know if you've got the full picture webman. I'm trying to set up a LAMP server using Dapper, I've limited time, and I'm happier working with a gui front end, hence ubuntu. In trying to transfer the files for the school's website into /var/www (it is the place to put these files, isn't it?) I get a popup telling me I haven't permission to do this. I assume, in command line, that the sudo bit of code is to move me up to the level of admin. My problem is how to do this through ubuntu. How do I log on as admin?

Next job is to figure out how to set up a database.

thanks for the time and patience.

[Joedetic]

You cant login as admin. You have to type sudo then the command. And then the password for your user.

 

If you can install proftp (sudo apt-get install proftpd) and set that up to FTP your files accross to a folder in your home directory.

 

Then do

 

cd ~

 

on the server. That'll take you to your home directory. Next you need to do

 

sudo cp -r (name of the folder you put the files in) /var/www

 

That'll move the contents of that folder to the www folder.

 

 

I'm doing the same as you this week with installing an ubuntu dapper LAMP server but to install a butchered up MRBS to be a resource booking system. So i've had to do similar stuff.

 

Anyway, i hope that's all correct...i'm sure someone will be able to correct me (i'm looking at you webman!)

[beeswax]

I was impressed with the ease of installing the Dapper LAMP server. I didn't time it, but reckon it took around 20 minutes. but as far as linux is concerned I've still got on my water wings and rubber ring. apart from some basic ms-dos some years ago I'm afraid i've done everything via a gui.

When I get round to sorting out a staff intranet i'm going to use W2K3 server and the free Sharepoint as that's got a room/resource booking add-on as well as a help desk. Though I hope to use the Dapper server for the school website and pupil intranet.

[CyberNerd]

by coincidence I found out that hte ubuntu root account can be enabled by

sudo passwd root

provided ssh allows root logins you could use sftp to upload files (with a gui)

TBH gui's are really for desktops and are an unnecessary overhead on servers.

[webman]

Hi beeswax, sorry yes I didn't read it all. Alt+F2 to get your "Run program" box up, or make a shortcut to this:

 

gksu nautilus /var/www

 

When ran, it will prompt you for your admin password (in a similar vein as Synaptic and other system administration utils) and launch the file browser with priviliges to write to /var/www :-)

[Geoff]

No! Never do that! It breaks stuff. Plus you don't get warnings anymore.

 

can you give more detail please, I am unaware sudo su caused problems on ubuntu/macs

 

Your enviroment is setup as your unprivledged user. Your shell is running with root priveledges. This results in lots of your config files in your home directory being owned by root and unreadable/unwriteable by your normal user account.

[beeswax]

Hi beeswax, sorry yes I didn't read it all. Alt+F2 to get your "Run program" box up, or make a shortcut to this:

 

gksu nautilus /var/www

 

When ran, it will prompt you for your admin password (in a similar vein as Synaptic and other system administration utils) and launch the file browser with priviliges to write to /var/www :-)

 

thanks webman. I have trouble getting letters (no prob with numbers) in the right order so spent a happy 5 mins trying to get gsku... to work. Now how do I set up a database?

[webman]

Right bare with me, from memory...

 

Ok, if you haven't already, you'll need to set a root password for mysql:

 

$ mysqladmin -u root password 

 

Replace with a strong password of your choice.

 

Now we need to create a new database and add another mysql user who can access it.

 

$ mysql -u root -p

 

This will load the mysql client and login as the root user and prompt you for the password (the one you just made in the previous step)

 

Create the new database:

 

mysql> create database cmstest;

 

You can replace "cmstest" with the name of the CMS you want to install. You should receive the message Query OK - the database has been made.

 

Now lets make a new user that is allowed to connect to this database only (Bad idea having root login to your mysql database from your scripts).

 

All one line:.

 

mysql> grant all privileges on cmtest.* to 'cms_user'@'localhost' identified by 'cmspass';

 

(One again, change "cmstest" to whatever name you gave to your database. You can also use any username you like.)

 

You can now log out of mysql by typing exit.

[Joedetic]

Or you could go to the terminal and type

 

sudo apt-get install mysql-admin

 

If i've remembered that to be the right package that'll install the GUI for administration of the local MySQL server.

 

Go to catalogues and add the database (schema) then go to the user administration section and add in the database access user and set the privilages you want.

[beeswax]

@Webman: when I type in the first code you give I get "syntax error near unexpected token 'newline'"

 

@ Joedetic: I hate to be a pain but when you say, "go to catalogues" where is that? I've done what I hope is a search and can't locate it.

 

sad to say that I woke at 4:27 (ah, digital clocks) with this churning through my mind. I couldn't wait to get in to work!