Time 'till live, ideas for the future

submitted by magnora7 from self.AntiExtremes

sorted by:
top
newinsightfulfun
you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 2 insightful - 2 fun2 insightful - 1 fun3 insightful - 2 fun -  (9 children)

You're on the money. I will try to find this in the db.

[–]magnora7[S] 1 insightful - 1 fun1 insightful - 0 fun2 insightful - 1 fun -  (8 children)

Sounds good. I'm surprised it's not easier to access, but oh well.

I'm creating the firewall right now. Do you know what ports you want left open? Right now we're going to enable only 80, 22, 8080, 443, 10000, and that's it. If you have any others you want left open, let me know and I'll add the exceptions.

We're also creating a backup right now, and an automated backup will now occur every Tuesday at 2am, on the server level.

[–][deleted] 2 insightful - 2 fun2 insightful - 1 fun3 insightful - 2 fun -  (7 children)

I think the default subs are in the Cassandra db, not in postgres. Haven't figured out how to query or update cassandra yet.

Chat needs port 8090 open. We should ensure postgres remote access is not allowed (allow ssh connections to postgres only), I forget which port this is.

Glad to hear about the backups, that is essential.

Some other last minute items:

If you want to create a public free github account , or if you have one, we can push our reddit changes. Can show people for transparency, but mainly that would be an off site backup.

Db password: we're still using the default password... we really need to change this.

Api credentials: there might be a default api account active, will have to check example.ini and ensure we're not exposing ourselves.

Email: I have not tested at all. If it's not working, maybe we put a notice somewhere until we get something in place. The ideal long term solution for me is outsourced mail sending, like SendGrid or Mandrill (pretty inexpensive but not free)

[–]magnora7[S] 1 insightful - 1 fun1 insightful - 0 fun2 insightful - 1 fun -  (6 children)

I was under the impression cassandra is more of a db management system than a database itself, it just overlays part of the postgresql database to enable multi-server communication to speed things up. But perhaps you must write to the database through that system.

I don't care about email at all. It's not set up, but I guess if you want it we can do that eventually. I'd rather just do everything through reddit's built-in messaging system, personally.

We just added 8090 to the open ports.

Postgre remote access port has been disabled, as we've blacklisted everything except the ports previously listed.

Change the db password, we'll do that soon. I have no idea about the api account, but thanks for bringing it on the radar.

Github account sounds cool, I've never used github before though, so perhaps you'd prefer to set that up to ensure it works correctly.

Check it out, we just registered our patreon at www.patreon.com/antiextremes

[–][deleted] 2 insightful - 2 fun2 insightful - 1 fun3 insightful - 2 fun -  (5 children)

Cassandra is an alternate (no sql) db. From the reddit docs, I got the impression they were transitioning everything to cassandra rather than postgres, but as it stands reddit is using 2 db systems. I think all of the relationship / numerical only data is in there. Will try to connect and find the default subs tonight.

good work on the firewall.

I will also post our code to a GitHub and change the db password (new password will be in development.update)

Patreon looks good and works!

[–]magnora7[S] 2 insightful - 1 fun2 insightful - 0 fun3 insightful - 1 fun -  (0 children)

Ah ok. Yes I gather cassandra was the new add-on they had to expand the multi-server capabilities and speed the site up.

Let me know if you make any progress there. Just add all the subs to the default if you figure it out, they're all listed at www.antiextremes.com/subreddits

Awesome, thanks for doing the github and db pw.

[–]magnora7[S] 2 insightful - 1 fun2 insightful - 0 fun3 insightful - 1 fun -  (0 children)

Thank you for your generosity on Patreon!! :D

[–]magnora7[S] 2 insightful - 1 fun2 insightful - 0 fun3 insightful - 1 fun -  (2 children)

Hey the chat is working great now. The chat windows stealing focus with the auto-scrolling is my biggest bug atm, but thankfully that's not a very big bug overall :) Let me know how things go. I'm done for tonight. Cheers. I'm excited to see this place grow as we invite more people

Glad you like the patreon look too :)

[–][deleted] 2 insightful - 2 fun2 insightful - 1 fun3 insightful - 2 fun -  (1 child)

The focus stealing fix just went live. So far the server load is low, we might survive tomorrow. Cheers and congrats.

[–]magnora7[S] 2 insightful - 1 fun2 insightful - 0 fun3 insightful - 1 fun -  (0 children)

Sweet! Things are going perfectly so far, we're getting our first trickle of users.

Our server guy estimates we can handle 500 simultaneous users before we'd need to upgrade our server plan. So odds are we won't hit that tomorrow, but we'll see, hah. I'll broaden the announcement over the coming days, I think I'll have welcomed everyone I can welcome by a week from now or so, that's kind of what I'm thinking. Then we'll just take it from there.