08-17-2009
Thank you. That helped quite a bit. But now I'm getting the following error:
"ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
There isn't a mysql.sock in /tmp. However /tmp does have the following permissions:
drwxrwxrwt 6 root wheel 512 Aug 17 20:07 .
Originally it was just a default setup. There was no my.cnf file. I found a .cnf file in /usr/local/share/mysql/my-medium.cnf and used that to configure options in mysql. I moved it to /var/db/mysql and renamed it my.cnf. Restarted, everything seemed fine. I was able to log into mysql but now I can't seem to login and I'm not sure why. I did try commenting out the socket part in my.cnf but that didn't seem to help.
EDIT:
I found a couple other default .cnf files. There was my-medium.cnf (which I originally used), my-small.cnf and my-large.cnf. I ran a diff to compare to the originals. It looks like the issue is related to these two lines:
query_cache_size = 8M
thread_cache_size = 4
That was causing the problem. When I removed them. Everything seemed to work fine... well at least I could use: mysql -u root -p
What did those commands do that caused it to not work?
Last edited by Dark Severance; 08-17-2009 at 06:36 PM..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi guys!
well, as some of you might have noticed, i was having issues getting my linux box going correctly -- well, after some long hours and the help of you guys and my trusty o'reilly linux in a nutshell book, everything's runing great and i'm getting much more comfortable using the file... (3 Replies)
Discussion started by: aenemated
3 Replies
2. UNIX Desktop Questions & Answers
question:
i just installed FreeBSD 4.7 on my laptop, when i log in as root, i can startx no problem at all but when i try to start it as a user, i can't. otiginally it told me i needed to be a member of the group 'wheel' to do startx, no problem, added myself in /etc/group, but for some reason i... (1 Reply)
Discussion started by: Calum
1 Replies
3. UNIX for Advanced & Expert Users
i'm following the, "How to setup and secure Snort, MySQL and Acid on FreeBSD 4.6 Release" off of the snort.org website.
in the documentation it says snort should be installed through the following:
-----
make -DWITH_MYSQL -DWITH_FLEXRESP ; make install
-----
later it says to do the... (13 Replies)
Discussion started by: xyyz
13 Replies
4. UNIX for Dummies Questions & Answers
I have been using Linux for 3 years now, and I think I am getting enough knowledge (and confidence) to try some more 'traditional' unix variants. I installed FreeBSD 5.0-CURRENT. I have a couple of questions for the time being:
1) Frequently when I need to compile software packages they can't... (16 Replies)
Discussion started by: cbkihong
16 Replies
5. BSD
All,
I am a bit of a BSD newbie and haven't really played with it for years, but I have had a recent situation whereby someone attempted to load a custom kernel module and ended up breaking my BSD server.
I managed to fix it by doing the following:
Booting into loader mode:
unload
set... (3 Replies)
Discussion started by: drbabbers
3 Replies
6. UNIX for Dummies Questions & Answers
I wrote a script to batch-create directories with .htaccess and .htpasswd files.
I am using the following line to create the .htpasswd file:
htpasswd -cb .htpasswd $USER $PASS
However, I keep getting this message in return:
Usage: htpasswd passwordfile username
The -c flag creates a new... (1 Reply)
Discussion started by: Spetnik
1 Replies
7. Solaris
Hi there,
I'm building a couple of E4500's both with the same spec and seem to be having an issue with the disk boards on each.
I’m running the following config
E4500 6 x 400MHz, 6GB, 2 x X2612A with cards, 1 x disk board with 2 x 9.1GB 10K Disk
I have configured the machine as... (0 Replies)
Discussion started by: wallrunn3r
0 Replies
8. BSD
Hi!
I have a major issue with FreeBSD 7.1 i386.
We did a change in our Unix env where we exchanged home storage from a NetAPP running udp to a NetAPP running tcp.
Now I cant mount homedirs since NFS/AMD seem to fallback to udp :(
Trying to force it with amd options nfs_proto=tcp and so on.
... (0 Replies)
Discussion started by: Esaia
0 Replies
9. AIX
(1) Hi, Am working on FreeBSD 7.4/i386 and installed Opera 11.01 through ports collection manually... But when I run first time am getting "opera: cannot connect X server. Error: Unknown error: 0" What is this error all about???? Please help me to sort out this issue!!!
(2) Hi, currently am... (12 Replies)
Discussion started by: Priya Amaresh
12 Replies
10. BSD
I just got FreeBSD up and running with an XFCE desktop on an old Gateway laptop. It works great, except the wireless setup is scaring me. I can connect to my home WiFi fine most of the time, but I'm concerned about other WiFi that I will need to connect to away from home.
I understand that I can... (1 Reply)
Discussion started by: BrentBANKS
1 Replies
LEARN ABOUT SUSE
ocf_heartbeat_mysql
OCF_HEARTBEAT_MYSQL(7) OCF resource agents OCF_HEARTBEAT_MYSQL(7)
NAME
ocf_heartbeat_mysql - Manages a MySQL database instance
SYNOPSIS
mysql [start | stop | status | monitor | promote | demote | notify | validate-all | meta-data]
DESCRIPTION
Resource script for MySQL. May manage a standalone MySQL database, a clone set with externally managed replication, or a complete
master/slave replication setup.
SUPPORTED PARAMETERS
binary
Location of the MySQL server binary (optional, string, default /usr/bin/mysqld_safe)
client_binary
Location of the MySQL client binary (optional, string, default mysql)
config
Configuration file (optional, string, default /etc/my.cnf)
datadir
Directory containing databases (optional, string, default /var/lib/mysql)
user
User running MySQL daemon (optional, string, default mysql)
group
Group running MySQL daemon (for logfile and directory permissions) (optional, string, default mysql)
log
The logfile to be used for mysqld. (optional, string, default /var/log/mysqld.log)
pid
The pidfile to be used for mysqld. (optional, string, default /var/lib/mysql/mysqld.pid)
socket
The socket to be used for mysqld. (optional, string, default /var/lib/mysql/mysql.sock)
test_table
Table to be tested in monitor statement (in database.table notation) (optional, string, default mysql.user)
test_user
MySQL test user (optional, string, default root)
test_passwd
MySQL test user password (optional, string, no default)
enable_creation
If the MySQL database does not exist, it will be created (optional, integer, default 0)
additional_parameters
Additional parameters which are passed to the mysqld on startup. (e.g. --skip-external-locking or --skip-grant-tables) (optional,
string, no default)
replication_user
MySQL replication user. This user is used for starting and stopping MySQL replication, for setting and resetting the master host, and
for setting and unsetting read-only mode. Because of that, this user must have SUPER, REPLICATION SLAVE, REPLICATION CLIENT, and
PROCESS privileges on all nodes within the cluster. (optional, string, no default)
replication_passwd
MySQL replication password. Used for replication client and slave. (optional, string, no default)
replication_port
The port on which the Master MySQL instance is listening. (optional, string, default 3306)
max_slave_lag
The maximum number of seconds a replication slave is allowed to lag behind its master. Do not set this to zero. What the cluster
manager does in case a slave exceeds this maximum lag is determined by the evict_outdated_slaves parameter. (optional, integer, default
3600)
evict_outdated_slaves
If set to true, any slave which is more than max_slave_lag seconds behind the master has its MySQL instance shut down. If this
parameter is set to false in a primitive or clone resource, it is simply ignored. If set to false in a master/slave resource, then
exceeding the maximum slave lag will merely push down the master preference so the lagging slave is never promoted to the new master.
(optional, boolean, default false)
SUPPORTED ACTIONS
This resource agent supports the following actions (operations):
start
Starts the resource. Suggested minimum timeout: 120.
stop
Stops the resource. Suggested minimum timeout: 120.
status
Performs a status check. Suggested minimum timeout: 60.
monitor
Performs a detailed status check. Suggested minimum timeout: 30. Suggested interval: 10.
promote
Promotes the resource to the Master role. Suggested minimum timeout: 120.
demote
Demotes the resource to the Slave role. Suggested minimum timeout: 120.
notify
Suggested minimum timeout: 90.
validate-all
Performs a validation of the resource configuration. Suggested minimum timeout: 5.
meta-data
Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5.
EXAMPLE
The following is an example configuration for a mysql resource using the crm(8) shell:
primitive example_mysql ocf:heartbeat:mysql
op monitor depth="0" timeout="30" interval="10"
SEE ALSO
http://www.linux-ha.org/wiki/mysql_(resource_agent)
AUTHOR
Linux-HA contributors (see the resource agent source for information about individual authors)
resource-agents 1.0.3 07/05/2010 OCF_HEARTBEAT_MYSQL(7)