Ubuntu Servers :: Cannot Access PHPMyAdmin From External IP
Jul 6, 2011
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.
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 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.
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 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!
I have proftpd setup on my Aspire Revo (which I'm using as an HTPC) so that I can download files to my mac when I feel like watching in bed or whatever. I recently purchased a 1TB WD Elements to store my media. I have proftpd setup so that I can access every file on the computer. However, when I try to gain access to the Elements HD, I get an FTP error from Cyberduck that says:
/media/Elements: no such file or directory
Note that I have not formatted the drive or anything - just set it up straight out of the box. My media is loaded on to it, and XBMC reads the files fine. Is there a way I can enable the hard drive (or the OS) to share these files over FTP, or is this not possible?
I just installed the Ubuntu 9.10 and then installed Oracle 10 Express and all went fine. I can access oracle on 127.0.0.1:8080/apex address however when I try to access the server on it's external ip address (192.168.1.14) even when I'm on my Ubuntu machine it's failing. I'm new to Linux so I'm sure this should be silly and simple issue but I can't find a way around it. I need this so I can access the oracle server from outside world (other nodes on the network).
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.
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 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
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?
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.
Im using CentOs on a remote server. I've recently installed phpmyadmin but cant access from [URL] I checked the files and found only 3 folders in /var/lib/phpmyadmin -config / save / upload - all of them empty. Whenever I try intstall phpmyadmin again it just says its already installed and up to day.
I'm trying to install phpMyAdmin on my Ubuntu 10.10 server. I type the following command (I don't use "sudo" because I'm logged in as root, I know its not safe):
Quote: apt-get install phpmyadmin and go through the installation. I allow the installation to configure the database, and I chose the correct server (Apache2), when it asks for passwords, I use the same password that I use for the rest of the server (i.e. it is the account password for root, sudo, and my account). Once the installation is complete, I try and access it from a computer on the same network. I type "http://***.***.*.*/phpmyadmin" and I get the message saying the directory isn't there. I go into Webmin to confirm that the directory isn't there, and it isn't.
My questions are (1) Why isn't the phpmyadmin directory in my Apache Server root? (2) Is it installed with apt-get, if so, where? (3) How do I know what server I selected for it to install to? (4) What do I need to do to get it to install correctly?
I'm having a problem with my webdav share. I have a secure webdav folder that gets accessed via a non-standard port and requires basic authentication. I can connect and interact with it fine via cadaver. However, when I try to connect from nautilus, it says "Access was denied." To make it even stranger, sometimes I can click on the folder in nautilus (it still mounts) and access it. Sometimes not (just repeats the error message and won't show me the contents). I may not even un-mount it, but just look at other folder, then click it again and be able to access it, but again - only rarely.
I asked a friend to try connecting from his windows vista computer and it would not work. It would not work from my windows XP virtual computer either. However, it mounts and works just find from my work computer (also Windows XP).
So it seems to be a 50/50 chance that the drive will mount on any given computer/system and work. Do anyone know what the problem may be? I'm guessing user permissions, but I can't figure out what.
I've made sure the webdav folder is owned by www-data and www-data has read access to the password file as well.
When I try connecting from nautilus, I get this in the log file:
Code:
Here is one of the (many) sites I've tried looking at: [url]
I have an external USB drive with one ext4 partition on it. When I plug it in it's mounted and a file manager window pops up. However, I am not able to create files/folders unless I'm root. I have to open Nautilus as root to put files on it. How do I set it so that I as a user can add files/folders to the drive having them end up with the same owner/permissions I have as a user? It's to cumbersome having to sudo every move with regards to the USB drive.
I have the old version 8.10 installed in my laptop. The laptop already some battery issue and after the power failure i cannot access the external usb drives anymore.I have ntfs-configuration installed and do not know how to access the drives using the tool.Every time i try to access the drive it says that i do not have the privilege to mount the volume.
Strangest thing...yesterday my 11.04 box lost the ability to access anything external. I can ssh to the box from outside my network, and all other boxes on my network are fine, but this one box can't hit anything external. If I attempt to ping a site it's doing the same resolution, but no packets are delivered.
Up until yesterday it was running fine, and I didn't make any changes to my home network or install any updates. Totally stumped.
Edit: this is a wired connection with a static internal IP.
