Labels

Android (1) Apache (1) bash (2) boost (2) C (37) C++ (5) cheatsheet (2) CLion (6) css (3) Debian (35) DL (17) dns (1) Docker (3) Dreamweaver (2) Eclipse (3) fail2ban (5) git (6) GitHub (5) Hacking (4) html (8) http (1) iOS (1) iPad (1) IRC (1) Java (34) javascript (3) Linux (186) Mac (22) Machine Learning (1) mySQL (54) Netbeans (7) Networking (1) Nexus (1) OpenVMS (6) Oracle (5) Pandas (3) php (17) Postgresql (8) Python (9) raid (1) RedHat (15) Samba (3) Slackware (54) SQL (14) ssh (1) svn (1) tar (1) ThinkPad (1) Virtualbox (4) Visual Basic (2) Visual Studio (1) Windows (8) wire (1)

Tuesday, 7 April 2020

To block, unblock or check IP addresses with iptables in Linux

To block or check IP addresses with iptables

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

The format for setting a cookie in php is as follows:

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

Server Settings for Dreamweaver to allow publishing to a site connected to locally.

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 below are examples of 2 triggers I set up on a database recently.

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.

Real examples with my_db:

The following will backup the structure, triggers, functions and procedures; 
mysqldump --host=[...] -udev -p --no-data --triggers --routines my_db > my_db_structure.sql
 
The following will backup the entire database, as above but including the data;
mysqldump --host=[...] -udev -p --triggers --routines my_db > my_db_all.sql

To restore a MySQL database

See this link here

shell> mysql -u root -p < dump.sql

Within mysql (first login, see below);
mysql> source dump.sql

To login to mysql, do;
mysql -u username -p

If the dump file does not create the database, then this must first be created;
shell> mysqladmin create dbname

Within mysql (this works for me);
mysql> CREATE DATABASE IF NOT EXISTS dbname; mysql> USE dbname; mysql> source dump.sql

Real example with my_db:
Firstly, ensure the database has been created by logging in and doing:
 
CREATE DATABASE mydb;
 
then;
 
mysql --host=[...] -udev -p my_db < my_db_all.sql
 
 
To backup and restore database users and grants, see here

Saturday, 29 February 2020

Monday, 24 February 2020

Connect to Postgres database with php

This extension enables PHP to connect to and use PostgreSQL databases.

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

The following commands will help determine the number and size of memory modules installed in a Linux system.

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.

In the project folder, project/nbproject/project.properties we can modify various attributes that affect the project properties, such as;

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

TO BE TESTED

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();