New Install: Can't connect to port 5433

New install locally to mac os.

+--------------------------------------------------------------------------------------------------+
|                                            yugabyted                                             |
+--------------------------------------------------------------------------------------------------+
| Status              : Running. Leader Master is present                                          |
| Web console         : http://127.0.0.1:7000                                                      |
| JDBC                : jdbc:postgresql://127.0.0.1:5433/yugabyte?user=yugabyte&password=yugabyte  |
| YSQL                : bin/ysqlsh   -U yugabyte -d yugabyte                                       |
| YCQL                : bin/ycqlsh   -u cassandra                                                  |
| Data Dir            : /Users/paul/var/data                                                       |
| Log Dir             : /Users/paul/var/logs                                                       |
| Universe UUID       : fd3952ea-dc93-4cf3-8d8e-28d9e24f823a                                       |
+--------------------------------------------------------------------------------------------------+

I can connect to the web admin, cassandra endpoint. But not 5433.

Pauls-MacBook-Pro:yugabyte paul$ bin/ysqlsh   -U yugabyte -d yugabyte
ysqlsh: could not connect to server: Connection refused
	Is the server running on host "localhost" (::1) and accepting
	TCP/IP connections on port 5433?
could not connect to server: Connection refused
	Is the server running on host "localhost" (127.0.0.1) and accepting
	TCP/IP connections on port 5433?

Log file is below.

Pauls-MacBook-Pro:logs paul$ cat yugabyted.log
[yugabyted start] 2022-03-20 11:31:58,613 INFO:  | 0.0s | cmd = start using config file: /Users/paul/var/conf/yugabyted.conf (args.config=None)
[yugabyted start] 2022-03-20 11:31:58,627 INFO:  | 0.0s | Found directory /private/var/lib/yugabyte/bin for file yb-admin
[yugabyted start] 2022-03-20 11:31:58,627 INFO:  | 0.0s | Starting yugabyted...
[yugabyted start] 2022-03-20 11:31:58,632 INFO:  | 0.0s | Daemon grandchild process begins execution.
[yugabyted start] 2022-03-20 11:31:58,633 INFO:  | 0.0s | yugabyted started running with PID 1350.
[yugabyted start] 2022-03-20 11:31:58,634 ERROR:  | 0.0s | Error changing RLIMIT_NOFILE from 4864 to 64000: current limit exceeds maximum limit
[yugabyted start] 2022-03-20 11:31:58,635 WARNING:  | 0.0s | WARNING: Failed to meet recommended settings. Ulimits too low - open_files.
Note yugabyted will still run, although it may fail for larger workloads. For more info, see https://docs.yugabyte.com/latest/deploy/manual-deployment/system-config

[yugabyted start] 2022-03-20 11:31:58,636 INFO:  | 0.0s | Found directory /private/var/lib/yugabyte/bin for file yb-master
[yugabyted start] 2022-03-20 11:31:58,637 INFO:  | 0.0s | Found directory /private/var/lib/yugabyte/bin for file yb-tserver
[yugabyted start] 2022-03-20 11:31:58,638 INFO:  | 0.0s | About to start master with cmd /private/var/lib/yugabyte/bin/yb-master --stop_on_parent_termination --undefok=stop_on_parent_termination --fs_data_dirs=/Users/paul/var/data --webserver_interface=0.0.0.0 --metrics_snapshotter_tserver_metrics_whitelist=handler_latency_yb_tserver_TabletServerService_Read_count,handler_latency_yb_tserver_TabletServerService_Write_count,handler_latency_yb_tserver_TabletServerService_Read_sum,handler_latency_yb_tserver_TabletServerService_Write_sum,disk_usage,cpu_usage,node_up --yb_num_shards_per_tserver=1 --ysql_num_shards_per_tserver=1 --cluster_uuid=fd3952ea-dc93-4cf3-8d8e-28d9e24f823a --rpc_bind_addresses=127.0.0.1:7100 --server_broadcast_addresses=127.0.0.1:7100 --replication_factor=1 --use_initial_sys_catalog_snapshot --server_dump_info_path=/Users/paul/var/data/master-info --master_enable_metrics_snapshotter=true --webserver_port=7000 --default_memory_limit_to_ram_ratio=0.35 --instance_uuid_override=3a4d4d8e20414f65809ce952793572a2 --master_addresses=127.0.0.1:7100
[yugabyted start] 2022-03-20 11:31:58,643 INFO:  | 0.0s | master started running with PID 1351.
[yugabyted start] 2022-03-20 11:31:58,644 INFO:  | 0.0s | Node was a member of some cluster before. Skipping master setup
[yugabyted start] 2022-03-20 11:31:58,645 INFO:  | 0.0s | Querying for all masters in cluster
[yugabyted start] 2022-03-20 11:31:58,645 INFO:  | 0.0s | Waiting to get the full master addrs list from master
[yugabyted start] 2022-03-20 11:31:58,646 INFO:  | 0.0s | run_process: cmd: [u'/private/var/lib/yugabyte/bin/yb-admin', u'--init_master_addrs', u'127.0.0.1:7100', u'list_all_masters']
[yugabyted start] 2022-03-20 11:31:58,707 INFO:  | 0.1s | run_process returned 1:
OUT >>

<< ERR >>
<<
[yugabyted start] 2022-03-20 11:32:03,229 INFO:  | 4.6s | Got all masters: []
[yugabyted start] 2022-03-20 11:32:03,730 INFO:  | 5.1s | run_process: cmd: [u'/private/var/lib/yugabyte/bin/yb-admin', u'--init_master_addrs', u'127.0.0.1:7100', u'list_all_masters']
[yugabyted start] 2022-03-20 11:32:12,411 INFO:  | 13.8s | run_process returned 0:
OUT >>
Master UUID                      	RPC Host/Port        	State    	Role
3a4d4d8e20414f65809ce952793572a2 	127.0.0.1:7100       	ALIVE    	LEADER

<< ERR >>
<<
[yugabyted start] 2022-03-20 11:32:12,412 INFO:  | 13.8s | Got all masters: [u'127.0.0.1:7100']
[yugabyted start] 2022-03-20 11:32:12,413 INFO:  | 13.8s | Got full master addrs list: [u'127.0.0.1:7100']
[yugabyted start] 2022-03-20 11:32:12,414 INFO:  | 13.8s | Old master flag is: [u'--tserver_master_addrs=127.0.0.1:7100'] and new master flag is: --tserver_master_addrs=127.0.0.1:7100
[yugabyted start] 2022-03-20 11:32:12,414 INFO:  | 13.8s | About to start tserver with cmd /private/var/lib/yugabyte/bin/yb-tserver --stop_on_parent_termination --undefok=stop_on_parent_termination --fs_data_dirs=/Users/paul/var/data --webserver_interface=0.0.0.0 --metrics_snapshotter_tserver_metrics_whitelist=handler_latency_yb_tserver_TabletServerService_Read_count,handler_latency_yb_tserver_TabletServerService_Write_count,handler_latency_yb_tserver_TabletServerService_Read_sum,handler_latency_yb_tserver_TabletServerService_Write_sum,disk_usage,cpu_usage,node_up --yb_num_shards_per_tserver=1 --ysql_num_shards_per_tserver=1 --cluster_uuid=fd3952ea-dc93-4cf3-8d8e-28d9e24f823a --rpc_bind_addresses=0.0.0.0:9100 --server_broadcast_addresses=127.0.0.1:9100 --cql_proxy_bind_address=0.0.0.0:9042 --server_dump_info_path=/Users/paul/var/data/tserver-info --start_pgsql_proxy --pgsql_proxy_bind_address=0.0.0.0:5433 --tserver_enable_metrics_snapshotter=true --metrics_snapshotter_interval_ms=11000 --webserver_port=9000 --default_memory_limit_to_ram_ratio=0.6 --instance_uuid_override=c410abde22234bf79841821f159dc110 --start_redis_proxy=false --tserver_master_addrs=127.0.0.1:7100
[yugabyted start] 2022-03-20 11:32:12,418 INFO:  | 13.8s | tserver started running with PID 1363.
[yugabyted start] 2022-03-20 11:32:12,419 INFO:  | 13.8s | Node was a member of some cluster before. Skipping tserver setup
[yugabyted start] 2022-03-20 11:32:17,565 INFO:  | 19.0s | Waiting to get the full master addrs list from master
[yugabyted start] 2022-03-20 11:32:17,566 INFO:  | 19.0s | run_process: cmd: [u'/private/var/lib/yugabyte/bin/yb-admin', u'--init_master_addrs', u'127.0.0.1:7100', u'list_all_masters']
[yugabyted start] 2022-03-20 11:32:22,637 INFO:  | 24.0s | run_process returned 0:
OUT >>
Master UUID                      	RPC Host/Port        	State    	Role
3a4d4d8e20414f65809ce952793572a2 	127.0.0.1:7100       	ALIVE    	LEADER

<< ERR >>
<<
[yugabyted start] 2022-03-20 11:32:22,638 INFO:  | 24.0s | Got all masters: [u'127.0.0.1:7100']
Pauls-MacBook-Pro:logs paul$

Got an old laptop. Mac 10.14.

In the logs:

==> /Users/paul/var/logs/tserver/postgresql-2022-03-22_193933.log <==
dyld: lazy symbol binding failed: Symbol not found: ___darwin_check_fd_set_overflow
  Referenced from: /private/var/lib/yugabyte/postgres/bin/postgres (which was built for Mac OS X 11.0)
  Expected in: /usr/lib/libSystem.B.dylib
dyld: Symbol not found: ___darwin_check_fd_set_overflow
  Referenced from: /private/var/lib/yugabyte/postgres/bin/postgres (which was built for Mac OS X 11.0)
  Expected in: /usr/lib/libSystem.B.dylib

I can use postgres 14, until I get a newer laptop.

Thanks to Radek for helping me on slack.

1 Like