Question: Error During Installation

Error During Installation

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 hos

GF

Gennaro F.

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

  • MS

    Mian Saleem

    Answered

    Hello,

    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

  • GF

    Gennaro F.

    Answered

    Leaving the socket field empty gives me this error: DB Error: SQLSTATE[HY000] [1045] Access denied for user ‘username’@‘localhost’ (using password: YES)

  • GF

    Gennaro F.

    Answered

    Now 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

  • GF

    Gennaro F.

    Answered

    this 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

  • GF

    Gennaro F.

    Answered

    another error: validation.required (and 3 more errors)

  • GF

    Gennaro F.

    Answered

    I 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]

  • GF

    Gennaro F.

    Answered

    If you want to install it yourself, let me know, thanks.

  • MS

    Mian Saleem

    Answered

    Hello,

    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

  • GF

    Gennaro F.

    Answered

    I 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?

  • MS

    Mian Saleem

    Answered

    Hello,

    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