A little bit of wisdom
Grant privileges* on table: To grant SELECT, INSERT, UPDATE, and DELETE privileges on table name: data_table to a user name jdoe, you would run the following GRANT statement: GRANT SELECT, INSERT, UPDATE, DELETE ON data_table.* TO ‘jdoe’@’localhost’; *Privileges can be any of: SELECT, INSERT, UPDATE, DELETE, INDEX, CREATE, ALTER, DROP, GRANT, ALL Revoke privileges on […]
This configuration should work with most UK ISPs – I use Unchained ISP and it works well with them. See my other posts to use the VA887 as a modem instead of a router, and use Linux as a PPPoE provider. Note that the config will require some adjustment to suit your own ISP and […]
I’m using Linux PPPoE for my internet connection, along with a Cisco VA887 router, in modem mode. Here’s the configuration for my specific ISP, but there’s no reason why this shouldn’t work with typical UK ISP’s This configuration should reside in /etc/ppp/peers/YOUR_ISP_NAME noipdefault defaultroute replacedefaultroute hide-password bsdcomp 15 deflate 15 noauth refuse-eap user ‘your isp […]
I’m using a Cisco VA887 as a modem, and here is the config, which should work with most UK ISPs. I also used the 887 as a PPPoE router previously and here is my config for that. My unit has had the fan removed, hence the ‘nolog’ option for the fan. To enhance passive cooling, […]
My MPD player has multiple USB interfaces, and I needed to maintain device order across reboots. The output of lsusb: The first 4 characters are the vendor ID (vid) and the second 4 are the product ID (pid) lsusb Bus 001 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub Bus 003 Device 001: ID […]
A (very) quick ‘howto’ to make a wireless access point from a Linux machine (should also with with Raspberry Pi with some modifications to the config files) NOTE: This howto assumes you already have a supported wireless network adaptor – not all adaptors support AP mode. Requirements: ifupdown / bridge-utils/ crda / wireless-regdb / hostapd […]
Despite following the installation guide, I encountered various issues when configuring archlinux (2021.12.01) recently. I’m not sure if these were failures on my part, but in any case I documented my configuration steps below. First step was to get a working internet connection. My network interface is enp3s0 so all commands reference that: Manually add […]
I was getting the following message in my log files on my Debian firewall. kernel: conntrack: generic helper won’t handle protocol 47. Please consider loading the specific helper module. The nf_conntrack_proto_gre module needs to be loaded to resolve this. modprobe nf_conntrack_proto_gre To load it automatically at boot, I created a new file (gre.conf) in /etc/modules-load.d […]
I have an Eco-Eye Smart energy meter, and they provide software for Windows, but nothing for Linux. When I purchased the meter, I also bought the optional USB cable, which emulates a serial port. This made it quite trivial to connect and read within Linux. On my Linux server, the device appeared as /dev/ttyUSB0 So […]
When building an image that is to be used on multiple machines of the same type, it’s useful to keep the drivers after running SYSPREP. To do this run the following prior to SYSPREP Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\Sysprep\Settings\sppnp Select Edit – New DWORD value Name the new value PersistAllDeviceInstalls Set to a value of 1 and […]
by