Hi Folks,
For some reason, I had to update the MySQL password and now I am unable to access my SuiteCRM application, is there any way to achieve it?
Many thanks!
Hi Folks,
For some reason, I had to update the MySQL password and now I am unable to access my SuiteCRM application, is there any way to achieve it?
Many thanks!
Hi,
The question is not Clear. Anyhow i try to answer.
You can add this new password to SuiteCRM config file DB CONFIG array index.
If you are using Linux, and you are on a Lamp Stack, then you can do it either by command line
https://www.a2hosting.com/kb/developer-corner/mysql/reset-mysql-root-password
or by files
https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
Hopefully this will help you.
Hi,
Actually, I was using āsuiteā as my password, but I have got requirement to add a new DB name sales1, so I was giving privileges to the new DB via following command:
GRANT ALL PRIVILEGES sales1.* to ārootā@ālocalhostā IDENTIFIED BY āsuiteā;
But this time system denied as password was not fulfilling the policy, so I put it
GRANT ALL PRIVILEGES sales1.* to ārootā@ālocalhostā IDENTIFIED BY āSuite@ā;
This was the scenario, now I am not able to access my application, nor I am able to change my password to the old one, as it doesnāt satisfy the password policy.
Where can I add this new password to SuiteCRM config file DB CONFIG array index? Could you please share the exact path?
Thanks!
root directory of SuiteCRM/config.php
in case of any issue and instant communication please skype me
Hi,
It worked, thanks a lot for the help.
Many thanks!
Hi,
I am stuck with some other issue, and you might help me on this:
I need to calculate the Estimated Opportunity amount based on the products under that Oppty. Suppose I have to create an Opportunity with 2 products:
Product A Value: 100 Quantity 1
Product B Value: 100 Quantity 8
So I need an extra field, which calculate the Estimated Oppty value, like in this case itāll be: 900.
How can I achieve this?
(Note: Product is my Subpanel under the Opportunity)
Hi,
You want to show this field in Which Module??
In opportunity or in Product??
Itāll work anywhere.
But if itāll display in Oppty, then itād be awesome
This is a lengthy things, i can help you over skype.
I have another call right now, after 30 mints if possible?
sure
Hi,
I sent you invitation on SKYPE, but it is still pending.
If you could help me on the above mentioned issue, thatād be great.
Many thanks!
Hi,
I have received no Request
Hi,
I have sent couple of invitation to you on SKYPE and it is still showing as Pending. I am using SKYPE for Business, could this be the reason?
Many thanks!
Hi,
Can you please tell your skype name? I have received no invitation yet!!
Rachit Sinha
(rachit.sinha@sagepub.in)
done. Please join me there
I have changed the mysql password. Iāve replaced the new password in suitecrm/.env.local and suitecrm/public/legacy/config.php and suitecrm/public/legacy/config_si.php (SuiteCRM 8).
Now i can login through suitecr/public/legacy/index.php but not through the main login page. the legacy login does not show the header and keeps login out.
Any ideas what might be happening?
Try to find any other .env files, there might be more, and your system might be using a different one than you thought