I have an EmonCMS installation working ok since 2016.
At the beginning I made regular updates, but then I made some changes of my own to some visualizations and got tired of porting them to every new version.
Recently I added some solar panels and have been investing some tome on this topic again and decided it was time to update EmonCMS.
The main problem I’m having is the message “Can’t connect to database, please verify credentials/configuration in settings.ini” but if I use the command line with the same exact auth information it works correctly (the credentials are just for testing so I didn’t bother to hide them):
> mysql -u TESTECMS -pTESTEcms2021 -h localhost -D EmonCMS2 > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Welcome to the MariaDB monitor. Commands end with ; or \g. > Your MariaDB connection id is 12110276 > Server version: 5.5.56-MariaDB MariaDB Server > > Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. > > Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. > > MariaDB [EmonCMS2]> show tables; > +--------------------+ > | Tables_in_EmonCMS2 | > +--------------------+ > | app_config | > | dashboard | > | device | > | feed_172 | > | feed_174 | > | feed_176 | > | feed_178 | > | feed_180 | > | feed_184 | > | feed_193 | > | feed_27 | > | feed_28 | > | feeds | > | input | > | multigraph | > | rememberme | > | schedule | > | users | > +--------------------+ > 18 rows in set (0.00 sec) > > MariaDB [EmonCMS2]> > [sql] > server = "localhost" > database = "EmonCMS2" > username = "TESTECMS" > password = "TESTEcms2021" > port = 3306
Another thing is that the setting.ini is missing this option “‘phpfiwa’=>array(
‘datadir’ =>”, I can only find the option for phpfina and phptimeseries.
PS: I still have the original EmonCMS working in another virtual web folder and with other database.
Edit - formatted text - Moderator