When try to load chat via browser https://myhipchatserver.com/chat it shows the message below:
I had a look in HipChat logs but I couldn't find any specific error, algo tried to follow some troubleshooting guide for HipChat server but it's different of DataCenter version.
Could anyone please help?
Thanks in advance
Hey Filipe,
Not much to go on, but my suggestions would be to view the network calls being made by the page and see if there's any insights they may give. If using Chrome, View > Developer > Developer Tools, then the network tab. Below is what ours looks like (Server, but provide the same for your DC install and it might give useful info).
Also worth checking that the SSL cert is all OK at sslshopper.com/ssl-checker.html
A few other questions:
- can you login using iOS/Android apps?
- do you get anything (if so, what) when going to https://myhipchatserver.com/ ?
CCM
Hi Craig, Thanks for your answer I got it working, the problema was the FQDN I run the command:
PGPASSWORD=$(cat /hipchat/config/site.json | jq -r '.databases.hipchat_postgres.pass') psql -h $(cat /hipchat/config/site.json | jq -r '.databases.hipchat_postgres.servers[0]' | awk -F: '{print $1}') -U $(cat /hipchat/config/site.json | jq -r '.databases.hipchat_postgres.user') -d $(cat /hipchat/config/site.json | jq -r '.databases.hipchat_postgres.schema')
after get access I run the query:
select * FROM configurations;
after I see that the FQDN was wrong I insert the right one in the database and everything started to work.
Thanks again.
Best Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Glad to hear it’s all working!
unsure if the below would work, but if anyone else stumbles on this with a similar issue in the future, you should be able to change the hostname using the admin UI (which I believe works even with the wrong hostname set).
CCM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Tks Craig just for future referente this doesn't work with Datacenter version.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Fellipe
The previous answer that worked for you. Where do you run the commands?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, Noni.
Yes, I run opened the developer tools and saw the request was going to wrong address than I run the commands above to change de FQDN. I'm using HipChat DataCenter.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi thanks for your reply. I'm also using hipchat datacenter. The PGPassword.... command do you run that on the database as well ? Or on the hipchat server
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Noni, you have to logon in on node (any node) and after get root access you run the PGPassword... command in the console, after execute it you will be in the database, so just run the query
select * FROM configurations;
hope it helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey @Hey @Felipe Barros - your DC specific information just helped me out with the same issue, but a bit of extra detail.
I'd installed a clean DC install, then imported an export from HipChat server and had the same type of error (webui and app wouldn't connect). The network traffic on the web-ui showed errors for http-bind
Figuring it was hostname related, I did some digging (checked /etc/hosts setup was correct) and then came back to this thread.
Possibly cause I didn't run /setup/ on a clean install but instead did an import though, my configurations table in psql didn't have a hostname.
https://confluence.atlassian.com/hipchatkb/how-to-update-the-base-url-fqdn-of-hipchat-data-center-945548852.html showed what the key should be through (fqdn) and just adding this for next time, if you don't have a fqdn value in the database.
So, if you log in to psql and run:
select * from configurations WHERE key = 'fqdn';
If this returns 1 row (and the value isn't the hostname you've pointed at your load balancer), then you want to run
UPDATE configurations SET value = 'hipchat.example.com' WHERE key = 'fqdn';
If you get 0 rows returned, run:
INSERT into configurations VALUES ('fqdn','hipchat.example.com');
Then run this on all nodes
hipchat datacenter restart
CCM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.