Ubuntu Servers :: MySQL Not Accepting Passwords Via Php
Jun 5, 2011
I have just set my self up a new LAMP server running php and mysql. I get the following error when trying to acces mysql databases through php Code: Could not connect: Access denied for user 'danhorni'@'localhost' (using password: NO) I am using a password I can login fine through phpmyadmin
However I just built a 10.10 server, installed webmin, vmware, and the server is working perfectly. I configured my bind 9 server using the latest webmin and on the server everything resolves perfectly to both the internet and lan. I have it set to 127.0.0.1, the server ip address is 10.1.50.25. However, it will not accept dns client queries in which they cannot resolve to the lan or internet. I have the dhcp giving out the dns server 10.1.50.25. NSLOOKUPS from the client show query refused. I know there has to be some setting or config that will allow clients to query but I am not able to locate it, and I am not totally knowledgeable of named.conf and been all through the webmin module and configuration settings.
I'm not sure if this belongs in the Server or Networking section of the forums. Anyway, last month I upgraded my server to Ubuntu 10.04 LTS. Since then, I've had a recurring problem wherein after a certain period of time, the server stops accepting network connections. Ubuntu 10 will continue to reject network connections until someone logs into the server locally, after which time network connectivity is restored and the cycle begins anew. Essentially, the server goes into a "half sleep mode". I say half because the computer is still on and the fans are running.
I've done some searching around various forms and initially figured this issue was related to problems with the Network Manager service (https://bugs.launchpad.net/ubuntu/lu...er/+bug/524454), so I removed the service altogether. However, this problem is still occurring.
I've poured over /var/log/messages and /var/log/syslog, but have noticed no irregular behavior. Has anyone else experienced this issues? I'd rather not resort to downgrading back to Gusty Gibbon if I can help it.
I am happy to provide more information if its needed
Im trying to set up a Proxy server on my CentOS server and I have been looking at Squid, however I wondered if there is a proxy server that will support having authenticated users and passwords in a MySQL database?I wanted to do this so I have good control over who is connected through my proxy.
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.
I'm trying to set up the server to at least ask for a password. I can connect to it without any trouble, but so can everyone else.How can I make samba ask for a password?
Although my smb.conf file cites /etc/samba/smbpasswd as the password file, I see that it is not in some database file. Since smb.conf doesn't seem to look anywhere else but /etc/samba/smbpasswd, how can I direct it to the new password scheme. At least this is what I find when using SWAT to display the smb.conf file contents.This seems to be preventing my windows client having access to shared printers, but yet, not shared files.
I recently built a small server for my dad, to host a business website aswell as manage storage of important documents (raid 1).Yesterday I thought I would try out zentyal. I got it working, mostly. It seemed very useful.However, ANY password authentication; including login, sudo, ssh, was extremely laggy. Were talking a minute after entering the password.I have done
Code: sudo apt-get purge zentyal zentyal-samba And
I wonder if it is possible to have two passwords for one user account in 9.10. I have a long login password (5 words about 45 characters with spaces caps). I would like to set a shorter password for Authentication, sudo, etc. While retaining the original for logging in.In short:Have long password to login to computer.Have short password for everything after login.
On other editions of ubuntu server I had no problem saving multiple users and passwords with htdigest but now it seems it is only possible to save one user and password. Code: sudo htdigest -c /etc/apache2/passwords directory user When I add a second username and password for the same directory it overwrites the first.
So I've set up a Samba server through the gui. When I've labeled my shares as accessible to everyone, I can get to it no problem. However, when I tie it down to a specific samba user, I can't.
By all indications, it appears that it isn't saving the password because every time I go to edit users, it has the exact same string in the password field.
I recently set up a ldap server for user authentication and I want to be able to configure the passwd utlity to automatically update the password for the local account AND on the ldap server. How would I go about this?
We use a Linux server with AFS on it. I changed the linux root password using passwd. The new password will let me log in as root but when I try to change the AFS admin password it asks for the root password. When I put in the password that it let me log in as root. It tells me authentication failed. And when I run the password command with -admin admin, it asks for the admin password. I put in the admin password that worked before I changed the root and it says authorization failed.
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
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 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'm trying to start my MySQL server, and it fails if the /etc/mysql/my.cnf file is there. If it isn't, then it fails - syslog shows me this:
Code: Jun 5 11:02:53 myhost /etc/init.d/mysql[21733]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Jun 5 11:02:53 myhost /etc/init.d/mysql[21733]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
I have probably found a bug in the Ubuntu php5 package. At first I thought it's a problem with Zend Framework, which I use, then I thought it's a php issue, but now it seems to be a problem with Ubuntu's php packages. My problem is that under certain conditions, php is going to read records from the mysql database table infinite times. For a much more detailed description of the bug,[URL]..
I've tried on an x86 Ubuntu Desktop edition, and an x64 Ubuntu Server edition, both 10.04, and both had this bug. I have set up a test system (x86 Ubuntu Server edition 10.04), and compiled apache2 and php5 from source, but used the mysql-server package from the repository. And I couldn't reproduce the bug. However, after copying the self-compiled libphp5.so file from the test system to the desktop that produces the error, I could still reproduce the error on the desktop. This suggests me that the problem is either not in php, or - more probably - there are multiple php binaries used in the repository version, and therefore it doesn't matter that I've copied my libphp5.so because mysql functions are somewhere else. I've found a mysql.so file in /usr/lib/php5/20090626+lfs coming from the php5-mysql package. Does that have anything to do with this issue?
Is there a php,mysql built in?What folder do i put my website?What command do i need to use to start and stop apache?If there isnt php,mysql built in how do i install it ?
I'm using ubuntu 10.04 LTS I install mysql..Code: sudo apt-get install mysql-server.I set up my password and confirm,I type mysql at the terminal and i get this back.
I posted this in Networks but have had little luck in that forum lately...I haven't been able to connect via ssh to my media server at home. It's running Karmic (non-server version) and has sshd installed. I generated a rsa and dsa key pair and added them to the server in .ssh/authorized_keys and .ssh/authorized_keys2 by use ofcat key >> .ssh/authorized_keys(2)Changed sshd_config to only accept Keys and kept port 22, since I will port forward through router and make firewall exception down the line.I made an account on the server with the same name as my laptop. Here's output from ssh -v daniel@10.0.0.10
PHP Code: daniel@Geek:~/.ssh$ ssh -v daniel@10.0.0.10OpenSSH_5.1p1 Debian-6ubuntu2, OpenSSL 0.9.8g 19 Oct 2007debug1:Reading configuration data /etc/ssh/ssh_configdebug1: Applying o
My mysql server won't start on my machine. It simply fails with no errors. Code: sudo /etc/init.d/mysql restart * Stopping MySQL database server mysqld [ OK ] * Starting MySQL database server mysqld [fail]
When I run cat /var/log/mysql.err the file is empty, thinking this might be a permissions issue I tried chowning to a mysql user. Here's the current permissions. Code: ls -alh /var/log/mysql* -rw-r----- 1 mysql adm 0 2009-09-30 11:08 /var/log/mysql.err -rw-r----- 1 mysql adm 0 2010-01-15 09:07 /var/log/mysql.log -rw-r----- 1 mysql adm 20 2009-11-25 07:35 /var/log/mysql.log.1.gz -rw-r----- 1 mysql adm 20 2009-11-24 07:59 /var/log/mysql.log.2.gz -rw-r----- 1 mysql adm 20 2009-11-23 07:56 /var/log/mysql.log.3.gz -rw-r----- 1 mysql adm 20 2009-11-22 07:54 /var/log/mysql.log.4.gz -rw-r----- 1 mysql adm 20 2009-11-21 07:47 /var/log/mysql.log.5.gz -rw-r----- 1 mysql adm 20 2009-11-20 07:43 /var/log/mysql.log.6.gz -rw-r----- 1 mysql adm 20 2009-11-19 07:35 /var/log/mysql.log.7.gz
/var/log/mysql: total 8.0K drwxrwsrwx 2 mysql adm 4.0K 2009-09-30 11:08 . drwxr-xr-x 16 root root 4.0K 2010-01-15 10:24 .. Still having the same issue, mysql server is still failing and /var/log/mysql.err is still empty.
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
I'm using ubuntu 9.10 64bit and I'want to configure php mysql and lampp. Also the package mysql-ser is already installed, so if I install MYSQL GUI tools(Administrator, query browser..) from my synaptic package manager will it detect the mysql already installed ? Also tried configuring lampp by extracting it in my /opt directory and i started the server, which MySQL ll it detect the one which was previously installed otr the oin that in gui tools ?
Also think the current ubuntu repository does't have latest build of mysql GUI tools, so how the above mentioned things ll change if I try to download the individual package.
Oveall what I want is to configure Mysql GUI tools, Mysql workbench, xampp and php(For this I'm using Bluefish and Komposer). Please help me out so that I can leave windows for my Web-projects.