Slackware :: Running Apache / Php / MySQL On Startup And Install PhpMyAdmin?
Dec 29, 2008
After a new install of Slackware 12.2, I carried out the following procedures to get everything working successfully right out of the box. The server is a standalone system, used for testing and educational purposes, so please bear that in mind. NB: Throughout this post when you see a single # at the start of a line it means you are typing the commands as root user. You should not include the #, only the text after it.
### setup Apache with php enabled
Login as root user on your Slackware box and type:
# pico -w /etc/httpd/httpd.conf
I am at work right now and noticed my blog is down because of a database connection error. phpmyadmin wont load either it says theres an error, and webmin wont load either. So what would cause a mysql to go down? a hack or update? i am running ten.o four ubuntu server.
I run Ubuntu 10.04. For some reason, MySQL won't start on startup. How do I make it run on startup? I installed it by installing LAMP using tasksel and did everything according to: [URL]. Also, I have another problem: When I try to start/stop/restart mysql in the terminal, the terminal will not give me any prompts after entering the command. E.g., after entering "sudo service mysql start", nothing will happen. Even after waiting for 30min, nothing happens.
i have apache and mysql running, i can access my web server by visiting localhost on port 80 but for some reason when it doesnt work when i try using my ISP provided IP address... (it used to work).. i have my router setup with a DMZ on my LAN IP (my computers IP, this is the computer in my home network that serving with apache).. i also cant seem to shut down my mysql server (theres an update ive been trying to get) even when i use sudo...
I want to upgrade Apache, PHP, and MySql from a default version I'm having in my installed Slackware. What is the proper step to do this? Will it cause some problem if I upgrade them?
I have 2 Servers Server A running apache, php, phpmyadmin Sever B running MySQL
Server A has IP of 192.168.1.110 Server B has IP of 192.168.1.120
I edited /etc/phpmyadmin/config.inc.php
To have these:
(This par was confusing to I just re-added the line above instead of searching for it all).
Then I set the MySQL vi /etc/mysql/my.cnf to comment out #bind-address = 127.0.0.1
There is another line that most of the guides asked me to comment out but I cannot find that like: # skip-networking
The Next closest match to that is: skip-external-locking
I will assume that is not it and leave it alone....
I keep getting errors for example: "Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly"
Another error was it canno connect because it is not accepting connections from the IP Address of my webserver...
I been going off old outdate guides and informaion around the internet and nothing is working
I have 2 Servers Server A running apache, php, phpmyadmin Sever B running MySQL Server A has IP of 192.168.1.110 Server B has IP of 192.168.1.120
[Code]...
(This par was confusing to I just re-added the line above instead of searching for it all).
Then I set the MySQL vi /etc/mysql/my.cnf to comment out #bind-address = 127.0.0.1 There is another line that most of the guides asked me to comment out but I cannot find that like: # skip-networking
The Next closest match to that is: skip-external-locking
I will assume that is not it and leave it alone....
I keep getting errors for example: "Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly"
Another error was it canno connect because it is not accepting connections from the IP Address of my webserver..
The original issue started when i couldnt login to phpmyadmin. I noticed an error when installing it and when trying to login, my credentials that I supplied upon install failed. After ages of messing around trying to reset I decided to try and uninstall phpmyadmin and MySQL and start again. This has produced more issues as I uninstalled MySQL first and phpmyadmin asks for credentials that are in a database, which I have already deleted. This causes major issues trying to uninstall it. Anyway, I have used all these commands:
I'm totally new to MySQL / PHPAdmin and have been dropped in at the deep end regarding getting MySQL and phpMyAdmin upgraded... When I look at the RPM's I see:
But when I go to the GUI I see: Welcome to phpMyAdmin 2.5.7-pl1 MySQL 4.0.16-standard-log running on localhost as root@localhost So to start with I'm not totally sure what version I'm running! I need to get these upgrades done due to PCI requirements so they are saying to upgrade to at least 4.0.25 I'm currently running RedHat9 so ideally need to know the easiest way to upgrade to a later 4.0 or 4.1 version.
I have a centos 5.5 machine. First I upgraded my php to php 5.3. So I was then installing phpMyAdmin so I just put the whole folder into my /var/www/html/phpMyAdmin.The I tried to run my phpMyAdmin and I got this error Cannot load mysql extension. Then I uinstall my mysql db and reinstall it. Again it show me the same error.For addition info via the php info page for the Configure Command I saw this option -without-mysql' .
I just installed Centos 5.5 on one of my systems today and something is eluding me. Basically I had a web site and forum software (phpBB, but I don't think it's that, other forum software like Xoops does the same thing) running on Fedora 13, and I copied it over to the new Centos installation. Apache is running fine and displays a PHP test file and .html files just fine.
MySQL seems to be fine, I can log into that, show databases etc. Just can't get any forum software to know there is MySQL there. I did change the path of the site, and the databases, and edited /etc/my.cnf and /etc/httpd/conf/httpd.conf to reflect that. Thought I made the needed changes in /etc/php.ini but who knows. Seemed like everything should have tar'd up and moved easy, but not the case...
One server is a dedicated MySQL server. After upgrading that one to Ubuntu 10.04 (from an ancient Suse 9.2), both servers are running Ubuntu 10.04 LTS.I have another server that I use to administer the database server via phpMyAdmin. However since the upgrade it is not able to connect. I get an error #1130 Cannot log in to the MySQL server. The same happens if I try to connect remotely from the command line with: mysql -u root -h 129.79.137.121 -pI'm not sure if this is an iptables/ports problem or a configuration problem on the MySQL end or something else entirely.I've searched and tried the suggestions I've found in various places but none seems to have fixed it.
How do I connect to the MySQL server using phpmyadmin?It's asking me for a username and password and I was not asked for a root password when I installed MySQL (unlike in Windows).I tried no password, I tried root as a password, I tried$ mysqladmin -u root -p blahEnter password: mysqladmin: connect to server at 'localhost' failederror: 'Access denied for user 'root'@'localhost' (using password: YES)'Nothing I've tried is working obviously.Why does this have to be so stupid? Why couldn't MySQL ask me what password I want to use?
I am just configuring my PC for learning php. If I install phpMyAdmin from rpm, it works however if I download it manually and put in /home/user/public_html/phpMyAdmin and then browse [URL], I just see a blank page. What is the reason?
I've downloaded and installed Apache, mySQL and PHP via YAST. The web server is up and running and I am able to create and modify databases in phpMyAdmin. What's strange is that I am working on some other websites which use php includes to deliver my stylesheets, scripts etc. However, these includes do not work. I can view my website but all I see is the output from the html within the php file. Anything that is being delivered through includes does not display or run so all my content is unstyled.
So the problem is that phpMyAdmin does not want to connect to host name (at remote server) but connects to that same server fine if it's ip address is used. Command line "mysql -h hostname ..." works fine and connects to host name. Mysqladmin also works.
it's giving error:
***** Error
MySQL said: #2005 - Unknown MySQL server host 'host.name' (2) ******
I've disabled SElinux and temporarily disabled Iptables but no luck.
Somehow I feel MySQL is not doing DNS lookup when used by Apache/PHP. So it just understands ip addresses.
I found that on MySQL startup you can disable DNS lookup. [URL] Not sure if it's disabled and how to enable it at startup. Could not find anything at "System" -> "Administration" -> "Services".
I am running Ubuntu 9.10 with Apache, phpMyAdmin and MySQL. Normally phpMyAdmin loads properly, but the other day I created a large database of 6,000+ tables and 1.3 GB of data in the entire database. Now phpMyAdmin loads and shows my different databases, but if I try to open the new large database, it just loads a white page with no content. Does anyone know if I can reconfigure my server so it will be able to show parts of the database?
I just install Ubuntu on a new computer I got, and set up LAMP. I started poking around in MySQL (more than I should have) and managed to break it. I've been trying to fix it, but I can't. I've done apt-get --purge mysql-client, but when I reinstall it it's the same thing. How can I reinstall MySQL (and PHPmyadmin) from a completely clean slate? (There's no important data on there)
My phpmyadmin stopped working. I reinstalled it and it gives error #2002. I found that this error is from mysql, which i couldn't repair and i begin to reinstall it. First I was with Debian 5.03, but i played with /etc/apt/sources.list and after upgrading
I have now 5.05
The problem is that when i install mysql-server a dependency appear in mysql-server-5.0. I follow this instructions[url] and after sudo apt-get install mysql-server mysql-client
I get this error:
Code:
How can i fix this dependency? I didn't find anything relative in google.
mysql-server-5.0 --configure gives error: command not found
I uninstalled all related with mysql and execute dpkg --purge mysql-server then reboot and run first apt-get install mysql-server-5.0 mysql-client-5.0 and then apt-get install mysql-server mysql-client There was no error
Code:
But there was another error when run mysql -u root -p
I have installed on a remote server phpmyadmin 3.3.1 and mysql 5.1.46 on a centos 5.4 OS.
Any newly created user with phamyadmin is unable to login both from mysql command line (from localhost) and phpmyadmin (localhost and remotely).
No prob when the user is created with mysql command line (from localhost). All of the users created with phpmyadmin, are not "visible" recognized from the show user command via the mysql command line. The setting I used when I create any user was the same as the ones with the mysql command line creation.
The error message I get when accessing from mysql command line (from localhost) is the following: "Access denied for user ... @localhost (using password: yes)"
What commands can be used to install software such as "phpMyAdmin" to Fedora? As I am setting up Apache in Fedora. How to install "phpMyAdmin" and setup phpMyAdmin, so that I can use internet explorer to manage the phpMyAdmin to configure the MySQL database remotely.
Summary: Does a discrepancy between MySQL client library 5.0.x and MySQL server of 5.1.50 cause "inconsistent behavior", as reported by phpMyAdmin? The longer version: Windows Sysadmin taking the plunge into Linux. I tried to spare you all the rookie questions and did a fair bit of reading. I'm rather happy I was able to get CentOS 5.5 installed and running, configured iptables, got the kernel updated, Apache, MySQL and PHP installed. Then upgraded PHP to 5.2 after I figured out how repos and priorities work.
I got phpMyAdmin installed and running, then decided to upgrade from 2.11 to 3.3.7 but it keeps complaining that my MySQL client libraries are something like 5.0.63, while my server is 5.1.50, and this may cause "inconsistent behavior" or something of the like. So, feeling industrious, I decided to find an updated client.
MySQL-client-community-5.1.50-1.rhel5.i386.rpm
But it wouldn't let me install it as it conflicted with the default mysql-server installation. I also couldn't remove just the old client, to update to a newer one. So I blew away everything mysql on my server and installed the above client
MySQL-server-community-5.1.50-1.rhel5.i386.rpm
and that server file. I'm assuming I'm missing dependencies now as phpMyAdmin claims it can't load the mysql extension. Attempting to 'yum' php-mysql tried to install 'mysql' as a dependency, which immediately conflicted with the files I'd installed. At this point I'm wondering if I'm closing in on successfully installing a version that phpMyAdmin doesn't complain about, or if I should even care that it is complaining and just go back to all the repo versions of everything.
# rpm -e MySQL-shared-community-5.1.50-1.rhel5.i386.rpm error: package MySQL-shared-community-5.1.50-1.rhel5.i386.rpm is not installed
Has anyone successfully kickstarted a rhel/fedora/centos over HTTPS ? In other words, is it possible to do the rhel/fedora/centos install from running apache with SSL enabled?
I made a full install of Slackware and have been using one of my boxes as an Apache web server. I recently tried to install Joomla, the PHP CMS software, and when I ran the pre-install requisite checker (The second step of the installation), the installer notified me that I do not have MySQL support. I find this especially strange as I've made webpages using PHP that made use of MySQL databases.
My pre-post research has lead me to several other people with the same problem. Half were using windows, and just had not uncommented the "extension mysql.so" line in the php.ini file. The other half solved their problem by installing their distro's php-mysql module. According to what I'd read, you can still use MySQL if you don't have that module installed, but Joomla does need it to be able to use the MySQL database.
I've searched long and hard for this plugin/add-on/module for Slackware, but to no avail. It's available in RPM format, and I know that it's possible to use rpm2tgz to convert these files, but I don't know exactly what the issue is, and if Slackware may be different. I don't want to install that and then find out that it overwrote something that I'd needed.
I have installed debian on my laptop and included during the installation the webserver version. Now I want to develop a page locally to test it before I put it on the web. I first had an old reflex, jumping straight away and installing xampp. But then I thought that I already all that it takes as I installed the webserver feature of debian. I installed phpmyadmin ( with the command #apt-get install phpmyadmin) as to be able to create and attribute databases but when I try to log in I have the following message:
"Error #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)"
I googled but I cannot find the mysql.conf (I searched using "find") but with no result. It is all very blury what is going on with this webserver option running on my laptop...
An error accoured during the root filesystem check.
Installed fresh Slack 13.0 version, at 7GB virtual hdd, with cfdisk, created two primary partitions, 500 mb for swap, whats left, to second partition, made it bootable, installed full software package, used all default selections, only refused to configure network. At first restart, I got a screen with many statements, that looks like errors, and a last one, that looks like critical error. An image I have been working on Windows my whole life and only worked with already installed linux systems a bit. Installed RedHat and FreeBSD on VirtualPC previously and succesfully. Now, I stumble upon this error and cant think of next step.
Just a warning / question about Encfs on Slackware current. I doesn't work due to the upgrade to boost 1.4.2. I ran encfs on an old install of 13.0 to get at my data, but I'd prefer to access it right from current. A big warning: if you try to access your encrypted data on current it will corrupt your encfs6.xml file and I don't know if it is recoverable (I had a backup of mine).
