[Solved] Installation Problem

HuMo-genealogy is a free online genealogical program for your own website!
Forum for remarks, wishes, bugs and tips.
Post Reply
buf007
Posts: 3
Joined: Mon 25 Nov 2019, 05:50

[Solved] Installation Problem

Post by buf007 »

Hi,

Install software on to my Synology NAS DSM 218play.
Using Mariadb 10

http://honeytree.itchyman.synology.me/admin/index.php

Clean install of mariadb
Have create database and user

Database connection status:
*** There is no MySQL connection: please check host/ username and password. ***
*** No database found! Check MySQL connection and database name ***

Edited the /admin/php.ini
not sure which php.ini

GRANT ALL PRIVILEGES ON `familytree`.* TO 'humogenroot'@'localhost' WITH GRANT OPTION;
User avatar
Huub
HuMo-genealogy programmer
HuMo-genealogy programmer
Posts: 2693
Joined: Wed 27 Aug 2008, 11:34
Location: Heerhugowaard, Netherlands
Contact:

Re: Installation Problem

Post by Huub »

Hi buf007,

Welcome at the forum!

I have two Synology NAS servers, but never used them for HuMo-gen. I probably will try this soon.
There is no MySQL connection: please check host/ username and password.
This fault message is generated by HuMo-gen if host, username or password are wrong.
host normally is: localhost.
Username and password can be generated in PHPMyAdmin.

It's not necessary to change files in HuMo-gen. In some cases the ini or htaccess files can be a problem, just (temporary) remove them.
:arrow: HuMo-genealogy update? Backup your database! Editing in HuMo-genealogy? Backup your data!
Make multiple backups with: PHPMyAdmin, gedcom export and database export.

HuMo-genealogy software: http://humo-gen.com
buf007
Posts: 3
Joined: Mon 25 Nov 2019, 05:50

Re: Installation Problem

Post by buf007 »

http://honeysett.itchyman.synology.me:6 ... /index.php

Database connection status:
*** There is no MySQL connection: please check host/ username and password. ***
*** No database found! Check MySQL connection and database name ***

My user has all rights to Database.
Get the same with root / buf007 user

Have rename php.ini / htaccess

Can all three users can connect using HeidiSQL using created credentials

Worked it out had to use the the IP Address with port 3307 being MariaDB port number

192.168.1.245:3307

Enable MariaDB port 3307 on Synology NAS firewall and router firewall
Ensure MariaDB enable in info Center Services
Created User on Synology NAS access to web directory
Post Reply