Using $e->getCode()!=1049 and update stepDatabaseConfiguration

dbTest :

• throw error if DB connection can not be done
• return (bool)db exist

You're sure for code ? It work for

• User have 'global' permission for this dn name + db don't exist : return false
• User don't have 'global' permission for this dn name + db don't exist : throw error
  with mysql. Not tested with another DB

Works for MySQL but not Postgres.

Maybe partly my fault. The exception code 1049 for "Database not found" exception only works for MySQL.

Maybe this could help?

http://stackoverflow.com/questions/15177652/pdo-check-if-database-exists

Not sure which databases it works for, though.

OK, it's what i think this part ois DB specific

1st solution then must do it in 2 part :

• Try a SQL connect with DB
• If not : try SQL connect without DB : if OK : return false, if not : return true
  We are unsure This user have the right to create DB

2nd solution : find the correct SQLSTATE error returned , no driver dependant (or find the 3 errorCode() for mysql/pgsql and mssql)

PS: http://docstore.mik.ua/orelly/java-ent/jenut/ch08_06.htm ?

@olle : can you validate if LS is able to create table https://raw.githubusercontent.com/LimeSurvey/LimeSurvey/3ff4864c0c5d32016fb1f7f8bead380856a66571/application/controllers/InstallerController.php (previous file) with pgsql ?

Seems return 7 : OK
But connect without "database' aren't accepted ?

I just try with a user who have all rights on my system : with old system retunr "invalid connexion"

Will do.

Uploaded screenshot with my error.

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=17399

I'm unsure if we can send the error if DB not exist and myusql/pgsql.

Actaulllly right on DB are not completely done.

I make some other try (to send user access to this DB error specifc)

I'm not so sure that we should let the installer to create a DB. It implies to push people to use a db user with a strong level of permissions... which is a bad security behaviour... does other Web app like joomla or spip installers can create databases ?

Yes,

I have a specific user with sp_% rights only in mysql.
for pgsql : in general : i create the DB before.

I really think to udate the system again, but more simple and try to send maximum information.

For example : if user don't have DB access : we don't have to try without dbname.

PS: DB creation is done since LS exist.

2.50+ Build 160215 released