Category: debian

Posted on

mysql error 1356 references invalid table(s) or column(s) or function(s) or definer/invoker of view webmin

Long story short, I recovered a mysql backup from my old LAMP server and afterwards I kept getting a view error when editing users. After many hours of trying to find a fix I was about to dump and rebuild the mysql.user schema since it was what was messed up since it had old user rights and everything from my old server. I googled for hours and hours trying to fix it finally what did it was one simple command….

mysql_upgrade --force

boom user view worked
boom I can edit and add users again through the webmin interface.
Thanks for reading hope this helped!

Posted on

Setting up Transmission and OpenVPN on Debian using only CLI, with auto start and VPN up check script. Private Internet Access

To begin, lets start with installing Transmission and OpenVPN.
To install Transmission

sudo apt install transmission-daemon

Once it is installed you will want to access the web GUI from another machine so lets go into the settings.json and tweak a few things so you can access it. 

First we need to stop transmission 

sudo service transmission-daemon stop

Then with your favorite editor go ahead and open the settings file, I prefer nano so 

nano /etc/transmission-daemon/settings.json

We need to just change a couple lines, where I have 192.168.10.* type your lan range be it 192.161.* or 192.168.0.* the * is a wildcard that will let anyone on your lan access the transmission web-GUI.

“rpc-authentication-required”: false,
“rpc-bind-address”: “0.0.0.0”,
“rpc-enabled”: true,
“rpc-whitelist”: “192.168.10.*”,

Continue reading “Setting up Transmission and OpenVPN on Debian using only CLI, with auto start and VPN up check script. Private Internet Access”