Open ralphjsmit opened 3 years ago
remnesia
commented
3 years ago I have the same issue, for me it happened when my PC crashed while DBngin was still running. If i create a new DB it works instantly and also takes a little longer to load. For the other DB it shoots on green instantly and wont create the .sock files in my /tmp/ folder
marcorieser
commented
2 years ago I have the same issue, for me it happened when my PC crashed while DBngin was still running. If i create a new DB it works instantly and also takes a little longer to load. For the other DB it shoots on green instantly and wont create the .sock files in my /tmp/ folder
same
Ebeldev
commented
2 years ago I'm on a fresh install
Mac Intel on Monterey 12.4
I just install DBNGIN and TablePlus is not able to connect to db.
This is the error: 2022-06-17T11:19:13.091797Z 0 [System] [MY-010931] [Server] /Users/Shared/DBngin/mysql/8.0.27/bin/mysqld: ready for connections. Version: '8.0.27' socket: '/tmp/mysql_3306.sock' port: 3306 MySQL Community Server - GPL.
This seems to be a MAC problem. No database works with dbngin or just plain mariadb or mysql.
I tried a lot of solutions mentioned on differents resources. Nothing works. I really do not understand.
huyphams
commented
2 years ago Hi @Ebeldev if you right-click on the server, you will see a menu "Show database files" where you can find the error log: "mysqld.local.err" there will be the error details.
Ebeldev
commented
2 years ago 2022-06-17T03:05:39.536426Z 0 [System] [MY-010116] [Server] /Users/Shared/DBngin/mysql/8.0.27/bin/mysqld (mysqld 8.0.27) starting as process 24320
2022-06-17T03:05:39.538955Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /Users/mac-dw-eti/Library/Application Support/com.tinyapp.DBngin/Engines/mysql/C8EB2F85-7BC6-4E63-86AE-6E872BB1A9B6/ is case insensitive
2022-06-17T03:05:39.539864Z 0 [Warning] [MY-010122] [Server] One can only use the --user switch if running as root
2022-06-17T03:05:39.719758Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-06-17T03:05:39.801610Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-06-17T03:05:39.923446Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2022-06-17T03:05:39.923471Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2022-06-17T03:05:39.924220Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-06-17T03:05:39.924254Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-06-17T03:05:39.937441Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2022-06-17T03:05:39.937466Z 0 [System] [MY-010931] [Server] /Users/Shared/DBngin/mysql/8.0.27/bin/mysqld: ready for connections. Version: '8.0.27' socket: '/tmp/mysql_3306.sock' port: 3306 MySQL Community Server - GPL.
2022-06-17T03:55:42.998910Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user
huyphams
commented
2 years ago Did you use a custom config or something? I don't see any issue except this one
One can only use the --user switch if running as root
Ebeldev
commented
2 years ago I was able to create and connect with mysql 5.7.23. But with mysql version 8.0.19 and mysql 8.0.27, I can't connect.
Ebeldev
commented
2 years ago @huyphams No I do not have any custom config.
Ebeldev
commented
2 years ago I got it to work with mysql 8.0.27
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
Do not use Sequel Pro use instead Sequel Ace. Sequel pro does not connect with mysql 8.0. Sequel Ace
Finally after one full fresh Mac install, I spend like 3 days working on this issue.
ralphjsmit
commented
2 years ago @Ebeldev Congrats that you got it working! Did you have to completely reinstall your Mac?
Please fill out the detail below, it helps me investigate the bug:
Driver (Ex: PostgreSQL 10.0):
MySQL 8.0.19 and every other driver
DBngin build number: 3.4 (36)
macOS version: Big Sur 11.4 on M1
The steps to reproduce this issue: Starting today my DBngin application doesn't start the databases anymore. When I click 'Start' it almost instantly turns to green (before today that always took slightly longer). When I run commands like
it gives me zero response.
Do you have any idea how this could be caused? It is very frustrating, because there's also some important data in the databases that I don't want to lose. When I create a new database, it does work normally, till I shut down my Mac. After that, it displays the same behaviour.
I do have a backup though, can I perhaps put some DBngin backup back?How can I fix this and backup my data? Many thanks!
Update #1: my newly created test database does work now, but my older and existing databases are still giving no response.
Update #2: I found out that DBngin doesn't create the files mysqlx.sock.lock and mysql_3306.sock.lock. This is causing the problem, because without those files, you get
'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'.Console data As a reference, here are the logs from my console when I start and stop a few databases: