hello dear all,


i have some issues in setting up the limesurvey on a OpenSuse Server


i have created a db on a server - but if i setup the installation process i get funny errfors - all the time


well i i do not know what to do now.


the issue: in short: i cannot connect to a created database - allways the system complains - there is no such db..


question: can i connect to the db in another way!? is there a other method thinkable - love to hear from you


regards

by the way - i am using the newest version - the unstable that i have downloaded two days ago...

idea: can i install or create here some things manually - i guess that the connection of the installer script does not work propperly

are there any workarounds

There are something that broke in your configuration.
If you think it can be a LS version issue : try with 3LTS version.

Since you have already a WP db : did you try with the same settings ?

hello dear DenisChenu,

thx for the quick reply.


well now i intalled the stable version - this one; Stable (LTS) Release 3.25.0
downloade date: 20 november 2020


errors:


btw: i once have had this error: one year ago

forums.limesurvey.org/forum/installation...-no-such-file-or-dir


at the moment i do not know what was going on and how i got this fixec one year ago


any idea

Hi,

wpfan2099 wrote: at the moment i do not know what was going on and how i got this fixec one year ago

Always a good idea to put detail on fix

wpfan2099 wrote: any idea

No, sorry ...

Strangely : yo didn't have any issue with WP ?

hello dear Denis,


many thanks for the quick reply - great to hear from you again


youre right it is a good idea to add the solution to the fix. All i remember i that in the last year i had several issues.
And probably also some that i assumed that the interaction between WP (and probably some .htaccess-weird-things were causing issues. Besides this - i have had some session-trouble that time : the session path was not writeable

to sume up the old issues: sometimes i stuck within the installation process - and the installer-script came to a halt in the mid. And yes - addtionally i have had the issues that are described in the linked thread ( see the cited link) where the db-connection probably caused the issue#



nowadays:
but in these days -(note: we have set up a new server and we re on a pretty new (that means: actual ) version of PHP. So all that general things are set quite well - and i have

In this time it seems to be a bit easier: i only struggle with the DB-connection. All things goes well - untill i try to connect with the installer to the DB. This step fails in both (versions)


- the LTS 3 Version and
- the unstable version


i am trying to figure out what goes wrong here - i try to find out more about the error message.

Any thing i could do else - can i do some manual - configurations - e.g. to go round the installer-script!??

look forward to hear from you again

have a great day

hello dear Denis,


many thanks for the help - and the hints - so far: well i guess i have to digg deeper with that error-message:



see the many findings of issues - all over the board here. - some issues and errors that i have encountered and some of outhers.


that said: i really like Limesurvey - but i have to take care that it runs on my platform as well. So i will have to talk to my server-admin - we need to have a closer look at the mysql-sockets.. - see more below: And after that i will come back and report all the findings.


at the moment - the installation (db-connection) fails with both - the LTS3 and the unstable brandnew version.. Weird things - arent they!`?


see the threads:


forums.limesurvey.org/forum/installation...-no-such-file-or-dir
forums.limesurvey.org/forum/installation...-no-such-file-or-dir
forums.limesurvey.org/forum/installation...-sqlstate-hy000-2002





here some more findings: the folks / and user that face the same issue with the mentioned survey script as i do - they have posted some ideas and findings - food for thought:

cf: www.limesurvey.org/forum/installation-a-...-sqlstate-hy000-2002

klaus said: I run LimeSurvey on Linux for a few years now. After a reboot, probably an update, lime does not start anymore. I get the error
CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2002] No such file or directory

Kevin: also answered in the above mentioned thread: I updated to 2.62.2+170203 a few days ago and I am also having the same issue. I got the error a few times after the update but refreshing the page seemed to work. Now I can't login or view a survey.
I can connect from the command prompt.


shru123:

I am facing same issues, I have installed new version of Apache 2.4.25 , php version 7.1.1. but in php 7.1.1 not supporting MySQL driver, it supports only mysqli. and limesurvey doesn't work without MySQL driver. please help me its urgent what to do.

Following my research I looked for the connectionstring in the config.php and found:
stackoverflow.com/questions/29695450/pdo...ch-file-or-directory

Quick test (run in shell):
some ideas:
SQLSTATE[HY000] [2002] No such file or directory means php cannot find the mysql.default_socket file. Fix it by modifying php.ini file. On Mac it is mysql.default_socket = /tmp/mysql.sock (See PHP - MySQL connection not working: 2002 No such file or directory)
SQLSTATE[HY000] [1044] Access denied for user 'username'@'localhost' CONGRATULATION! You have the correct mysql.default_socket setting now. Fix your dbname/username/password.


a tipp: You need to change host from localhost to 127.0.0.1

[[
Laravel 4: In your app/config/database.php try changing host from localhost to 127.0.0.1
Laravel 5: In the .env file, change DB_HOST from localhost to 127.0.0.1
]]


and a highly rated tip - with tremendous ratings and many many agreements:


stackoverflow.com/questions/20723803/pdo...ch-file-or-directory

the error message indicates that a MySQL connection via socket is tried (which is not supported).
In the context of Laravel (artisan), you probably want to use a different / the correct environment. Eg: php artisan migrate --env=production (or whatever environment). See here.

I had the exact same problem. None of the above solutions worked for me. I solved the problem by changing the "host" in the /app/config/database.php file from "localhost" to "127.0.0.1".

Not sure why "localhost" doesn't work by default but I found this answer in a similar question solved in a symfony2 post. stackoverflow.com/a/9251924/1231563

Update: Some people have asked as to why this fix works so I have done a little bit of research into the topic. It seems as though they use different connection types as explained in this post stackoverflow.com/a/9715164/1231563

The issue that arose here is that "localhost" uses a UNIX socket and can not find the database in the standard directory. However "127.0.0.1" uses TCP (Transmission Control Protocol), which essentially means it runs through the "local internet" on your computer being much more reliable than the UNIX socket in this case.



i will discuss all that with the server-admin - we will look for the db-socket!

i come back and report all the findings


cheers

hi there did allmost everything.

- created new db - with new user
- used a old db and user - which works perfectly since years now.


- results: all failed - everything failed- with both the old and the new installation

any idea!`?

look forward to hear from you

Any ideas of Workarounds for solving these issues!?

look forward to hear from you

regards

It is very hard to help in your case. My guess is that there is something in your server configuration blocking Limesurvey.

Of course a Bug in Limesurvey that only appears with your very specific server configuration can't be excluded completely, but my guess would be that it is due to your server configuration at some point. Now, finding this specific configuration is tough. And nothing that someone here in the forum will be able to help I guess.

Have you tried to install Limesurvey in another server environment, just for test purposes?

Hi,

Son't know exactly what happen for yo but.

There some specific system when you create a localhost string for SQL connexion : it rewrite it to go to socket. But in general this socket are /var/mysql/mysql.sock or something like this.

But it was never something like /usr/local/LimeSurvey/var/LimeSurvey_mysqld.sock directly. Here : it seems more a dpocker or something else.

Maybe try something like this : stackoverflow.com/a/6263868/2239406

hello dear Denis hello deaR Holch
first of all : many many thanks for the quick reply and for your continued suppport. I will digg deeper and will try out all you have described and mentioned.

i will look and have a closer look at all things - and yes: i come back and report all the findings.

have a great day