I tried this a few days ago. After the install I can't start mysql, it
says, Can't connect to local MySQL server throuh socket '/tmp/mysql.sock'
(111)
Wrong answer. You need to check the database directory for the error (*.err
log) read the last few lines and learn why "Can't connect..." and fix the
problem...
Is the database directory configured in my.cnf and the start script(i.e.
/usr/local/share/mysq/mysql.server) (which both most be the same by the way
:o) owned by mysql:mysql? That's often a mistake newbies make. Anyway, read
the error log and mysql will tell you why start failed.
Don't kid yourself. There is no black magic in these binaries. They install
for hundreds of thousands of users like me who just did one eight minutes
ago and it works like a charm. In other words, mysql really does work: count
on it to be that way; and assume there is something you have missed or have
done incorrectly and fix that. That's your new paradigm wherein things work.
Lesson over. :o)
best..
Mike
----- Original Message -----
From: "Jim Douglas" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Saturday, March 11, 2006 7:48 PM
Subject: RE: [Dbmail] Receiving mail
From: "M. J. [Mike] OBrien" <[EMAIL PROTECTED]>
Reply-To: DBMail mailinglist <[email protected]>
To: "DBMail mailinglist" <[email protected]>
Subject: [Dbmail] Receiving mail
Date: Sat, 11 Mar 2006 17:08:45 -0500
I saw that. That upgrade will resolve the dbmail build with mysql but...
When I upgrade to MySQL 5.0.18 the Postfix build with mysql can't
complete because it can't find libsqlclient.so.14. (I spent a few hours
trying to resolve the libsqlclient.so.14. before going back to MySQL
4.0.16)
I'm using Fedora Core 4.
Jim
Hey Jim:
Here's 'howto' on a fresh from MySQL AB binaries pkg that you should be
able to install yourself.
MySQL client is where your problem begins so far. Nothing to do with mail
yet... not really a thing of this list but... Get MySQL installed and
working to the point of being able to do command line queries: >mysql and
then in mysql "show databases" and seeing "mysql" "test" as the databases.
You have conflicted MySQL client issues; linker problems; dependency
issues and who knows what else... I suggest you remove all the old mysql
clients you currently have installed. If you can't, unlink them. You seem
to have a range. Cleaning up the mysql server and clients and installing a
current MySQL 4.1.18 is a worthwhile start.
I take it you are back to using MySQL 4.0.16. That's just barely OK . If
you get it working::live with it. But I think if all your responders on
this list are about to be Dads/Moms to this installation, this child needs
to have a predictably good future. :o)
Use MySQL 4.1 to ensure scalability, upgradeability and ease your
headaches. I know nothing about your Fedora Core 4 build but wonder if its
possible to remove the MySQL RPMs and install a binary package direct from
MySQL. Here's how:
See: http://dev.mysql.com/downloads/mysql/4.1.html
Give them (MySQL AB) a read and see if you think this is for you. This is
MySQL from the horses mouth. :o)
They have non-RPM already-compiled binaries which you can install on your
own using your native shell tools. Simple stuff.
I think you will end up with a /usr/local/mysql installation
Is this you: Linux, Intel C/C++ compiled, glibc-2.3
Sound about right?
Do something like this:
1) You need to get all the old stuff out of there so try uninstalling all
the mysql and mysql clients you have on your system. Restart your system
to clear any linkers or package thingies or whatever.
2) Install a nice clean MySQL 4.1.18
mkdir /usr/install
cd /usr/install
wget http://dev.mysql.com/downloads/mysql/4.1.html
gunzip mysql-standard-4.1.18-pc-linux-gnu-i686-icc-glibc23.tar.gz
tar xvf mysql-standard-4.1.18-pc-linux-gnu-i686-icc-glibc23.tar.gz.tar
cd mysql-standard-4.1.18-pc-linux-gnu-i686-icc-glibc23.tar.gz
./configure
make
make install
(You can watch each step for troubles -- hopefully none.)
good luck...
Mike
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
I tried this a few days ago. After the install I can't start mysql, it
says,
Can't connect to local MySQL server throuh socket '/tmp/mysql.sock' (111)
Jim
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
