Ubuntu Servers :: Bind Phpmyadmin To Localhost Only?
Mar 18, 2010
Have basic LAMP setup on 9.10 box. I want to have a publicly accessible website AND I want to have phpmyadmin available. The only thing is I would rather not have the phpmyadmin interface available on the internet. I usually open a ssh port forwarded tunnel when I need to use phpmyadmin on this server. I want to add a directive to make phpmyadmin bind only on localhost. I have found the phpmyadmin config file in /etc/apache2/conf.d
phpmyadmin.conf -> ../../phpmyadmin/apache.conf
I have tried adding some LISTEN directives, but apache does not like my directives-- I am obviously not doing it right. I have looked for a bit on the internet and can't find out how to disable external access to a configured site in Apache.
i setup a localhost in my system. but am not getting access to the phpmyadmin by entering the user name and password i entered at the time of set up. the /etc/phpmyadmin/config-db.php file is shown below.
<?php ## ## database access settings in php format ## automatically generated from /etc/dbconfig-common/phpmyadmin.conf ## by /usr/sbin/dbconfig-generate-include
[code]....
when i access http://localhost/phpmyadmin/ , the login screen appears but entering the username and password as in the file gives the error #1405 cannot log into mysql server.
i have fedora 11 installed in my laptop and apache server by default. after starting httpd and mysqld services i was able to access localhost through browser.(e.g. [URL]). before installing phpMyAdmin everything goes right. after installing phpMyAdmin it created problem in localhost. now typing [URL] it opens joomla site but without images and without intending of content. when i type [URL] in browser it ask for user name and password. i already provide user name(root) and password(my_root_password) in /etc/phpMyAdmin/config.inc.php. but it doesnt open.
I've just reinstalled XAMPP in my machine. Now, I can't get phpmyadmin to work. Before this was okay. But since I lost its password I need to reinstall it again. Now I got it reinstalled, another problem occured. When I enter localhost/phpmyadmin in my browser, it tells me to open the file with a program which is obviously something must be wrong during the installation or the system is screwed. Here's the screenshot:
Another problem is I can't get Apache and MySQL to run using the XAMPP wizard. But by using shell I can get it worked, but when I see the wizard, it just says stopped. What's wrong? Although I have pressed Execute it still can't be run.
From terminal: Code: me@me-laptop:~$ sudo /opt/lampp/lampp start [sudo] password for me: Starting XAMPP for Linux 1.7.4... XAMPP: Another web server daemon is already running. XAMPP: Another MySQL daemon is already running. XAMPP: XAMPP-ProFTPD is already running. XAMPP for Linux started.
I had the brilliant idea to make my own web server since i had a silicon mechanics 1u server collecting dust. Ive got apache running. Phpmyadmin is installed but i cant get into the admin panel. When it asks for the user name and password no matter what i use it wont let me log in.
I am trying to install mcrypt for use in phpMyAdmin but am having some trouble. I apt-get'd the mcrypt-php5 package and it installed, but it seems to only function on the Apache Module version of php5 and not the CGI version. Both versions show the mcrypt extension installed in phpinfo, but in phpMyAdmin only one of them removes the error about mcrypt. Other extensions (such as cURL) which I installed with apt-get have worked, so I'm not sure why this one does not.
EDIT: I also compared the CGI php.ini and the apache2 php.ini and there were no differences there. I also confirmed that the php.ini file for the CGI version is loading from that location.
My situation I recently installed Ubuntu 10.04 LTS Server on a virtual machine. I installed apache2, php and mysql-server. Several vhosts I sat up are running fine and I can also connect to the MySQL server using the mysql command-line client. I now want to setup PhpMyAdmin to allow the vhosts owners to administrate their DBs. I installed the package using:
Code: apt-get install phpmyadmin I answered the questions and accepted the creation of the phpmyadmin database. The install finished successfully. I did a small modification to the main website vhost to access it easily: Code: Alias /phpmyadmin /usr/share/phpmyadmin
I am able to access phpmyadmin via my web browser using either my local ip followed by /phpmyadmin and by using the same layout with localhost. If i use my DNS name provided by no-ip which i bound to in apache2 i am able to get to the "It works!" page with the domain name but if i use /phpmyadmin after it, it will tell me that there is no such directory.
I'm setting up a home web server using LAMP that I want to use to access files and practice coding, but I am very new to Linux and web servers. I currently have it so I can access phpMyAdmin and the test pages locally through my internal IP, but whenever I try to access it through the external IP I get this router management console that I don't know the password or username to. I know my router login and password and it's not the same as that. I've forwarded port 80 and when that didn't work I tried changing /etc/apache2/ports.conf to 8080 and I forwarded that port on my router with no luck too.
It doesn't seem to matter if I have any ports forwarded, though, it still brings me to the same screen regardless. Also, I have set up a static IP on the server by modifying the /etc/network/interfaces file. I've attached a screenshot with the actual router management console screen. I won't have access to the server until later, but, if you require any output from the server I will be sure to post it as soon as I get home. I'm not using ubuntu for my webserver, but debian instead because ubuntu server had a whole bunch of problems with my PCMCIA network card. Ubuntu suggestions should work just fine, but I just thought I should clarify.
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 get an error message that says phpMyAdmin - Error, Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.
So I did some googling and found a post here {URL]... which speaks about resetting the ownership of the session directory. However I am wondering how I can find out what the owner if the directory is (if its root or admin or ...)
It's strange because it all worked fine just about two hours ago and I am not sure since I have the server automatically download security updates if there is something it automatically downloaded that caused this. Also how to make the server stop automatically downloading security updated?
I installed ubuntuserver edition 10.10 on my old p3.Installation went fine and i installed LAMP and SSH along with it.*everyhting i do past this point is via LAN on my laptop using root account on putty or winSCP.*I installed phpmyadmin, loged in with root, duplicated the root acount and gave the duplicate any host (%) access. Next i created an account with access only to the users database (for use in my php to check username and password).Next thing i did was change the apache2 config 000-default to disable indexing.After that i changed the php.ini file to allow 6GB uploads (for movies).Rebooted... and thats where the problems start.I CANT:Acces phpmyadmin with any acount.Login on my website.I CAN:login to mysql using root.I HAVE:Checked if the mysql database and table for websitelogin still existed, they do.Checked mysql useracounts and they are still there.So something changed after the reboot, because it was working fine before i did.
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 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'm still getting my head around setting things up on my web server, I've configured php to run off of Fast CGI, rather than mod_php, due to better memory consumption. I've managed to get my virtual hosts configured to work with fastcgi, ensuring the following options are set:
I tried adding those settings to /etc/phpmyadmin/apache.conf, but this doesn't seem to work. Whenever I go to www.mydomain.com/phpmyadmin , I just get a 403 Forbidden Error. This used to work no problems on mod_php.
[URL].. because the alias is set so that my virtual hosts can access it through /phpmyadmin. There is probably something basic I am missing here.
I encountered a problem when I am trying to access my phpmyadmin the error came up: Wrong permissions on configuration file, should not be world writable!
Instead of XAMPP or LAMP, I installed a local web server to my Ubuntu 10.04. Apache and phpmyadmin works well.
I copied the files of my Joomla website to /var/www folder. When I go to administrator panel, it works. But when I type in the browser "http://localhost/[folder_name], a blank page appears and nothing else.
I was wondering if anyone knows how to make a zone file for bind dns server that points "example.com" and all (by all i mean any) sub-domains to this 127.0.0.1 address. and i wanted to set up a virtual host in apache to use /var/www/eample/index.php for 'example.com' and all of its sub-domains.
After spending what seems like an eternity trying to learn how to host a couple of webpages on my laptop for no better reason than to practice creating them without paying for a server. .for the time being, I kept getting the usual errors (stuff I have seen lots of tutorials on) and this time kept getting
"The connection was refused when attempting to contact localhost"
Just by random chance I happened to open up Chromium for one of my attempts and low and behold, I get the much awaited
Quote:
It works! This is the default web page for this server.The web server software is running but no content has been added, yet. I can even login to phpMyAdmin from Chromium. So what's going on with Firefox? Doesn't work in Seamonkey either. Using 10.04
Am having trouble setting up a localhost DaviCal server. I've followed the directions here: [url]
And everything seems to be working, but when I go to: [url]
I get the "Not Found" page. How do I tweak this to use it locally from my computer? Have searched and tried to follow various tutorials, but no luck.
What I'm trying to do is setup a CalDav server locally on my computer so I can interface Thunderbird with it. The reason being then I can sync my Android phone with the CalDav server on my computer, thus syncing my Thunderbird calendar with it. Android is great, but currently the only ways to sync your calendar is to go through google's servers (not interested) or use the new CalDav sync software from the market... which is what I'm trying to do.
I am still a newbie at Linux, but have managed to get about 6 different Kubuntu systems up and all running a localhost test web server. I always start out with a server .iso and after installing I add a kubuntu desktop GUI. I have an old laptop that was running 8.04 server w/xubuntu desktop gui and it was running my test web pages through localhost. I got a wild hair and thought it was about time to upgrade to 10.04 server. I always do a complete install and this time I tried lubuntu desktop GUI. I really like lubuntu but for some reason can not get localhost to run. I get a 402 forbidden error. same error with 127.0.0.1 Here is what I get when I run this command
