Hi
I have what i think is a strange issue -
All my users are NIS users and they can access this box fine. I have a MySQL server running on this box that is running fine. The OS 'root' user can authenticate and use MySQL fine e.g.
[root@xxxxxxx]# mysql -u bugs -pxxxx bugs Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 3.23.58
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Yes i know thats an ancient MySQL version but this is an app requirement, dont get me started!
now when a NIS user tries to use the db
[root@xxxx]# su - bugzilla bugzilla@xxxx$ mysql -u bugs -pxxxx bugs ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
any ideas why this is or what i can do to make it work?
thanks
any ideas why this is or what i can do to make it work?
Why does the version of mysql that comes with 4.x not work? The compat libs and oldpassword options should allow it to work with 3.x mysql clients just fine.
Since you're not using the provided mysql for 4.x, how did you install what you've got? I think at this point you need to provide some more details for what you're doing and how you got there.
Why does the version of mysql that comes with 4.x not work? The compat libs and oldpassword options should allow it to work with 3.x mysql clients just fine.
Since you're not using the provided mysql for 4.x, how did you install what you've got? I think at this point you need to provide some more details for what you're doing and how you got there.
'they' want the new box to have exact same versions of software to one that recently died. I am afraid its as simple as that and at the moment i can't change that. If i can prove that it is not possible then i may be able to change versions somewhat but i need to attempt to get this working first.
thanks for your input regarding the compat libs
Tom Brown spake the following on 8/31/2006 12:43 AM:
Why does the version of mysql that comes with 4.x not work? The compat libs and oldpassword options should allow it to work with 3.x mysql clients just fine.
Since you're not using the provided mysql for 4.x, how did you install what you've got? I think at this point you need to provide some more details for what you're doing and how you got there.
'they' want the new box to have exact same versions of software to one that recently died. I am afraid its as simple as that and at the moment i can't change that. If i can prove that it is not possible then i may be able to change versions somewhat but i need to attempt to get this working first.
thanks for your input regarding the compat libs
Then maybe the new box needs to have the same linux distribution that was on the old box. That way everything is the same as the old box. Then maybe you could plan a test with a newer version of everything after you are back online.
-
Jim Perrin -
Scott Silva -
Tom Brown