LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices



Reply
 
Search this Thread
Old 07-15-2011, 12:30 AM   #1
autophil
Member
 
Registered: Jun 2006
Location: Harrogate, N. Yorkshire
Distribution: Salix-14.1
Posts: 122
Blog Entries: 1

Rep: Reputation: 15
A few queries about LAMP. My LAMP is not burning!


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!

Last edited by autophil; 07-15-2011 at 12:32 AM.
 
Old 07-15-2011, 02:46 AM   #2
bathory
Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 10,973

Rep: Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343
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
 
Old 07-16-2011, 04:37 AM   #3
autophil
Member
 
Registered: Jun 2006
Location: Harrogate, N. Yorkshire
Distribution: Salix-14.1
Posts: 122
Blog Entries: 1

Original Poster
Rep: Reputation: 15
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.
 
Old 07-16-2011, 02:14 PM   #4
bathory
Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 10,973

Rep: Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343
Like said above, check the system logs under /var/log and the mysql log (/var/lib/mysql/darkstar.err)
 
Old 07-17-2011, 03:56 AM   #5
autophil
Member
 
Registered: Jun 2006
Location: Harrogate, N. Yorkshire
Distribution: Salix-14.1
Posts: 122
Blog Entries: 1

Original Poster
Rep: Reputation: 15
/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!
 
Old 07-17-2011, 04:28 AM   #6
bathory
Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 10,973

Rep: Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343Reputation: 1343
Hi,

Have a look at this post

Regards
 
1 members found this post helpful.
Old 07-17-2011, 08:37 AM   #7
Hangdog42
LQ Veteran
 
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,791
Blog Entries: 1

Rep: Reputation: 414Reputation: 414Reputation: 414Reputation: 414Reputation: 414
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?
 
Old 07-20-2011, 01:31 PM   #8
autophil
Member
 
Registered: Jun 2006
Location: Harrogate, N. Yorkshire
Distribution: Salix-14.1
Posts: 122
Blog Entries: 1

Original Poster
Rep: Reputation: 15
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!

Last edited by autophil; 07-20-2011 at 01:38 PM.
 
  


Reply

Tags
lamp, mysql


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
LAMP how? Doug.Gentry Linux - General 5 12-13-2009 10:14 AM
LXer: Enterprise LAMP Summit & Big LAMP Camp LXer Syndicated Linux News 0 09-21-2009 02:51 AM
LXer: LAMP vs. LAMP Rematch LXer Syndicated Linux News 0 11-08-2006 04:03 AM
LXer: LAMP vs. LAMP LXer Syndicated Linux News 0 08-23-2006 12:33 AM
Little LAMP help ElementNine Linux - Software 4 01-19-2004 04:26 AM


All times are GMT -5. The time now is 11:08 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration