Heisenberg - Digital Alchemist, Software Architect, Automation Specialist and Mechanical Engineer.
Labels
Tuesday, 7 April 2020
To block, unblock or check IP addresses with iptables in Linux
The format to block and IP address is as follows:
iptables -A INPUT -s BAN-IP-ADDRESS -j DROP
iptables -A INPUT -s BAN-IP-ADDRESS/MASK -j DROP
To block an IP address, use the following;
iptables -A INPUT -s 192.168.254.100 -j DROP
To view all blocked IP addresses, do;
iptables -L INPUT -v -n
OR
iptables -L INPUT -v -n | less
OR (especially if blocked with fail2ban) **
iptables -L -n --line
To check for a specific IP address, do;
iptables -L INPUT -v -n | grep "192.168.254.100"
To unblock an IP address, do;
iptables -D INPUT -s 192.168.254.100 -j DROP
Alternatively to unblock an entry blocked with fail2ban (see ** above) do;
iptables -L -n --line
then find the IP address you wish to unban.
then do
iptables -D ruleName n
where ruleName is the rule name associated with the banned IP
and n is the number associated with the banned IP
ref: https://www.cyberciti.biz/faq/linux-howto-check-ip-blocked-against-iptables/
Set and retrieve cookies with php
setcookie(name, value, expire, path, domain, security);
I only use the name, value and expire, where expire is in seconds, so;
time() + 24*60*60 is 1 day.
Tuesday, 24 March 2020
Server Settings for Dreamweaver
In my example, my web server is on my local network, accessible from the internet, so to prevent setting up firewall rules and port forwarding to allow external access to FTP etc, I would rather connect using the local private IP address.
However, previously when attempting this, the default directory was the home directory for the user used which is no good.
The screen shot below, shows how to properly accomplish this;
Saturday, 7 March 2020
MySQL triggers
The first one was to evaluate a condition on inserting a new record, while the second one was to evaluate the same condition but this time on update.
Sunday, 1 March 2020
Backup and restore MySQL database
To backup a MySQL database
See this link here
shell> mysqldump [arguments] > file_name
shell> mysqldump --all-databases > dump.sql
shell> mysqldump --triggers --routines --all-databases > dump.sql
shell> mysqldump --databases db1 db2 db3 > dump.sql
shell> mysqldump --databases dbname > dump.sql
OR omit the --databases
shell> mysqldump test > dump.sql
To dump only specific tables from a database use;
shell> mysqldump dbmane table1 table3 table7 > dump.sql
To dump only the structure from a database use;
shell> mysqldump --no-data dbmane > dump.sql
shell> mysqldump --d dbmane > dump.sql
Note: -d includes the triggers.
To dump only the routines from a all databases use;
mysqldump -u username -p -n -t -d -R --all-databases > routines.sql
To add the host 192.168.254.198 and the user root, do;
shell> mysqldump --host=192.168.254.198 --port=3307 -u root -p dbmane > dump.sql
See also my post here for details on how to simply copy the table structure.
mysqldump --host=[...] -udev -p --no-data --triggers --routines my_db > my_db_structure.sql
To restore a MySQL database
To login to mysql, do;
mysql -u username -p
Saturday, 29 February 2020
Convert PostgreSQL database to MySQL
Monday, 24 February 2020
Connect to Postgres database with php
This is specifically for Slackware.
1) install php-pgsql
Slackbuild install file ready for 14.2 here
Slack build page here
2) To enable the pgsql extension for php, go to /etc/php.d/pgsql.iniand uncomment the line:
; extension=pgsql.so
Friday, 14 February 2020
Physical memory modules installed in Linux
dmidecode -t memory
dmidecode -t memory | grep -i size
dmidecode -t 16
dmidecode -t 17
lshw -class memory
Wednesday, 12 February 2020
Java Netbeans project.properties, manifest file, code signing certificates and jnlp files.
See the # Optional override of default tags.
manifest.custom.permissions=all-permissions
Specifically if using a jnlp file, then the permissions and codebase options should match otherwise Java security might not allow application to launch.
In Netbeans, under webstart, choose user defined and enter full codebase, also note this post re having different jar files with different certificates.
For more details, see here:
https://blog.david14.com/2020/07/application-blocked-by-java-security.html
See here for a walkthrough; https://docs.oracle.com/javase/tutorial/deployment/webstart/deploying.html
Also see here: https://www.oracle.com/technical-resources/articles/javase/ds-jnlp-javawebstart.html
Tuesday, 11 February 2020
Printing via UDP in Python
import socket
import system
udpSocket=socket.socket(socket.AF_INET,socket.SOCK_DGRAM)
message ="SEND THIS TO ZEBRA"
ip='192.168.0.100'
port=20000
udpSocket.sendto(message,(ip,port))
Socket clientSocket = new Socket(AddressFamily.InterNetwork,
SocketType.Stream, ProtocolType.Tcp);
clientSocket.NoDelay = true;
IPAddress ip = IPAddress.Parse("192.168.192.6");
IPEndPoint ipep = new IPEndPoint(ip, 9100);
clientSocket.Connect(ipep);
byte[] fileBytes = File.ReadAllBytes("test.txt");
clientSocket.Send(fileBytes);
clientSocket.Close();
