Ubuntu Servers :: Can't Access Mysql Mod_proxy?
Feb 5, 2010
I set up mod_proxy in order to get rid of :8080 now I cant access phpmyadmin through the browser. what is the quickest way to turn off mod_proxy and access phpmyadmin? I would like to optimize the tables and back up the sql file. I just need to turn it on for a bit, and then enable mod_proxy again.Right now, if I got to localhost/phpmyadmin, it redirects to the main application.
I have used a2enmod, and added
sudo a2enmod proxy
sudo a2enmod proxy_http
sudo a2enmod proxy_ajp
[Code]...
View 2 Replies
ADVERTISEMENT
Jan 14, 2011
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
View 4 Replies
View Related
Jul 15, 2010
When you access mysql within the same Apache server (same ip address) via php, do you need to GRANT user ip in order to login to mysql?
Where are the log files for php, mysql etc?
View 4 Replies
View Related
Dec 11, 2010
I'm running an Ubuntu 9.04 Minimal server and trying to get MySQL to work correctly. But when I try to access MySQL with the root user it doesn't want to.
Code:
mysql -u root -p
Enter password:
[code]....
View 4 Replies
View Related
Jul 22, 2011
I erased Windows a week ago and is loving Ubuntu 10.04 (which changed to xubuntu after installing Qimo for Kids??) ever since. Now I want to get coding again and PHP is working fine, but I can't access mysql!?I followed a ton of guides, completely removed, reinstalled etc. Nothing works.Here some stuff that might be interresting. I can't remember the "ls" and "awk" and "grep" commands to use, so please guide me if you need more info.
sudo mysql status
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
sudo update-rc.d mysql defaults
update-rc.d: warning: /etc/init.d/mysql missing LSB information
[code]...
View 4 Replies
View Related
Aug 15, 2010
We started our project (it's a website "employee performance appraisal system") in windows by starting with some html forms and then slowlyadded php ,javascript and other stuff in windows we had no issues of insertion and retrieval of data from thedatabase.Now,we decided to shift the entire stuff to drupal the html forms along with those php files but we had 2 issues with this1. the first one was ..we created "page" for each html form and copied the html code into "page" but we didn't find where our pages are getting stored (do they get stored in mysql database that we create for drupal siter do they remain as html pages somwhere?)2.second problem was ...for admin in drupal I gave the username "root" and a password ..similarly for mysql also I gave a password.
now I used phpmyadmin and created another database called "appraisal" which is supposed to hold the data of our website.when I try to insert data into one of the tables of this database (attendance table) ,the following error occured "Attempt to connect failed access denied for user 'root'@'localhost'(using password:NO) cannot run querry insert intoattendance values('x','y')" Access denied for user 'root'@'localhost' (usingpassword:NO)Also I'm unable to access mysql as a normal user only super user can access and can we unset the password that's required to reach mysqlprompt?
View 2 Replies
View Related
Jan 3, 2011
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.
View 2 Replies
View Related
Jun 11, 2011
I configured the server freeradius with mysql and I think I configured well freeradius and mysql but when I m testing my configuration with:
radtest nezar azerty 127.0.0.1 0 azerty1234
I have always:
rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=108, length=20
View 1 Replies
View Related
Mar 29, 2009
I'm running Fedora 10 with Apache 2.2.11 and I noticed something a little strange going on. This morning, logwatch alerted me to the following concerning apache:
Code:
Sure enough, the apache access log file shows the following:
Code:
mod_proxy is disabled in the apache config file anyway (default mod_proxy commented out):
Code:
When I tried to access my web server to check, it was down, and I got the following when checking its status:
Code:
So I checked the apache error logs and found the following:
Code:
There's nothing wrong with line 188 of the config file:
Code:
It seems fairly apparent that there has been an attempt to use my web server as a proxy to gain access to other servers, so I have a couple of questions:
1) I presume that the attack failed, since mod_proxy was disabled?
2) Why did my web server crash? (It has never done this before). It seems very suspicious that it tried to restart, but failed to load proxy_module modules/mod_proxy.so on the same night that someone had attempted to use mod_proxy. I have since successfully started apache without making any configuration changes.
3) Do I need to worry that any part of my system has been compromised?
View 4 Replies
View Related
Aug 22, 2010
I am trying to create solution with Reverse Proxy, mod_proxy and mod_proxy_connect. I haven't really used this before so I am just curious if I am doing it right. I have attached what I am trying to do plus a copy of the config:Here is my current requirement
We are going to have 3 servers, right now our top level domain is[URL] We have an E-Commerce Server in Production Right now that already has an SSL Cert on it so right now the production server for E-Commerce is [URL] However, as we are growing, we don't want to use subdomains, so instead, we want to use the reverse proxying feature on apache. We are running mostly windows servers and IIS for the E-Commerce, CMS and the Wordpress Server. Assume the following -
Apache Proxy Server 10.100.10.60
E-Commerce Server 10.100.10.3 (www.ooolalashop.com)
Content Management Server 10.100.10.3 (cms.ooolalashop.com)
Word Press Blog Server 10.100.10.3 (blog.ooolalashop.com)
1) We need the following mapped
[URL] - maps to ecommerce server - since ssl cert is going to stay on the server, on the proxy we just create a static host that points to the e-commerce server
[URL]
All of these should be pretty easy to reverse proxy
2) We need to be able to proxy the SSL connection or have it pass through to the server on the back end with the domain [URL] right now we are getting some errors Here is the error I get with SSL [Sun Aug 22 01:51:30 2010] [warn] proxy: No protocol handler was valid for the URL /. If you are using a DSO version of mod_proxy, make sure the proxy submodules are included in the configuration using LoadModule.
Here is a copy of the config
<VirtualHost *:80>
ServerAdmin support@cometcomputing.com
ServerNamewww.ooolalashop.com
DocumentRoot/var/www/ooo
[code]....
View 1 Replies
View Related
Jan 13, 2010
I am up and running. Symptom: webapp/servlet deployed to Tomcat, utilizes JDBC driver for MySQL connectivity. Upon launching application in browser and performing action requiring database interaction, exception thrown, server log:
[Code]...
View 1 Replies
View Related
Jul 3, 2010
I have Virtualbox setup
WinXP Host
Ubuntu 10.04 is the guest
Mysql is installed in ubuntu and it works fine in the guest (ubuntu)
Internet works fine in the host and the guest. Bridged Network.
Now, here is the thing... i want to access mysql from my host to load some data into it.
how do i access mysql from my host Win XP?
View 3 Replies
View Related
Apr 15, 2011
I can not access my MySQL database from any remote host on my home network, I keep getting "Access denied for user 'dbuser'@'192.168.1.10' (using password: YES)"
From what I've read this seems to be a permission problem, I tried
'dbuser'@localhost';
'dbuser'@'%';
'dbuser'@'192.168.1.10';
and between each change of permission, I've flushed privileges.
View 1 Replies
View Related
Mar 20, 2010
I have a php app set up in the default virtualhost, and want to add a Grails app. The grails app runs on [URL] and I want to configure apache2 to proxy that folder to Jetty using mod_proxy.
Module is enabled
Code:
$ sudo a2enmod proxy
Module proxy already enabled
[code]....
Quote:
[Sun Mar 21 00:14:56 2010] [warn] proxy: No protocol handler was valid for the URL /mailscan. If you are using a DSO version of mod_proxy, make sure the proxy submodules are included in the configuration using LoadModule. My apache2.conf contains no LoadModule lines, and a2enmod says it's already enabled. Does Ubuntu Desktop (Karmic) use the DSO versions of modules, or did I miss something else? I'm aware I should also use mod_proxy_html to make sure only the "portless" version of the address is outputted, but I can fix that later!
View 1 Replies
View Related
Feb 16, 2011
My Linux server which is running my company website have been hacked. Today I saw a number of clients (customers) with some fun characters entries on my database. Access denial on really clients.
View 2 Replies
View Related
Sep 28, 2009
I was trying to install MySQLbd (a module for python to connect and access MySQL) I followed these steps for installation[URL].. but while I am getting some installation errors. When I try to run $ python set.py build I am getting the following errors (I removed few errors as I can post more than 10000 characters here)
[Code]...
View 3 Replies
View Related
Mar 26, 2010
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)
View 4 Replies
View Related
May 13, 2011
I have install mysql on my fedora12. My different mysql server is located in us. I want to check health status and hits per seconds everything. Is it possible with mysql-administrator command.
now a these days i am connect through ssh and excuting below command
#mytop mysql -u root -p <passwd>
In my mysql db i have added the userip & passwd (allowed the privileages for that ip)
If i use mysql-administrator i am getting below error
MySQL Error Nr. 2003
Can't connect to MySQL server on '66.98.152.64' (111)
View 6 Replies
View Related
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
Jul 28, 2009
I am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
View 2 Replies
View Related
Mar 26, 2010
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]
View 4 Replies
View Related
Apr 15, 2010
I have a proxy with SSL that forward any request to a backend platform. In this moment I have a problem if I'm trying to execute an activex on the backend platform. I'm reading that the mod_proxy blocks any activex request because it don't trust for the system. How I can do? I'm reading about mod_security.
Code:
View 2 Replies
View Related
Apr 14, 2011
There is a simple select query in a.php. If i run directly a.php, there is no problem but if i call a.php from b.html with ajax i have Access denied for user 'www-data'@'localhost' (using password: NO)error.
View 2 Replies
View Related
Jul 26, 2010
i have installing the server XAMPP on my PC but i can't access to Mysql
[root@localhost lampp]# mysql -u root -p
bash: mysql: command not found
View 5 Replies
View Related
Nov 3, 2010
I have figured out how to use virtualhost, proxypass and proxypassreverse. So far, so good.
The problem I'm experiencing is this:
I have a reverse proxy server running apache (123.123.123.123)
Behind this proxy server I have a http server running apache (124.124.124.124).
This http server has multiple sites (virtualhost), it's only reachable via the proxy server.
If i run a nslookup on www.somedomain.com I get 123.123.123.123 (Not really but you understand what I mean)
I put my proxy to have the IP 123.123.123.123, so far so good. The requests come in to the proxy server.
I want my http server to be named 124.124.124.124.
In the http server I wish to set up my virtualhosts like this:
How do I get my proxy to grab the data from the http server?
If I do like this I will only make another request to my proxy server.
If I do like this, only the first page in the httpd.conf in my http server will work.
Do I need to setup a different DNS server for the proxy server? I would hate that. Perhaps use hosts-file in proxy. Or maybe I can use sub-domains?
View 1 Replies
View Related
May 14, 2010
I seem to be having a problem with mod_proxy and https websites. A simple connection to port 80 works fine but all calls to 443 fail.
I had a look at my firewall but can't see anything that would block port 443, although I get no tcpdump traffic on that port on the deb01 client when I try and connect to it. I disabled the firewall but still no luck.
My configuration consists of 3 VMs (KVM) each running a different website.
I get the following error when connecting to ssl deb01
Code: An error occurred during a connection to deb03.example.com.
SSL received a record that exceeded the maximum permissible length.
(Error code: ssl_error_rx_record_too_long)
The following is what can be found on the host
Code:
View 1 Replies
View Related
Apr 15, 2010
I have an httpd server with mod_proxy that forward any request to an another server.
the flow is: client --> requesto proxy [url]forward to server [url]
I'm reading this error in my httpd log in LogLevel debug (after some request):
Code:
Code:
and this is my ssl.conf in /etc/httpd/conf.d
Code:
how I can find the root cause?
View 2 Replies
View Related
Nov 19, 2010
I'm working on setting up a hosted OSS app on a VPS and have a question about doing some proxying. I have Centos 5.5/Apache 2.2 running on 2 VPS's, in different locations, accessible from the net. One of these hosts the app itself, the other will be used as a web portal where the end user will login to auth and then be able to access the app. Now, since I don't wan't access to the app server from the world at large, I want to firewall it and only allow access from the portal machine. So what I think I need to do is set up a reverse proxy with mod_proxy, and then if the end user auths forward them to a specific url on the app server.
So when they connect to [url] and log in I need them to be redirected to app.machine.com/theirdir
So the questions I have are:
1) Can this be done? If so, is mod_proxy the way to do it? Configuring Apache isnt a problem, but I havent worked with mod_proxy.
2) If this does work, will it also work with SSL?
3) I've seen a few small tutorials on the net, but not doing exactly what I want to. They all use the reverse proxy with a public IP connecting to a server with a private IP behind a firewall, while I have public IP's on both ends. From a network standpoint I know this shouldn't matter, but I'm not familiar with mod_proxy's particulars itself.
View 1 Replies
View Related
Feb 16, 2011
Cannot seem to use my mysql password, keep getting the error
"Access denied for user 'root'@'localhost' (using password: YES)"
So I tried checking my password using mysql -u root -p and I get the same error as above. I've tried accessing mysql with skip grant tables disabling the need for a password so I could reset my root password. After going through the necessary steps I still get the error above when typing my password in for mysql.
View 4 Replies
View Related
Mar 23, 2011
I've been using ubuntu for quite a few years, and know the basics of databases. However, how to get them to talk to each other... Not so much.
I need to be able to connect to a MySQL database using Microsoft Access 20074. The database is going to be running on my server, which runs ubuntu server 10.10.
So far, I have installed MySQL server and libmyodbc. I took the deetails for the odbc.ini file from the ODBC ubuntu community page, so this is the current setup (database name is business):
Code:
[ODBC Data Sources]
odbcname = MyODBC 3.51 Driver DSN
[business]
[Code].....
When I try to connect using Access, I get "Server does not exist or access denied."
View 3 Replies
View Related
