Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQLSTATE[IMSSP]: An invalid keyword 'user' was specified in the DSN string Propel2-Beta4 #2013

Open
GeorgeOnyango opened this issue Jul 27, 2024 · 0 comments

Comments

@GeorgeOnyango
Copy link

propel init create a wrong DSN when pdo_sqlsrv driver is selected.
I observed line 389 in the InitCommand.php literally inserts user and password into the DSN as shown in the code snippet below. This in turn results to SQLSTATE[IMSSP] error being thrown later when the DSN is used in the PdoConnection.php to establish a connection to MSSQL server.

$fullDsn = sprintf('%s;user=%s;password=%s', $options['dsn'], urlencode($options['user']), urlencode($options['password']));

Changing the line to the snippet below fixes the problem but I suppose this might in turn result to an error for the other drivers that requires/supports user and password in the DSN string.

$fullDsn = $options['dsn'];
@GeorgeOnyango GeorgeOnyango changed the title SQLSTATE[IMSSP]: An invalid keyword 'user' was specified in the DSN string SQLSTATE[IMSSP]: An invalid keyword 'user' was specified in the DSN string Propel2-Beta4 Jul 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant