It is the # sign that is not recognized by PHP’s parse_url() function as valid, this issue is not related to Symfony, but to Doctrine DBAL
Think it could be because you have a # (or some special character?) on your password. Seems an issue with Doctrine DBAL. Do you have a # on your password?
During the install process, I think we need to encode the password, when adding to DATABASE_URL .
I’m not 100% sure on it yet, though I have a feeling that your issue with not being able to login, may be related with the following thread. Could you, please, try installing a providing a password without any special characters? (I’m guessing that # and % may cause problems).
As mentioned on the thread, I’ve raised this internally .
Yes, I do have a # sign in my password - so should I change the password? It’s the same password on a version 7 install and works so I take it this is because you’re using a different framework for v8?
In order to keep your password you can url encode the #. Try replacing the # with %23 in DATABASE_URL on .env.local.
Notes:
other special characters may also need to be encoded.
I didn’t try it yet, on the github issues I’ve linked before some people where still having issues with %23. So I’m not 100% on this
The alternative is to use a simple password for the moment, until we change the install command to auto encode the password for you (i.e. to do the same that was explained in 1) )
I’ve found some stackoverflow threads about performance with windows + php + symfony. Though I still need to have a better look at it. It seems that symfony can be slower on windows. Adding them here in case they help.
hey, sorry for delayed reply. I tried removing the previous install, dropping the DB and re-installing everything. Still getting the same error. This time I used the command-line options so I know there’s no typo in the password:
If I understand, I should be able to login with username: admin and password: test. But I’m getting the login credentials incorrect error.
Everything else with the install script seems to have worked–the login page loads at the URL and the database tables were created and there’s a row for my admin user in the users table.
[2021-08-04 15:12:16] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred in driver: could not find driver" at /srv/http/suitecrm8/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred in driver: could not find driver at /srv/http/suitecrm8/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 0): could not find driver at /srv/http/suitecrm8/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 0): could not find driver at /srv/http/suitecrm8/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:39)"} []
Any ideas how to resolve? Running php 7.3.29-1, apache 2.4.48-1, mariadb 10.5.11-1
I’m having issues getting the new interface up and running.
I’ve been able to install via the CLI and can login using the Legacy URL, (http://localhost/legacy/index.php?action=Login&module=Users), however the new login page just keeps on telling me that the username and password are incorrect. The console logs a polyfills-es2015.af170ffe981b0ba2d77d.js:118 POST http://localhost/login 500 (Internal Server Error).
In the logs I also get: request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\ConnectionException: "An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory" at /var/www/html/SuiteCRM/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 112 {"exception":"[object] (Doctrine\\DBAL\\Exception\\ConnectionException(code: 0): An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory at /var/www/html/SuiteCRM/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:112, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /var/www/html/SuiteCRM/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /var/www/html/SuiteCRM/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:39)"} []
I’ve confirmed that pdo_mysql is installed and is running, I’ve also checked to ensure that rewrites is enabled. I just cant see what I’m doing wrong
Running Apache2 with PHP8 on Ubuntu (latest) inside of Docker/Docker-Compose.
Cheers!
My guess at the moment is that it could be docker config related issue. I Imagine you have your db setup on a separate service of docker compose, something like:
db:
image: mysql
ports:
- "3306:3306"
environment:
...
if so, on the db url are you using localhost / 127.0.0.1 for the server address? Could you try using the name of your docker database service, on the above example is db. You can change this on .env.local file that should have been generated on install.
From what I’m able to understand the error is usually thrown when doctrine tries to do the connection using socket. However, your config seems ok, and doctrine should not be trying to do that.
Bit of an update - still not cracked this.
Have checked permissions, (but running under docker there isn’t really much to do there).
I have found this in the network responses since downgrading PHP to 7.4, I guess line 10 is the most interesting:
ERROR_JS_ALERT_SYSTEM_CLASS: “System”
ERROR_JS_ALERT_TIMEOUT_MSG_1: “Your session is about to timeout in 2 minutes. Please save your work.”
ERROR_JS_ALERT_TIMEOUT_MSG_2: “Your session has timed out.”
ERROR_NOTIFY_OVERRIDE: “Error: ResourceObserver->notify() needs to be overridden.”
ERROR_NO_BEAN: “Failed to get bean.”
ERROR_NO_RECORD: “Error retrieving record. This record may be deleted or you may not be authorized to view it.”
ERROR_TYPE_NOT_VALID: “Error. This type is not valid.”
ERROR_UNABLE_TO_RETRIEVE_DATA: “Error: Unable to retrieve data for {0} Connector. The service may currently be inaccessible or the configuration settings may be invalid. Connector error message: ({1}).”
ERR_ADDRESS_KEY_NOT_SPECIFIED: “Please specify ‘key’ index in displayParams attribute for the Meta-Data definition”
ERR_AJAX_LOAD: “An error has occurred”
ERR_AJAX_LOAD_FAILURE: “There was an error processing your request, please try again at a later time.”
ERR_AJAX_LOAD_FOOTER: “If this error persists, please have your administrator disable Ajax for this module”
ERR_A_REMINDER_IS_EMPTY_OR_INCORRECT: “A reminder is empty or incorrect.”
ERR_BAD_RESPONSE_FROM_SERVER: “Bad response from the server”
ERR_CANNOT_CREATE_METADATA_FILE: “Error: File [[file]] is missing. Unable to create because no corresponding HTML file was found.”
ERR_CANNOT_FIND_MODULE: “Error: Module [module] does not exist.”
ERR_COMPATIBLE_PRECISION_VALUE: “Field value is not compatible with precision value”
ERR_CONNECTOR_FILL_BEANS_SIZE_MISMATCH: “Error: The Array count of the bean parameter does not match the Array count of the results.”
ERR_CONNECTOR_NOT_ARRAY: “connector array in {0} been defined incorrectly or is empty and could not be used.”
ERR_DB_FAIL: “Database failure. Please refer to suitecrm.log for details.”
ERR_DB_VERSION: “SuiteCRM {0} Files May Only Be Used With A SuiteCRM {1} Database.”
ERR_DECIMAL_SEP_EQ_THOUSANDS_SEP: “The decimal separator cannot use the same character as the thousands separator.\n\n Please change the values.”
ERR_DELETE_RECORD: “A record number must be specified to delete the contact.”
ERR_EMPTY_COLUMNS_LIST: “At least, one element required”
ERR_EXISTING_PORTAL_USERNAME: “Error: The Portal Name is already assigned to another contact.”
ERR_EXPORT_DISABLED: “Exports Disabled.”
ERR_EXPORT_TYPE: "Error exporting "
ERR_EXTERNAL_API_SAVE_FAIL: “An error occurred when trying to save to the external account.”
ERR_FACTOR_TPL_INVALID: “Factor Authentication message is invalid, please contact to your administrator.”
ERR_FILE_NOT_FOUND: “Error: Could not load file {0}. Please check system and web server permissions.”
ERR_FILE_WRITE: “Error: Could not write file {0}. Please check system and web server permissions.”
ERR_INVALID_EMAIL_ADDRESS: “not a valid email address.”
ERR_NOTHING_SELECTED: “Please make a selection before proceeding.”
ERR_NOT_ADMIN: “Unauthorized access to administration.”
ERR_NO_DB: “Could not connect to the database. Please refer to suitecrm.log for details (0).”
ERR_NO_HEADER_ID: “This feature is unavailable in this theme.”
ERR_NO_INVITEES_FOR_REMINDER: “No invitees for reminder.”
ERR_NO_SINGLE_QUOTE: "Cannot use the single quotation mark for "
ERR_NO_SUCH_FILE: “File does not exist on system”
ERR_OPT_IN_RELATION_INCORRECT: “Opt In requires the email to be related to Account/Contact/Lead/Target”
ERR_OPT_IN_TPL_NOT_SET: “Opt In Email Template is not configured. Please set up in email settings.”
ERR_QUERY_LIMIT: “Error: Query limit of $limit reached for $module module.”
ERR_REMINDER_IS_NOT_SET_POPUP_OR_EMAIL: “Reminder is not set for either a popup or email.”
ERR_RETURN: “Return to Home”
ERR_SEARCH_INVALID_QUERY: “An error has occurred while performing the search. Your query syntax might not be valid.”
ERR_SEARCH_NO_RESULTS: “No results matching your search criteria. Try broadening your search.”
ERR_SELF_REPORTING: “User cannot report to him or herself.”
ERR_SMARTY_UNEQUAL_RELATED_FIELD_PARAMETERS: “Error: There are an unequal number of arguments for the ‘key’ and ‘copy’ elements in the displayParams array.”
ERR_SQS_NO_MATCH: “No Match”
ERR_SQS_NO_MATCH_FIELD: "No match for field: "
ERR_STORE_FILE_MISSING: “Error: Unable to find Store implementation file”
ERR_SUHOSIN: “Upload stream is blocked by Suhosin, please add “upload” to suhosin.executor.include.whitelist (See suitecrm.log for more information)”
ERR_TWO_FACTOR_CODE_FAILED: “Two Factor Authentication code failed to send.”