ZM DB question [SOLVED]
Posted: Sun May 28, 2023 2:56 pm
I had installed ZM 1.36X before my pc crashed without any problem, after re-installed new OS (MX Linux, Debian 11 based Linux), got an error when trying to re-start mysql service (service unrecognized error), here are my questions about DB in ZM:
1) why ZM has 2 DB > MySQL & MariaDB?
2) did not notice any error during zm-install, after install, when trying to start ZM, got an error saying that could not connect to zm DB through user zmuser, checked the users & DB, neither was present. (I seem to rememeber that in my previous install the DB prompt showed mysql, but this time it showed MariaDB, does this mean that both zm and zmuser should be installed in MySQL and not in MariaDB? If this is true, why use 2 DB instead of 1?
3) can I install MySQL first, then LAMP, then zm-install, is there any instructions to check the installation step by step?
4) can I use only MariaDB? I've added zm and zmuser to MariaDB, what else should I change to make ZM use MariaDB instead of MySQL?
ps: I seemed to see that the new install, a message saying that DB uses unix socket, but during zm-install I asked NOT to use unix socket, is this a bug in the install script?
1) why ZM has 2 DB > MySQL & MariaDB?
2) did not notice any error during zm-install, after install, when trying to start ZM, got an error saying that could not connect to zm DB through user zmuser, checked the users & DB, neither was present. (I seem to rememeber that in my previous install the DB prompt showed mysql, but this time it showed MariaDB, does this mean that both zm and zmuser should be installed in MySQL and not in MariaDB? If this is true, why use 2 DB instead of 1?
3) can I install MySQL first, then LAMP, then zm-install, is there any instructions to check the installation step by step?
4) can I use only MariaDB? I've added zm and zmuser to MariaDB, what else should I change to make ZM use MariaDB instead of MySQL?
ps: I seemed to see that the new install, a message saying that DB uses unix socket, but during zm-install I asked NOT to use unix socket, is this a bug in the install script?