Error During Installation

0

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

Question Resolved For: Simple Forum - Responsive Bulletin Board 0 Votes 14 Answers 860 Views
Asked by Gennaro F. 1 year ago

0

Answered by Mian Saleem

Thank you for updating

0

Answered by Mian Saleem 1 year ago

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

0

Answered by Gennaro F. 1 year ago

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

0

Answered by Gennaro F. 1 year ago

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

0

Answered by Gennaro F. 1 year ago

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

0

Answered by Gennaro F. 1 year ago

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

0

Answered by Gennaro F. 1 year ago

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]

0

Answered by Gennaro F. 1 year ago

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

0

Answered by Mian Saleem 1 year ago

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

0

Answered by Gennaro F. 1 year ago

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?

0

Answered by Mian Saleem 1 year ago

Hello,

As I know the json support was added to MariaDB v10.2 so you will need a more recent version.

Thank you

We use Cookies

We use cookies to ensure that we give you the best experience on our website. By continuing to browse the site you are agreeing to our use of cookies.