Before asking for help please read "Requesting Help and Suggestions" by clicking on that tab above here.
  • Page:
  • 1

TOPIC:

Error during Installation 2.0.3 2 years 1 month ago #1

  • century
  • century's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 12
Hello,

I got an error during Installation 2.0.3.

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

My server settings are ok, look at the screenshot.
The database dbxxxxxx_5 is new and empty.

If I try 127.0.0.1 instead of localhost so I have the same result.

What's wrong with my Installation?
What I need to do?

Thanks for helping.
century
Attachments:

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

Error during Installation 2.0.3 2 years 1 month ago #2

  • fisharebest
  • fisharebest's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 15818
> If I try 127.0.0.1 instead of localhost so I have the same result.

The *exact same* error message?

This should not be possible.

The error "2002 no such file or directory" should only be possible with localhost.

In MySQL, there is a variable @@socket
In PHP, there is a setting mysql.default_socket
These must be the same.

On my laptop, here is how I check the settings:

$ php -i | grep mysql.default_socket
pdo_mysql.default_socket => /tmp/mysql.sock => /tmp/mysql.sock

$ mysql -e "SELECT @@socket"
+-----------------+
| @@socket        |
+-----------------+
| /tmp/mysql.sock |
+-----------------+

$ ls -l /tmp/mysql.sock 
srwxrwxrwx  1 gr4376  wheel  0 25 Mar 11:47 /tmp/mysql.sock
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

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

Error during Installation 2.0.3 2 years 1 month ago #3

  • century
  • century's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 12
Hi,

you're right, not exact the same, only last part.

If I try with 127.0.0.1 than I get this one:

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

Maybe I should ask my Hoster because of this error message?
But other (older) versions are running on the same server. I have installed about 4 years ago.

Greetings
century
Attachments:

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

Error during Installation 2.0.3 2 years 1 month ago #4

  • fisharebest
  • fisharebest's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 15818
Does your database account have permission to create new databases?

I guess not.

Can you create the database using phpMyAdmin?

If not, you can use an existing databse - but with a different table-prefix.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

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

Error during Installation 2.0.3 2 years 2 weeks ago #5

  • century
  • century's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 12
Hello,

I have created a new table "test" in the new database.
It works but not the installation.

What I need to do?
Attachments:

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

  • Page:
  • 1
Powered by Kunena Forum