DrSiva2022

Pls someone help...

ok i moved all .err and ib_xyz files to a folder and restarted mariadb. Now its not logging that much error . but logs like this Brought to you by linuxserver.io ─────────────────────────────────────── To support LSIO projects visit: https://www.linuxserver.io/donate/ ─────────────────────────────────────── GID/UID ─────────────────────────────────────── User UID: 99 User GID: 100 ─────────────────────────────────────── [custom-init] No custom files found, skipping... UMASK corrected from 022 to 0640 ... 230810 15:19:07 mysqld_safe Logging to '/config/databases/1ea560a3a27c.err'. 230810 15:19:07 mysqld_safe Starting mariadbd daemon with databases from /config/databases [ls.io-init] done. when you go into 1ea...... .err file . this is what is inside 230810 15:19:07 mysqld_safe Starting mariadbd daemon with databases from /config/databases 2023-08-10 15:19:07 0 [Note] Starting MariaDB 10.6.13-MariaDB-log source revision a24f2bb50ba4a!!!!!!!!d584937f36 as process 363 2023-08-10 15:19:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2023-08-10 15:19:07 0 [Note] InnoDB: Number of pools: 1 2023-08-10 15:19:07 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2023-08-10 15:19:07 0 [Note] mariadbd: O_TMPFILE is not supported on /var/tmp (disabling future attempts) 2023-08-10 15:19:07 0 [Note] InnoDB: Using Linux native AIO 2023-08-10 15:19:07 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2023-08-10 15:19:07 0 [Note] InnoDB: Completed initialization of buffer pool 2023-08-10 15:19:07 0 [Note] InnoDB: 128 rollback segments are active. 2023-08-10 15:19:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2023-08-10 15:19:07 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2023-08-10 15:19:07 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2023-08-10 15:19:07 0 [Note] InnoDB: 10.6.13 started; log sequence number 33112; transaction id 4 2023-08-10 15:19:07 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-08-10 15:19:07 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool 2023-08-10 15:19:07 0 [Note] InnoDB: Buffer pool(s) load completed at 230810 15:19:07 2023-08-10 15:19:07 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine 2023-08-10 15:19:07 0 [Note] Server socket created on IP: '0.0.0.0'. 2023-08-10 15:19:07 0 [Note] Server socket created on IP: '::'. 2023-08-10 15:19:07 0 [ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type varchar(, found type char(141). 2023-08-10 15:19:07 0 [ERROR] mariadbd: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2023-08-10 15:19:07 2 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine 2023-08-10 15:19:07 0 [Note] /usr/bin/mariadbd: ready for connections. Version: '10.6.13-MariaDB-log' socket: '/run/mysqld/mysqld.sock' port: 3306 MariaDB Server 2023-08-10 15:19:08 4 [Warning] Aborted connection 4 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication) 2023-08-10 15:19:08 5 [Warning] Access denied for user 'root'@'localhost' (using password: YES)

tried and this is the result : root@a5ca99f8f429:/# mysql -uroot -p Enter password: ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2) root@a5ca99f8f429:/#

I stopped all services , restarted mariadb , even went to older version as mentioned , still its outputting this ins log. Caught SIGTERM signal! cat: /var/run/mysqld/mysqld.pid: No such file or directory UMASK must be a 3-digit mode with an additional leading 0 to indicate octal. The first digit will be corrected to 6, the others may be 0, 2, 4, or 6. UMASK corrected from 022 to 0640 ... 230809 22:46:55 mysqld_safe Logging to '/config/databases/f4e153d31abe.err'. 230809 22:46:55 mysqld_safe Starting mariadbd daemon with databases from /config/databases last time it was nextcloud update which screwed and it was down for long time since i didnt time to fix , now mariadb. Why is even simple updates are causing such a huge headache ?

sorry for late reply. I was little disappointed the way it went down. Its also a wake up call for me who thought this would be a robust solution. My mistakes were few .. adding wrong repository address (in one way the "https://" inclusion should have not taken down the entire app) , and second was not taking app data backup regularly. TBH , ididnt know it existed. I have made the nextcloud share as "Export: YES" and have moved the files to another location on unraid itself. In my case there is no CONTAINER AT ALL to STOP , its all gone , no listing of that app. So have to do a fresh reinstall of nextcloud. Let me update how it goes.Will setup everything and upload one or two pics from phone and then try to put back the folder which i moved back to nextcloud and hope the app recognizes and adds it to its database or whatever. Developers , kindly let me know if you want anything (log files etc) before i do a reinstall. Should be a casestudy how one wrong url could totally remove the app from listing and become unrecoverable.

I can able to see the files which it uploaded , luckily they were encrypted i think. Shall i backthem up and do a fresh install ? Also how to prevent this from happening in future ?

Kindly look here , version and config files are empty. How can i proceed as per your link ?

Thanks for the reply. I have nextcloud down for more than a week now Attaching the screenshots and also version.php and config.php files. couldnt upload .php files here , so here is the files https://file.io/okWxkorivszf they are empty.

I cant even find the app in the docker list. Even version.php or config.php , all are empty. What should i do ?

UPDATE TO THIS POST : Under previous app its showing as plugin. someone pls help.

I was running it fine for past few weeks. I went to nextcloud few days back and it showed PHP incompatibilty error , then went inside unraid and read on forum to update to different repository , i typed wrong , and it did something , and now its not showing in apps list and in previous apps page , it has only "remove option" screenshot here :

PLs help , the nextcloud is not even listing in app section

can someone help me wrong repository address and now nextcloud has vanished from app list and even on previous app list there is only option to remove it. Kindly help me recover nextcloud updated

help pls

IT shows like this

Wonderful. Will try to implement them. Currently i am using nextcloud for backing up my camera folder from phone. Currently yhe automated process is pretty nice. At the same time , i wish there was option to clear the camera folder on phone in specific time , in automatic way. Will try to use syncthing to integrate unraid and phones etc.

Today when i opened , NExtcloud was showing error regarding PHP version incompatibility. I then searched and found to do this i did a mistake by copying the link instead of the text so instead of lscr.io/linuxserver/nextcloud:26.0.2-ls246 122 I pasted : http://lscr.io/linuxserver/nextcloud:26.0.2-ls246 Now i cant find nextcloud in apps Someone help me./ When i try to install , i get this error : One or more ports used by this application are already in use by another service or app running on your server. You will need to adjust the host ports accordingly on the template

Source of Media : 1. My phone 2. My sony a6400 Camera 3. Mom Phone 4. My wife phone 5. Online downloads for personal and for office works. Storage : 1. Individuals phones 2. Me and my mom have Google one Subscriptions 3. NAS( UNRAID ) 4. PC The problem : 1. Our phones are getting full rapidly 2. I need one place to pour all contents and manage into (possibly into Unraid) 3. sync on other cloud service (blackblaze ? or other similar ? AWS ?) as final backup 4. Managing , sorting and syncing first and foremost , what should i do to first sync all these files to local NAS ? All have android I want individual person to have their own space on UNRAID , but they could share a part to common pool , say for example the camera uploads . Whatsapp and other media can remain in thier own personal space on unraid. How to sort and manage these medias ? If i am going to automate , what should be the folder structure ? I work with lightroom / PS etc , but still struggling to use LR to manage my photos.. when i start syncing all photos onto Unraid , how can i used LR with unraid ? Should i allow LR to manage the media or some docker app on unraid to manage ? How to sync all uploaded files to other cloud service for storage alone. I want the common folders to be either visible on all devices or even sync with all devices( for eg official document PDF`s like PAN , driving license etc..) I think you guys can get the picture here , rather than me going into further details.

I am planning to shuck my current ext hdd and install them into my unriad server. I dont want to copy the contents from these hdd onto another and add these hdd to unraid. is it possible to add the hdd with contents onto unraid ? Next question is how do i mount the entire hdd to shows as drives on windows vm ?

any help ?

I was interested in having a NAS when i cam across synology. It was nice and simple. Like many other tech enthusiast , i wanted to build my own. So far , i have (mostly used products) 1. Motherboard - B450M PRO-VDH PLUS 2. PSU - 650W Cossair 3. RAM - 16GB GSKILL 3000mhz cl16 4. CASE - Fractal NODE 804 My Need : 1. File storage and personal files backup. I am planning to have 4TB of my storage for my personal files backup with appropriate RAID setup Add in more HDD for media and other files . 2. Ability to run Pi-hole , Home assistant , VM`s , possible Plex Server for my Himedia Q5 Pro( or Nvidia Shield in future). 3. Have Some TB`s of Old and New Music Files in FLAC format. So want them to be served at will to all my family members and move away from spotify or be as a second option. (how to do it on android ? any specific app ?) 4. Remotely backup my business database and files to this NAS at regular intervals as secondary backup. 5. Stream movies / Tv shows which i have in my HDD to all my family members , either in same network or when away from home. 6. Run Linux distros for me to learn linux. Now , which CPU should i go for ? I have limited budget only.. about 150-200$. Should i get a dedicated AMD CPU and get a cheaper GPU or Go for G series AMD CPU`s ?