oalvarado Posted January 19, 2012 Share Posted January 19, 2012 Hello all; I'll start out with the hardware interface: VPS hosting @ myhosting . com --> Linux(CentOS) Parallels Plesk 10.4.4 Problem: I'm trying to host an auction on this server. My php.ini file is configured as per the instructions on the software, the installation for the software is done online you type in the following to install: yourdomain.com/admin/install.php. The installation is a series of five steps, 1. verify if server is supported. 2 DB creation. 3. LICENSE CHECK. 4. writing of config files 5. DB dump. Is there problems with this software or perhaps the server? Doing the install as per the instructions on step 3. the License check comes back as license failed. I found a way around that bypassing the license check, by the way I do have a license for it and a receipt that I paid for it. After modifying the software I'm able to get to step 4. writing of config files. When clicking o the next button (step 5) I get the following error on the browser: Database access error. Please contact the site administrator. UPDATE PHPAUCTIONXL_settings SET sitename='', siteurl='', adminmail='' Access denied for user 'xxxxxxxxx'@'localhost' (using password: NO) Well I am using a password to connect to the DB and I know the software (script) works fine because I tested it on my computer first using wamp and it installs with no errors. Anyways after speaking to the script developer he tells me that the server is the problem, even dough I change my php.ini file the host is restricting my f url open or that I might have a session variable issue at the server. Could that be true? Well I'm open to any suggestions or Ideas if someone here is willing to help the link to the install is below with the DB user and passwords. www.pujasyganas.com/admin/install.php -->l ink to install localhost user: xxxxxxx pwd: xxxxxx create new DB : auction License #: 6DF68320JY372946V If some one here is up to a challenge I'm open to upload the files or give acces to the server just let me know. Thanks in advance guys. Quote Link to comment https://forums.phpfreaks.com/topic/255352-issues-connecting-to-db/ Share on other sites More sharing options...
ManiacDan Posted January 19, 2012 Share Posted January 19, 2012 Welcome to the forums. Please note that you've posted your database credentials in public and now you need to change your password. Now. Quote Link to comment https://forums.phpfreaks.com/topic/255352-issues-connecting-to-db/#findComment-1309224 Share on other sites More sharing options...
nullpoint81 Posted January 19, 2012 Share Posted January 19, 2012 Yeah, ouch. You've set yourself back a bit with this post... Does your host give you a name prefix at all? (for example - my host adds the generated username, lets say "ithaca_", and then adds the name of the domain - so it would be ithaca_randomwebsite for the username). The password would come back as "No" since the username "may" be incorrect...I would try the prefixed name, or if you have CPanel, look in the MySQL DB wizard as the correct username (if there eve is one, mind you) should be listed there. But yeah, you (hopefully) will pull this info offline before the Russian viagra squad gets hold of it. Quote Link to comment https://forums.phpfreaks.com/topic/255352-issues-connecting-to-db/#findComment-1309270 Share on other sites More sharing options...
PFMaBiSmAd Posted January 19, 2012 Share Posted January 19, 2012 The error message, occurring at the time you are trying to execute an UPDATE query, means that you don't have a database connection at that time. You would need to troubleshoot why the actual logic responsible for creating a database connection isn't doing so. The quickest way of pinning down what is and is not working would be to set php's error_reporting to E_ALL and display_errors to ON so that all the php detected errors will be reported and displayed. Just a few wild guess, but the configuration file either has short open tags in it or it didn't actually get written to due to a file/folder permissions. Quote Link to comment https://forums.phpfreaks.com/topic/255352-issues-connecting-to-db/#findComment-1309278 Share on other sites More sharing options...
nullpoint81 Posted January 19, 2012 Share Posted January 19, 2012 I'm open to upload the files or give acces to the server just let me know. Kinda did already. Hope you check this thread soon sir. Quote Link to comment https://forums.phpfreaks.com/topic/255352-issues-connecting-to-db/#findComment-1309279 Share on other sites More sharing options...
ManiacDan Posted January 19, 2012 Share Posted January 19, 2012 I'm open to upload the files or give acces to the server just let me know. Kinda did already. Hope you check this thread soon sir. Since he went 6 hours without noticing his db creds in public, I killed them. OP, you absolutely 100% must change your database password the instant you read this. Right now, stop reading and go change your password. Quote Link to comment https://forums.phpfreaks.com/topic/255352-issues-connecting-to-db/#findComment-1309287 Share on other sites More sharing options...
nullpoint81 Posted January 19, 2012 Share Posted January 19, 2012 I'm open to upload the files or give acces to the server just let me know. Kinda did already. Hope you check this thread soon sir. Since he went 6 hours without noticing his db creds in public, I killed them. OP, you absolutely 100% must change your database password the instant you read this. Right now, stop reading and go change your password. The cake is a lie. And so is your website...well, now. I'm still looking for help with my own damn issue, but keep checking back to see the drama unfold. Oh dear, my life. Quote Link to comment https://forums.phpfreaks.com/topic/255352-issues-connecting-to-db/#findComment-1309317 Share on other sites More sharing options...
nullpoint81 Posted January 19, 2012 Share Posted January 19, 2012 OP, you absolutely 100% must change your database password the instant you read this. Right now, stop reading and go change your password. It's good that you took the time to do that. I already did that once on my own server (just posting code without thinking) and left it up for maybe 4 seconds. But seriously, how...can...what? What is wrong with some people? Here are all my website credentials, login just like I would and do whatever! Ok, no. Quote Link to comment https://forums.phpfreaks.com/topic/255352-issues-connecting-to-db/#findComment-1309319 Share on other sites More sharing options...
oalvarado Posted January 28, 2012 Author Share Posted January 28, 2012 Thanks alot guys to all who responded to my problem. the best answer to solve this problem was by PFMaBiSmAd, I now know where my problem is, apparently I have a session_start() problem. Warning: session_start() [function.session-start]: open(/var/lib/php/session/sess_ep254bt7v3n7a9ejfnludsnr00, O_RDWR) failed: Permission denied (13) in /var/www/vhosts/Pujasyganas.com/httpdocs/admin/install.php on line 1 Warning: Unknown: open(/var/lib/php/session/sess_ep254bt7v3n7a9ejfnludsnr00, O_RDWR) failed: Permission denied (13) in Unknown on line 0 Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0 the new question is how to resolved this issue since I dont have a folder php in (var/lib) folder? Thanks again for all your help. Quote Link to comment https://forums.phpfreaks.com/topic/255352-issues-connecting-to-db/#findComment-1312066 Share on other sites More sharing options...
PFMaBiSmAd Posted January 28, 2012 Share Posted January 28, 2012 You need to set the session.save_path setting so that it points to an actual folder to hold the session data files. Quote Link to comment https://forums.phpfreaks.com/topic/255352-issues-connecting-to-db/#findComment-1312072 Share on other sites More sharing options...
ManiacDan Posted January 29, 2012 Share Posted January 29, 2012 These session errors have nothing to do with your database issues. Did you change your password? Quote Link to comment https://forums.phpfreaks.com/topic/255352-issues-connecting-to-db/#findComment-1312080 Share on other sites More sharing options...
oalvarado Posted January 30, 2012 Author Share Posted January 30, 2012 Thanks again guys to all who helped out. My problem was with session_start() that was an easy fixed just giving the file a 777 permission Quote Link to comment https://forums.phpfreaks.com/topic/255352-issues-connecting-to-db/#findComment-1312446 Share on other sites More sharing options...
AyKay47 Posted January 30, 2012 Share Posted January 30, 2012 Thanks again guys to all who helped out. My problem was with session_start() that was an easy fixed just giving the file a 777 permission Giving a file 0777 permissions is never a proper fix. Quote Link to comment https://forums.phpfreaks.com/topic/255352-issues-connecting-to-db/#findComment-1312449 Share on other sites More sharing options...
ManiacDan Posted January 30, 2012 Share Posted January 30, 2012 Neither is refusing to respond to "did you change your database password" Quote Link to comment https://forums.phpfreaks.com/topic/255352-issues-connecting-to-db/#findComment-1312606 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.