Web based family history software

Question [SOLVED] Help with installing 2.0.3 on synology box

  • wtuser
  • Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 4 hours ago #1 by wtuser
On the page that ask for mysql information, I am getting the error message

SQLSTATE[HY000] [2002] No such file or directory (SQL: CREATE DATABASE IF NOT EXISTS `webtrees` COLLATE utf8_unicode_ci)

Does the installation process create the database?
Why this error?

Thanks

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

More
3 years 11 months ago #2 by fisharebest
Replied by fisharebest on topic Help with installing 2.0.3 on synology box
> Does the installation process create the database?

webtrees will attempt to create it, if it does not exist.

Note that on many web-hosts, you will not have permission to create a database.
This option is mostly useful for local/development servers.

> Why this error?

This error indicates that your MySQL configuration is incorrect.

You are attempting to connect via a "socket" (a special file), and this socket is not found.

Did you specify "localhost" for your MySQL server? Try "127.0.0.1"

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

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

  • wtuser
  • Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 11 months ago #3 by wtuser
Replied by wtuser on topic Help with installing 2.0.3 on synology box
I am using MariaDB 10 which apparently requires a password. I am not sure if that might make a difference.

I have tried using "localhost" and "127.0.0.1".
MariaDB 10 uses port 3307, but I tried entering 3306 but that did not make any difference.

What other configuration changes need to be made?

Thanks

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

More
3 years 11 months ago #4 by fisharebest
Replied by fisharebest on topic Help with installing 2.0.3 on synology box
When you say you changed localhost to 127.0.0.1 and it "did not make any difference" do you mean that

a) You still get the exact same error message "No such file or directory"
b) You get a different error message.

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

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

  • wtuser
  • Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 11 months ago #5 by wtuser
Replied by wtuser on topic Help with installing 2.0.3 on synology box
I am receiving the exact same error message with the No such file or directory.

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

  • wtuser
  • Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 11 months ago #6 by wtuser
Replied by wtuser on topic Help with installing 2.0.3 on synology box
I apologize. When I use localhost, I get "No such file or directory". When I use 127.0.0.1, I get Connection refused.

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

More
3 years 11 months ago #7 by xmlf
Please try to install other php programs, such as wordpress. If you still have problems, I suggest you go to stackoverflow.com/ for advice or use a search engine to find the answer.After all there are more professionals there.

Wang Family Website of Suining County, China
www.snwsjz.com
A family tree website that is customized, more humanized and convenient for users.

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

  • bertkoor
  • Offline
  • Platinum Member
  • Platinum Member
  • Greetings from Utrecht, Holland
More
3 years 11 months ago - 3 years 11 months ago #8 by bertkoor
Replied by bertkoor on topic Help with installing 2.0.3 on synology box

wtuser wrote: When I use 127.0.0.1, I get Connection refused.


"connection refused" happens when the connection to the database can be made, but the credentials (user & password) are wrong. Check it at the source (database itself) and check again for typo's...

If you have PhpMyAdmin running on your NAS (see www.synology.com/en-global/knowledgebase...S_with_phpMyAdmin#t3 )
use it to create a new user with a password. Perhaps the default user "root" with it's default empty password is not suitable for webtrees (well, it never should be)
In text files you never know whether it gets interpreted as a space character (which is not equal to an empty string)

stamboom.BertKoor.nl runs on webtrees v1.7.13
Last edit: 3 years 11 months ago by bertkoor.

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

  • wtuser
  • Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 11 months ago #9 by wtuser
Problem solved.

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

Powered by Kunena Forum
}