#known 2024-09-04
2024-09-04 UTC
[mattl], [mattl]2, [aciccarello], [Joe_Crawford] and [marksuth] joined the channel
# 
tantek.com looks like it got deleted in Discord
# 
twistedtranssister I am back again, and apparently as empty in the head as the previous go around. I am trying, and in vain, to get Known installed on my self hosted Namecheap. I did it previously, but doing the exact same steps this time only yields heartache and "Oh no! We couldn't connect to the database.
# twistedtranssister This probably means that the database settings changed, this Known site hasn't been set up yet, or there's a database problem."
# IWDiscord <twistedtranssister>
# twistedtranssister No installer initiates or anything. Just that error.
# [mattl]2 I can help.
# [mattl]2 I have about an hour now if you want some help getting it up?
# twistedtranssister that would be much appreciated!
# [mattl]2 do you want to share your URL to your site?
# twistedtranssister yes my URL is: lonestarmensch.com
# [mattl]2 awesome, that’s a great domain name!
# [mattl]2 okay so you have a database from namecheap and you know the mysql username, password, port number, database name and mysql hostname?
# twistedtranssister Mysql Username/Password and database. I reached out to namecheap and they said the hostname to use was the
# twistedtranssister 'localhost'
# twistedtranssister Is there anywhere I can snag that from cpanel?
# [mattl]2 okay, that’s good. let me make a very simple PHP file to test those details for you. one sec.
# [mattl]2 stick that in a test.php and let’s see if we can get it to connect?
# twistedtranssister okay and that test.php is just put into the root publichtml right?
# [mattl]2 yep
# twistedtranssister right on. created and populated with what you sent over
# [mattl]2 you may need to rename .htaccess to something else for a moment too
# [mattl]2 as I think that’ll try and rewrite everything to use index.php
# twistedtranssister gotcha. And thats the one in the publichtml as well?
# [mattl]2 yep
# twistedtranssister okay, got that renamed as well
# [mattl]2 hm.. can you show me what else you have in that publichtml folder?
# [mattl]2 happy to join a zoom call if that’s useful to
# IWDiscord <twistedtranssister>
# [mattl]2 *too
# twistedtranssister (https://imgur.com/a/uUX76iM)
# twistedtranssister [edit] (https://imgur.com/a/uUX76iM)
# twistedtranssister in case the relay doesnt send screenshots
# [mattl]2 it did… just slowly.
# [mattl]2 can you make a mattl.php page that just says `<?php phpinfo(); ?>`
# [mattl]2 trying to see if something odd is going on
# [mattl]2 do you have access to any log files in cpanel?
# twistedtranssister let me take a gander at that, and also I have created that file for you 🙂
# [mattl]2 thank you
# twistedtranssister Not seeing anything regarding logs T_T
# [mattl]2 i think it’s called “errors” under “metrics” in cpanel
# twistedtranssister no errors in webserver or suEXEC
# [mattl]2 hm, you’ll need to reach out to namecheap support… getting a 500 error on your site and that should be logged somewhere.
# [mattl]2 maybe they have to turn it on for you?
# twistedtranssister I can definitely check. Thats at least a direction to look 🙂
# [mattl]2 I’ll be back around tomorrow but getting that test.php file to do something is something you can ask them about too
# twistedtranssister Because I took the zip archive from the known site, uploaded it to the root, unzipped its contents there. Created the MYSQL database/user/pass and then went into PHPmyadmin and uploaded the schema to populate the things (word is escaping me). Then created the config.ini and input the mysql username password and database name and localhost as the server and then navigate to my site in the browser. Those are the right
# twistedtranssister Just verifying before I go to support, that way they dont faff me about xD
# [mattl]2 that sounds right but i’m confused to why test.php isn’t working. you could try temporarily removing everything else you uploaded or just sticking it in a “known” folder for nwo
# [mattl]2 so you only have test.php and “known”
# twistedtranssister Did that for you
# twistedtranssister should the perms on the test.php be just the default 644?
[benatwork] joined the channel
# [benatwork] Coming to this late. Hi!
# [mattl]2 oh hey ben!
# twistedtranssister The man himself! Hello ben 🙂
# [mattl]2 nothing else in that folder? No .htaccess or anything?
# twistedtranssister Correct, but good news!!!
# twistedtranssister An error log was created in the file manager!
# [mattl]2 oh good… let’s see it
# [mattl]2 can’t browse to it, you’ll need to pastebin it
# [mattl]2 http://paste.debian.net is good because you can give it a short timeout
# twistedtranssister http://paste.debian.net/1328474/
# [mattl]2 ahhhh, okay. my bad.. sorry edit that test.php and put in your username and password for your database
# twistedtranssister oh crap xD Let me change that real fast
# twistedtranssister Okay, so it is throwing the same error in the log, this time it is showing for the user
# [benatwork] something to check a little later on is if your configuration folder is empty (it should be if you're trying a fresh install)
# [mattl]2 can you try changing localhost in that file to 127.0.0.1
# twistedtranssister ....omg I feel dumb as hell. I was pre-creating the config.ini. When I deleted it and put everything in the root, the installation flow comes up, however I am getting an error from the database still. But thats progress!
# [mattl]2 yeah, test.php just tries to see if we can get a basic connection to the database
# twistedtranssister "We couldn't connect to your database. Please check your settings and try again. Here's the error we got:
# IWDiscord <twistedtranssister>
# twistedtranssister SQLSTATE[28000] [1045] Access denied for user 'lonepvne_admin'@'localhost' (using password: YES)"
# [mattl]2 change localhost to 127.0.0.1
# [mattl]2 it should be the same but let’s follow their instructions too
# twistedtranssister Hmmm. still denied
# twistedtranssister This is puzzling
# [mattl]2 i’d speak to support, get that one thing figured out
# [mattl]2 i have to bounce, time to get out of my office building
# twistedtranssister I appreciate your help! You got me to the edge! I should have it from here 🙂 Have a great evening!!!
# [benatwork] Also - feel free to email me if you need at mailto:ben@werd.io
# [benatwork] Consider me your tech support on the Known side
# twistedtranssister Thank you very much Ben! And most auspicious news, it is up and running now. All is good in the world!
# [mattl]2 What was the issue?