if I should ask this in the server section. But since I use the desktop version of Ubuntu I will ask here. Basically my server is going on pension. Hardware is outdated and all that. Since it's main job was serving me with MySql databases with web interfaces I sommer want to shift all of that over to my desktop and run my databases on the desktop. It's only me that access it so don't see why I can't run it localhost.
My question is. The three main things I need, apache, Mysql and php, are they in the repositories in Synaptec ? If not how hard will the install and config of those three apps be on Ubuntu Desktop? (I've always used Fedora as server with everything build-in so have no experience of installing mysql, apache and php from scratch)
Running MYSQL 5.5.12 and MYSQL Workbench 1:5.2.34 on up-to-date Arch linux Set up MYSQL with root account and password. When running Workbench as user, got error when trying to connect :
Quote:
Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Can't connect to MySQL server on '127.0.0.1' (111)
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from
After commenting #skip-networking in my.cnf error changed to :
Quote:
Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Lost connection to MySQL server at 'reading initial communication packet', system error: 0
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from
Copying my.cnf to /etc/ and running Workbench as root didn't change anything, i still get the second error The wiki [URl] says to enable MYSQL in /etc/hosts.allow but i didn't do it, i guess it is required only when trying to access MYSQL from remote hosts which i dont.
I used 4 host to establish a high-availability web server system. 2 Load Balancer + 2 Web Server(installed MySQL Server 5.5). 2 MySQL Server used Multi-Master Replication.Used "Amoeba" as MySQL Proxy which direct the write statement to a specific MySQL Server.I can login Amoeba and MySQL Server using MySQL client. I tried query something in XAMMP on Windows XP. It work!
Compiled php 5.3.6 soruce + MySQL 5.5 Server, Client, Shared, Shared-Compact Above software installed on different host. And the phpinfo showing MySQL I doubt something wrong in my php.ini. Used default php configuration.
I've installed apache2 on ubuntu 10.04 and everything works fine, but when I use functions that needs to connect to Internet, it doesn't work. Is there a simple setup I've forgot? I've been searching and looking for a solution, but I'm stuck!
I did something silly and changed my root user access for mysql access to Any from localhost using webmin. I get an access dented when i try to open up the mysql editing page on webmin. Can any of you tell me if there is a way to change it back to hosts=localhost I am using webmin 1.5.30 on Centos 5.5. I am hoping I can change it by command line or if I can access the config files and change it that way?
I have installed VirtualBox on a MacBook and installed RHEL6 on a guest server ("Orion") in VirtualBox. I am trying to follow the tutorial at xenocafe on Apache Web Server Tutorial for Linux. I've checked a few other websites for port forwarding, and have used VBoxManage to set
I am able to ssh into the Virtual Box guest server using:
$ ssh -l rmt1 -p 2222 localhost
I believe this means that the port forwarding works. I am able to start and stop httpd on the guest with no warnings. I retired a problem with DocumentRoot by setting SELinus to disabled. My trouble is that: When I bring up a browser on the host and try localhost 8888 and expect to see my sample html page housed on the guest server (located under root / www), what I get is a spinning wheel.
And when I bring up a browser on the guest and try localhost 80 and expect to see the sample page I made, what I get is the well-known Apache test page. I am stuck in knowing (1) how to cause port 80 output from the guest to be interpreted by the host browser searching port 8888 (Or, Why does ssh into the guest work but http out of the guest not work), and, (2) how to arbitrarily determine the location of what the very first webpage is that will be loaded.
I'm running wordpress and have gone to the painstaking effort of setting up the ftp server on my 5.3 machine so it can do its own updates and download plugins. However, I've found that if I try to download anything, I get a "unable to resolve host..." error from the script. If I watch Iptraf while making the request, I see all the port 53 requests going to 127.0.0.1. Pings are too.
However, if I ssh in, I can ping and wget and whatever I want all day long and all the DNS requests to go the router (Clarkconnect 3.2 gateway machine). The web browser in the terminal works fine too. What is it about the php scripts that is causing them to misdirect pings and dns requests? I've never seen anything like it and can't find anything on the web about it either.
I have setup a Linux Centos with apache server on it in a home network. Everything works fine. When I access the webserver I put in the address bar the IP address of the server which is 192.168.0.150 and when hit enter, it prompts the page where I have to put login information. The login information is set to: username: admin@localhost.local password: *************
It takes long time for authentication go through and load the page eventhough I am accessing the site in a same home local area network with fast ethernet connection. How can I change the localhost.local to something else like maybe [URL] instead and if I have to change settings in other files as well?
I have some confusion about mysqladmin and mysql.I am using mysql version Quote:
[root@localhost freepbx-2.7.0]# mysql --version mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1 My MySQL is running Quote: [root@localhost freepbx-2.7.0]# /etc/init.d/mysqld status mysqld (pid 11440) is running...
I've just upgraded my laptop to Fedora 14 and installed LAMP on it for a test environment. I've followed the official instructions to install but seem to have a problem that I didn't have on F13 or Opensuse. Each time I try to access index.php on localhost I get a permission denied message and an SElinux alert. I have tried 7 different solutions on various forums and just can't view anything in a browser.
/var/www/html has been set to chmod 777 /var/www/html/index.php has also been set to chmod 777
A standard user can definitely read and write to the above files/folder. Until I commented it out the Welcome/Test page was working perfectly.
I set up a servber on my local machine, & also PHp - Both working fine.I'm trying to load up MYSQL i have installed it, & *can* start/stop the server. however if I do anything else with it, I get this error :-
Quote:
root@gordon-desktop:~# sudo mysqladmin -u root -h localhost password MYPASSWORD mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Query :-
1) How do I know MYSQL is actually active ? (apart from the message it says that its statrted (or stopped).
2) Is there a way to
a) Find out the usernames that are recorded on the MYSQL server ? b) set / RESET the 'root' username (I know MYSQL root user is different to PC root user) c) anything else I can do on the PHP / website code to see if MYSQL is working
(as yet, no tables / databases etc have been set up - as I can't get past this error message - I get the same error when setting up a database.)
Ps I did allow my usermname (when logged in to ubuntu) to edit / create files in the /usr/www/ directory (but it is still OWNED by 'root' - that directory)
I am planning on installing an Apache server today. I know how to get it to point to addresses like "localhost" or my outside ip, but how do I get it to point to a URL like [URL]? (That's just an example URL)
My config: Ubuntu 9.0.4 (all up to date with security patches) Apache 2.2.11 MySQL version 5.0.75 PHP Version 5.2.6-3ubuntu4.5
I'm running Ubuntu as a Virtual machine with VMWare on top of a Windows 2008 Server. It has been working perfectly for nearly 9 months. I have one processor and 2GB of Ram assigned to the Virtual machine. Memory usage seldom ever reaches more than 50%, swapfile is hardly used either. I noticed recently that sites were loading very slow from time to time. Webmin showed me that USER / KERNEL were together using 100% cpu. I then started searching for answers to what was causing this and then read about using HTOP. I then installed HTOP and found that the following processes were the culprits /usr/sbin/mysqld /usr/sbin/apache2 -k start
There are multiple instances of mysqld and apache2 listed in HTOP, I assume this is because I run multiple sites on the box. It does however seem limited to only one or two PID's that are repeatedly maxing out the CPU at 100% (every 30 seconds to a minute) sometimes the CPU will stay maxed at 100% for nearly a minute and then free itself again but it is doing this continually. At the point when the CPU maxes out at 100% there will be one instance of mySQLD and one instance of Apache2 right at the top of HTOP and between the two they will be hogging 100% cpu. All the sites are either Wordpress or Joomla sites and I am quite confident it's one of these sites causing a problem.
My issue is that I cannot pin down which PID belongs to which site. Then, once I know which site it is how do I then trace what process / file inside that site is casuing the problem? I figured one of my busiest sites (wordpress) might be the culprit and I installed the W3 Total Cache plugin today but that has not helped this 100% cpu problem, so for all I know it might be another WP site on the box or even one of the Joomla sites. I've noticed that the TIME column on the one MYSQLD instance that maxes out is very long so it seems like Mysql is keeping some connection open or something?
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...
Running slackware13.1 with mysql on box2 and apache on box1 both in same lan. How do i configure mysql for apache connection? I have looked at many mysql config. howto which i can follow but i'm confused about whether the connection type is considered remote connection because the 2 services are on seperate boxes but are in same lan? Apache will be serving public webpages not just to the lan.
We are working on a new ERP for the company. This will run in MySQL 5.1.x, the GUI will be Web, the language PHP. This is a big project, is a good option to have the 3 applications in the same server or is better to have Mysql on 1 server and httpd+php on other server?
Speaking that I want to virtualize this app with Xen on Centos 5.5 as Host and the guest's will run Ubuntu.
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 have been using wamp on an xp box and now have set up ubuntu with the localhost server seeming to be going okay.
As this is just a desktop graphical test server with no real public hosting, I was hoping to find a control panel like in wamp where one can stop/start php, apache, mysql, phpmyadmin and see logs etc.