wtrainer Posted April 5, 2014 Share Posted April 5, 2014 Hello there, I am trying to install PW 2.4 on linux webserver I can see the welcome message "Welcome. This tool will guide you through the installation process" When i click "Get started" i am taken to "/install.php" with the following error:- Error: Exception: SQLSTATE[28000] [1045] Access denied for user 'madabout'@'localhost' (using password: NO) (in /home/madabout/public_html/subdomain/wire/wire/core/ProcessWire.php line 143) This error message was shown because /install.php still exists. Error has been logged. I have looked in ProcessWire.php and it seems to me that incorrect mySQL config options have been passed in. But the install hasn't asked me for any mySQL options, and i don't know where to provide them. Could someone please help me with this error? Many thanks, West Link to comment Share on other sites More sharing options...
ryan Posted April 5, 2014 Share Posted April 5, 2014 You might need to grab a fresh copy, as it sounds like you might have a partially installed copy where some settings are already present. What does the URL in your address bar show when the error occurs? You mentioned "/install.php" but what about the hostname and path? Link to comment Share on other sites More sharing options...
wtrainer Posted April 8, 2014 Author Share Posted April 8, 2014 Hi Ryan, The URL is http://wire.madaboutbrighton.net/install.php I have started with a fresh copy, but the exact same thing is happening. I click the Get Started button and see the error. What could be going wrong? Cheers, West Link to comment Share on other sites More sharing options...
netcarver Posted April 8, 2014 Share Posted April 8, 2014 @wtrainer What permissions does MySQL user "madabout" have? Make sure they can create and insert into tables. Also, is your web server on the same box as the MySQL server? If not, you probably need to widen madabout's login permissions to allow them to login from a different host. Link to comment Share on other sites More sharing options...
wtrainer Posted April 9, 2014 Author Share Posted April 9, 2014 "madabout" isn't the user to create/edit/update the database. PW has not asked me for any mySQL details (username, password, IP, port, etc) Shouldn't PW ask for my credentials before trying to setup a database? Cheers, West Link to comment Share on other sites More sharing options...
JeffS Posted April 9, 2014 Share Posted April 9, 2014 Check your root/site/config.php for credentials. If they are there, you don't have a clean install. 1 Link to comment Share on other sites More sharing options...
wtrainer Posted April 10, 2014 Author Share Posted April 10, 2014 First of all, thanks for you help... I'm downloading process wire from the PW download page using the link - Download ProcessWire 2.4 ZIP file I'm not sure how the install can be anything but clean. I have the following config.php files:- ~/wire/config.php ~/site_default/config.php None of them contain a reference to any database Could you please specify the exact file and location to check? PW seems to be using the main account on the server to try and access/create the database. But obviously this would require a password, which i have not been asked to enter. Is there supposed to be a wizard where i enter my credentials when first accessing PW? Link to comment Share on other sites More sharing options...
adrian Posted April 10, 2014 Share Posted April 10, 2014 Is it possible that you have an .htaccess file at the root of http://wire.madaboutbrighton.net/ that is not the one that comes with PW? I see that http://wire.madaboutbrighton.net/ looks just fine, but if you add anything to that url you get the error you mentioned, so I am wondering if it is loading some other content somehow via a rewrite rule or something. Link to comment Share on other sites More sharing options...
wtrainer Posted April 10, 2014 Author Share Posted April 10, 2014 It is the default PW htaccess file. I simply renamed htaccess.txt to .htaccess This really has me stumped!! Link to comment Share on other sites More sharing options...
adrian Posted April 10, 2014 Share Posted April 10, 2014 Maybe some rewrite rules or other weird apache directives in the apache conf file? I really don't know - sorry! Link to comment Share on other sites More sharing options...
netcarver Posted April 10, 2014 Share Posted April 10, 2014 @wtrainer I'm just looking at the path reported in your error message; "(in /home/madabout/public_html/subdomain/wire/wire/core/ProcessWire.php line 143)." I suspect that the ".../wire/wire/core/..." should only be ".../wire/core/..." which makes me wonder if the zip extraction was to the right place. I don't know but it's the only lead I can give you at the moment. Personally I install PW using "git clone" directly from the repos and that saves me having to worry about extracting to the right place. Anyway, hope you get to the bottom of this. 1 Link to comment Share on other sites More sharing options...
adrian Posted April 10, 2014 Share Posted April 10, 2014 The url of the site is: http://wire.madaboutbrighton.net/ (which works as expected BTW, until you proceed to the next step) so I think the two wires is correct, but maybe the wire subdomain is causing a conflict somehow? 2 Link to comment Share on other sites More sharing options...
netcarver Posted April 10, 2014 Share Posted April 10, 2014 @adrian I missed that, so yes, it is probably right then. Link to comment Share on other sites More sharing options...
wtrainer Posted April 10, 2014 Author Share Posted April 10, 2014 yes, wire is the subdomain folder, so wire/wire is correct. Thanks for your input though. I think i am going to scrap this for now, it's just too annoying. Thanks again, West Link to comment Share on other sites More sharing options...
Soma Posted April 10, 2014 Share Posted April 10, 2014 But then no matter what you enter it does show the same error http://wire.madaboutbrighton.net/klajsdlas http://wire.madaboutbrighton.net/hello.php ... Currently the installer shows at http://wire.madaboutbrighton.net/ which normally would be at http://wire.madaboutbrighton.net/install.php There's no way I see why PW is causing this issue. It could be an already installed PW or an .htaccess somewhere. The database credentials are stored in /site/config.php after you entered them and when PW was able to connect to DB. It doesn't matter what folder or sufolder PW is put. It doesn't try to connect to a db at that point as you haven't yet come to enter it. So something's wrong on the server and how you have set things up. If htaccess is already enabled, it is somehow already trying to route to the index.php, that's maybe why it would somehow already tries to load ProcessWire.php core. But there's no way PW already knows you're database. When I try to reproduce something alike, I can only get domain.com/randomstr to show a PW error but no sight of DB or ProcessWire.php. I can even delete the index.php and /core/ProcessWire.php and install PW fine to the very end. Link to comment Share on other sites More sharing options...
cstevensjr Posted April 11, 2014 Share Posted April 11, 2014 (edited) I read this over a few times and it seems to me that @wtrainer has not created the mySQL user and credentials prior to installing ProcessWire. Edited April 11, 2014 by cstevensjr 1 Link to comment Share on other sites More sharing options...
wtrainer Posted April 11, 2014 Author Share Posted April 11, 2014 @soma Thanks for your comment If htaccess is already enabled, it is somehow already trying to route to the index.php It made me realise what i had done. I had manually copied htaccess.txt to .htaccess before running the installer. I've tried lots of CMS's over the past few weeks, and setting up the .htaccess before doing anything else seems to be the norm. Very silly of me. Everything is working fine now. Thanks for all your help and sorry for wasting all your time!!!!! 3 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now