Db_host_instance SQLEXPRESS when using mariadb?

SuiteCRM Forum - English Language
1

image
Should’t it say “mariadb” when you are running that and not Ms SQL?

Thanks in advance.

Kind regards
PowerQuest

2

I don’t think so. I have MySQL and I also see SQLEXPRESS in that value. It’s the default that the installer uses.

If it works, I think it’s better to leave it as SQLEXPRESS.

3

Ok, just wanted to double check sure to be sure.

Thank you! :+1:

Kind regards
PowerQuest

1 Like
4

@PowerQuest
Type of DB set two parameters db_type and db_manager.

  • 'db_type' => 'mysql','db_manager' => 'MysqliManager', for MySQL and MariaDB
  • 'db_type' => 'mssql','db_manager' => 'SqlsrvManager', for MS SQL Server
1 Like
5

Thank you! :heart: :ok_hand:

Kind regards
PowerQuest

6

Should not db_host_instance say mysql too then instead of SQLExpress?

7

So @p.konetskiy is this correct when using MariaDB?

image

8

@PowerQuest

I am using the following parameters for MariaDB.

  'dbconfig' => 
  array (
    'db_host_name' => '127.0.0.1',
    'db_host_instance' => 'SQLEXPRESS',
    'db_user_name' => '<user_name>',
    'db_password' => '<password>',
    'db_name' => '<db_name>',
    'db_type' => 'mysql',
    'db_port' => '',
    'db_manager' => 'MysqliManager',
  ),
1 Like
9

Thank you so much @p.konetskiy :heart: