Server :: MySQL 5.0.32-Debian_7etch8 "forgets" Permissions Repeatedly
Apr 25, 2011
I'm a PostgreSQL administrator. We have a few sites (maybe 30? 40?) that use MySQL as a backend, but nothing like the thousands of sites that run PostgreSQL. As you can imagine, my knowledge of PostgreSQL has grown much faster than my knowledge of MySQL. The problem, then, is very likely to be PEBKAC. This past weekend we had an upstream transformer incident that managed to take out an enterprise APC, causing this particular server to reboot. The server environment is a bit wanky (I didn't set it up this way), with both PostgreSQL and MySQL running together on a Debian "Etch" box, with PostgreSQL taking up the lion's share of resources (it has 200+ databases vs. MySQL's 10 or so). Both PostgreSQL and MySQL came up after the reboot, but now MySQL is acting "funny".
Initially after the reboot, sites were getting "Could not connect to MySQL." I went in and looked at the user and db tables and fixed the permissions, ran flush permissions, and all sites came up. Happy DBA. Over the remaining weekend and this morning, we're seeing a repeated issue where sites get "Could not connect to MySQL", and it affects sites independently of each other (site "A" is fine, site "B" gets "could not connect to mysql"). I checked the max_connections and max_user_connections and noticed that they were a bit lower than I'd like, so I bumped them up (now set to: 1000 max_connections, 800 max_user_connections) and ran flush permissions again. All is well once more.
Then it happened again. Granted, it's not nearly as frequent as it was Saturday, but it still occurs. This is becoming problematic (and, as you can imagine, quite a headache). I'm the only DBA in my company, so *ANY* ticket that has the word "database" in it, regardless if it's PostgreSQL/MySQL/MSSQL/DB2/Oracle/etc... find their way to me...and this one has me a bit stumped. Every time it occurs, I can run "flush permissions" and everything works again. I've considered the short-term fix of creating a cronjob, but that's quite a hack and I'd rather just fix the cause rather than treat the symptom.
Edit - a bit more background on this particular server: I had it running PostgreSQL 8.3.5, then went on vacation. When I returned, it was running PostgreSQL 8.4beta1 (it's a production box! /me cries) and now PostgreSQL has all kinds of library version mismatch issues and what-not. I scolded the IT tech who gave dev root on this box, revoked all dev permissions, and I've been busy building a replacement machine to move all of the PostgreSQL databases to, but due to some purchasing delays the replacement box isn't ready yet. It's entirely possible that MySQL has similar issues, though I've not witnessed anything of the sort (yet).
View 1 Replies
ADVERTISEMENT
Jun 14, 2010
I am using Joomla and a script within it. That Script is suppose to copy tables from one DB to another.
Code:
Error(1) [1142] query [CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`]. DB Error: CREATE VIEW command denied to user 'localiz_master'@'localhost' for table 'test_users' SQL=CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`
Error [1142] retrying query [CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`]. DB Error: CREATE VIEW command denied to user 'localiz_master'@'localhost' for table 'test_users' SQL=CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`
localiz_master: name of the DB from which data is suppose to be copied.
jos_users: name of the table form the main DB.
localiz_master: user for the DB.
localhost: host
test_users: name of the table to be created.
We do have phpmyadmin but the user's table is hidden. What SSH command we might run to make localiz_master user have access to all the databases.
View 6 Replies
View Related
Jun 22, 2010
I'm using an older redhat system (2.6.9-22.ELsmp) here which is running an older mysql (server version: 4.1.12). I don't think that's the source of the problems. I believe that have understood things rightly when I say that the mysql root user is unrelated to the linux root user ... in my case I believe the root user to be the unix user mysql. So when I connect to the server (local host from a local terminal) I use:
Code:
-bash-3.00$ mysql -u mysql -p
and enter a blank password
This gets me on, however I seem unable to do anything like create database or alter privilege. I wonder if its related to my finding no database called mysql?
-bash-3.00$ mysql -u mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 11 to server version: 4.1.12
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> show databases;
+----------+
| Database |
+----------+
| test |
+----------+
1 row in set (0.00 sec)
Although I understand that show databases will not show things I have no priv to see. Does this mean my settings for the users are all screwed? How do I rectify this situation? Some other (perhaps) useful information.
Code:
[root ~]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
So my BASEDIR seems to be nothing like is suggested in the documentation at [URL].
View 2 Replies
View Related
Jun 7, 2011
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
[Code]...
View 6 Replies
View Related
Aug 9, 2010
Im running Ubuntu 10.04 with the latest updates and im connecting from windows xp using tortisesvn.When I do svn+ssh//Connection_name/var/svn/repoI can connect just fine. The problem is that im asked 3 times for my password before the folder will display. I guessing its 3 times because the repo is 3 levels deep. In tortise if I click a folder to go another level deeper im asked for my password again. "Connection_name" is the name of the onnection profile I setup in Putty which is used by tortise via plink. I tried setting up a auth key but that didnt help either. If I use putty to open up the "connection_name" ssh connection, im only asked once for my password and can operate as normally expected.
View 3 Replies
View Related
Jun 2, 2010
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.
View 9 Replies
View Related
Jul 2, 2010
A user from our domain sent an email with big attachments to a recepient of other domain, and the same email was sent several times to the receiver.
I checked the df and qf file on our sendmail server, in /var/spool/mqueue and found following:
qfo5SHgJqX006403:Mreply: read error from remote-host.somedomain.com.
qfo5SHgJqX006403:MDeferred: Connection timed out with remote-host.somedomain.com.
I deleted all qf and df files for this particular mail. So deleting the df and qf file has stopped sending mails repeatedly to the receiver.
Is this problem at our end or the receipient end? Why is the same mail sent several times to the receiver?
View 2 Replies
View Related
Jan 13, 2010
MySQL gets installed with root user by default, root user can administer every mysql database installed in the system. Question is how to create a new user that will not be able to administer all the databases in the system the way as root user is? Can it be done using webmin?
View 7 Replies
View Related
Feb 1, 2009
I've created a mysql user and he can connect Joomla to mysqld when everyone has full permissions to the mysql homedir but I know this is bad from a security standpoint. If I set mysql user as the only one with permissions then I can't connect. I know Joomla support is not very help from past experience, wish I could dump it for something else but it does work great once it is configured so I need to keep it around, can anyone make a guess as to what permissions I need to have set on mysql's home dir so that joomla can still connect yet I am more secure than now?
View 11 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
Aug 25, 2010
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
View 4 Replies
View Related
Feb 22, 2011
I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
View 7 Replies
View Related
Aug 2, 2010
I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run
Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:
[code]...
View 13 Replies
View Related
Jun 4, 2009
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community
View 16 Replies
View Related
Jun 18, 2010
I was having issues with MySQL Server and uninstalled it. I still have my databases at /lib/var/mysql.
My question: if I install MySQL Server (same version, 5.1) again, will it delete my databases, or will they still work?
View 1 Replies
View Related
May 23, 2011
How can I really, really remove everything related to mysql / mysql-server. I read and tried all kinds of things, but on every reinstall there is still old mysql stuff there, for example an existing password. Even resetting the password does not help.
Reason of removal: it looks like the mysql setup is really corrupt, so I want to remove, and then do a fresh install. Running Ubuntu 11.04 64-bit
sander@R540:~$ sudo apt-get purge mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package mysql-server is not installed,
[Code]....
View 4 Replies
View Related
Jan 30, 2011
I installed mediawiki the other day and went with the default innodb option. However a week later something went wrong. And since I have scripts that nightly backup /var/ I just copied the backup of /var/lib/mysql/wikidb/ (as I've done with MyISAM). Then when I connect the wikidb database. I can see the tables (via "show tables"), but when I do any query with them (check table X, select * from X) I get:
Code:
Table 'wikidb.X' doesn't exist I've since read that can can't just copy the database directory like MyISAM, and there appears to be no way that I can find to restore or fix Innodb, without a dump of the data. And I never got a chance to do a mysqldump of the data. So has anybody got any idea how I can at least view the "page" table from the files I've backed up in /var/lib/mysql/wikidb/ ?
View 1 Replies
View Related
Mar 3, 2009
I just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -
[mysqld]
datadir=/var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
[Code]...
View 16 Replies
View Related
Jul 14, 2010
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 4 Replies
View Related
Nov 9, 2010
i want to know what is use or benefit of using s and t permission?i have used them but could not understand its uses.please explain me with suitable example.Also tell me about umask command to flag on s and t.
View 1 Replies
View Related
Mar 15, 2010
I am getting the following error when starting mysql using 'sudo /etc/init.d/mysql start':
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: ^G/usr/bin/mysqladmin: connect to
[code]....
View 1 Replies
View Related
Nov 15, 2010
I'm using CentOS 5 on VMware workstation 7 for testing purposes. When I restart the VM it forgets all my preferences or other settings (keyboard(using azerty here), firefox bookmarks, even the desktop beackground) are reset. This happens with the root user and the default centos user. Is there something I'm looking over or is there something I can do about that problem?
View 5 Replies
View Related
Jul 14, 2010
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 3 Replies
View Related
Aug 13, 2011
Everytime I change my screen brightness from screen settings, the new brightness level stays for the current session only and then gets reset back to 100% every time i reboot my pc... What am i doing wrong?
View 3 Replies
View Related
Jun 29, 2010
After installing Ubuntu 10.04 on an nvidia dualmonitor system there is a weird behavior. Every program starts in the middle of the two dual monitors (overlapping both).
View 1 Replies
View Related
Jan 20, 2010
This worked fine in 9.04, but doesn't in 9.10 (fresh install).
If I tell my ssh-agent about a private encrypted key via "ssh-add .ssh/mykey" then everything works fine.
But if I log out and then log back in it's not there and there is no Gnome prompt to ask for the password to decrypt. So I have to do an "ssh-add" everytime I log in.
View 4 Replies
View Related
May 10, 2010
I've just installed 10.04 x64 and I've had some problems with samba (cifs/windows file sharing). It seems like samba is forgetting user passwords, so on every reboot I have to add a password for the user that needs access: sudo smbpasswd -a tietze
I've tried restarting samba (sudo service sbmd restart), but it does not work. I have to add a new password for the user with the command above.
I tried to google a bit for a solution, but only found the following thread with a problem that seems related: [other] Samba forgets user
making samba remember passwords betweeen reboots/shutdowns?
View 1 Replies
View Related
Apr 29, 2011
This occurred sometime in the past couple of days, perhaps because of an update that I just blindly accepted or due to some tinkering of my own. But for some reason, my gksudo never remembers the password I put in there anymore. When I sudo in a terminal it remembers no problem, and my sudo-via-terminal also responds to the "timestamp_timeout=x" variable in /etc/sudoers as it should. But does gksudo have it's own "/etc/sudoers" file where you can override the caching period for the password or does it reference the regular /etc/sudoers also?
View 2 Replies
View Related
May 20, 2011
This occurred sometime in the past couple of days, perhaps because of an update that I just blindly accepted or due to some tinkering of my own. But for some reason, my gksudo never remembers the password I put in there anymore. When I sudo in a terminal it remembers no problem, and my sudo-via-terminal also responds to the "timestamp_timeout=x" variable in /etc/sudoers as it should. But does gksudo have it's own "/etc/sudoers" file where you can override the caching period for the password or does it reference the regular /etc/sudoers also? I have no clue where else to look....
View 7 Replies
View Related
Feb 14, 2010
I am using Fedora 12 with KDE4 and when I logged in to my KDE desktop for the first time, the screen resolution was 2048x1536, which was unusable for me. Therefore I set the screen resolution to 1280x1024 through the System Settings > Display in KDE4. However, whenever I log out and back in, the resolution falls back to 2048x1536. When I go to System Settings > Display to set it right, as soon as I click the Display button in System Settings, before changing any resolution, the screen falls back to the 1280x1024 setting
View 2 Replies
View Related