Fedora :: Using PhpMyAdmin MySQL Cannot Connect With Host Name But Ip Address Works
Oct 3, 2010
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 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..
I have a problem with Samba. I've already configured my SMB.conf file, but I can't connect to my Windows shares by their host name. for example: if I try to connect to GDEA73-PC-1 share = netshare, server connection fails. if I try to connect to 192.168.1.171 then share = netshare, it works. How do I fix this? When I run findsmb, I am on the GDEA73 NETWORK workgroup as I configured, but my local PC is the only one on it...
I am running a server with Ubuntu 10.04 and mysql v.5.4.41-3ubuntu12.1.I am unable to connect to my mysql server remotely, (error 111). I have added the port 3306 to iptables. It is able to connect to the loopback address (127.0.0.1) but not through its external address.
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.
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:-
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 am using Fedora 7 in my server. Currently windows server 2003 (Active Directory integrated with DNS) is running. I want to switch my DNS to Linux. In my small organization there are only 20 users using static IP address and the IP are mostly permanent. so should deploy name server or I just populate eateries in /etc/hosts file ?
Right now I have a machine set up running Fedora. I have configured inittab to accept Console Logins, but I am having problems getting my netbook running PuTTY to connect. How would I go about finding the Host Name and Port to connect to?
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
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.
i have linux server application based on centos 5 that run httpd daemon from /usr/local/pf/conf/httpd.conf which is generated from the /usr/local/pf/conf/templates/httpd.conf.apache22 file
the problem is every time i run my linux server application i am not able to access phpmyadmin unless i stop my linux server application which is stop it httpd daemon then start "service httpd start"
i have been told by forum moderator to create an alias for my phpmyadmin in Virtual Host but it stil dont work, i am not able access my phpmyadmin site
this is what i have done to solve this problem - open /usr/local/pf/conf/templates/httpd.conf.apache22 file then look for
<VirtualHost *:%%admin_port%%> - add Alias /phpmyadmin "/usr/share/phpmyadmin" (Failed) - add Alias /phpmyadmin /usr/share/phpmyadmin (Failed) - add Alias /phpmyadmin "/usr/share/phpmyadmin/" (Failed)
[Code]....
why i still cant open my phpmyadmin site ? or why i cant run phpmyadmin together with my linux server application because it use the same daemon (httpd daemon)
I install and configure the vncserver following and reading 1000papers, but all of this present the same problem; when i try to connect to my vncserver,recive this mesage: unable connect to socket: No route to host (113) The OS version is Fedora Core 14 and tigervnc-server i try different solutions including:Allow TCP connection modifing files /etc/gdm/custom.conf and /usr/share/gdm/gdm.chemas Disable SELinux removing iptables Here follow the vncserver configuration:
[code].....
The ip address of the vncserver is correct because i can do ssh on it. Where or what can i do?
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 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.
i have linux server application based on centos 5 that run httpd daemon from /usr/local/pf/conf/httpd.conf which is generated from the /usr/local/pf/conf/templates/httpd.conf.apache22 file
the problem is every time i run my linux server application i am not able to access phpmyadmin unless i stop my linux server application which is stop it httpd daemon then start "service httpd start"
i have been told by forum moderator to create an alias for my phpmyadmin in Virtual Host but it stil dont work, i am not able access my phpmyadmin site
this is what i have done to solve this problem
- open /usr/local/pf/conf/templates/httpd.conf.apache22 file then look for <VirtualHost *:%%admin_port%%> - add Alias /phpmyadmin "/usr/share/phpmyadmin" (Failed) - add Alias /phpmyadmin /usr/share/phpmyadmin (Failed) - add Alias /phpmyadmin "/usr/share/phpmyadmin/" (Failed)
[Code]....
NB : my phpmyadmin is install on /usr/share/phpmyadmin with /etc/httpd/conf.d/phpmyadmin.conf as phpmyadmin configuration file
why i still cant open my phpmyadmin site ? or why i cant run phpmyadmin together with my linux server application because it use the same daemon (httpd daemon)
At work we run DHCP. hostnames have the format: computername.city.mycompany.com
I have a laptop runing Fedora 13 and a desktop I use for backups, etc. My laptop is named copernicus. Desktop is named galileo. If ping either hostname from itself I get back the localhost IP address. If I ping the fully resolved hostname it tells me unknown host. The desktop is exporting an NFS share I use for backing up work data. I need the laptop to be able to resolve host names to mount the share since we use DHCP. The desktop is dual boot and if it is booted into windows my laptop can resolve the hostname properly. What do I need to do in Fedora to get it to register a hostname with the DNS and/or DHCP server? Should the domain and the search path below both say the same thing?
Here is resolv.conf on the laptop (I am at home). The desktop looks the same, except for a different nameserver. Both computers can resolve other hostnames, just not each other.
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 have an auxillary laptop that I use with Fedora 9 on it. Up until now, I have been using wireless just fine with a an old Marvell card. A friend needed a wireless card, so I gave it to her because I had a spare Belkin card (PCMIA) with a RT2500 chipset. This chipset has been supported in Fedora for a long time, and it does it fact work but it will not obtain an IP address and disconnects from the Network Manager upon every attempt to connect.. I get an error that says "set bit rate" failed and I cannot get assigned an IP address from my router.
I do not use encryption. Nothing I have tried with sysconfig-network has had any affect.
iwlist scan finds the router just fine with a good signal, but will not connect.
i'm new to MySQL and i designed a database using MySQL and PHP recently but dont know how to port it to my host company. How do i save the database on my flash drive then transfer to my host on my website's control panel.
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 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 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
