User Tools

Site Tools


emoncms_and_dietpi
Emoncms on a Pi2 v1.1 running diet pi

https://dietpi.com/#downloadinfo

“emoncms 404 Not Found: Is modrewrite configured on your system?”

Open /etc/lighttpd/lighttpd.conf with a text editor and enable the rewrite module by uncommenting it (remove the #). It will then look something like this:

/etc/lighttpd/lighttpd
server.modules = 
   (
    "mod_access",
    "mod_alias",
    "mod_compress",
    "mod_redirect",
    "mod_rewrite",
    )
 

Then add the rewrite regular expression to the same file; https://tech.borpin.co.uk/2018/10/13/emoncms-on-dietpi/

/etc/lighttpd/lighttpd
url.rewrite-if-not-file = (
"^/emoncms/([^?]*)$" => "/emoncms/index.php?q=$1",
"^/emoncms/([^?]*)\?(.*)$" => "/emoncms/index.php?q=$1&$2"
)

sudo service lighttpd restart .

emoncms: Access denied using password(YES)

you can resolve this by the steps following

start/stop mysql by using service mysqld start/stop/restart instead of service mysql start/stop/restart

make sure you have the right password for mysql user - root, if no, please reset password

edit mysql config file, usually /etc/my.cny, add skip-grant-tables under [mysqld], then restart mysql, now you can go into mysql without password, then reset password by using

update mysql.user set authentication_string=password('123qwe') where user='root' and Host = 'localhost'; flush privileges;

https://www.databasestar.com/access-denied-for-user-root-at-localhost/

Step 1: Open the my.cnf file. This may be stored in:

/etc/my.cnf /etc/mysql/my.cnf

If you’re not sure where it is, search your MySQL installation folder (e.g. on Windows or Mac) for the file.

If you don’t have a my.cnf file (MacOS does not include one by default). You can create one in the /etc folder if you like.

Step 2: Add the word skip-grant-tables under the word [mysqld]. Your file may look like this:

[mysqld] skip-grant-tables

Step 3: Restart the MySQL server.

Step 4: Login to the root account:

mysql -u root -p

Step 5: Flush the privileges, which tells the server to refresh the grant tables and apply your changes, with this command:

FLUSH PRIVILEGES;

Step 6: Set a new password for the account:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_new_password';

Substitute the word your_new_password with a new secure password that you want to use for the root account.

Step 7: Open the my.cnf file you opened in step 1, and remove the line about skip-grant-tables, and save the file.

Step 8: Restart the MySQL server again.

Step 9: Log in to the root account again:

mysql -u root -p

You should now be able to log in successfully with your new password and not get an error.

emoncms_and_dietpi.txt · Last modified: 2023/04/08 09:59 by admin