Thanks, I thought it was something to do with how I configured the database itself. I found sql-connection.conf and changed things around. I think the permission issues came from screwing around with the default pi user before creating the new user. I'll probably rebuild it all once I have a better grasp of how everything is working together.
Got it running properly now! I'll rebuild it tomorrow, test, and document it all.