00:31 <stellar-slack> <dzham> It looks easy enough to “add TLS support”, but then you need to be able to configure it also… cipher suite, protocols, caching, stapling

03:03 <stellar-slack> <sacarlson> I got the proxy working on apache without to much trouble should be up now at https://api.equid.co/federation

07:45 <stellar-slack> <sacarlson> I think I've found a bug in https://github.com/stellar/federation that doesn't permit changing username to user_login in db search

07:46 <stellar-slack> <sacarlson> federation = "SELECT user_login, account_id FROM wp_users WHERE user_login = ?" won't work

07:47 <stellar-slack> <sacarlson> federation = "SELECT username, account_id FROM wp_users WHERE username = ?" but this does even if the colum user_login exists

08:12 <stellar-slack> <sacarlson> created issue https://github.com/stellar/federation/issues/4

11:10 <stellar-slack> <bartek> @sacarlson: https://github.com/stellar/federation/issues/4#issuecomment-171256196

11:14 <stellar-slack> <sacarlson> @bartek so your saying that the colum names in the federation lookup are hardcoded? strange you can change the table name but not the colum names

11:16 <stellar-slack> <bartek> you can change the order of the fields in the result set. it's better to name the fields rather than depend on the order.

11:17 <stellar-slack> <sacarlson> I had planed to just point them to values that wordpress already used. but that's ok I'll do the work around then

11:18 <stellar-slack> <sacarlson> also did you fix the bug it has in not puting out the header value for cors Access-Control-Allow-Origin: *

11:18 <stellar-slack> <sacarlson> I already fixed that in my version

11:19 <stellar-slack> <bartek> yeap, it will be included in 0.0.3 that I will release today

11:19 <stellar-slack> <sacarlson> very good. I might make a branch that allows changing the colum values at some point

11:23 <stellar-slack> <sacarlson> and thanks for your feedback @bartek

11:42 <stellar-slack> <bartek> @sacarlson: federation 0.0.3 released: https://github.com/stellar/federation/releases/tag/0.0.3

11:42 <stellar-slack> <sacarlson> thanks @bartek

11:43 <stellar-slack> <bartek> damn, the tool we use for building `gb` has changed recently and this build is broken. fixing.

11:43 <stellar-slack> <sacarlson> ha ha ok

11:51 <stellar-slack> <bartek> ok, fixed

12:38 <stellar-slack> <sacarlson> and if anyone has a wallet with the new standard stellar federation I would like you to try lookup of both sacarlson*http://equid.co|equid.co and zipperhead*http://equid.co|equid.co they should work to the standard forward and reverse

13:13 <stellar-slack> <sacarlson> my present prototype wallet does do federation lookup of sacarlson*http://equid.co|equid.co , but presently doesn't follow the stellar standard on stellar.toml yet http://sacarlson.github.io/transaction_tools.html. it also defaults to http://equid.co|equid.co if no @ or * is seen in the address

14:49 <stellar-slack> <jed> sacarlson: you don't need a work around. You just need to change your SQL command in the config

14:50 <stellar-slack> <jed> use `SELECT blah as name` <- note the *as name* part

14:51 <stellar-slack> <bartek> @jed https://github.com/stellar/federation/issues/4#issuecomment-171256196 :P

14:55 <stellar-slack> <jed> I know

14:55 <stellar-slack> <jed> did seem like he understood judging from the chat here though.

15:10 <stellar-slack> <sacarlson> so do I take it we do have a but then as that's what I thought I did try that failed

15:11 <stellar-slack> <sacarlson> I provided the example sql database file to duplicate

15:13 <stellar-slack> <sacarlson> I'm personally looking at the code and fail to see why it doesn't work

15:15 <stellar-slack> <sacarlson> but when I'm fresh tomaro I'll take another look

15:16 <stellar-slack> <bartek> does this configuration work for you (take from your issue and fixed): ``` [queries] federation = "SELECT account_id as id FROM wp_users WHERE user_login = ?" reverse-federation = "SELECT user_login as name FROM wp_users WHERE account_id = ?" ``` does it return any errors?

15:16 <stellar-slack> <sacarlson> yes

15:17 <stellar-slack> <sacarlson> as noted

15:17 <stellar-slack> <bartek> what errors?

15:17 <stellar-slack> <sacarlson> I get error: Server error: missing destination name user_login

15:18 <stellar-slack> <bartek> did you restart the server after changing config.toml file?

15:18 <stellar-slack> <sacarlson> yes

15:19 <stellar-slack> <sacarlson> the database as you can see in the example proved also has info at that colum location

15:21 <stellar-slack> <bartek> can you run `cat config.toml` before starting federation server and copy console output here?

15:21 <stellar-slack> <sacarlson> sure I can probly do that

15:22 <stellar-slack> <bartek> (don't forget to obscure your passwords from that file)

15:23 <stellar-slack> <sacarlson> good to tell me that as it's late here now and I'm not to clear

15:24 <stellar-slack> <sacarlson> so I will put it in the broken state as it is working now in the know working state with the colum names as it wants them

15:24 <stellar-slack> <sacarlson> or so you want to verify it now works first?

15:25 <stellar-slack> <bartek> I just want to make sure it loads the correct config file

15:25 <stellar-slack> <sacarlson> ok so broken to start it is

15:26 <stellar-slack> <bartek> it doesn't start?

15:27 <stellar-slack> <sacarlson> it works perfect at now now it does start in the broken state also just error when fed data with expected results

15:27 <stellar-slack> <bartek> what do you mean by the broken state?

15:28 <stellar-slack> <sacarlson> broken state being that error above returns instead of the expected results of a reverse or forward federation

15:28 <stellar-slack> <bartek> ok, can you `cat config.toml`?

15:28 <stellar-slack> <sacarlson> give me a movent to put it in broken state

15:29 <stellar-slack> <sacarlson> yes I can cat both broken and none broken

15:38 <stellar-slack> <jed> you didn't put the `as name` part

15:39 <stellar-slack> <jed> you can change what the columns are returned as as part of the SQL statement

15:40 <stellar-slack> <bartek> looking at your SQL schema (the one you added to the github issue), your queries section has to be like this: ``` [queries] federation = "SELECT account_id as id FROM wp_users WHERE user_login = ?" reverse-federation = "SELECT user_login as name FROM wp_users WHERE account_id = ?" ```

15:40 <stellar-slack> <bartek> change it, restart the server and it should work

15:43 <stellar-slack> <sacarlson> the example of sql I'm using is in the report

15:46 <stellar-slack> <sacarlson> oh cool I'll try your above queries see if they work

15:50 <stellar-slack> <sacarlson> nope looks like same results

15:51 <stellar-slack> <jed> you sure you change the config and restarted?

15:51 <stellar-slack> <sacarlson> yes I can demonstrate again

15:52 <stellar-slack> <bartek> some questions: - why are you `killall federation`? how do you send this server to the background? - can you execute this commands in this order and send us your console output? ``` cat config.toml ./federation ```

15:53 <stellar-slack> <sacarlson> ok

15:56 <stellar-slack> <sacarlson> if you want to remote in and see I'll provide you ssh login

15:56 <stellar-slack> <bartek> ok, it's a progress. now you have `missing destination name name`. my guess is you are using 0.0.1, switch to 0.0.3

15:56 <stellar-slack> <bartek> we changed field names in 0.0.2

15:57 <stellar-slack> <sacarlson> oh ok I should have tried that but I was afraid I would brake the other fix I added

15:57 <stellar-slack> <sacarlson> I'll give 0.0.3 a try

15:58 <stellar-slack> <bartek> btw. you don't have to compile it, you can download it from: https://github.com/stellar/federation/releases

15:58 <stellar-slack> <sacarlson> ok cool will do

15:58 <stellar-slack> <sacarlson> I should have added the commit code I was working from sorry

16:20 <stellar-slack> <sacarlson> holly crap it works now with 0.0.3

16:20 <stellar-slack> <sacarlson> I'll move it to point at wordpres

16:24 <stellar-slack> <sacarlson> yup works now when I point it at wordpress database also thanks @bartek and the rest of you all

16:24 <stellar-slack> <bartek> cool

16:25 <stellar-slack> <sacarlson> but I guess I have the only wallet that can do federation?

16:27 <stellar-slack> <sacarlson> I would like to hear that some other wallet can test federation for sacarlson*http://equid.co|equid.co that should now be active

16:28 <stellar-slack> <bartek> ``` {"stellar_address":"sacarlson*http://equid.co|equid.co","account_id":"GAMB56CPYXJZUM2QSWXTUFSFIWMNHB6GZBUFJ2YJQJRGW6WH223NRLND"} ``` works for me ;)

16:29 <stellar-slack> <sacarlson> cool thanks again @bartek

19:56 <stellar-slack> <jed> bartek ^

19:56 <stellar-slack> <jed> https://api.equid.co/federation?type=name&q=sacarlson*equid.co works

19:56 <stellar-slack> <jed> powderfan you are on the latest js-sdk ?

20:00 <stellar-slack> <powderfan> yes 0.3.4

20:00 <stellar-slack> <powderfan> same result with 1EGeCvza3PuBo5hSGiG8fqidGY4iAMVYre*http://naobtc.com|naobtc.com. works if I type the url, but FederationServer.resolve returns an error

20:07 <stellar-slack> <bartek> for http://naobtc.com|naobtc.com there is a problem with SSL certificate for www subdomain: https://www.naobtc.com/ I'm checking what's wrong with http://equid.co|equid.co

20:10 <stellar-slack> <powderfan> maybe use http and without www? At least this one works in the browser `http://naobtc.com/.well-known/stellar.toml`

20:12 <stellar-slack> <bartek> it would be insecure. someone in the middle could change the FEDERATION_SERVER value and for example: change destination of a payment

20:13 <stellar-slack> <powderfan> yeah true

20:25 <stellar-slack> <bartek> for http://equid.co|equid.co the problem is also with a certificate: https://www.sslshopper.com/ssl-checker.html#hostname=equid.co it doesn't have intermediate certificates. it can be fixed by a domain operator by merging intermediate certificates from certificates provider

20:28 <stellar-slack> <bartek> for example: https://api.equid.co/federation doesn't work in Firefox

21:21 <stellar-slack> <powderfan> Ok, thx @bartek! Any working example I can use to test my code? Preferredly returning a memo as well.