Hello,
you should not use shards, unless you really need them. Also, if you
upgraded from v0.8 to latest master, please update boss.config too.
On Monday, February 29, 2016 at 9:45:29 PM UTC+2, Mert Öztürk wrote:
>
> Hello,
>
> I am using the current CB master for OTP 18, and running erlang 18.2.
> In my local, everything was going fine with MySQL connection. Now i am
> trying to setup my CB app on remote vps but can not connect to MySQL. I
> checked a lot but couldnt figure out the problem.
> My db shards model looks like this in boss.config;
>
> {db_shards, [
> [
> {db_host, "localhost"},
> {db_adapter,mysql},
> {db_port, 3306},
> {db_write_mode, safe},
> {db_read_mode, master},
> {db_username, "root"},
> {db_password, "123456"},
> {db_name, "all_data"},
> {db_shard_id,all_data},
> {db_shard_models, [data1,data2,data3,data4,data5,data6]}
>
> ]
> ]},
>
> Although i check root password and all root privileges still can not
> connect to the database named "all_data" containing tables:
> data1,data2,data3,data4,data5,data6
> I get the following error;
>
> [error] gen_server <0.105.0> terminated with reason: no match of right
> hand value {connection_error,{error,failed_changing_database}} in
> boss_db_controller:'-make_shards/2-fun-0-'/4 line 370
> 14:32:16.358 [error] gen_server <0.104.0> terminated with reason: no match
> of right hand value {connection_error,{error,failed_changing_database}} in
> boss_db_controller:'-make_shards/2-fun-0-'/4 line 370
> 14:32:16.359 [error] gen_server <0.103.0> terminated with reason: no match
> of right hand value {connection_error,{error,failed_changing_database}} in
> boss_db_controller:'-make_shards/2-fun-0-'/4 line 370
> 14:32:16.359 [error] gen_server <0.102.0> terminated with reason: no match
> of right hand value {connection_error,{error,failed_changing_database}} in
> boss_db_controller:'-make_shards/2-fun-0-'/4 line 370
> 14:32:16.359 [error] gen_server <0.101.0> terminated with reason: no match
> of right hand value {connection_error,{error,failed_changing_database}} in
> boss_db_controller:'-make_shards/2-fun-0-'/4 line 370
> 14:32:16.382 [error] CRASH REPORT Process <0.105.0> with 0 neighbours
> exited with reason: no match of right hand value
> {connection_error,{error,failed_changing_database}} in
> boss_db_controller:'-make_shards/2-fun-0-'/4 line 370 in
> gen_server:terminate/7 line 826
> 14:32:16.383 [error] CRASH REPORT Process <0.104.0> with 0 neighbours
> exited with reason: no match of right hand value
> {connection_error,{error,failed_changing_database}} in
> boss_db_controller:'-make_shards/2-fun-0-'/4 line 370 in
> gen_server:terminate/7 line 826
> 14:32:16.383 [error] CRASH REPORT Process <0.103.0> with 0 neighbours
> exited with reason: no match of right hand value
> {connection_error,{error,failed_changing_database}} in
> boss_db_controller:'-make_shards/2-fun-0-'/4 line 370 in
> gen_server:terminate/7 line 826
> 14:32:16.383 [error] CRASH REPORT Process <0.102.0> with 0 neighbours
> exited with reason: no match of right hand value
> {connection_error,{error,failed_changing_database}} in
> boss_db_controller:'-make_shards/2-fun-0-'/4 line 370 in
> gen_server:terminate/7 line 826
> 14:32:16.384 [error] CRASH REPORT Process <0.101.0> with 0 neighbours
> exited with reason: no match of right hand value
> {connection_error,{error,failed_changing_database}} in
> boss_db_controller:'-make_shards/2-fun-0-'/4 line 370 in
> gen_server:terminate/7 line 826
> 14:32:16.384 [error] Supervisor {<0.100.0>,poolboy_sup} had child
> undefined started with {boss_db_controller,start_link,undefined} at
> <0.105.0> exit with reason no match of right hand value
> {connection_error,{error,failed_changing_database}} in
> boss_db_controller:'-make_shards/2-fun-0-'/4 line 370 in context
> child_terminated
> 14:32:16.384 [error] Supervisor {<0.100.0>,poolboy_sup} had child
> undefined started with {boss_db_controller,start_link,undefined} at
> <0.104.0> exit with reason no match of right hand value
> {connection_error,{error,failed_changing_database}} in
> boss_db_controller:'-make_shards/2-fun-0-'/4 line 370 in context
> child_terminated
> 14:32:16.385 [error] Supervisor {<0.100.0>,poolboy_sup} had child
> undefined started with {boss_db_controller,start_link,undefined} at
> <0.103.0> exit with reason no match of right hand value
> {connection_error,{error,failed_changing_database}} in
> boss_db_controller:'-make_shards/2-fun-0-'/4 line 370 in context
> child_terminated
> 14:32:16.385 [error] Supervisor {<0.100.0>,poolboy_sup} had child
> undefined started with {boss_db_controller,start_link,undefined} at
> <0.102.0> exit with reason no match of right hand value
> {connection_error,{error,failed_changing_database}} in
> boss_db_controller:'-make_shards/2-fun-0-'/4 line 370 in context
> child_terminated
> 14:32:16.386 [error] Supervisor {<0.100.0>,poolboy_sup} had child
> undefined started with {boss_db_controller,start_link,undefined} at
> <0.101.0> exit with reason no match of right hand value
> {connection_error,{error,failed_changing_database}} in
> boss_db_controller:'-make_shards/2-fun-0-'/4 line 370 in context
> child_terminated
>
> Your help would be appreciated.
> Regards
> Mert
>
>
>
--
You received this message because you are subscribed to the Google Groups
"ChicagoBoss" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
Visit this group at https://groups.google.com/group/chicagoboss.
To view this discussion on the web visit
https://groups.google.com/d/msgid/chicagoboss/6691936a-692c-48a8-a68d-9174b0e1714a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
