Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Using IP.Board on FreeBSD, having SQL/Apache Issues
Top Forums Web Development Using IP.Board on FreeBSD, having SQL/Apache Issues Post 302344824 by Dark Severance on Monday 17th of August 2009 05:23:44 PM
Old 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

apache issues

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

FreeBSD 4.7 X issues - assistance req'd please

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

snort installation on freebsd issues

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

Some FreeBSD issues

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

FreeBSD - Kernel Queries/Issues

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

Resolved: htpasswd issues (-b) on FreeBSD

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

E4500 Disk board issues

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

FreeBSD AMD NFS over TCP issues

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

Networking Issues - Opera, FreeBSD, 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

FreeBSD DHCP wpa_supplicant Wi-Fi Issues

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 OSF1

iscc

iscc(7) 						 Miscellaneous Information Manual						   iscc(7)

NAME

       iscc - serial communications interface

SYNOPSIS

       controller  iscc0  at  isa0

DESCRIPTION

       An  onboard  Zilog  8530  DUART	provides  AXPvme-based Single Board Computers with console (CON) and auxiliary (AUX) serial communications
       ports.  Both serial communications ports can operate at baud rates from B50 to B38400,  excluding B134 (see tty(7)).

       On AXPvme Single Board Computers configured with a graphics head as the system console, the CON serial communications port (/dev/tty01)	is
       available for use by application programs as an additional communications port.

       In  the	absence  of a graphics head, the CON serial communications port (/dev/console) becomes the system console. When used as the serial
       system console, the CON serial communications port always operates at 9600 BPS, 8-bits, and no parity.

       Regardless of system console, the AUX serial communications port (/dev/tty00) is always available for use by application programs.

RESTRICTIONS

       Data communications equipment attached to the CON serial communications port must be set to 9600 BPS, 8-bits, no parity when configured	as
       the serial system console. The iscc terminal driver enforces this restriction.

       No modem control is supported for either the CON or AUX serial communications ports.

FILES

       console terminal local terminal local terminal

RELATED INFORMATION

       console(7), devio(7), tty(7), MAKEDEV(8) delim off

																	   iscc(7)
All times are GMT -4. The time now is 01:05 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy