Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: Pinoc on May 21, 2006, 01:46:51 AM

Title: MySql installation problems
Post by: Pinoc on May 21, 2006, 01:46:51 AM

As an old windows user i tried to uninstall mysql on my sme 7 and now i have some big problems getting it installed again.
Can anyone help me how to reinstall mysql again ?
Because i lost my password i thougt the solution was to reinstall - it's not a good solution - please help me.
Is there som automated scripts that can do the job ?

Allan - from Denmark

Title: MySql installation problems
Post by: pfloor on May 22, 2006, 04:31:50 AM

"Because i lost my password i thougt the solution was to reinstall "

There is no "user known" password for mysql.  It is 41 characters long and is set and stored by the system and should NEVER be changed.  You don't need to know it to log into mysql from the command line.

If you are running rc2 you can use the following commands to reset the mysql password back to it's original state.

# cd /var/service/mysqld
# runsvctrl d .
# expand-template /root/.my.cnf
# expand-template /var/service/mysqld/set.password
# /usr/libexec/mysqld --bootstrap --user=mysql --skip-grant-tables < ./set.password
# runsvctrl u .

After you have fixed the password...DON'T EVER CHANGE IT AGAIN.

Title: Re: MySql installation problems
Post by: CharlieBrady on May 22, 2006, 04:37:42 AM

Quote from: "Pinoc"

As an old windows user i tried to uninstall mysql on my sme 7 and now i have some big problems getting it installed again.

How did you uninstall it? We really need to know that to know how much needs to be done to reinstall it.

Title: MySql installation problems
Post by: Pinoc on May 23, 2006, 02:25:59 PM

I waas using the rpm -e packagename

For erasing - I guess a new complete install would be the solution.



Allan

Title: MySql installation problems
Post by: CharlieBrady on May 23, 2006, 04:03:39 PM

Quote from: "Pinoc"

I waas using the rpm -e packagename

Please do not obfuscate your reporting. I'm guessing you mean that you did:

rpm -e mysql

If so, I would expect you would see something like:

[root@test7 ~]# rpm -e mysql
error: Failed dependencies:
        libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.i386
        libmysqlclient.so.14 is needed by (installed) dovecot-0.99.14-1.2.el4.rf.i386
        libmysqlclient.so.14 is needed by (installed) mysql-server-4.1.12-3.RHEL4.1.i386
        libmysqlclient.so.14 is needed by (installed) php-mysql-4.3.9-3.12.i386
        libmysqlclient_r.so.14 is needed by (installed) mysql-server-4.1.12-3.RHEL4.1.i386
        mysql = 4.1.12-3.RHEL4.1 is needed by (installed) mysql-server-4.1.12-3.RHEL4.1.i386
        mysql >= 3.23 is needed by (installed) turba-h3-2.0.4-02sme01.noarch
        mysql is needed by (installed) rt-3.4.5-1.noarch
        mysql is needed by (installed) e-smith-horde-1.12.0-02.noarch
        mysql is needed by (installed) e-smith-mysql-1.12.0-05.noarch
[root@test7 ~]#

The package would not have been removed and there would be no damage to repair.

So I repeat my question - how did you (really) remove mysql?

Quote

For erasing - I guess a new complete install would be the solution.

That would be one solution, but certainly not the only one.

Title: MySql installation problems
Post by: Pinoc on May 23, 2006, 09:06:14 PM

Well i'not sure anymore - i did so many different things and i have no experience of Linux.
Another group told me to type this : rpm -qa | grep mysql
which gives this result :
php-mysql-4.3.9-3.12
mysql-4.1.12-3.RHEL4.1

I sure messed it up - need to reinstall complete SME ?


Allan

Title: MySql installation problems
Post by: Pinoc on May 23, 2006, 09:13:06 PM

rpm -e perl-DBD-MySQL mysql-3.23.52-3

Maybe - not sure - sorry


Allan