1 Topic by heeter (edited by heeter 2025-11-23 08:43:52)

  • heeter
  • Member
  • Offline
  • Registered: 2016-11-22
  • Posts: 84

Topic: error in upgrade mariadb

Hi I am in the process of following the upgrade from 1.7.2 to 1.7.3, and I have reached the mysql update.

getting this error:

root@mail:/tmp# wget -O /tmp/vmail.mysql https://github.com/iredmail/iRedMail/raw/1.7.3/update/1.7.3/vmail.mysql

root@mail:/tmp# mysql vmail < /tmp/vmail.mysql
--------------
call irm173_schema_change()
--------------

ERROR 1 (HY000) at line 57: Can't create/write to file '/tmp/#sql-temptable-360-3ab-7d4.MAI' (Errcode: 13 "Permission denied")

root@mail:/tmp#

Don't know how to get around this

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,528

Re: error in upgrade mariadb

Is /tmp/ full? Or is it read-only?

3 Reply by heeter (edited by heeter 2025-11-25 00:45:34)

  • heeter
  • Member
  • Offline
  • Registered: 2016-11-22
  • Posts: 84

Re: error in upgrade mariadb

Hi ZhangHuangbin

/tmp is empty,

here is what my permissions looks like:

root@mail:/# ls -l
total 4005960
lrwxrwxrwx   1 root root          7 Feb 16  2024 bin -> usr/bin
drwxr-xr-x   4 root root       4096 Nov 11 06:34 boot
dr-xr-xr-x   2 root root       4096 Feb 16  2024 cdrom
drwxr-xr-x  20 root root       4080 Nov 22 17:39 dev
drwxr-xr-x 101 root root       4096 Nov 23 00:14 etc
drwxr-xr-x   7 root root       4096 May 22  2024 home
lrwxrwxrwx   1 root root          7 Feb 16  2024 lib -> usr/lib
lrwxrwxrwx   1 root root          9 Feb 16  2024 lib32 -> usr/lib32
lrwxrwxrwx   1 root root          9 Feb 16  2024 lib64 -> usr/lib64
lrwxrwxrwx   1 root root         10 Feb 16  2024 libx32 -> usr/libx32
drwx------   2 root root      16384 May 22  2024 lost+found
drwxr-xr-x   2 root root       4096 Feb 16  2024 media
drwxr-xr-x   2 root root       4096 Feb 16  2024 mnt
drwxr-xr-x  10 root root       4096 Nov 23 00:15 opt
dr-xr-xr-x 247 root root          0 Nov 22 17:39 proc
drwx------   9 root root       4096 Nov 23 00:38 root
drwxr-xr-x  30 root root        960 Nov 24 10:41 run
lrwxrwxrwx   1 root root          8 Feb 16  2024 sbin -> usr/sbin
drwxr-xr-x   2 root root       4096 May 22  2024 snap
drwxr-xr-x   2 root root       4096 Feb 16  2024 srv
-rw-------   1 root root 4102029312 May 22  2024 swap.img
dr-xr-xr-x  13 root root          0 Nov 22 17:39 sys
drwxr-xr-x   7 1001 1001       4096 Nov 24 16:36 tmp
drwxr-xr-x  14 root root       4096 Feb 16  2024 usr
drwxr-xr-x  15 root root       4096 May 22  2024 var
root@mail:/# ls -l /tmp
total 4
-rwxr-xr-x 1 root root 2589 Nov 23 00:35 vmail.mysql
root@mail:/#

I don't have any issues running the other IRMail updates through the /tmp folder, just this particular file.

Thank you

4 Reply by heeter

  • heeter
  • Member
  • Offline
  • Registered: 2016-11-22
  • Posts: 84

Re: error in upgrade mariadb

Lolol

I rebooted the irm server, now it installed,