GF
Asked
Good morning, I'm installing simple forum v2 and when entering the "settings" parameters it gives me this error (DB Error: SQLSTATE[HY000] [2002] No such file or directory).
My database host is localhost while the socket I don't understand what parameters I need to enter. The error comes out when I insert localhost in the socket, if I leave it blank I get this error (DB Error: SQLSTATE[HY000] [1045] Access denied for user 'username'@'localhost' (using password: YES)).
Can you help me understand what to write in socket, where to find this parameter. Thank you
My database host is localhost while the socket I don't understand what parameters I need to enter. The error comes out when I insert localhost in the socket, if I leave it blank I get this error (DB Error: SQLSTATE[HY000] [1045] Access denied for user 'username'@'localhost' (using password: YES)).
Can you help me understand what to write in socket, where to find this parameter. Thank you
- MSAnsweredHello,
You can leave the socket field empty, that's an optional input.
Please make sure that the db user must have all privileges on the database.
Thank you - GFAnsweredLeaving the socket field empty gives me this error: DB Error: SQLSTATE[HY000] [1045] Access denied for user 'username'@'localhost' (using password: YES)
- GFAnsweredNow it gives me this error. This is just a part: SQL: unable to create tables, SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json DEFAULT NULL, `batch_uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4' at line 10 (Connection: mysql, SQL: /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `activity_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `activity_log` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `log_name` varchar(255) CHARACTER SET utf8mb4 COLLATE
- GFAnsweredthis is my database configuration:
Server Database
Server: Localhost via UNIX socket
Tipo di server: MariaDB
Connessione Server: SSL inattivo Documentazione
Versione del server: 5.5.68-MariaDB - MariaDB Server
Versione protocollo: 10
Utente: username@localhost
Codifica caratteri del server: cp1252 West European (latin1)
Web server
nginx/1.24.0
Version client database: libmysql - mysqlnd 8.2.9
Estensione PHP: mysqli Document curl Document mbstring Document
Versione PHP: 8.2.9 - GFAnsweredanother error: validation.required (and 3 more errors)
- GFAnsweredI haven't even installed one, I'm stuck in the installation phase of version 2.
Regular license violation! you have used the provided license for 50+ installations. You are allowed to have single active installation per license. Something wrong? please email to [email protected] - GFAnsweredIf you want to install it yourself, let me know, thanks.
- MSAnsweredHello,
You don't have to keep installing if there is any issue. Please reach us with details so that we can suggest.
Please make sure that your server meets the requirements before installation. Beta required php8.1 and MySQL57.10+ (version supports json).
The first database error is due to permissions and second is due to the non-supported database version. It's doesn't support json.
I have reset your license, please avoid this again.
Thank you - GFAnsweredI have Maria db v5.5.68
Php v8.1.24
Can you let me know if it's ok?
If this doesn't work, is the simple forum 1 version ok? - MSAnsweredHello,
As I know the json support was added to MariaDB v10.2 so you will need a more recent version.
Thank you - Login to Reply