MySQL Forums
Forum List  »  Utilities

Error: Invalid database connection
Posted by: Philippe Florent
Date: May 31, 2016 06:23AM

Hello,

I get this error starting fabric on debian 2.4

[INFO] 1464696852.220653 - MainThread - Initializing persister: user (fabric_store), server (localhost:3306), database (mysql_fabric).

Error: Invalid database connection.


I have been debugging the python script
apparently after the connector has done its handshake, mysql returns an error
"unknown database mysql_fabric"

wich is odd since the script is supposed to create the db after logging to the server

can someone look into this ? thanks

but if I do it manualy, fabric_store has access and can create the db

How to repeat:
mysqlfabric manage start
[INFO] 1464592921.549109 - MainThread - Initializing persister: user (fabric_store), server (localhost:3306), database (mysql_fabric).
Error: Invalid database connection.

mysql -u fabric_store -p*********
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 58
Server version: 5.7.12 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database mysql_fabric;
Query OK, 1 row affected (0.00 sec)




installed packages:

mysql-connector-python_2.1.3-1debian8.2_all.deb
mysql-server_5.7.12-1debian8_amd64.deb-bundle.tar
mysql-utilities_1.5.6-1debian8_all.deb

followed instruction :

https://dev.mysql.com/doc/mysql-utilities/1.5/en/fabric-create-user.html
https://dev.mysql.com/doc/mysql-utilities/1.5/en/fabric-configuration-file.html


regards

Options: ReplyQuote


Subject
Views
Written By
Posted
Error: Invalid database connection
1595
May 31, 2016 06:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.