New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

cant run create.py for DB creation #126

Closed
direktorn opened this Issue Aug 24, 2016 · 6 comments

Comments

Projects
None yet
4 participants
@direktorn

direktorn commented Aug 24, 2016

Hi,
Whatever I do the DB script will not connect to the MySQL (MariaDB) Backend:
(flask) PowerDNS-Admin# ./create_db.py
INFO: Wait for database server
ERROR: Couldn't connect to database server

However Pdns works fine with the same backend, I can run mysql -u with the username and password in my config-file and it works fine.

Ubuntu 16.04
mysql Ver 14.14
PowerDNS 4.0.0-alpha2 (Intrestingly an alpha build comes with Ubuntu 16.04)
Latest PowerDNS-Admin from git.

DATABASE CONFIG

You'll need MySQL-python

SQLA_DB_USER = 'powerdnsadmin'
SQLA_DB_PASSWORD = 'xxxxxx'
SQLA_DB_HOST = 'xxx.xxx.xxx.xxx'
SQLA_DB_NAME = 'powerdnsadmin'

MySQL

SQLALCHEMY_DATABASE_URI = 'mysql://'+SQLA_DB_USER+':'+SQLA_DB_PASSWORD+'@'+SQLA_DB_HOST+'/'+SQLA_DB_NAME

I have tried binding the script to both localhost and to other IPs but no success.

@michielvisser

This comment has been minimized.

michielvisser commented Aug 24, 2016

I had the same issue with this, CentOS 7 with MariaDB. The following solved this for me:
yum install MySQL-python
pip install python-mysql

Somehow these are not part of the installation of the requirements. After that, all went well...

@direktorn

This comment has been minimized.

direktorn commented Aug 24, 2016

I have followed the installation guide here and mysql-phyton should be installed.

@direktorn

This comment has been minimized.

direktorn commented Aug 26, 2016

It there any guide(s) available that can help me go trough the steps of isntalling PDNS-Admin on an vanilla Centos or Ubutu? I have not been successful following an guides :(

@alythemonk

This comment has been minimized.

alythemonk commented Aug 27, 2016

Into this problem, I don't know if this is the right thing to do, BUT I inserted mysql-python at the end of my requirements.txt and re-ran it ... I again could be off base but that worked for me ?

@direktorn

This comment has been minimized.

direktorn commented Aug 28, 2016

@alythemonk That did the trick, it also showed that i was missing the mysql-developer package. Perhaps it could be good to update the requirements.txt file.

Now everything works as expected: )

@ngoduykhanh

This comment has been minimized.

Owner

ngoduykhanh commented Sep 5, 2016

The mysql developer package was removed from requirements.txt file in PR #104 . It should be optional since user can use difference kind of DB backend. Please reference to README, WIKI for more information.

@ngoduykhanh ngoduykhanh closed this Sep 5, 2016

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment