I installed a standalone server and tried to install an APS package so I can compare the logs from my multiserver setup. From multi server environment it doesn't create DB user and DB. So I tried to run the query(SELECT default_dbserver FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = '3' LIMIT 0,1) from the logs below and see if it will return the default_dbserver. It returned "0" not the server id of DB Server. --LOGS FROM MULTISERVER ENVIRONMENT---------------------------------------------------------------------------------------- SELECT config FROM server WHERE server_id = 1 LIMIT 0,1 2019-10-05T19:41:18.674142+08:00 23758 Query SELECT * FROM aps_packages WHERE id = '541' LIMIT 0,1 2019-10-05T19:41:18.675916+08:00 23758 Query SELECT sys_groupid FROM web_domain WHERE domain_id = '18' LIMIT 0,1 2019-10-05T19:41:18.676496+08:00 23758 Query SELECT client_id FROM sys_group WHERE groupid = '3' LIMIT 0,1 2019-10-05T19:41:18.677025+08:00 23758 Query SELECT sys_groupid FROM web_domain WHERE domain_id = '18' LIMIT 0,1 2019-10-05T19:41:18.677312+08:00 23758 Query SELECT client_id FROM sys_group WHERE groupid = '3' LIMIT 0,1 2019-10-05T19:41:18.677580+08:00 23758 Query SELECT server_id,server_name,db_server FROM server WHERE server_id = '1' LIMIT 0,1 2019-10-05T19:41:18.677860+08:00 23758 Query SELECT default_dbserver FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = '3' LIMIT 0,1 2019-10-05T19:41:18.678344+08:00 23758 Query SELECT COUNT( * ) AS cnt, sys_datalog.action, sys_datalog.dbtable FROM sys_datalog, server WHERE server.server_id = sys_datalog.server_id AND sys_datalog.user = 'admin' AND sys_datalog.datalog_id > server.updated GROUP BY sys_datalog.dbtable, sys_datalog.action 2019-10-05T19:41:18.681749+08:00 23758 Query SELECT client.limit_client FROM sys_user, client WHERE sys_user.userid = 1 AND sys_user.client_id = client.client_id LIMIT 0,1 --LOGS FROM STANDALONE SERVER ENVIRONMENT---------------------------------------------------------------------------------------- 2019-10-05T11:24:50.549470Z 226 Query SELECT * FROM aps_packages WHERE id = '19' LIMIT 0,1 2019-10-05T11:24:50.550931Z 226 Query SELECT sys_groupid FROM web_domain WHERE domain_id = '2' LIMIT 0,1 2019-10-05T11:24:50.551332Z 226 Query SELECT client_id FROM sys_group WHERE groupid = '0' LIMIT 0,1 2019-10-05T11:24:50.551567Z 226 Query SELECT sys_groupid FROM web_domain WHERE domain_id = '2' LIMIT 0,1 2019-10-05T11:24:50.551782Z 226 Query SELECT client_id FROM sys_group WHERE groupid = '0' LIMIT 0,1 2019-10-05T11:24:50.551987Z 226 Query SELECT server_id,server_name,db_server FROM server WHERE server_id = '1' LIMIT 0,1 2019-10-05T11:24:50.552258Z 226 Query SELECT php_fpm_chroot FROM web_domain WHERE domain_id = '2' LIMIT 0,1 2019-10-05T11:24:50.552565Z 226 Query SELECT count(database_id) as number FROM web_database WHERE database_name = 'c0aps1' LIMIT 0,1 2019-10-05T11:24:50.552943Z 226 Query SELECT count(database_id) as number FROM web_database WHERE database_name = 'c0aps2' LIMIT 0,1 2019-10-05T11:24:50.553241Z 226 Query SELECT count(database_user_id) as number FROM web_database_user WHERE database_user = 'c0aps1' LIMIT 0,1 2019-10-05T11:24:50.554531Z 226 Query SELECT count(database_user_id) as number FROM web_database_user WHERE database_user = 'c0aps2' LIMIT 0,1 2019-10-05T11:24:50.554842Z 226 Query SELECT database_user_id FROM web_database_user WHERE database_user = 'c0aps2' LIMIT 0,1 2019-10-05T11:24:50.555181Z 226 Query SELECT PASSWORD('9729700500076681') as `crypted` LIMIT 0,1 2019-10-05T11:24:50.555599Z 226 Query INSERT INTO `web_database_user` (`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`database_user`,`database_user_prefix`,`database_password`) VALUES ('1','0','riud','ru','',0,'c0aps2','c0','*56341332019E4389A246434C57BE07C74A1DA530')
