Although I ran this to check the cardano-db-sync and got not found could that be the issue or something else. please help if you can as i need to run transactions for minting native assets asap preferably.
cardano-db-sync --version
command not found: cardano-db-sync
I would use --database-path $HOME/cardano-src/cardano-node/testnet-db/ for testnet and --database-path $HOME/cardano-src/cardano-node/mainnet-db/ for mainnet or something like that.
In How to run cardano-node | Cardano Developer Portal it only says that the directories should exist. mkdir $HOME/cardano-src/cardano-node/testnet-db for testnet and mkdir $HOME/cardano-src/cardano-node/mainnet-db for mainnet should be enough.
You can tell all kinds of servers (it’s not just cardano-node-specific), on which Internet addresses to answer requests. 127.0.0.1 is the local loopback interface, so with that the server will only answer requests from the current machine. 0.0.0.0 most often means “bind on every available interface”, so that it will answer on the local loopback, on the address given to your ethernet port, on the address given to your wifi connection, …
For relays and block producers, it’s pretty important to have them open on all interfaces, since they want and need incoming connections (although the original design said that they should work with only outgoing connections, but SPOs say they don’t). For this to really work, the router also has to be configured to forward requests to the right machine inside the network. Normally, they don’t. They wouldn’t even know if Cardano requests should go to your computer, the TV or the Playstation.
If you just use the node to mint some tokens (or as the backend of a wallet or something like that), you would not need the node to answer external requests and --host-addr 127.0.0.1 is probably okay. (Your router wouldn’t be configured in the way described above, anyway.)
cardano-cli doesn’t use the TCP/IP interface, when talking to cardano-node, but it uses a Unix socket – a special file on the file system that behaves a bit like a connection over the network. That’s what you tell it to open with --socket-path $HOME/cardano-src/cardano-node/db/node.socket (by the way, if we distinguish mainnet and testnet db folders, we should probably just put that one level up or so) and tell cardano-cli to find with export CARDANO_NODE_SOCKET_PATH="$HOME/cardano-src/cardano-node/db/node.socket" (has to also be adapted, when you put it somewhere else).
Above, I suggested that it’s perhaps not a good idea to have the databases of testnet and mainnet in the same folder and that may well be the cause of your problems.
If we do not use $HOME/cardano-src/cardano-node/db/ anymore, but separate $HOME/cardano-src/cardano-node/mainnet-db/ and $HOME/cardano-src/cardano-node/testnet-db/, then you will probably want to delete the whole $HOME/cardano-src/cardano-node/db/ to keep it tidy and also, because each of these folders eats up several GiB.
But then the socket shouldn’t be configured in that directory, also.
You could configure cardano-node with --socket-path $HOME/cardano-src/cardano-node/testnet-db/node.socket if you are running testnet and with --socket-path $HOME/cardano-src/cardano-node/mainnet-db/node.socket if you are running mainnet. That would especially be necessary if you want to run both at the same time (and your machine is powerful enough for that craziness).
You could also choose --socket-path $HOME/cardano-src/cardano-node/node.socket and put it outside the database folder and use the same socket for testnet and mainnet. Should be totally fine, as long as both are not running at the same time.
In any case, cardano-cli needs to know, where the node is. Therefore, all walkthroughs that I have seen contain something like export CARDANO_NODE_SOCKET_PATH="$HOME/cardano-src/cardano-node/db/node.socket" somewhere near the beginning. Whatever you have decided above needs to be reflected there.
If you distinguish mainnet and testnet, it needs to be export CARDANO_NODE_SOCKET_PATH="$HOME/cardano-src/cardano-node/testnet-db/node.socket" before you can do something with a running testnet node and export CARDANO_NODE_SOCKET_PATH="$HOME/cardano-src/cardano-node/mainnet-db/node.socket" to connect to a running mainnet node.
If you decide that the socket should be the same and put it one level up, it would be export CARDANO_NODE_SOCKET_PATH="$HOME/cardano-src/cardano-node/node.socket" in both cases.
Perhaps, some guide told you to put in .bashrc, .zshrc or something like that. Then the easiest way would be the “same socket for mainnet and testnet” choice and just edit it there (and remember that it only takes effect for newly started shells after the change).