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]...
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)
I just installed FC12 x86_64. After a clean install I found that httpd, mysql, svn, svnadmin, etc are already installed. I still need to install and configure tomcat running as a worker behind httpd and configure everything. But my question is about security. What do I need to do to ensure that when I start httpd and mysql that they are secure? Are there default settings that I need to change? Are there security patches I need to apply?
System Config:
Fedora Core 12 x86_64
AMD Athlon II X2 250 3.0 GHz dual core
GIGABYTE GA-MA785GM-US2H
G.SKILL 4GB (2 x 2GB) 240-Pin DDR2 SDRAM DDR2 1066 (PC2 8500) Dual Channel Kit Desktop Memory Model F2-8500CL5D-4GBPK
Whenever i try to create a account either then the root and login as it i get a error Access is Denied if though the password is correct.
View 3 Replies View RelatedThere 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 RelatedCannot 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.
On my Ubuntu 10.04 lucid lynx server edition machine I have an Apache http server listening on port 80 and today I installed the Funambol server which added an Apache Tomcat server listening on port 8080. From within my lan I can reach both servers, but from outside the lan I can only reach the http server on port 80 and not the Funambol server on port 8080. I get a time out message instead.
In my router I have setup port forwarding, such that both ports 80 and 8080 get forwarded to my server machine. Must Tomcat be told to listen to external requests? Is my server listening on port 8080 only for requests inside the lan? Or is there some authorization that fails when I try to visit from outside my lan?
Here is some netstat output, I don't know if the differences between the 80 line and the 8080 line are relevant:
Code:
remon@compaq:~$ sudo netstat -nlp | grep 80
tcp 0 0 0.0.0.0:8009 0.0.0.0:* LISTEN 1778/java
[Code]....
I just finish tring to get my mail server running but I get an error in my mail.log
Jan 21 16:33:08 server imapd-ssl: Connection, ip=[::ffff:67.223.78.XX]
Jan 21 16:33:08 server authdaemond: failed to connect to mysql server (server=127.0.0.1, userid=postfixadmin): Access denied for user 'postfixadmin'@'localhost' (using password: YES)
Jan 21 16:33:08 server imapd-ssl: LOGIN FAILED, user=jason@[mydomain].com, ip=[::ffff:67.223.78.76]
Jan 21 16:33:08 server imapd-ssl: authentication error: Input/output error
I have the right password in all the mysql config files and tried to reset the password in the sql database with no luck. I granted perms to all and its still giving me the error.
We need to only allow access to a web page only to some ips. We want to do this via Apache but it seems like the standard way of denying all and allowing some ips doesn't work because we mount a webapp using tomcat.
The sites-enabled file looks like this:
Code:
NameVirtualHost *:443
<VirtualHost *:443>
ServerName web.address.com:443
ErrorLog /var/log/apache2/app_ssl_error.log
[Code]....
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."
I am not sure if this is the correct forum to post this as I have usually been able to find the answers from other peoples threads.The error I receive is below.(changed "at" as can't post links)"#1045 - Access denied for user 'root' at 'localhost' (using password: NO)" Not entirely sure what has happened here. I have had this server running for a long time and today it seems to have spat it's dummy out!I have checked the config.inc.php and the controluser and controlpass are entered correctly so the error saying a password is not being usPHP Code:Thisis needed for cookie based authentication to encrypt password incookie
View 2 Replies View RelatedI'm having a hard time to access MySQL from the local or remote shell.
If I try to access MySQL, using mysql -u root -pxxxx I get the error 1045 Access denied...
MySQL is running and I can access it, using phpmyadmin.
There must be something blocking shell access. Can anybody confirm and tell me how to check/configure for shell access?
I'm using ca preconfigured CenOS from PBX in a flash and it seems they did some security settings - but I can't find any further information.
I know I should probably post there, but the Mods didn't activate my account yet. And you know how it is if you try to figure something out. You won't stop.
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]....
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 tried to follow some the tutorials on google to setup mysql for remote access however, cannot seem to do it. am i missing something.
i have edited /etc/mysql/my.cnf bind-address directive to a static ip address. then, i grant user@'%' access to database and restart mysql
after doing all that, when i try to remote access mysql i get "Access denied for user"
I think I screwed up my Administrative username in mysql.
mysql -u root mysql
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
Can I just copy all the files in /var/lib/mysql >>reinstall MySQL >> copy all the old folders into the new /var/lib/mysql ( while MySql is off)
Setup an Ubuntu LAMP server to house a Wordpress site. Everything is gravy but I am having some troubles getting emails to route outside my local network. I have setup Internet and also added my ISP SMTP as a smarthost - either way I get the dreaded Relay Access Denied 5.7.1.
I am using DynDns as I do not have a static IP - not sure if this makes a difference?
telnet my_dyn_dns.org 25
ehlo localhost
250-my_dyn_dns.org
250-PIPELINING
250-SIZE 10240000
[Code]....
I have also tried the above with my ISP smtp IP in relayhost - same error.
I've set up Ubuntu Server 10.04 LTS 64-bit. I've set up zfs-fuse and created a zpool named 'data' which contains two 2TB WDC Green HDD's in raid1 (mirror). I've set up an NFS server to share the pool. So far so good. But now, I want to write to the pool. It has occurred to me that I need to be root to do that. On the server, this is not a problem (sudo cp...) but on my laptop I can not copy anything to the pool because I'm not a superuser.
View 1 Replies View RelatedI have setup my own home server . All the applications are working perfectly except one I can't send Emails. I check weda my smtp has any errors not welll I got this
Code:
SMTP -> FROM SERVER:
220 server1.example.com ESMTP Postfix (Ubuntu)
SMTP -> FROM SERVER:
[code]....
How yo get ride of access denied 404/403 for localhosts other folders? i am using lamp and trying to access my site which is placed in a folder wthin the document root. but its showing access denied. how i can edit permissions?
View 3 Replies View RelatedThis is my first post, I hope I'm the the right place. I installed mysql mysql-server php-mysql perl-DBD-mysql libdbi-dbd-mysql via "yum install -y" on a server running CentOS 5.3 X86_64 The install completes successful with no errors, but once I start mysqld via "chkconfig --level 35 mysqld on" ; "service mysqld start" There are no errors in /var/log/mysqld.log netstat shows mysqld listening on 3306 and localhost is in /etc/hosts
[Code]...
My postfix is ok with receiving emails but i can send mail to my domain only [URL] When I want to send to other domains i receive this error (in the maillog):
Quote:
postfix/smtpd[14172]: NOQUEUE: reject: RCPT from 93-46-46-73.ip106.fastwebnet.it[93.46.46.73]: 554 5.7.1 <giannileggio@shoppeo.com>: Relay access denied; from=<info@sampledomain.com> to=<giannileggio@shoppeo.com> proto=ESMTP helo=<[36.234.52.97]>
it is the same via thunderbird or via telnet. This is my configuration
Quote:
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
broken_sasl_auth_clients = yes
command_directory = /usr/sbin
[code]....
I used 'sampledomain' instead of my real domain
i have configured mail server with postfix with dovecot with no encryption:When connecting with Thunderbird imap is working fine. when sending email from another domain to this domain again it is fine. but when i want to send mail frommy domain to another it gives me error and this is /var/log/maillog:
Code:
Jan 18 18:23:09 srv1 postfix/smtpd[3991]: NOQUEUE: reject: RCPT from unknown[95.81.67.120]: 554 5.7.1 <Recipient email>: Relay access denied; from=<Sender> to=<Recipient email> proto=ESMTP helo=<[127.0.0.1]>
[code]....
I have recently upgraded to 10.04 and I am trying to access my apache and sshd servers from the net but I have not succeed so far when those two are using their regular ports.If I change their ports to something greater than 1024 they work fine.80->8010 22->4567(I can access the servers when I am connecting from local net: 192.168.1.0/24) Is this restriction build into the new kernel? Is there something I can do to fix this without recompiling the kernel?
View 3 Replies View RelatedI have installed mysql-server, but i have no access. I have set the password during installation process.
Used command:
mysql -u root -p
error message:
[code]....
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]...
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?
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]....
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]...
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?