Ubuntu Installation :: Cannot Connect To MySQL Db Through Drupal
Dec 24, 2010
i'm in the process of migrating from Drupal 5 to Drupal 6. My main Drupal page won't load. I have been stepping through the index.php Eclipse and XDebug.The error I'm receiving is:"can't connect to local MySQL server through socket '/tmp/mysql.sock'".i think the sock file setting is correct; it matches what the MSQL control panel has.
First question: if my.cnf says the sock file is in /var/run/mysqld, why do I keep getting the error that it can't open /tmp/mysql.sock? How do I tell Drupal to use '/var/run/mysqld/mysqld.sock'?
Second question: the mysql command-line interface (i.e., after i have logged into mysql from the terminal) doesn't mention a port from the listing obtained by entering 's'. is it possible that 3306 is a mistake? (I have tried commenting out the port reference and i still get the error identified at the top of the thread.)
does anyone have any ideas about how to resolve the 'sock' error? Many thanks if you do. Merry Christmas, too.
View 9 Replies
ADVERTISEMENT
Jun 7, 2011
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
View 6 Replies
View Related
Mar 15, 2010
I am getting the following error when starting mysql using 'sudo /etc/init.d/mysql start':
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: ^G/usr/bin/mysqladmin: connect to
[code]....
View 1 Replies
View Related
Jul 9, 2009
I have two VMs, one as a web server and one as a database server. Both are RHEL5.2 Web server httpd-2.2.3-22.el5_3.1 php-5.1.6-23.2.el5_3 Database server mysql-5.0.22-2.1
On the web server, I can connect to the database just fine with a user I created with all privileges on *.*
Both phpMyAdmin and Drupal, though, tell me they cannot connect to the database. phpMyAdmin says :#2003 - The server is not responding..Drupal says:Failed to connect to your MySQL database server. MySQL reports the following message: Can't connect to MySQL server on '172.16.1.1' (13).However, I can also connect to the database with a simple little PHP test script.What do I need to do to get these apps to see the database that is up, running, available, reachable, in existence, etc. etc???
View 3 Replies
View Related
Jun 2, 2010
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
View 9 Replies
View Related
Feb 16, 2011
But now I have task of connecting mysql and tomcat. I dont have any idea on this. However I looked some manuals but did not find any luck. how to connect mysql with tomcat. btw I have downloaded mysql connector and copied the .jar file to $CATALINA_HOME/lib
View 4 Replies
View Related
Apr 2, 2010
When I type mysql,
vignesh@vignesh:~$ mysql
I get this error.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
So, I checked whether the file mysqld.sock is there in its respective folder, but I could not find that file. How to create the file and start mysql server.
View 1 Replies
View Related
Aug 31, 2014
I have just completed my fresh Debian installation. I have added MySQL server and client using the package manager.
Now I am trying to connect from my PC to the MySQL server (on debian) but getting the following message:
2003: Can't connect to MySQL server on 10.0.0.111 (10061)
View 7 Replies
View Related
Aug 25, 2010
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
View 4 Replies
View Related
Dec 6, 2010
I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).
Error I receive is:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
View 6 Replies
View Related
Feb 22, 2011
I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
View 7 Replies
View Related
Jul 23, 2009
I have just migrate from UBUNTU to Fedora 11. Tried to install cacti by 'yum install cacti' everything presumably went correctly. But when trying to get cacti running on a browser it's showing:
Code:
FATAL: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'
Checked everything else including installing new mysqld-server (using yum install) and still not working.
Trying the installation steps from [URL], but could not find where mysql was installed. Mysqld should already be running, cos I can see it using webmin-server-mysql. Did a test as shown on [URL], everything seems ok. No major problem when using UBUNTU with apt-get install.
View 8 Replies
View Related
Jul 4, 2011
I am trying to uninstall my LAMP server and my Drupal 7 installation. Unfortunately I cannot find any instructions on uninstalling Druapl from my system. The ones that exist are far too old( < 2008 ) to be relevant. Could someone please direct me how to go about this? Note: I did not use Synaptic for installation. I downloaded the file from the drupal.org site.
View 1 Replies
View Related
Jun 8, 2010
Can anyone tell me all the steps of how to install drupal 6.0 and start using it ?
View 4 Replies
View Related
Nov 29, 2010
I have installed Drupal 6 using synaptic and it shows as installed in synaptic but NOT in my Ubuntu software center but it is nowhere to be found.
View 4 Replies
View Related
Feb 27, 2011
I have installed debian-6.0.0-i386-DVD on my vmware. I want to install php 5.2 on it. But whatever mirror i'm using in my source.list i'm not getting my php 5.2.17 installed. Is there a debian mirror that i can use in my source.list to install php 5.2.15? I do not want to install 5.3, because it's not working for drupal 6 yet. I'm new to linux. i'm using apg -get update to receive the update.
View 1 Replies
View Related
Sep 1, 2011
There are many ways of accomplishing this installation. What this tutorial attempts to do is to outline the most basic installation possible. It show you how to install Drupal from the command-line to speed up "development" of your website. [[EDIT]] REMOVED LAMP SERVER INSTALL PART OF TUTORIAL AS THERE ARE MUCH BETTER (MORE SECURE) TUTORIALS ON THIS TOPIC.
Install drush for using the command line on Drupal. Create some management scripts to manage Drupal via the command-line. Create some installation scripts to install drupal via the command-line. Make the scripts executable and install them in /usr/local/bin. Open a terminal and install Drupal with one command.
01. You have your LAMP server, Drupal MySQL database and databse user setup and ready to go! For development sites on my local desktop machine I use root as drupal's database user because it speeds up re-installation when necessary.
02. Install drush (DRUSH 4.4 AVAILABLE IN NATTY WITHOUT PPA)
#apt-get install drush
03. Create 3 folders to hold your drupal backups, scripts and libraries
#mkdir /home/user/drupal/backup
#mkdir /home/user/drupal/scripts
#mkdir /home/user/drupal/libraries
#cd /home/user/drupal/scripts
04. Create a script to manage web server permissions
#gedit drupal-siteperms && chmod +x drupal-siteperms
---------cut-and-paste----------
#! /bin/bash
cd /var/www
[code]...
View 2 Replies
View Related
Feb 2, 2011
how to install Drupal in fedora?
View 1 Replies
View Related
Sep 29, 2010
I wrote a code in C to connect to MySQL by using mysql_real_connect function but I recieved error "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" (by using mysql_error function).
I also did the following things: in mysql I typed 'SHOW VARIABLES LIKE '%SOCKET%'', it returned /var/lib/mysql/mysql.sock I typed 'mysql_config --socket' in shell, it returned /var/lib/mysql/mysql.sock I modified /etc/my.cnf file
View 3 Replies
View Related
Jun 16, 2011
I've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
[code]...
View 10 Replies
View Related
Apr 2, 2009
I have the latest LAMP running on F10 but need to do a database conversion from mysql 4.1.22 to mysql 5 for a client.
View 4 Replies
View Related
Aug 1, 2010
So, I've managed to install xampp on ubuntu and now I want access mysql through the ubuntu terminal. When I try with:
mysql -u root -p
I get:
the application can be found in the following packages
[code]....
View 5 Replies
View Related
Oct 26, 2010
I am looking for some advice on the best way to connect to a MySQL database on a Ubuntu server via SSH. The application is built using VB6 and is installed on a Windows server.
View 2 Replies
View Related
Dec 22, 2010
I am in the process of installing a genome brower on an ubuntu 10.04 (lucid). I achieved to see the browser once. Then, the mysql.sock disappeared and to solve this I tried first, to reboot the server with no results. Then I removed and reinstalled the MySQL server installing mysql-server-5.1. Now, I have a socket and MySQL is running (checked these out) but when I try to see the browser that is what I obtain:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
View 1 Replies
View Related
Mar 9, 2011
I'm trying to run php scripts on Kubuntu 10.04 that connect to a MySQL database. These scripts run perfectly on OS X 10.6.6, but when I run them in Kubuntu, I get the following error: The script...
[Code]...
The error message: "Fatal error: Call to undefined function mysql_connect() in..." I've seen some posts in other boards about Red Hat problems like this, but nothing that can help with Kubuntu.
View 4 Replies
View Related
Jul 24, 2011
I'm using ubuntu 10.04 LTS I install mysql..Code: sudo apt-get install mysql-server.I set up my password and confirm,I type mysql at the terminal and i get this back.
View 1 Replies
View Related
Apr 3, 2010
how to connect mysql server from ubuntu,.
View 3 Replies
View Related
Nov 10, 2010
im in the process of installing LAMP. im presently installing mysql and that's where i got into trouble...
im following the this tutorial [URL]
i tried the following :
Step 3. This is where things may start to get tricky. Begin by typing the following into Terminal:
mysql -u root
and i got this output:
root@konlah-laptop:/home/konlah# mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
obviously my question is why can't i connect to local mysql?
View 4 Replies
View Related
Nov 19, 2010
I've looked everywhere for this (simple) problem, and I can't get this working. I have a mysql server on my LAN which is accessible from within the server.I want to access the mysql server from another computer on the LAN, but it never works.
View 7 Replies
View Related
Mar 8, 2011
My problem is that for some reason I can't connect to my MySQL on my server.I know it's not the script, other than the information that I'm using to connect.The MySQL server is set to "localhost" so I set the host in my php script to "localhost".I check for the username and they say I should try "root" so I set the username to "root".Then I put in my root password.When I go to where my php script actually starts, it gives me the error saying that I cannot connect. I know the rest of the script works and the error refers to the info I'm using to go in
View 9 Replies
View Related
