Koozali.org: home of the SME Server

Obsolete Releases => SME Server 9.x => Topic started by: ElFroggio on October 22, 2014, 05:46:38 PM

Title: Crashed and now problem with the websites
Post by: ElFroggio on October 22, 2014, 05:46:38 PM

Hi,

I had drive problem, so I decided to redo a full install from SME9 to SME9. I did a backup from the console > admin > backup from the menu.

Did the full install, did the restore when prompted.

The websites in the ibays do not work. The ibays are there. I use drupal and drupal complained that that there is no connection to the MySQL database.

Now I can't access mysql. When I try to access mysql interactively use the username/password

I get:

Code: [Select]

ERROR 1045 (28000): Access denied for user 'usrfoto'@'localhost' (using password: YES)
I have tried all the other users and root and I get the same message.

Any suggestion on what to do?

Thanks

Title: Re: Crashed and now problem with the websites
Post by: Stefano on October 22, 2014, 06:40:00 PM

is mysql running?

Code: [Select]

service mysqld status
ps aux | grep mysqld


Title: Re: Crashed and now problem with the websites
Post by: ElFroggio on October 22, 2014, 07:16:38 PM

Quote from: Stefano on October 22, 2014, 06:40:00 PM

is mysql running?

Code: [Select]

service mysqld status
ps aux | grep mysqld


Code: [Select]

[root@ethelbert html]# service mysqld status
mysqld (pid  2572) is running...
[root@ethelbert html]# ps aux | grep mysqld
root      1231  0.0  0.0    112    28 ?        Ss   08:13   0:00 runsv mysqld
smelog    1289  0.0  0.0   3944   392 ?        S    08:13   0:00 /usr/local/bin/multilog t s5000000 /var/log/mysqld
mysql     2572  0.0  0.2 341412 12068 ?        Sl   08:14   0:05 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid
root     21023  0.0  0.0 103256   860 pts/0    S+   10:13   0:00 grep mysqld

Actually, I'm a little bit further ahead. Something didn't go properly with either the SME server backup (from the console menu) or the SME server restore during the install. It did not re-create the mysql users, only the default sme users were recreated.

/Syv

Title: Re: Crashed and now problem with the websites
Post by: Stefano on October 22, 2014, 09:34:33 PM

Quote from: ElFroggio on October 22, 2014, 07:16:38 PM

Something didn't go properly with either the SME server backup (from the console menu) or the SME server restore during the install. It did not re-create the mysql users, only the default sme users were recreated.

/Syv

this should not happen and, in any case, investigated via a bug in bugzilla

Title: Re: Crashed and now problem with the websites
Post by: zatnikatel on October 23, 2014, 03:14:32 AM

should you not login as root or admin as the user he mite be loggi in with is not added to mysql

Title: Re: Crashed and now problem with the websites
Post by: CharlieBrady on October 23, 2014, 04:08:20 PM

Quote from: Stefano on October 22, 2014, 06:40:00 PM

is mysql running?

That's not the issue. Error message is 'accessed denied' so that is a password issue.

Title: Re: Crashed and now problem with the websites
Post by: janet on October 24, 2014, 12:40:38 AM

ElFroggio

Firstly please lodge a bug report & while waiting for a response please do not make further changes to your system.
Backup & Restore should work correctly.

Secondly you might consider repeating the Restore operation to see if you get the same result, or maybe you did not wait for the restore to fully complete. Please do this on a different system or hard drive, so the evidence of the original attempt is stil available to bugs triage workers.

Title: Re: Crashed and now problem with the websites
Post by: Stefano on October 24, 2014, 10:16:32 AM

Quote from: CharlieBrady on October 23, 2014, 04:08:20 PM

That's not the issue. Error message is 'accessed denied' so that is a password issue.

touchè :-)