Topic: Crashed and now problem with the websites

[ElFroggio]

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

[Stefano]

is mysql running?

Code: [Select]

service mysqld status
ps aux | grep mysqld


[ElFroggio]

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

[Stefano]

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

[zatnikatel]

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

[CharlieBrady]

is mysql running?

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

[janet]

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.

[Stefano]

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

touchè