[Klug-general] LAMP start up problem

Mon Jul 23 11:23:29 UTC 2012

Thanks for the advice. The error log reports that 'mysql_connect' is not 
recognised as a valid php instruction. I've noticed that everywhere it 
is installed apache is called apache2. Could that be a problem? Deeply 
into ignorance here.
MikeR

On 23/07/12 12:07, Alan Buchel wrote:
> tail -f /var/log/apache/access.log or error.log will help diagnose php 
> and file issues (precise log names differ according to distro)
>
> For troubleshooting mysql purposes I normally use the root mysql user 
> credentials for php auth instead of "mick".
>
> Also phpmyadmin is usually an easy install, allowing you to get a gui 
> view of your mysql db's, permissions etc.
>
> On 23/07/12 11:42, Michael E. Rentell wrote:
>> Good morning all,
>> As a part of my plan to limit the atrophying of my ageing brain I am 
>> working through 'PHP & MySQL for Dummies'. I think I have got apache 
>> installed OK because when I point firefox at localhost I get the 
>> 'It's working' response. So I then composed the following script, 
>> called it test.php and stored it in /var/www:
>>
>> -----------------------------
>>
>> <html>
>> <head>
>> <title>PHP Test</title>
>> </head>
>> <body>
>> <p>This is an HTML line
>> <p>
>> <?php
>>   echo "This is a PHP line";
>>   phpinfo();
>> ?>
>> </body></html>
>>
>> ----------------------------
>>
>> When I point firefox at it I get a huge table of dozens of properties 
>> which baffle me. But it seems to indicate that php is also working.
>>
>> The next step in the book is to generate a mysql db so from the CLI I 
>> went through generating mydb, user mick and a simple password. 
>> However, there is no data in this DB.
>>
>> Then to test that I composed the following script, called it 
>> test2.php and added it to /var/www:
>>
>> --------------------------
>>
>> <?php
>>
>> $host = "localhost";
>> $user = "mick";
>> $pass = "simplepassword";
>>
>> $r = mysql_connect($host, $user, $pass);
>>
>> if (!$r) {
>>     echo "Could not connect to server\n";
>>     trigger_error(mysql_error(), E_USER_ERROR);
>> } else {
>>     echo "Connection established\n";
>> }
>>
>> echo mysql_get_server_info() . "\n";
>>
>> mysql_close();
>>
>> ?>
>>
>> ----------------------------
>>
>> When I point firefox at localhost/test2 I get a completely clear 
>> screen. It neither seems to work or return the error. It is supposed 
>> to return a different table of parameters etc.
>>
>> Am I doing something stupid here/ If anyone can help an aged beginner 
>> I would be most grateful. I've been banging my head against this for 
>> several days and the book isn't any help as it expects the text to 
>> 'just work' and it don't.
>>
>> MikeR
>> in Folkestone
>>
>>
>> _______________________________________________
>> Kent mailing list
>> Kent at mailman.lug.org.uk
>> https://mailman.lug.org.uk/mailman/listinfo/kent
>
>
> _______________________________________________
> Kent mailing list
> Kent at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/kent

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.lug.org.uk/pipermail/kent/attachments/20120723/81a6403f/attachment.htm>