How do I install a Server in Linux to use with a Database (SOLVED)

Linux Support
1

Hi All,
I want to make a database up in Libre Office. It will need to be accessible to 3 or 4 users.
I want to put Apache (or something similar) on the same computer.
This is from a tutorial I saw in Linux User (I think) and seemed to be quite straightforward, but, at a point in the installation he went into his XP setup on his VM. So my first question is this, how do I set up a VM for Win XP ?

Mark is this machine able to run XP as a virtual Machine ?
Toshiba Satellite L-350 17P System Unit
Intel Pentium Dual CPU T3400@2.16GHz 2.17GHz
Installed RAM 2.00 GB
64 bit OS
Currently running Win 7 and Peppermint 6 as a dual boot.

EDIT Would this thread be better posted in the Libre Office forum ?

2
So my first question is this, how do I set up a VM for Win XP ?

You will need to install Virtual box you’ll find it in the repos

sudo apt-get install virtualbox

You would then need to have a Windows install disc to install into the VM you may also need guest additions be you can deal with that if and when the need arises

Good luck

Graeme

3

A bit lost on what the WinXP VM is for in that setup.
There is a simple LibreOffice tutorial on Linux User & Developer albeit with MySQL back-end.

4

Hi
@ Graeme, I have an XP disc I can use to get Win XP if I go that route.
@ SeZo, I have bookmarked that tutorial and was wondering if that would be easy enough to do.
I will try it and report back when I hit trouble if that is ok.
EDIT SeZo that is the tutorial I was doing last night when he opened his VM win XP to download and set up PHPAdmin.

5
EDIT SeZo that is the tutorial I was doing last night when he opened his VM win XP to download and set up PHPAdmin.
OK, maybe I am getting a bit tired, but where does it say VM in
[i]Step 05

Install and test phpMyAdmin

Type sudo apt-get install phpmyadmin to begin installation. When prompted to choose a web server, choose Apache2, select it with the space bar and press Return. When requested, give it the MySQL root password and then choose a password for phpMyAdmin and make a note of it. Navigating to http://localhost/phpmyadmin/ should take you to a functioning login page. Log in using the MySQL root username and password. We’ll use MySQL to set up and maintain the actual database, although we’ll create the fields from within LibreOffice later on.[/i]

6

Sorry SeZo, I seem to be more tired than you :frowning:
I just retried that tutorial and I have a couple of points.
1-- In Step 02 I have installed Apache Server and used the http://localhost command.
This opens a page that says ‘It Works!’ which I am happy with, it then says
‘You should replace this file (located at /var/www/html/index.html) before continuing to operate your HTTP Server’ ?
Replace with what ? I haven’t a clue and need a bit more instruction.
2-- Step 05 Navigating to http://localhost/phpmyadmin/ should take you to a functioning login page. Wrong
When I try that I get an error
Not Found
The requested URL/phpmyadmin/ was not found on this server
Apache 12.4.7 (Ubuntu) Server at localhost on Port 80

7

You’re supposed to replace it with whatever you want serve … eg. a website that you want others to to be served when they enter the IP address of the server on port 80.

Did you install phpmyadmin ?

8

Thanks Mark,

I thought I had installed phpadmin but it comes up with an 404 Not Found error

9

Check whether you installed it or not:

dpkg -l | grep phpmyadmin

?

10

Hi Mark,
This is the result of that command
don@ldwatson ~ $ dpkg -l | grep phpmyadmin
ii phpmyadmin 4:4.0.10-1 all MySQL web administration tool
don@ldwatson ~ $

11

Try to add phpmyadmin to the apache configuration:

sudo nano /etc/apache2/apache2.conf

then add the phpmyadmin path to the config file.

Include /etc/phpmyadmin/apache.conf

Save and exit

Restart apache:

sudo service apache2 restart

Then access phpmyadmin by going to http://localhost/phpmyadmin/

12

Thanks SeZo,
I carried out those suggestions and when I restarted Apache I got this
don@ldwatson ~ $ sudo service apache2 restart
[sudo] password for don:

  • Restarting web server apache2 AH00558: apache2: Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1. Set the ‘ServerName’ directive globally to suppress this message
    [ OK ]
    don@ldwatson ~ $

Undaunted, I carried on and after the Apache restart I was at the phpAdmin login screen ;D
Is there anything I need to do about the above message ‘Set the ServerName etc.’ ?

EDIT 1 At the login I have a problem as I can’t find the notes I took of the relevant passwords.
Is this a complete wipe job or is there some way to recover them ?
Thanks for the help I just wish I wasn’t so dim :-[

EDIT 2 I have found the passwords and have logged on successfully. I may need to change the password later as I have saved it and when I enter the localhost/phpmyadmin command it bypasses the login screen ?

13
Is there anything I need to do about the above message 'Set the ServerName etc.' ?
That would be useful if you are running your website, anyhow it is only showing on start-up, so you can ignore it.

Saved passwords can be cleared in your browser.

14

Thanks SeZo,
I will report back later if (when) I hit any problem, but it seems to be working ok at the moment.
I will try and get this tutorial finished today.

15

Hi SeZo,
I have finished the tutorial and it gave a very good insight into what to do when setting up a database server.
It is going to take a while to get my head around this information but the the prgrammedoes work and I am very pleased.
Thanks for all your help I will mark this solved next week after I have used it (tried to break ?).

take care
Don W