This is on Windows Server 2019 on a machine I purchased to run a development environment and a bit of monitoring.
New setup using Xampp 7.4
PHP 7.4.13
MySQL MariaDB 10.4.17
Apache 2.4.6
Every attempt it creates a table called oc_migrations and nothing more, despite being a local mysql databas on port 3306 and root access with FULL privileges.
From what I gather searchin on that SQLSTATE code it seems to be generated by a typo or a mismatch or something I donât know how it appeared. Since it creates that table it does communicate with the database server, but fails after that one table creation. I have downloaded your full v 20 package and copied the files to xamppâs htdocs folder to run the site from there.
Have you tried deleting entire Database and start again?
Check the permissions in the creation of database:
CREATE DATABASE nextcloudDB CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE USER 'nextcloud1'@'localhost' IDENTIFIED BY 'password1';
GRANT ALL PRIVILEGES ON nextcloudDB.* TO 'nextcloud1'@'localhost';
FLUSH PRIVILEGES;
exit;
I deleted the database and started over three times in a rowâŚ
Thanks, that did not help, despite creating the database . It still only creates the oc_migrations tableâŚ
An exception occurred while executing âSELECT uid, displayname FROM oc_users WHERE uid_lower = ?â with params [ânextcloudâ]: SQLSTATE[42S02]: Base table or view not found: 1146 Table ânextclouddb.oc_usersâ doesnât exist
I could try creating and populating the database manually and then skip the setup⌠its a thing I have done many times when moving sites, albeit not with Nextcloud. What file has the DB entries�
Again, running Xampp LAMP on Windows Server with Apache and PHP working fine for other things.
NOT using IIS. Not even installed, dual Xeon 12 cores and 144GB DDR3 RAM.
Yes I have read that, I assumed it was referring to using Windos Server IIS as Server. Nothing else.
It is not running on IIS, it is running on xampp with apache/mariadb/php74.
Are you seriously telling me you canât run Nextcloud on a Windows server even if you use the same LAMP or LEMP configuration you would use on Linux or in a VM/Docker/K8 ?
Not interested in doing it that way since it adds an additonal hurdle in regards to system file access in Windows. Linix is crappy, been at it, there are like 25 different ways to do things, there are hardly any standards and I am fed yup with trying 5 different distros that all have a sligthly different approach in how to achive a wanted result. yum, zypper, dnf, bash CRAP
I share the frustration as the original poster of this issue. Iâm trying to get XAMPP/PHP/MySQL working on Windows 10 as well, but running into the same issue. Saying âwindows isnât supportedâ is garbage as Iâm afraid to say the vast majority of OS market share is still Windows users. I unfortunately made the switch to OwnCloud because of this issue.
A better way to approach this issue would be to figure out why oc_users isnât being created as part of the database creation process, but oc_migrations is. When I look at the nextcloud.log file, I see an error message that says something to the effect of
âHost localhost was not connected because it violates local access rulesâ, which is odd as the user I created has full privileges, but I assume this same thing happens if using the default root user as well.
My advice to the developers, download the 3 latest stable versions of NextCloud, the 3 latest versions of PHP, and the 3 latest versions of XAMPP onto a Windows 10 machine, and try to set up a server using XAMPPâs PHP and MySQL data. A tip, drag and drop the 3 NextCloud folders into the xampp/htdocs folder and call them nextcloud1, nextcloud2, nextcloud3 to make them easier to navigate to. This shouldnât be too hard to diagnose for the developers who know where to look at the logs, etc. But if at the end of the day it just plain old doesnât work cuz windows, switch to OwnCloud.
That may be true for the desktop market. On the server market it looks quite different. Depending on which statistics you look at, the market share of Windows on servers is well below 50%. And for web services that run on a LAMP or LEMP stack, itâs probably way less.
OwnCloud doesnât officially support Windows either.
Itâs from 2015 but I couldnât find anything on the website that says this has changed in the meantime. The official solution to run it on Windows at that time was to use a VirtualBox VM with Linux. Today you could also use WSL2, which is basically a Linux VM too.
Worked for me, so Iâm happy, basically doing the exact same setup routine, so somethingâs not working on the NextCloud side. Hope Windows sees some support soon as Iâve seen quite a few posts re: this issue.
Yeah but if it isnât officialy supported it can also break at any time. I hope you are using this set-up only for personal use and not in production for a company or even worse, offer it as a solution to small businesses who donât know they are paying you for an unsupported solution.