Netpap Documentation

mkdir:Cannot create directory ‘/.NVM’:Permission denied

(base) shockwave@Netpapverse:/home/shockwave$ nvm install v14.15
mkdir: cannot create directory ‘/.nvm’: Permission denied
mkdir: cannot create directory ‘/.nvm’: Permission denied
Downloading and installing node v14.15.5…
mkdir: cannot create directory ‘/.nvm’: Permission denied
creating directory /.nvm/.cache/bin/node-v14.15.5-linux-x64/files failed
Downloading https://nodejs.org/dist/v14.15.5/node-v14.15.5-linux-x64.tar.xz…
Warning: Failed to create the file                                                                                                                                                                        
Warning: /.nvm/.cache/bin/node-v14.15.5-linux-x64/node-v14.15.5-linux-x64.tar.x
Warning: z: No such file or directory
                                                                                                                                                                                                       0.0%curl: (23) Failure writing output to destination

Binary download from https://nodejs.org/dist/v14.15.5/node-v14.15.5-linux-x64.tar.xz failed, trying source.
grep: /.nvm/.cache/bin/node-v14.15.5-linux-x64/node-v14.15.5-linux-x64.tar.xz: No such file or directory
Provided file to checksum does not exist.
Binary download failed, trying source.
Clang v3.5+ detected! CC or CXX not specified, will use Clang as C/C++ compiler!
mkdir: cannot create directory ‘/.nvm’: Permission denied
creating directory /.nvm/.cache/src/node-v14.15.5/files failed
Downloading https://nodejs.org/dist/v14.15.5/node-v14.15.5.tar.xz…
Warning: Failed to create the file                                                                                                                                                                        
Warning: /.nvm/.cache/src/node-v14.15.5/node-v14.15.5.tar.xz: No such file or 
Warning: directory
curl: (23) Failure writing output to destination

Binary download from https://nodejs.org/dist/v14.15.5/node-v14.15.5.tar.xz failed, trying source.
grep: /.nvm/.cache/src/node-v14.15.5/node-v14.15.5.tar.xz: No such file or directory
Provided file to checksum does not exist.
(base) shockwave@Netpapverse:/home/shockwave$ nvm ls
               
->       system
mkdir: cannot create directory ‘/.nvm’: Permission denied
mkdir: cannot create directory ‘/.nvm’: Permission denied

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

(base) shockwave@Netpapverse:/home/shockwave$ nvm install v14.15

mkdir: cannot create directory ‘/.nvm’: Permission denied

Downloading and installing node v14.15.5…

mkdir: cannot create directory ‘/.nvm’: Permission denied

creating directory /.nvm/.cache/bin/node–v14.15.5–linux–x64/files failed

Downloading https://nodejs.org/dist/v14.15.5/node-v14.15.5-linux-x64.tar.xz…

Warning: Failed to create the file

Warning: /.nvm/.cache/bin/node–v14.15.5–linux–x64/node–v14.15.5–linux–x64.tar.x

Warning: z: No such file or directory

0.0%curl: (23) Failure writing output to destination

Binary download from https://nodejs.org/dist/v14.15.5/node-v14.15.5-linux-x64.tar.xz failed, trying source.

grep: /.nvm/.cache/bin/node–v14.15.5–linux–x64/node–v14.15.5–linux–x64.tar.xz: No such file or directory

Provided file to checksum does not exist.

Binary download failed, trying source.

Clang v3.5+ detected! CC or CXX not specified, will use Clang as C/C++ compiler!

mkdir: cannot create directory ‘/.nvm’: Permission denied

creating directory /.nvm/.cache/src/node–v14.15.5/files failed

Downloading https://nodejs.org/dist/v14.15.5/node-v14.15.5.tar.xz…

Warning: Failed to create the file

Warning: /.nvm/.cache/src/node–v14.15.5/node–v14.15.5.tar.xz: No such file or

Warning: directory

curl: (23) Failure writing output to destination

Binary download from https://nodejs.org/dist/v14.15.5/node-v14.15.5.tar.xz failed, trying source.

grep: /.nvm/.cache/src/node–v14.15.5/node–v14.15.5.tar.xz: No such file or directory

Provided file to checksum does not exist.

(base) shockwave@Netpapverse:/home/shockwave$ nvm ls

-> system

mkdir: cannot create directory ‘/.nvm’: Permission denied

How to solve it

(base) shockwave@Netpapverse:/home/shockwave$ export NVM_DIR=~/.nvm
(base) shockwave@Netpapverse:/home/shockwave$ . .nvm/nvm.sh

1 2	(base) shockwave@Netpapverse:/home/shockwave$ export NVM_DIR=~/.nvm (base) shockwave@Netpapverse:/home/shockwave$ . .nvm/nvm.sh

February 10, 2023

Enforce Case sensitive usernames in freeradius.

Solving Case Insensitivity Issues in Freeradius with MySQL

Introduction: When you install Freeradius with MySQL, you may encounter an issue where customers can log in regardless of the case sensitivity of their username. For example, “DFGT” and “DFGt” would both authorize successfully. This can be resolved by making a few changes to the Freeradius configuration files.

Problem: In a fresh installation of Freeradius with MySQL, the authorization check and reply queries are set to be case-insensitive. This means that the usernames are not stored in a case-sensitive manner, which can be a security issue for some applications.

radtest AL6RNs netpap localhost 3 testing123

 radtest AL6RNx netpap localhost 3 testing123
Sent Access-Request Id 68 from 0.0.0.0:51104 to 127.0.0.1:1819 length 76
	User-Name = “AL6RNx”
	User-Password = “AL6RNx”

Received Access-Accept Id 68 from 127.0.0.1:1819 to 0.0.0.0:0 length 68

1

2

3

4

5

6

radtest AL6RNx netpap localhost 3 testing123

Sent Access–Request Id 68 from 0.0.0.0:51104 to 127.0.0.1:1819 length 76

User–Name = “AL6RNx”

User–Password = “AL6RNx”

Received Access–Accept Id 68 from 127.0.0.1:1819 to 0.0.0.0:0 length 68

Which will authenticate similar to

 radtest AL6RNX netpap localhost 3 testing123
Sent Access-Request Id 68 from 0.0.0.0:51104 to 127.0.0.1:1819 length 76
	User-Name = “AL6RNX”
	User-Password = “AL6RNX”

Received Access-Accept Id 68 from 127.0.0.1:1819 to 0.0.0.0:0 length 68

1

2

3

4

5

6

radtest AL6RNX netpap localhost 3 testing123

Sent Access–Request Id 68 from 0.0.0.0:51104 to 127.0.0.1:1819 length 76

User–Name = “AL6RNX”

User–Password = “AL6RNX”

Received Access–Accept Id 68 from 127.0.0.1:1819 to 0.0.0.0:0 length 68

Solution:

To solve this.

Uncomment the code block below in the file

vim /etc/raddb/mods-config/sql/main/mysql/queries.conf

authorize_check_query = “\
	SELECT id, username, attribute, value, op \
	FROM ${authcheck_table} \
	WHERE username = BINARY ‘%{SQL-User-Name}’ \
	ORDER BY id”

authorize_reply_query = “\
	SELECT id, username, attribute, value, op \
	FROM ${authreply_table} \
	WHERE username = BINARY ‘%{SQL-User-Name}’ \
	ORDER BY id”

1

2

3

4

5

6

7

8

9

10

11

authorize_check_query = “\

SELECT id, username, attribute, value, op \

FROM ${authcheck_table} \

WHERE username = BINARY ‘%{SQL-User-Name}’ \

ORDER BY id”

authorize_reply_query = “\

SELECT id, username, attribute, value, op \

FROM ${authreply_table} \

WHERE username = BINARY ‘%{SQL-User-Name}’ \

ORDER BY id”

Comment back the following block of code

#authorize_check_query = “\
#	SELECT id, username, attribute, value, op \
#	FROM ${authcheck_table} \
#	WHERE username = ‘%{SQL-User-Name}’ \
#	ORDER BY id”

#authorize_reply_query = “\
#	SELECT id, username, attribute, value, op \
#	FROM ${authreply_table} \
#	WHERE username = ‘%{SQL-User-Name}’ \
#	ORDER BY id”

1

2

3

4

5

6

7

8

9

10

11

#authorize_check_query = “\

# SELECT id, username, attribute, value, op \

# FROM ${authcheck_table} \

# WHERE username = ‘%{SQL-User-Name}’ \

# ORDER BY id“

#authorize_reply_query = “\

# SELECT id, username, attribute, value, op \

# FROM ${authreply_table} \

# WHERE username = ‘%{SQL-User-Name}’ \

# ORDER BY id“

February 8, 2023

django.db.utils.DataError: (1406, “Data too long for column ‘data_id’ at row 1490”)

One of the ways this error occurs is when you have existing data that is a varchar and you want to convert to uuid

d=Data.objects.filter(data_id__icontains=”-“)
for x in d:
  x.data_id=str(x.data_id).replace(“-“,””)
  x.save()

1

2

3

4

d=Data.objects.filter(data_id__icontains=“-“)

for x in d:

x.data_id=str(x.data_id).replace(“-“,“”)

x.save()

February 8, 2023

How to Make Mikrotik an OpenVPN client

Download the openvpn ovpn profile. e.g mikrotik.ovpn

Ensure tls and tls cert are removed,lzo compression and openvpn supports tcp.

Navigate to mikrotik and click files

Click upload files

Click system > certificates ->Click Import

The import file will import the certificates.

Create a VPN profile.

Navigate to ppp -> profiles ->Click Add New.

Ensure you give profile a name and enable encryption.Leave other features in default state.

Create OVPN Client

Navigate to ppp -> interfaces ->Click add new ->Select ovpn client

Specify an arbitrary name for the client name.

Connect to:Specify openvpn server ip,available in the ip

port:Specify openvpn port

user:The ovpn profile name used increation of the openvpn client

profile:Specify the profile specified in the previous step.

mode:Specify ip

password:Leave password field blank.

Certificate:Specify the certificate identified with an underscore 1 or KT

Specifiy auth as sha1 and cipher as aes 256

The mikrotik should be able to connect to the vpn server.

February 1, 2023

Customize OPENVPN profile for Mikrotik client

Mikrotik support for vpn is quite versatile with several VPN clients/server setups to chose from,among them OPENVPN.

Facts to grasp before deployment of the openvpn:

Lacks support for

udp
lzo compression
tls
sha512

While deploying the ovpn file,make sure tls is disabled and the tls certificate absent.

Sample ovpn client for mikrotik

client
dev tun
proto tcp
remote PUBLIC IP PORT
resolv-retry infinite
nobind
persist-key
persist-tun
auth SHA1
cipher AES-256-CBC
ignore-unknown-option block-outside-dns
verb 3
—–BEGIN CERTIFICATE—– CA —–END CERTIFICATE—–

—–BEGIN CERTIFICATE—– cert—–END CERTIFICATE—–

—–BEGIN PRIVATE KEY—– Key—–END PRIVATE KEY—–

February 1, 2023

Blog

mkdir:Cannot create directory ‘/.NVM’:Permission denied

How to solve it

Enforce Case sensitive usernames in freeradius.

django.db.utils.DataError: (1406, “Data too long for column ‘data_id’ at row 1490”)

How to Make Mikrotik an OpenVPN client

Create a VPN profile.

Create OVPN Client

Customize OPENVPN profile for Mikrotik client

Sample ovpn client for mikrotik