In an every user has their own Stellar account setup, I am trying to get federation server to work but keep failing. The mysql tables are
- CREATE TABLE
idint(11) DEFAULT NULL,
first_namevarchar(255) DEFAULT NULL,
last_namevarchar(255) DEFAULT NULL,
friendly_idvarchar(255) DEFAULT NULL,
public_keyvarchar(255) DEFAULT NULL,
usernamevarchar(255) DEFAULT NULL,
domainvarchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;``
The federation.cfg file query is setup with: federation = "SELECT public_key as id FROM accounts WHERE friendly_id = ? AND domain = 'mdxfederation.space'"
My get request curl "https://mdxfederation.space:8002/federation?q=tunde_adebayo*mdxfederation.space&type=name"
it throws the same error ERRO lookup record: db get: get failed: Error 1054: Unknown column 'domain' in 'where clause' pid=2271
ps. There is no memo_type field in my .cfg file