Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: daley on March 29, 2007, 03:20:03 PM

Title: Help!!! - smerver 7.1.3 - Restore lost root access to mysql
Post by: daley on March 29, 2007, 03:20:03 PM

I have sudddenly lost root access to mysql on SMEServer 7.1.3 installation. Sad Logging on as root, thus:

[root@ns1 ~]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@ns1 ~]#

I don't know what I could have done to cause this, appreciate your help.

Thanks in anticipation.

Regards,
Daley

Title: Re: Help!!! - smerver 7.1.3 - Restore lost root access to my
Post by: cactus on March 29, 2007, 03:34:33 PM

Quote from: "daley"

I have sudddenly lost root access to mysql on SMEServer 7.1.3 installation. Sad Logging on as root, thus:

[root@ns1 ~]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@ns1 ~]#

I don't know what I could have done to cause this, appreciate your help.

Thanks in anticipation.

Regards,
Daley

It seems that you somehow have been tempering with the MySQL root password. You should never do this. See the wiki for resetting the MySQL root password (http://wiki.contribs.org/MySQL#Resetting_the_MySQL_root_password) and more information.

Title: Help!!! - smerver 7.1.3 - Restore lost root access to mysql
Post by: daley on March 29, 2007, 03:46:01 PM

Quote

 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 .

Thanks for help, i have restored the password....

i was wanted to use the phpmyadmin to set password for one of the database name "roundcule", if i using the contrib file without the database password, how can i do it?

example....

[root@ns1 ]# config show roundcube
roundcube=service
    DbPassword=
    Name=RoundCube IMAP Client
    PublicAccess=global-pw-remote
[root@ns1 ]#

Thanks so much,

Regards,
Daley

Title: Help!!! - smerver 7.1.3 - Restore lost root access to mysql
Post by: bpivk on March 29, 2007, 03:52:29 PM

Folow the install procedure as described on www.dungog.net

Title: Help!!! - smerver 7.1.3 - Restore lost root access to mysql
Post by: daley on March 29, 2007, 04:15:36 PM

Quote

# pico -w db.inc.php

# add password and shorten roundcubemail to roundcube
# note if your password has an @ you may have problems ?
$rcmail_config['db_dsnw'] = 'mysql://roundcube:hpxQLICHl-SNIP-vfpc034S@localhost/roundcube';

DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.

Where do i go wrong for the setup?, i can't find the mysql password with 'config show roundcube',

[root@ns1 ]# config show roundcube
roundcube=service
    DbPassword=
    Name=RoundCube IMAP Client
    PublicAccess=global-pw-remote
[root@ns1 ]#

Regards,
Daley[/b]

Title: Help!!! - smerver 7.1.3 - Restore lost root access to mysql
Post by: bpivk on March 29, 2007, 04:17:55 PM

Did you folow the procedure as described on dungog?
You have to install 2 (two) contribs.

Title: Help!!! - smerver 7.1.3 - Restore lost root access to mysql
Post by: daley on March 29, 2007, 04:38:07 PM

Yes, both files, i got it fixed, this contrib does not required password for the configuration file.

Thanks for help.
Daley