Categories
Mastering Development System & Network

Migration of password hashes from glftpd 2.01 (PKCS5_PBKDF2_HMAC_SHA1) to proftpd + mod_sql_passwd

For migrating from the de-factor closed source glftpd 2.01 to proftpd I need to migrate password hashes of the user accounts from glftpd to proftpd. Reading about the topic I figured mod_sql_passwd should do the trick. I therefore set up my proftpd server like this: <global> SQLBackend mysql SQLAuthTypes Crypt SQLAuthenticate users groups SQLConnectInfo testdbuser@testdbhost […]

Categories
Mastering Development System & Network

Migration of password hashes from glftpd 2.01 (PKCS5_PBKDF2_HMAC_SHA1) to proftpd + mod_sql_passwd

For migrating from the de-factor closed source glftpd 2.01 to proftpd I need to migrate password hashes of the user accounts from glftpd to proftpd. Reading about the topic I figured mod_sql_passwd should do the trick. I therefore set up my proftpd server like this: <global> SQLBackend mysql SQLAuthTypes Crypt SQLAuthenticate users groups SQLConnectInfo testdbuser@testdbhost […]

Categories
Bitcoin Cryptocurrency Mastering Development

Bitcoin core Rpc EOF?

I using regtest to test bitcoin core rpc in golang. package main import ( “fmt” “github.com/toorop/go-bitcoind” ) const ( SERVER_HOST = “127.0.0.1” SERVER_PORT = 18444 USER = “test” PASSWD = “1234” USESSL = false ) func main() { bc, err := bitcoind.New(SERVER_HOST, SERVER_PORT, USER, PASSWD, USESSL) if err != nil { fmt.Println(err) } result, err […]

Categories
Linux Mastering Development

python script not running from crontab

This is one of the so many questions asked in the forums. I’ve a script that runs perfectly if I run it from the linux terminal. However when I let it run from crontab at a reboot it doesn’t work. I programmed a simple script that runs from the same directory as my script that […]

Categories
Mastering Development

PostgreSQL ECPG database connection issue

I am trying to connect to PostgreSQL database using ecpg program and I am getting below error. cc testecpg.c /tmp/ccSzqgA7.o: In function `main’: testecpg.c:(.text+0x5d): undefined reference to `ECPGconnect’ testecpg.c:(.text+0x62): undefined reference to `ECPGget_sqlca’ testecpg.c:(.text+0x70): undefined reference to `sqlprint’ collect2: error: ld returned 1 exit status testecpg.c file generated after executing ecpg testecpg.pgc /* Processed by […]

Categories
Development

GoDaddy MySQL Table not receiving my Insert/Update request

I’m writing (using pycharm) to a database with multiple tables (I didn’t create this database, it was done by another developer). Table 1 & 2, I can write to (Insert, Update, etc), Table 3 is not receiving my commands from my pycharm (there are no error msgs on pycharm’s logs or sentry.io), but the auto […]

Categories
Development

Close connection to a database after finishing the query

So, basically,someone was telling me today that the way I Query my database was bad before I never close the connection after finishing and thus I probably had many open connection with the database running simultaneously. I looked online however, I did not get a straight answer. I am using MySQL Mariadb. and this is […]

Categories
Development

NameError instance of WindowManager is not defined kivy

I’m getting a NameError saying the instance of my WindowManager isn’t defined but I am defining it in the build class sm = WindowManager(). This used to work but now throws this error and I can’t see what’s been changed. When the user logs in it should transfer them to the information page but instead […]

Categories
Development

Jenkins Post Data via API

I would like to build jenkins job via API call. I have installed the python-jenkins but able to grase on how to POST data from a file and import the data into given parameters. The link to jenkins build looks like this: <host> job/prod/job/DNS/job/DDNSv1/build the parameters: registration_actions and entries field. Need help to create a […]

Categories
Development

AES_ENCRYPT() and AES_DECRYPT not working properly to store values in mysql using xampp server and python flask

I am learning python flask and developing a web page where I can register and store user details in encrypted format in MySQL database using XAMPP server and decrypting the same to verify user details during login. Here, while storing the encrypted password in database, the AES_ENCRYPT function is encrypting the string ‘password’ itself and […]