public void TestConnectingSocketBadHostName() { MySqlConnectionStringBuilder connStr = new MySqlConnectionStringBuilder(Connection.ConnectionString); connStr.Server = "foobar"; MySqlConnection c = new MySqlConnection(connStr.GetConnectionString(true)); var ex = Assert.Throws <MySqlException>(() => c.Open()); Assert.AreEqual((int)MySqlErrorCode.UnableToConnectToHost, ex.Number); }
public void Keepalive() { MySqlConnectionStringBuilder connStr = new MySqlConnectionStringBuilder(Connection.ConnectionString); connStr.Keepalive = 1; using (MySqlConnection c = new MySqlConnection(connStr.GetConnectionString(true))) { c.Open(); } }
public MySqlManager(ILogger log, MySqlConnectionStringBuilder masterConnectionString) { this.log = log; MasterConnectionString = new MySqlConnectionStringBuilder(masterConnectionString.GetConnectionString(true)) { Database = null }; MySqlDumpPath = "mysqldump"; MySqlPath = "mysql"; }
public void Setup(TestBase testClass, bool reinitDatabase = false) { if (!String.IsNullOrEmpty(Namespace) && !reinitDatabase) { return; } Debug.Assert(testClass != null); TestClass = testClass; Namespace = testClass.GetType().Name.ToLower(); string ns = Namespace.Length > 10 ? Namespace.Substring(0, 10) : Namespace; BaseDBName = "db-" + ns + "-"; BaseUserName = "******" + ns + "-"; var settings = new MySqlConnectionStringBuilder(); settings.Server = "localhost"; var port = Environment.GetEnvironmentVariable("MYSQL_PORT"); settings.Port = port == null ? 3306 : UInt32.Parse(port); settings.UserID = "root"; settings.Password = null; #if !(NETCOREAPP1_1 || NETCOREAPP2_2) var memName = Environment.GetEnvironmentVariable("MYSQL_MEM"); settings.SharedMemoryName = memName == null ? "MySQLSocket" : memName; var pipeName = Environment.GetEnvironmentVariable("MYSQL_PIPE"); settings.PipeName = pipeName == null ? "MySQLSocket" : pipeName; #endif settings.PersistSecurityInfo = true; settings.AllowUserVariables = true; settings.Pooling = false; settings.IgnorePrepare = false; settings.ConnectionTimeout = 600; TestClass.AdjustConnectionSettings(settings); MaxPacketSize = 1000 * 1024; RootSettings = new MySqlConnectionStringBuilder(settings.GetConnectionString(true)); Settings = new MySqlConnectionStringBuilder(settings.GetConnectionString(true)); Version = GetVersion(); InitializeDatabase(); }
public MySQL(MySQLConnectData connectData) { MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder(); builder.Server = connectData.Server; builder.Port = connectData.Port; builder.UserID = connectData.UserID; builder.Password = connectData.Password; builder.Database = connectData.DataBase; _connection = new MySqlConnection(builder.GetConnectionString(true)); }
private MySqlConnection GetConnection() { var builder = new MySqlConnectionStringBuilder(); builder.Server = serverAddress; builder.Port = 4309; builder.Database = "shorewarecdr"; builder.UserID = "st_cdrupdate"; builder.Password = "******"; return(new MySqlConnection(builder.GetConnectionString(true))); }
internal static String getConnectionString() { var Builder = new MySqlConnectionStringBuilder(); Builder.Server = oBEUMySQL.ServerName; Builder.Port = oBEUMySQL.Port; Builder.UserID = oBEUMySQL.Username; Builder.Password = oBEUMySQL.Password; Builder.SslMode = MySqlSslMode.None; return(Builder.GetConnectionString(true)); }
/// <summary> /// Creates a new MySqlConnection object with the exact same ConnectionString value /// </summary> /// <returns>A cloned MySqlConnection object</returns> object ICloneable.Clone() { MySqlConnection clone = new MySqlConnection(); string connectionString = settings.GetConnectionString(true); if (connectionString != null) { clone.ConnectionString = connectionString; } return(clone); }
public DB_Connect() { builder = new MySqlConnectionStringBuilder(); conn = new MySqlConnection(); builder.Database = "mscDB"; // Сюда надо записать правильные значения потом builder.UserID = "root"; builder.Password = ""; builder.Server = "localhost"; conn.ConnectionString = builder.GetConnectionString(true); conn.Open(); }
public MyCatRelationalConnection CreateMasterConnection() { var csb = new MySqlConnectionStringBuilder(ConnectionString) { Database = "MyCat", Pooling = false }; var optionsBuilder = new DbContextOptionsBuilder(); optionsBuilder.UseMyCat(csb.GetConnectionString(true)); return new MyCatRelationalConnection(optionsBuilder.Options, Logger); }
public void TestConnectingSocketBadDbName() { MySqlConnectionStringBuilder connStr = new MySqlConnectionStringBuilder(Connection.ConnectionString); connStr.Password = "******"; MySqlConnection c = new MySqlConnection(connStr.GetConnectionString(true)); var exception = Record.Exception(() => c.Open()); Assert.NotNull(exception); Assert.IsType <MySqlException>(exception); }
protected static void CreateConnection(string server, string bd, string login, string pass) { MySqlConnectionStringBuilder sb = new MySqlConnectionStringBuilder(); sb.Server = "localhost"; sb.Database = "taximanager_db"; sb.UserID = "root"; sb.Password = "******"; sb.CharacterSet = "utf8"; connection = new MySqlConnection(sb.GetConnectionString(true)); }
// Save button clicked private void btn_save_Click(object sender, EventArgs e) { // Save the new values MySqlConnectionStringBuilder builder_p = new MySqlConnectionStringBuilder(); builder_p.Server = tb_server_p.Text.Trim(); if (!String.IsNullOrWhiteSpace(tb_port_p.Text)) { builder_p.Port = uint.Parse(tb_port_p.Text); } else { builder_p.Port = defaultPort; } builder_p.Database = tb_dbname_p.Text.Trim(); builder_p.UserID = tb_username_p.Text.Trim(); builder_p.Password = tb_password_p.Text.Trim(); MySqlConnectionStringBuilder builder_b = new MySqlConnectionStringBuilder(); builder_b.Server = tb_server_b.Text.Trim(); if (!String.IsNullOrWhiteSpace(tb_port_b.Text)) { builder_b.Port = uint.Parse(tb_port_b.Text); } else { builder_b.Port = defaultPort; } builder_b.Database = tb_dbname_b.Text.Trim(); builder_b.UserID = tb_username_b.Text.Trim(); builder_b.Password = tb_password_b.Text.Trim(); Exception ex_p; Exception ex_b; if (validateConnection(builder_p, out ex_p)) { if (validateConnection(builder_b, out ex_b)) { save(builder_p.GetConnectionString(true), builder_b.GetConnectionString(true)); this.Close(); } else { MessageBox.Show("There is a problem with the backup connection configuration!" + Environment.NewLine + "Please verify that the configuration entered is correct." + Environment.NewLine + Environment.NewLine + "(" + ex_b.Message + ")", "Backup Connection Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("There is a problem with the primary connection configuration!" + Environment.NewLine + "Please verify that the configuration entered is correct." + Environment.NewLine + Environment.NewLine + "(" + ex_p.Message + ")", "Primary Connection Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void ConnectDb(string UserId, string Password, string Database = "world", string Hostname = "localhost") { var sql = new MySqlConnectionStringBuilder(); sql.Password = Password; sql.Database = Database; sql.UserID = UserId; sql.Server = Hostname; var dbCon = new MySqlConnection(sql.GetConnectionString(true)); Db = new TrinityDB(dbCon); }
public void InvalidCast() { executeSQL(String.Format("CREATE FUNCTION `{0}`.`MyTwice`( val int ) RETURNS INT BEGIN return val * 2; END;", Connection.Database), true); executeSQL(String.Format("CREATE PROCEDURE `{0}`.`spMyTwice`( out result int, val int ) BEGIN set result = val * 2; END;", Connection.Database), true); string user = Fixture.CreateUser("1", "123"); executeSQL(String.Format("GRANT EXECUTE ON FUNCTION `{0}`.`MyTwice` TO '{1}'@'localhost';", Connection.Database, user), true); executeSQL(String.Format("GRANT EXECUTE ON PROCEDURE `{0}`.`spMyTwice` TO '{1}'@'localhost'", Connection.Database, user), true); if (Connection.driver.Version.isAtLeast(8, 0, 1)) { executeSQL("GRANT SELECT ON TABLE mysql.db TO 'user1'@'localhost'", true); } else { executeSQL("GRANT SELECT ON TABLE mysql.proc TO 'user1'@'localhost'", true); } executeSQL("FLUSH PRIVILEGES", true); MySqlConnectionStringBuilder connStr = new MySqlConnectionStringBuilder(Connection.ConnectionString); connStr.UserID = user; connStr.Password = "******"; MySqlConnection con = new MySqlConnection(connStr.GetConnectionString(true)); // Invoke the function var cmd = con.CreateCommand(); using (con) { con.Open(); cmd.CommandText = "MyTwice"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new MySqlParameter("val", System.DBNull.Value)); cmd.Parameters.Add("@p", MySqlDbType.Int32); cmd.Parameters[1].Direction = ParameterDirection.ReturnValue; cmd.Parameters[0].Value = 20; cmd.ExecuteNonQuery(); Assert.Equal(cmd.Parameters[1].Value, 40); cmd.CommandText = "spMyTwice"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.Add(new MySqlParameter("result", System.DBNull.Value)); cmd.Parameters.Add("val", MySqlDbType.Int32); cmd.Parameters[0].Direction = ParameterDirection.Output; cmd.Parameters[1].Value = 20; cmd.ExecuteNonQuery(); Assert.Equal(cmd.Parameters[0].Value, 40); } }
public EmailStatusUpdateWorker(ILogger <EmailStatusUpdateWorker> logger, IConfiguration configuration, IModel channel, IEmailRepository emailRepository) { if (configuration is null) { throw new ArgumentNullException(nameof(configuration)); } _logger = logger ?? throw new ArgumentNullException(nameof(logger)); _channel = channel ?? throw new ArgumentNullException(nameof(channel)); _emailRepository = emailRepository ?? throw new ArgumentNullException(nameof(emailRepository)); _storedEmailStatusUpdatingQueueId = configuration.GetSection(_queuesConfigurationSection) .GetValue <string>(_emailStatusUpdateQueueParameter); _channel.QueueDeclare(_storedEmailStatusUpdatingQueueId, true, false, false, null); _consumer = new AsyncEventingBasicConsumer(_channel); _consumer.Received += MessageRecieved; try { var conStrBuilder = new MySqlConnectionStringBuilder(); var databaseSection = configuration.GetSection("Database"); conStrBuilder.Server = databaseSection.GetValue("Host", "localhost"); conStrBuilder.Port = databaseSection.GetValue <uint>("Port", 3306); conStrBuilder.UserID = databaseSection.GetValue("Username", ""); conStrBuilder.Password = databaseSection.GetValue("Password", ""); conStrBuilder.Database = databaseSection.GetValue("DatabaseName", ""); conStrBuilder.SslMode = MySqlSslMode.None; QSMain.ConnectionString = conStrBuilder.GetConnectionString(true); var db_config = FluentNHibernate.Cfg.Db.MySQLConfiguration.Standard .Dialect <NHibernate.Spatial.Dialect.MySQL57SpatialDialect>() .ConnectionString(QSMain.ConnectionString); OrmConfig.ConfigureOrm(db_config, new System.Reflection.Assembly[] { System.Reflection.Assembly.GetAssembly(typeof(Vodovoz.HibernateMapping.OrganizationMap)), System.Reflection.Assembly.GetAssembly(typeof(QS.Banks.Domain.Bank)), System.Reflection.Assembly.GetAssembly(typeof(QS.HistoryLog.HistoryMain)), System.Reflection.Assembly.GetAssembly(typeof(QS.Project.HibernateMapping.TypeOfEntityMap)), System.Reflection.Assembly.GetAssembly(typeof(QS.Project.Domain.UserBase)), System.Reflection.Assembly.GetAssembly(typeof(QS.Attachments.HibernateMapping.AttachmentMap)) }); QS.HistoryLog.HistoryMain.Enable(); } catch (Exception ex) { _logger.LogCritical(ex, "Ошибка чтения конфигурационного файла."); return; } }
public MysqlWrapper(string a_host, string a_user, string a_password, string a_database) { //the class constructor //sets the values of the connection string to the values of the parameters of the constructor conString.Server = a_host; conString.UserID = a_user; conString.Password = a_password; conString.Database = a_database; //sets the value of the connection variable using the connectionstring (true indicates that the password has to be included) con = new MySqlConnection(conString.GetConnectionString(true)); }
String CreateDatabaseConnectionString() { MySqlConnectionStringBuilder strBuilder = new MySqlConnectionStringBuilder(); strBuilder.Database = DatabaseName; strBuilder.Server = Host; strBuilder.UserID = UserId; strBuilder.Password = Password; strBuilder.Pooling = false; strBuilder.Port = uint.Parse(Port); connectString = strBuilder.GetConnectionString(true); return(connectString); }
private string GetConnectionString(string server, string uid, string pwd, string db, uint timeout) { MySqlConnectionStringBuilder connectionString = new MySqlConnectionStringBuilder(); connectionString.Server = server; connectionString.UserID = uid; connectionString.Password = pwd; connectionString.Database = db; connectionString.ConnectionTimeout = timeout; //不使用连接池 connectionString.Pooling = false; return(connectionString.GetConnectionString(true)); }
public MySqlRelationalConnection CreateMasterConnection() { var csb = new MySqlConnectionStringBuilder(ConnectionString) { Database = "mysql", Pooling = false }; var optionsBuilder = new DbContextOptionsBuilder(); optionsBuilder.UseMySql(csb.GetConnectionString(true)); return(new MySqlRelationalConnection(optionsBuilder.Options, Logger)); }
public void create_basic_connectionString_with_IntegratedSecurity() { MySqlConnectionString mySqlConnectionStringExpected = new MySqlConnectionString() { Server = "server", Database = "database", IntegratedSecurity = true }; MySqlConnectionString mySqlConnectionStringBuilder = new MySqlConnectionStringBuilder("server", "database"); Assert.AreEqual(mySqlConnectionStringExpected.GetConnectionString(), mySqlConnectionStringBuilder.GetConnectionString()); }
public void TestPersistSecurityInfoCachingPasswords() { MySqlConnectionStringBuilder connStr = new MySqlConnectionStringBuilder(Connection.ConnectionString); // Persist Security Info = true means that it should be returned connStr.PersistSecurityInfo = true; MySqlConnection c = new MySqlConnection(connStr.GetConnectionString(true)); c.Open(); c.Close(); MySqlConnectionStringBuilder afterOpenSettings = new MySqlConnectionStringBuilder(c.ConnectionString); Assert.AreEqual(connStr.Password, afterOpenSettings.Password); // Persist Security Info = false means that it should not be returned connStr.PersistSecurityInfo = false; c = new MySqlConnection(connStr.GetConnectionString(true)); c.Open(); c.Close(); afterOpenSettings = new MySqlConnectionStringBuilder(c.ConnectionString); Assert.True(String.IsNullOrEmpty(afterOpenSettings.Password)); }
public void DontAllowBatching() { MySqlConnectionStringBuilder connStr = new MySqlConnectionStringBuilder(Connection.ConnectionString); connStr.AllowBatch = false; connStr.CharacterSet = "utf8"; using (MySqlConnection c = new MySqlConnection(connStr.GetConnectionString(true))) { c.Open(); MySqlCommand cmd = new MySqlCommand("SELECT 1", c); cmd.ExecuteScalar(); } }
string GetMySqlConnectionString() { var csBuilder = new MySqlConnectionStringBuilder { Port = 3306, Password = "******", UserID = "root", Server = "localhost", Database = "sys" }; return(csBuilder.GetConnectionString(true)); }
public static MySqlConnection GetConnection() { var connBuilder = new MySqlConnectionStringBuilder(); connBuilder.Server = SQL_Host; connBuilder.UserID = SQL_User; connBuilder.Password = SQL_Password; connBuilder.Database = SQL_Database; connBuilder.Port = SQL_Port; connBuilder.Pooling = true; return(new MySqlConnection(connBuilder.GetConnectionString(true))); }
public void OneTimeSetUp() { Namespace = this.GetType().Name.ToLower(); string ns = Namespace.Length > 10 ? Namespace.Substring(0, 10) : Namespace; BaseDBName = "db-" + ns + "-"; BaseUserName = "******" + ns + "-"; var settings = new MySqlConnectionStringBuilder(); settings.Server = "localhost"; var port = Environment.GetEnvironmentVariable("MYSQL_PORT"); settings.Port = port == null ? 3306 : UInt32.Parse(port); settings.UserID = "root"; settings.Password = null; #if NET452 var memName = Environment.GetEnvironmentVariable("MYSQL_MEM"); settings.SharedMemoryName = memName == null ? "MySQLSocket" : memName; var pipeName = Environment.GetEnvironmentVariable("MYSQL_PIPE"); settings.PipeName = pipeName == null ? "MySQLSocket" : pipeName; #endif settings.PersistSecurityInfo = true; settings.AllowUserVariables = true; settings.Pooling = false; settings.ConnectionTimeout = 600; AdjustConnectionSettings(settings); MaxPacketSize = 1000 * 1024; RootSettings = new MySqlConnectionStringBuilder(settings.GetConnectionString(true)); Settings = new MySqlConnectionStringBuilder(settings.GetConnectionString(true)); Version = GetVersion(); Debug.Assert(!string.IsNullOrEmpty(BaseDBName)); InitializeDatabase(); Connection = GetConnection(false); Root = GetConnection(true); }
public DBControl(DBControl db) { this.serv = db.serv; this.user = db.user; this.passw = db.passw; this.db = db.db; MySqlConnectionStringBuilder stringBuilder = new MySqlConnectionStringBuilder(); stringBuilder.Server = serv; stringBuilder.Password = passw; stringBuilder.UserID = user; stringBuilder.Database = this.db; connection = new MySqlConnection(stringBuilder.GetConnectionString(false)); }
public void PersistSecurityInfo() { MySqlConnectionStringBuilder connStr = new MySqlConnectionStringBuilder(Connection.ConnectionString); connStr.PersistSecurityInfo = false; Assert.False(String.IsNullOrEmpty(connStr.Password)); MySqlConnection c = new MySqlConnection(connStr.GetConnectionString(true)); c.Open(); c.Close(); connStr = new MySqlConnectionStringBuilder(c.ConnectionString); Assert.True(String.IsNullOrEmpty(connStr.Password)); }
public DBController() { MySqlConnectionStringBuilder connStr = new MySqlConnectionStringBuilder { Server = "158.36.13.131", UserID = "dokumentpartner", Password = "******", Database = "bachelor", SslMode = MySqlSslMode.None }; conn = new MySqlConnection(connStr.GetConnectionString(true)); conn.Open(); }
public void TestConnectingSocketBadHostName() { MySqlConnectionStringBuilder connStr = new MySqlConnectionStringBuilder(Connection.ConnectionString); connStr.Server = "foobar"; MySqlConnection c = new MySqlConnection(connStr.GetConnectionString(true)); var exception = Record.Exception(() => c.Open()); Assert.NotNull(exception); Assert.IsType <MySqlException>(exception); MySqlException ex = exception as MySqlException; Assert.Equal((int)MySqlErrorCode.UnableToConnectToHost, ex.Number); }
public DBControl(string server, string uid, string password, string database) { serv = server; user = uid; passw = password; db = database; MySqlConnectionStringBuilder stringBuilder = new MySqlConnectionStringBuilder(); stringBuilder.Server = serv; stringBuilder.UserID = user; stringBuilder.Password = passw; stringBuilder.Database = db; connection = new MySqlConnection(stringBuilder.GetConnectionString(false)); }
public void SettingValueMultipeTimes() { MySqlConnectionStringBuilder s = new MySqlConnectionStringBuilder(); s["database"] = "test"; s["database"] = "test2"; Assert.AreEqual("database=test2", s.GetConnectionString(false)); }