Web based family history software

Question Problem accessing database on new installation

  • Penge58
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 3 weeks ago - 1 month 3 weeks ago #1 by Penge58
Hello

I am just now installing the latest version but from running the installation the software has problem accessing my database.
I have checked and re-check the login information but still it will not connect.

I know this could be difficult to answere but I try anyway if any of you have a hint for me.

SQLSTATE[HY000] [2002] Connection refused (SQL: CREATE DATABASE IF NOT EXISTS `engelarsen` COLLATE utf8_unicode_ci)

 
Attachments:
Last edit: 1 month 3 weeks ago by Penge58.

Please Log in or Create an account to join the conversation.

  • bertkoor
  • Offline
  • Platinum Member
  • Platinum Member
  • Greetings from Utrecht, Holland
More
1 month 3 weeks ago #2 by bertkoor
Replied by bertkoor on topic Problem accessing database on new installation
From the error message it seems the user can connect, but is not allowed to create tables etc.

Have you specified another owner / schema / database than the user which is used to connect?

stamboom.BertKoor.nl runs on webtrees v1.7.13

Please Log in or Create an account to join the conversation.

More
1 month 3 weeks ago #3 by fisharebest
Replied by fisharebest on topic Problem accessing database on new installation
Another possibility is that you are trying to connect to MySQL via the network (e.g. 127.0.0.1), but MySQL is only available by a socket (localhost).

Check your connection settings.

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • Penge58
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 3 weeks ago #4 by Penge58
Thank you folks

Please find attached the setting I have on the MySQL database.  
All rights are ticked.
The software is running on the same server as the linux is installed.  So I expect that localhost:3306 should be okay since I am not trying to connect from a remote site.  Should I try to specify the actuall IP adress instead of just localhost ?


Petter
Attachments:

Please Log in or Create an account to join the conversation.

More
1 month 3 weeks ago #5 by Franz Frese
Replied by Franz Frese on topic Problem accessing database on new installation
  1. Firewall rule: If your server deny/not allow 3306 port, can not connect it.
  2. Bind Address: if your bind address are 127.0.0.1 in MySQL configuration, you must change to 0.0.0.0 in [mysqld] on /etc/mysql/my.cnf
  3. Restart Service: you have to run command 'service mysql restart'

Please Log in or Create an account to join the conversation.

  • Penge58
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 3 weeks ago #6 by Penge58
Hello again

Thank you for trying to help me.
The problem is solved now.
It seemed to have something to do with the DNS setting at the domain holders site.
I managed to add a missing CNAME parameter and got rid of a warning message at my server and then also the SQL database connection worked.
So I have it installed now.

I have also imported at GEDCOM file from MyHeritage and it went well except the images/photos is not working yet.
I learned that I during the importing of the GEDCOM I needed to have the software to remove the path to the source for images at my local desktop. So I did.
The question is now, were should I now upload my images ?
I read one place that they should be upladed at data/media   ??
There is a data folder but no media subfolder.
So I created it and uploaded all my images to that folder.

Am I right so far ?

Petter
 

Please Log in or Create an account to join the conversation.

More
1 month 3 weeks ago #7 by hermann
Yes, you are right. You should be able to see and manage the media files in webtrees.

Hermann
Designer of the custom module "Extended Family"

webtrees 2.1.20 (all custom modules installed, PHP 8.2, MariaDB 10.6) @ ahnen.hartenthaler.eu

Please Log in or Create an account to join the conversation.

  • Penge58
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 3 weeks ago #8 by Penge58
Thank you for your reply. Yes everything is working fine now. I just wonder one thing. There is no Norwegian language possibility but Swedish and Danish. Not a big issue but is there a possibility for me to translate into Norwegian ? On a file level ? Create a new file with the norwegian words ?

Thanks

Please Log in or Create an account to join the conversation.

  • bertkoor
  • Offline
  • Platinum Member
  • Platinum Member
  • Greetings from Utrecht, Holland
More
1 month 3 weeks ago #9 by bertkoor
Replied by bertkoor on topic Problem accessing database on new installation
Norwegian language is optional and just needs a tick to be activated.

Go through some options in the Control Panel. Under website preferences?

stamboom.BertKoor.nl runs on webtrees v1.7.13

Please Log in or Create an account to join the conversation.

More
1 month 3 weeks ago #10 by fisharebest
Replied by fisharebest on topic Problem accessing database on new installation
Control panel -> Modules -> Languages

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • Penge58
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 month 3 weeks ago #11 by Penge58
Yes I see that I can enable Norwegian language now. 
I found it.

Thank you all for quick respons to my questions.

Thank youl

Petter
 

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum
}