Topic: MYSQL Problems and Removal

[r2ks]

Ok i really need some help on this. mysql Developed major problems over the weekend and just went from Bad to worse.
I have tryed everything that i could on these fourms to recover it no Luck. at this point my question is one how do i remove the mysql rpms so i can do a complete mysql reinstall. everytime i run a yum localinstall for mysql it says there is nothing to update.

I am at work and can not get to my server at this time i will check the psot at 4:00 pm est

Thanks

[bpivk]

Well you have to remove mysql first but i don't know how many other rpm's you'll remove in the process (BTW: yum remove is the proper command and then use yum install).

You should describe your problem and what you did to your server so that your mysql doesn't work.

[r2ks]

libmysqlclient_r.so.14 is needed by package mysql-server
Error: Missing Dependency: libmysqlclient.so.14(libmysqlclient_14) is needed by package mysql-server
Ok where do i find this rpm

Please help i do not want to have to redo this

[r2ks]

Hello,
i have Mysql upand running again but i have problems with it let me start with just a couple to see if i can get them resolved.

1.) horde mail when i login into the webmail it looks like it is going to connect then it just comes back to the login page.

2.) Joomla when i go to login to the administrator page it comes back and says you must be logged in.

3.)phpmyadmin when i try to change privligaes it just refreshes the screen and Nothing

4.)mysqlclient when i go to catalogs and click on a database it says can not fetch shcema.

any help on this would be Great

[bpivk]

1.) horde mail when i login into the webmail it looks like it is going to connect then it just comes back to the login page.

2.) Joomla when i go to login to the administrator page it comes back and says you must be logged in.

This could be a problem with cookies in your browser (had the same problem with joomla).

Browse with internet explorer and check the bottom right corner for a red eye. If you see one click on it (right click) and set the page to allowed and then refresh the page and try to log in again.

[r2ks]

Sorry that was not it wish it was that easy. i am convinced  that it has something to do with mysql and some how the Databases got corrupted because Moodle is also throwing a error "Query failed in load_user_capability" when i try to Login to that Like i said any help is appreciated

[bpivk]

Did you try with signal-event post-upgrade and signal-event reboot? This should revert some changes.

What does "config show mysqld" show?
Did you check the output of /var/log/mysqld/current?

[r2ks]

Did you check the output of /var/log/mysqld/current?

Code: [Select]

70610 18:00:38 [Note] /usr/libexec/mysqld: Shutdown complete
@40000000466c74900a6df1dc
@40000000466c74900e8d076c 070610 18:00:38 [Note] /usr/libexec/mysqld: ready for connections.
@40000000466c74900e8d2a94 Version: '5.0.37'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Source distribution
@40000000466c7f7b267f184c 070610 18:47:13 [Note] /usr/libexec/mysqld: ready for connections.
@40000000466c7f7b267f3b74 Version: '5.0.37'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Source distribution
@40000000466c7f8d02f8d764 070610 18:47:31 [Note] /usr/libexec/mysqld: Normal shutdown
@40000000466c7f8d02f8fe74
@40000000466c7f8d032a5b2c 070610 18:47:31 [Note] /usr/libexec/mysqld: Shutdown complete
@40000000466c7f8d032a7e54
@40000000466c7f8d07df9e0c 070610 18:47:31 [Note] /usr/libexec/mysqld: ready for connections.
@40000000466c7f8d07dfc134 Version: '5.0.37'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Source distribution
@40000000466c831b2cfb6f2c 070610 19:02:41 [Note] /usr/libexec/mysqld: Normal shutdown
@40000000466c831b2cfb8e6c
@40000000466c831b2d2a475c 070610 19:02:41 [Note] /usr/libexec/mysqld: Shutdown complete
@40000000466c831b2d2a6a84
@40000000466c831b314409a4 070610 19:02:41 [Note] /usr/libexec/mysqld: ready for connections.
@40000000466c831b314428e4 Version: '5.0.37'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Source distribution
@40000000466c83f6232f704c 070610 19:06:20 [Note] /usr/libexec/mysqld: ready for connections.
@40000000466c83f6232f9374 Version: '5.0.37'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Source distribution
@40000000466c8e392cae609c 070610 19:50:07 [Note] /usr/libexec/mysqld: Normal shutdown
@40000000466c8e392cae7fdc
@40000000466c8e392cf139e4 070610 19:50:07 [Note] /usr/libexec/mysqld: Shutdown complete
@40000000466c8e392cf15924
@40000000466c8e3931220e6c 070610 19:50:07 [Note] /usr/libexec/mysqld: ready for connections.
@40000000466c8e3931222dac Version: '5.0.37'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
@40000000466c8e912d85ec4c 070610 19:51:35 [Note] /usr/libexec/mysqld: Normal shutdown
@40000000466c8e912d860b8c
@40000000466c8e912ee2d0b4 070610 19:51:35 [Note] /usr/libexec/mysqld: Shutdown complete
@40000000466c8e912ee2f3dc
@40000000466c8ee007f91d64 070610 19:52:54 [Note] /usr/libexec/mysqld: ready for connections.
@40000000466c8ee007f93ca4 Version: '5.0.37'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
@40000000466c929507f387b4 070610 20:08:43 [Note] /usr/libexec/mysqld: ready for connections.
@40000000466c929507f3aadc Version: '5.0.37'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Source distribution
@40000000466c92ab038a651c 070610 20:09:05 [Note] /usr/libexec/mysqld: Normal shutdown
@40000000466c92ab038a8844
@40000000466c92ab03f7675c 070610 20:09:05 [Note] /usr/libexec/mysqld: Shutdown complete
@40000000466c92ab03f78a84
@40000000466c92ab08d25aac 070610 20:09:05 [Note] /usr/libexec/mysqld: ready for connections.
@40000000466c92ab08d279ec Version: '5.0.37'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Source distribution
@40000000466ca2042e7d8aec 070610 21:14:34 [Note] /usr/libexec/mysqld: Normal shutdown
@40000000466ca2042e7daa2c
@40000000466ca2042eb97e94 070610 21:14:34 [Note] /usr/libexec/mysqld: Shutdown complete
@40000000466ca2042eb99dd4
@40000000466ca20432dc1a7c 070610 21:14:34 [Note] /usr/libexec/mysqld: ready for connections.
@40000000466ca20432dc3da4 Version: '5.0.37'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Source distribution
@40000000466ca34715588404 070610 21:19:57 [Note] /usr/libexec/mysqld: Normal shutdown
@40000000466ca34715589f5c
@40000000466ca3471558b2e4 070610 21:19:57 [Note] /usr/libexec/mysqld: Shutdown complete
@40000000466ca3471558ca54
@40000000466ca39705937f74 070610 21:21:17 [Note] /usr/libexec/mysqld: ready for connections.
@40000000466ca3970593a684 Version: '5.0.37'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
@40000000466cb2051e57ff6c 070610 22:22:51 [Note] /usr/libexec/mysqld: ready for connections.
@40000000466cb2051e582294 Version: '5.0.37'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Source distribution
@40000000466cb21c2743e334 070610 22:23:14 [Note] /usr/libexec/mysqld: Normal shutdown
@40000000466cb21c27440a44
@40000000466cb21c2797a884 070610 22:23:14 [Note] /usr/libexec/mysqld: Shutdown complete
@40000000466cb21c2797c7c4
@40000000466cb21c2fcc4a3c 070610 22:23:14 [Note] /usr/libexec/mysqld: ready for connections.
@40000000466cb21c2fcc6d64 Version: '5.0.37'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Source distribution
@40000000466cb2f21120f4d4 070610 22:26:48 [Note] /usr/libexec/mysqld: ready for connections.
@40000000466cb2f211211414 Version: '5.0.37'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
@40000000466d232d2cd4287c 070611  6:25:39 [Note] /usr/libexec/mysqld: Normal shutdown
@40000000466d232d2cd447bc
@40000000466d232d2f6c6b44 070611  6:25:39 [Note] /usr/libexec/mysqld: Shutdown complete
@40000000466d232d2f6c8e6c
Config show mysqld
mysqld=service
    LocalNetworkingOnly=yes
    status=enabled

[CharlieBrady]

mysql Developed major problems over the weekend and just went from Bad to worse.

What did you do to cause the problems to start?

[r2ks]

a+rwx to /tmp and then I could get Health and Catalogs to work fine with MySQL
Administrator. This was an easier solution (for me) than rejiggering the tmp dir
environment variables.

[r2ks]

I also am haveing problem there is no Login page after i did a mv /home/httpd/html/horde /home/httpd/html/horde.30.old My question is how do i do a move back or Restore it to the orginal place.

the Last issue alot of my Problems was that the permissions got changed on the /tmp reset those and bing everything was working

[william_syd]

Version: '5.0.37'

[r2ks]

Version 5.037 of what Horde i thought there was only 3 out ?? I am not trying to be a smart --- i have seen alot of your post and respect all of your post.

Thanks

[william_syd]

Your mySQL is version 5.

Did you upgrade this at some stage ?

Do you have the centosplus repo enabled?

Sorry, my first reply was a little cryptic.

[r2ks]

Yes is is version 5
I did upgrade thinking i was going to be all set it did not work that way i have figured out alot in my trials and Errors. i am not sure if i do can you tell me how i would find that info.

And again thank you so much for your time.

Horde is the only thing not working at this time