restore operation failing, virtualmin-dav: Permission denied, please help

5 posts / 0 new
Topic locked
Last post
#1 Sat, 05/22/2010 - 08:05
rogeriobrito

restore operation failing, virtualmin-dav: Permission denied, please help

Hello all,

Last night I had a HD crash, and I lost all the data for about 50 domains.

I'd setup a daily full backup, to another CentOS 5.4 Virtualmin box. So on the other Virtualmin box I have all the gz files for each domain.

When I try to restore those files, some domains work, but most of them I get two errors:

...

Creating MySQL database joomla_97fmfrutalmaster .. .. MySQL database failed! : SQL desc db failed : Can't create/write to file '/tmp/#sql_32e8_0.MYI' (Errcode: 13) at ../web-lib-funcs.pl line 1332.

...

Restoring DAV users file .. .. copy failed : cp: cannot stat `/tmp/.webmin/658356_2_restore.cgi/acerte.org.br_virtualmin-dav': Permission denied

Re-starting DNS server .. .. done Applying web server configuration .. .. done

.. failed! See the progress output above for the reason why.

What can I do? Please help! I'm desperate. Thanks

Sat, 05/22/2010 - 08:25
andreychek

Howdy,

There's some thoughts on the particular error you're getting here:

http://dev.mysql.com/doc/refman/5.0/en/cannot-create.html

Does any of the information on there help with the problem you're seeing?

-Eric

Sat, 05/22/2010 - 20:09 (Reply to #2)
rogeriobrito

Thank's Eric,

I don't know how that happened, but the problem was that after I restored the first domain, my /tmp folter became his.

drwx------ 13 user user 4096 May 22 21:57 tmp

So I chowned it to

drwxrwxrwx 13 root root 4096 May 22 21:57 tmp

After that I could restore 80 virtual servers, only 2 with the following problem:

Restoring Mailman mailing lists .. .. no lists found in backup

Re-creating mail and FTP users .. Restore failed : SQL insert into user (host, user, password) values ('%', 'hotelrecantodosi', '11bfe8e320b20aba') failed : Duplicate entry '%-hotelrecantodosi' for key 1

Any idea what that may be?

Thank you Rogerio

Sat, 05/22/2010 - 22:31
andreychek

Ahh, nice catch with the /tmp permissions.

Well, the first message you shared suggests that it's not seeing any Mailman lists... did you have any setup?

The second message looks like it's having trouble re-importing a database entry... but it appears to be saying it already exists. Do things by chance work for you?

-Eric

Sun, 05/23/2010 - 11:14 (Reply to #4)
rogeriobrito

Yes, there wasn't any Mailman lists.

But to be able to restore those two virtual servers, I had to do it in two steps:

  • First a normal full restore, it fails with the above SQL error, and mail users are not restored (but MySQL database IS restored correctly)
  • Then a restore using "Only create servers with selected features", I selected everything but "Contents of server's MySQL databases".

It was restored successfully then.

Thank you

Rogerio

Topic locked