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

Server :: MySQL Permissions - Copy Tables From One DB To Another

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

Server :: MySQL Root User - Administration And Permissions

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

OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock

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

Server :: Svn Over Ssh Repeatedly Asking For Password?

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

General :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)

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

Server :: Mail Sent Repeatedly To The Receiver?

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

OpenSUSE Network :: MySQL Create User/permissions?

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

Fedora Servers :: Joomla+MySqlD: Mysql Homedir Permissions?

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

Ubuntu Servers :: Mysql Error Stopping MySQL Database Server Mysqld?

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

Software :: Connecting To Mysql Database - Can't Connect To Local MySQL Server Through Socket

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

Fedora :: MYSQL Error 2002 (HY000): Can't Connect To Local MySQL Server Through Socket?

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

Server :: Mysql 'Table 'mysql.user' Doesn't Exist'?

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

CentOS 5 :: Error: Mysql Conflicts With Mysql-server-community

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

Ubuntu :: Reinstalling MySQL Server - Still Have My Databases At /lib/var/mysql

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

Ubuntu :: Remove Everything Related To Mysql / Mysql-server?

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

Server :: Recover MySQL Innodb From /var/lib/mysql/ Backup?

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

CentOS 5 Server :: MySQL On Cent OS 5.2, Error In MySQL

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

CentOS 5 Server :: MySQL Setup Without 'mysql.server'

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

Server :: Benefit Of S-permissions And T-permissions?

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

Ubuntu Installation :: Cannot Start Mysql - "Can't Connect To Local MySQL Server Through Socket:"?

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

CentOS 5 :: Forgets All Settings After Restart?

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

Server :: MySQL Setup Without "mysql.server" In CentOS5

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

Fedora Hardware :: 15 Forgets Screen Brightness?

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

General :: Ubuntu Forgets Program Position?

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

Ubuntu Networking :: SSH Agent Forgets Identities?

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

Ubuntu :: Samba Forgets User Passwords?

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

Ubuntu :: Gksudo Forgets The Password Immediately?

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

Ubuntu :: Gksudo Forgets Password Immediately

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

Fedora :: KDE4 Forgets Screen Resolution After Log Out?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved