what does the message mean? when I start apache service

LuisVIII · 03-30-2008, 10:55 PM

Hello everybody in this forum!!!!!

I have never installed or configured these three programs before, so I'll thank you a lot for your help ... What happens is that I want to configure the Apache + PHP + MySQL on Mandriva 2008, I have already set my repositories and with urpmi I've installed these programs through the console and apparently without any problems.

when I wrote the following to start the apache service it showed me a message:
[root@localhost etc]# service httpd start
Starting httpd: httpd: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName
[ OK ]
[root@localhost etc]#

Can anybody tell what it means?: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName.

Best regards.

fotoguy · 03-31-2008, 12:19 AM

Looks like apache is reading your /etc/hosts file to determine your ipaddress and name for DNS.
If I remember, make sure you have something in your /etc/hosts file like, for example your ipaddress of the web server is 192.168.1.100 try:

Code:

127.0.0.1 localhost
192.168.1.100 localhost www.mydomain.com www

change www.mydoamin.com to whatever you have in the httpd.conf file

LuisVIII · 05-04-2008, 12:44 PM

Well, thanks for the help, first of all I want to work locally in my computer to test programs in PHP, however, when I want to try to test them inside the /var/www/html, those programs only work if they are called "index".
Does anybody could tell me why this happens ..?

Thank you and best regards...

Wim Sturkenboom · 05-04-2008, 01:58 PM

If you don't pass a specific webpage in the URL (e.g. http://yoursite or http://yoursite/sub1; both are directories)), apache will try to serve a file that's specified using the DirectoryIndex. If you want a specific page, you have to specify that page in the URL (like http://yoursite/myfirstpage.html).

Below 2 examples of DirectorIndex; the first one is the default that comes with my Slackware12

Code:

DirectoryIndex index.html
DirectoryIndex index.html main.php

LuisVIII · 05-12-2008, 11:54 PM

I have already tested programs sending data in a form in HTML and receiving data in a PHP file, without any problems. I wanted to keep such data in a table of a database, and so I created a MySQL database (empleados) and a table (trabajadores) in which I inserted a record.

Code:

mysql> create database empleados;
mysql> create table trabajadores(nombre varchar(20), apellido varchar(20), domicilio(20));
mysql> insert into trabajadores values('Luis','Vidrio','Conocido 77');

if I consult in mysql it shows the following:

Code:

mysql> select * from trabajadores;
+--------+----------+-------------+
| nombre | apellido | domicilio   |
+--------+----------+-------------+
| Luis   | Vidrio   | Conocido 77 |
+--------+----------+-------------+
1 row in set (0.00 sec)

I'm running locally without password.
When I want to consult on a PHP file (muestrareg.php) , It doesn't show anything at all.

Code:

http://localhost/Nuevo/muestrareg.php

PHP Code:



<?php
    //Variables del host y mysql
    $numip='127.0.0.1';
    $usuario='root';
    $contra='';
     
    //Conexion a la Base de Datos    
    $conexion=mysql_connect($numip,$usuario,$contra);
    //Selecciona una Base de Datos
    mysql_select_db('empleados',$conexion);
    $registros=mysql_query('SELECT * FROM trabajadores',$conexion);    

while ($consulta = mysql_fetch_array($registros))
{
    echo $consulta[nombre],'<br>';
    echo $consulta[apellido],'<br>';
    echo $consulta[domicilio],'<br>';
}
?>

Could anyone help with this problem?

Best Regards and thank you.

Wim Sturkenboom · 05-13-2008, 02:56 AM

Check the returned values

mysql_connect will return a link identifier on success or FALSE on error
mysql_select_db will return TRUE on success and FALSE on error

Code:

if ($conexion === FALSE)
{
    echo "Could not connect";
}

if (mysql_select_db('empleados',$conexion) === FALSE)
{
    echo "Could not select database";
}

Code examples are not tested !

LuisVIII · 05-14-2008, 09:13 AM

Quote:

Originally Posted by Wim Sturkenboom

Check the returned values

mysql_connect will return a link identifier on success or FALSE on error
mysql_select_db will return TRUE on success and FALSE on error

Code:

if ($conexion === FALSE)
{
    echo "Could not connect";
}

if (mysql_select_db('empleados',$conexion) === FALSE)
{
    echo "Could not select database";
}

Code examples are not tested !

Ok Wim Sturkenboom when run the program it tells "Could not connect" Why does it ocurr?

Regards.

chrism01 · 05-14-2008, 07:35 PM

See this page: http://au2.php.net/manual/en/function.mysql-connect.php
You should bookmark www.php.net

eggixyz · 05-14-2008, 08:10 PM

Hey There,

Check this from your code

Quote:

$numip='127.0.0.1';
$usuario='root';
$contra='';

//Conexion a la Base de Datos
$conexion=mysql_connect($numip,$usuario,$contra);

and make sure that you can do that as the user that the webserver runs as on the command line. Usually a failure to connect to a mysql db that's on the same server as apache is a mysql login/permissions issue

Hope that helps

Mike