No output on Windows when using mysql lib

[fatihkizmaz]

V version: V 0.2.4 c01a8a1.3291c59
OS: Windows 10 Pro v19044 64 bit

What did you do?
I am trying to test mysql connection on windows platform. I followed all the instructions (installed mysql, copied include and lib directories to directory thirdparty/mysql), but could not execute a basic test successfully. The fact is, it does not give any error, also it outputs nothing!

The sample code i used to test:

import mysql

fn main() {
	println('connecting..')
	mut conn := mysql.Connection{
		host: 'localhost'
		port: 3306
		username: 'root'
		password: ''
		dbname: 'mysql'
	}
	conn.connect() ?
	println('querying..')
	res := conn.query('show tables') ?
	for row in res.rows() {
		println(row.vals.join(', '))
	}
	println('disconnecting..')
	conn.close()
}

An image that shows terminal after running sample file. No output!

[Ouri028]

Getting the same issue on my end.

pub fn initialize_database() {
	if utils.get_env("FRESH_INITIALZE") == "true" {
		mut db := database.db_conn() or {panic("UNABLE TO CONNECT TO DATABASE WITH ERROR: $err")}
		sql db {
			create table entity.Users
			create table entity.Accounts
			create table entity.Roles
			create table entity.Active_Agents
			create table entity.Agent_Statuses
			create table entity.Stream_Interactions
		}
		logger.info("Fresh initialization has been completed.")
		db.close()
	} else {
		logger.info("Fresh initialization has been disabled.")
	}
}

C:\Users\Sylvester\Documents\Github\v-lang\vidi_widget_core>v run vidi_widget_core.v

C:\Users\Sylvester\Documents\Github\v-lang\vidi_widget_core>

[revosw]

I am not sure if this is the exact same error as you have encountered 3 years ago, but I missed an important step when I first tried to reproduce this.

• I downloaded mysql community edition as a zip
• I extracted the zip and moved the mysql contents to thirdparty/mysql
• Initialized the data directory by running ./mysqld.exe --initialize-insecure --console
• started the server by running ./mysqld.exe
• I made an example program

import db.mysql

fn main() {
	println('connecting..')
	mut conn := mysql.connect(
		host: 'localhost'
		port: 3306
		username: 'root'
		password: ''
		dbname: 'mysql'
	)!
	println('querying..')
	res := conn.query('show tables')!
	for row in res.rows() {
		println(row.vals.join(', '))
	}
	println('disconnecting..')
	conn.close()!
}

• Compiled with v run .

I also got absolutely no output. But when running powershell's $LASTEXITCODE, it showed -1073741515, which corresponds to 0x3FFFFECB. Simple searching didn't lead me to anything more specific than something related to linking libmysql.dll.

The problem was that I hadn't added thirdparty/mysql/bin and thirdparty/mysql/lib to PATH. After adding to PATH, the program ran exactly as it should.

[revosw]

@medvednikov Can close the issue, as the conditions for running the program back then isn't quite the same as now. And it works for me, so better if a new issue is posted

[JalonSolov]

Sounds like it very well could be the same problem, in which case at least the documentation on how to set things up on Windows needs to be improved. We should keep this one open to handle that.