Ater installation Unable to connect to ZM db.SQLSTATE[HY000] [2002] No such file or directory

Forum for questions and support relating to the 1.30.x releases only.
Locked
strelalex
Posts: 5
Joined: Thu Feb 16, 2017 3:34 pm

Ater installation Unable to connect to ZM db.SQLSTATE[HY000] [2002] No such file or directory

Post by strelalex »

Hello! I followed all instruction precisely, and everything went ok. But after that I always get Unable to connect to ZM db.SQLSTATE[HY000] [2002] No such file or directory
And I don't know what to do with it. I changed the socket path, as it was said but nothing changed. mysql and apache2 are running, followed all instructions but mysterious mistake...
Could someone help me out with that?


I use VPS server with 3GB RAM / 4 cores / 40GB space.
strelalex
Posts: 5
Joined: Thu Feb 16, 2017 3:34 pm

Re: Ater installation Unable to connect to ZM db.SQLSTATE[HY000] [2002] No such file or directory

Post by strelalex »

This shows:

Code: Select all

 "success": false,
    "data": {
        "code": 500,
        "name": "Database connection "Mysql" is missing, or could not be created.",
        "message": "SQLSTATE[HY000] [2002] No such file or directory",
        "url": "\/zm\/api\/host\/getVersion.json",
        "exception": {
            "class": "MissingConnectionException",
            "code": 500,
            "message": "Database connection \"Mysql\" is missing, or could not be created.",
Database connection is missing, or coudn't be created. Will search for this now...
strelalex
Posts: 5
Joined: Thu Feb 16, 2017 3:34 pm

Re: Ater installation Unable to connect to ZM db.SQLSTATE[HY000] [2002] No such file or directory

Post by strelalex »

maybe here is more clear??

Code: Select all

2017-02-16T14:28:57.620541Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-02-16T14:28:57.755457Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-02-16T14:28:57.799265Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-02-16T14:28:57.858896Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 4089e8e2-f454-11$
2017-02-16T14:28:57.860441Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-02-16T14:28:57.860727Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2017-02-16T14:29:03.111518Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-02-16T14:29:03.111557Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2017-02-16T14:29:03.265532Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-02-16T14:29:03.266609Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.17-0ubuntu0.16.04.1) starting as process 22594 ...
2017-02-16T14:29:03.269937Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-02-16T14:29:03.269956Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-02-16T14:29:03.269959Z 0 [Note] InnoDB: Uses event mutexes
2017-02-16T14:29:03.269962Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-02-16T14:29:03.269965Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-02-16T14:29:03.269968Z 0 [Note] InnoDB: Using Linux native AIO
2017-02-16T14:29:03.270163Z 0 [Note] InnoDB: Number of pools: 1
2017-02-16T14:29:03.270254Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-02-16T14:29:03.271714Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-02-16T14:29:03.278632Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-02-16T14:29:03.280411Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-02-16T14:29:03.293097Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-02-16T14:29:03.300247Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-02-16T14:29:03.300301Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-02-16T14:29:03.313023Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-02-16T14:29:03.313649Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-02-16T14:29:03.313659Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-02-16T14:29:03.314469Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 2535002
2017-02-16T14:29:03.314701Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-02-16T14:29:03.314770Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-02-16T14:29:03.316023Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170216 16:29:03
2017-02-16T14:29:03.318847Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-02-16T14:29:03.318862Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2017-02-16T14:29:03.318869Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2017-02-16T14:29:03.318896Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2017-02-16T14:29:03.325443Z 0 [Note] Event Scheduler: Loaded 0 events
2017-02-16T14:29:03.325548Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--d$
2017-02-16T14:29:03.325558Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-02-16T14:29:03.334424Z 0 [Note] End of list of non-natively partitioned tables
2017-02-16T14:29:03.335237Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.17-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2017-02-16T14:29:04.113612Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-02-16T14:29:04.117676Z 4 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-02-16T14:32:06.277312Z 5 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-02-16T14:43:38.586782Z 0 [Note] Giving 0 client threads a chance to die gracefully
strelalex
Posts: 5
Joined: Thu Feb 16, 2017 3:34 pm

Re: Ater installation Unable to connect to ZM db.SQLSTATE[HY000] [2002] No such file or directory

Post by strelalex »

on Debian I made it to work


Trying now on Ubuntu
Locked