Today was a big day for me and Linux. I started the day with a Linux web server with PHP but no MySQL. That’s a LAP server for all you techies. Pretty decent for serving static pages but not too great when it comes to doing anything with data.<\/p>\n
Never had MySQL working on this thing so I did a “yum install MySQL-server” to install MySQL. Then it was time to start this server up! Nothing. Well, not nothing. I got an error and a message that MySQL ended. Did a little searching and found a thread on this problem recommending that SELinux was the problem. It was keeping MySQL from accessing it’s database storage files. I used the command “setenforce 0” and all was well. I’m not sure if that’s a permanent change but hopefully it is. (A tip I got in my chatroom was to use “tail -f \/path\/to\/logfile” to watch a file when something’s going wrong. It shows you a live view of the log so you’ll want to open it in a separate terminal)<\/p>\n
Once I had the MySQL server running, I set a new password and I thought I’d install phpmyadmin to see if I could control it using the web interface I’m so familiar with. Not so fast bucko. PhpMyAdmin complained that MySQL support was not available to PHP! I created a test script to show me phpinfo() and then saw that PHP was compiled with –with-MySQL=shared,\/usr<\/p>\n
That’s supposed to mean that MySQL support is loaded as an extension to PHP but I could not find a suitable extension on my system. So I thought, I’ll just compile PHP. I downloaded the latest stable source for PHP4, compiled it, configured it and tested my PhpMyAdmin again. Nothing. Seems PHP was compiled into apache so my changes really didn’t take effect.<\/p>\n
Finally, I decided to compile apache and PHP from source. Apache would be compiled to load PHP as a module and PHP would be compiled with built-in support for MySQL. I downloaded and compiled apache 2 from source. Once both of those were built and installed, I manually added lines to the httpd.conf to activate PHP. At this point, things were running well. I had a LAMP server!<\/p>\n
I could use PhpMyAdmin but unfortunately so could anyone else with access to my webserver.
The solution to that: add .htaccess to the PhpMyAdmin folder so a username and password are required to get in there. It’s been a great learning experience and I kind of want to do it again on another box to see just how much of what I’ve learned applies to my next LAMP setup.<\/p>\n","protected":false},"excerpt":{"rendered":"
Today was a big day for me and Linux. I started the day with a Linux web server with PHP but no MySQL. That’s a LAP server for all you techies. Pretty decent for serving static pages but not too great when it comes to doing anything with data. Never had MySQL working on this […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-28","post","type-post","status-publish","format-standard","hentry","category-default"],"_links":{"self":[{"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/posts\/28","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/comments?post=28"}],"version-history":[{"count":0,"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/posts\/28\/revisions"}],"wp:attachment":[{"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/media?parent=28"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/categories?post=28"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/davidsterry.com\/blog\/wp-json\/wp\/v2\/tags?post=28"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}