A few queries about LAMP. My LAMP is not burning!

autophil · 07-14-2011, 11:30 PM

I hope this is the correct forum.
I have installed mysql as a slaptpkg. Although I have followed up everyone else's problems and tried the same solutions mine is still unable to connect.
I get the same ERROR 2002 (HY000): Can't connect . . . . . etc that everyone else gets. Then I get:

Quote:

# mysqld_safe &
[1] 10511
root[tmp]# 110715 06:10:25 mysqld_safe Logging to '/var/lib/mysql/darkstar.err'.
110715 06:10:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110715 06:10:26 mysqld_safe mysqld from pid file /var/lib/mysql/darkstar.pid ended

[1]+ Done mysqld_safe

Then the same ERROR 2002 . . . . .
I got all the groups and permissions in place. In /etc/my.cnf it points to
/var/run/mysql/mysql.sock
though I have tried /var/lib and /tmp

Another thing is: I installed Apache and also php. How can I test that these are up and running?
Give me oil in my LAMP!

bathory · 07-15-2011, 01:46 AM

Hi,

Quote:

...
110715 06:10:26 mysqld_safe mysqld from pid file /var/lib/mysql/darkstar.pid ended

Looks like mysqld is not starting actually. Check the logs to see why it happens.

Quote:

Another thing is: I installed Apache and also php. How can I test that these are up and running?

You can create a php page containing

Code:

<?php
phpinfo();
?>

and visit it with your browser.

Regards

autophil · 07-16-2011, 03:37 AM

Thanks for that.
I still cannot get it all together.
For the record I found this link on another similar thread
http://connie.slackware.com/~mrgobli...kware-lamp.php
And it does provide easy to follow directions. So I have Apache and php up and running, Its just this 2002 error in Mysql that im battling with.

bathory · 07-16-2011, 01:14 PM

Like said above, check the system logs under /var/log and the mysql log (/var/lib/mysql/darkstar.err)

autophil · 07-17-2011, 02:56 AM

/var/lib/mysql/darkstar.err
looks like this

Quote:

110717 09:40:14 mysqld_safe mysqld from pid file /var/lib/mysql/darkstar.pid ended
110717 09:41:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110717 9:41:42 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
110717 9:41:42 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110717 9:41:42 InnoDB: Initializing buffer pool, size = 8.0M
110717 9:41:42 InnoDB: Completed initialization of buffer pool
110717 9:41:42 InnoDB: Started; log sequence number 0 44233
/usr/libexec/mysqld: File './mysql-bin.000012' not found (Errcode: 13)
110717 9:41:42 [ERROR] Failed to open log (file './mysql-bin.000012', errno 13)
110717 9:41:42 [ERROR] Could not open log file
110717 9:41:42 [ERROR] Can't init tc log
110717 9:41:42 [ERROR] Aborting

110717 9:41:42 InnoDB: Starting shutdown...
110717 9:41:48 InnoDB: Shutdown completed; log sequence number 0 44233
110717 9:41:48 [Note] /usr/libexec/mysqld: Shutdown complete

110717 09:41:48 mysqld_safe mysqld from pid file /var/lib/mysql/darkstar.pid ended

I did try <#mysql_upgrade>
but it gives an ERROR 2002 message once again.

I think my "server" is not installed or not started but there is no other package to install.
I have also tried mysqld_safe --user=mysql &
and mysqld_safe &
and mysqld_safe --user=root &

I also bought the book called Teach Yourself MYSQL in 10 minutes <ha ha>

Any good pointers welcome!

bathory · 07-17-2011, 03:28 AM

Hi,

Have a look at this post

Regards

Hangdog42 · 07-17-2011, 07:37 AM

Can I ask why you installed mysql from slaptpkg when Slackware comes with mysql by default? I'm wondering two things: 1) is the slaptpkg package up to snuff, and 2) by potentially installing a second mysql, did the config files get messed up?

And lastly, did you run mysql_install_db?

autophil · 07-20-2011, 12:31 PM

Thanks bathory, Im working on it.
Hangdog42, Im actually running the latest Salix which is suposedly like a light-weight Slackware. Mainly because Im not fully into bittorrent yet. Im quite impressed with Salix's similarity to Slackware and its compact size. I didnt find MySql on the system.
Hey, I like your website man!