http://vpsbible.com/forums/forum/databases Setup Unmanaged VPS for Linux Noobs! en-US Fri, 10 Feb 2012 00:45:07 +0000 http://bbpress.org/?v=1.0.2 q http://vpsbible.com/forums/search.php http://vpsbible.com/forums/topic/unable-to-import-database#post-2780 Tue, 31 Jan 2012 13:28:16 +0000 perryb 2780@http://vpsbible.com/forums/ <p>OK so the problem was actually down to me pasting the command in rather than typing it into the terminal - hence the split and and the resulting error </p> http://vpsbible.com/forums/topic/unable-to-import-database#post-2779 Tue, 31 Jan 2012 12:26:05 +0000 perryb 2779@http://vpsbible.com/forums/ <p>I can log into mysql using:</p> <p><code>mysql -u root -p</code></p> <p>But if I try to import a database:</p> <pre><code>mysql -u root -p localhost example &lt; example.sql</code></pre> <p>I get kicked out with the following error (notice the split after 'root'):</p> <pre><code>$ mysql -u root ERROR 1045 (28000): Access denied for user &#039;root&#039;@&#039;localhost&#039; (using password: NO) $ -p exmple &lt; example.sql</code></pre> http://vpsbible.com/forums/topic/wordpress-reinstall-error-establishing-connection-to-database#post-2749 Wed, 28 Dec 2011 22:12:06 +0000 hanasazi 2749@http://vpsbible.com/forums/ <p>And terrified to restart ANYthing! </p> http://vpsbible.com/forums/topic/wordpress-reinstall-error-establishing-connection-to-database#post-2748 Wed, 28 Dec 2011 22:10:31 +0000 hanasazi 2748@http://vpsbible.com/forums/ <p>I'm having this problem and more! I'm a total noob to VPS and secure WP installations and losing hair by the minute with numerous re-installs. I got your book, Guv, WordPress Ultimate Security. And trying to catch up fast bc I'm working for a client and way behind schedule. I really need a hero right now, every instruction I try to implement results in database errors and/or 500 internal server errors. Can you, or someone, help me figure out what I'm doing wrong? host: ipower; unmanaged VPS with VHM and cPanel, RapidSSL Security Certificate. </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2690 Mon, 24 Oct 2011 22:38:23 +0000 Joe Crocetta 2690@http://vpsbible.com/forums/ <p>I think there's a log rotate tutorial on the site somewhere. </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2685 Sat, 22 Oct 2011 19:44:56 +0000 Dan Ahn 2685@http://vpsbible.com/forums/ <p>just installed phpmyadmin again and it works. could you just tell me how to limit access.log from getting too big? </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2684 Sat, 22 Oct 2011 19:42:24 +0000 Dan Ahn 2684@http://vpsbible.com/forums/ <p>guvnr, this happened again so I looked deeper, and I realized it was access.log that became 18gb every 3 months...that was why mysql wouldn't start.</p> <p>I happened to do this though. </p> <p>sudo apt-get remove mysql-server libapache2-mod-auth-mysql php5-mysql<br /> sudo apt-get autoremove<br /> sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql</p> <p>everything works now but my phpmyadmin link is broken. any idea how to fix that and how to limit access.log from getting too big?</p> <p>Thanks! </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2489 Sun, 07 Aug 2011 08:05:41 +0000 SuicideKings 2489@http://vpsbible.com/forums/ <p>I ran into this issue as well on 2 different installs. This worked for me to get it to kick up reliably after reboot:</p> <p>I edited /etc/init/mysql.conf and commented out this:</p> <pre><code>#start on (net-device-up # and local-filesystems # and runlevel [2345])</code></pre> <p>...and changed it to just this:</p> <p><code>start on runlevel [2345]</code></p> <p>Maybe an issue with some OpenVZ setups?...because that's what both problems happened on and just thinking about the network differences between the two platforms. With Xen though I haven't had a problem. </p> http://vpsbible.com/forums/topic/phpmyadmin-error#post-2474 Tue, 26 Jul 2011 03:39:57 +0000 Brian Stewart 2474@http://vpsbible.com/forums/ <p>Reinstalled phpmyadmin and its now giving #1045 Cannot log in to the MySQL server</p> <p>*Ninja Edit*</p> <p>Turns out I could log in as root as no ***** user existed I presumed the ***** user i set up during the intial stages of the vps would be the same. </p> http://vpsbible.com/forums/topic/phpmyadmin-error#post-2473 Tue, 26 Jul 2011 03:19:26 +0000 Brian Stewart 2473@http://vpsbible.com/forums/ <p><a href="http://img811.imageshack.us/img811/261/welp.jpg" rel="nofollow">http://img811.imageshack.us/img811/261/welp.jpg</a></p> <p>After using a stackscript and following the phpmyadmin tut Im getting the above error msg.</p> <p>Any Advice ? </p> http://vpsbible.com/forums/topic/no-input-file-specified-shown-at-phpmyadmindomaincom#post-2468 Sun, 24 Jul 2011 19:58:19 +0000 the_guv 2468@http://vpsbible.com/forums/ <p>big cheers mycol :) </p> http://vpsbible.com/forums/topic/no-input-file-specified-shown-at-phpmyadmindomaincom#post-2467 Sun, 24 Jul 2011 04:10:07 +0000 mycol 2467@http://vpsbible.com/forums/ <p># here it is if anyone cares</p> <p>server<br /> {<br /> server_name .mydomain.org;</p> <p> access_log /var/log/nginx/example.com.access.log;</p> <p> error_log /var/log/nginx/example.com.error.log;</p> <p> root /var/www/mydomain.org;</p> <p> index index.php index.html index.htm;</p> <p> # use fastcgi for all php files<br /> location ~ \.php$<br /> {<br /> fastcgi_pass 127.0.0.1:9000;<br /> fastcgi_index index.php;<br /> fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;<br /> include fastcgi_params;<br /> }</p> <p> # deny access to apache .htaccess files<br /> location ~ /\.ht<br /> {<br /> deny all;<br /> }<br /> } </p> http://vpsbible.com/forums/topic/no-input-file-specified-shown-at-phpmyadmindomaincom#post-2466 Sun, 24 Jul 2011 04:09:03 +0000 mycol 2466@http://vpsbible.com/forums/ <p>resolved. I ended up rebuilding the linode, lol. pretty sure it was a problem with php.ini pointing to a non-existing web root. </p> <p>Guv, the guide was going well until we got to the php-fpm/fastcgi section. The flow breaks down and on my inital go I got discombobulated. Ultimately I installed nginx via the repository they show on their main page. Then I used a very clean domain.conf in sites-available. So far so good! </p> http://vpsbible.com/forums/topic/no-input-file-specified-shown-at-phpmyadmindomaincom#post-2464 Sat, 23 Jul 2011 10:28:38 +0000 mycol 2464@http://vpsbible.com/forums/ <p>I should also mention I opted to have sites located at</p> <p>/home/public_html</p> <p>I did not use '/home/USERNAME/public_html</p> <p>Could this be adding to the problem? </p> http://vpsbible.com/forums/topic/no-input-file-specified-shown-at-phpmyadmindomaincom#post-2463 Sat, 23 Jul 2011 10:23:54 +0000 mycol 2463@http://vpsbible.com/forums/ <p>I followed the guide and got php-fpm working in my multisite arrangement. Websites came up but I was unable to access phpmyadmin.domain.com without the error "No input file specified". I went back and installed fastCGI but I'm still having problems. Any ideas? </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2457 Thu, 21 Jul 2011 12:21:19 +0000 the_guv 2457@http://vpsbible.com/forums/ <p>Dan, you could do that anyway .. it won't hurt but will ensure you have the correct startup entry for the mysql daemon. Then again, this is setup in the script.</p> <p>Otherwise, it may be that you have a corrupted db. I'd recommend you take steps, at least, to optimize it. </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2456 Thu, 21 Jul 2011 00:28:44 +0000 Dan Ahn 2456@http://vpsbible.com/forums/ <p>The thing is, everything works fine for like a month, and when the traffic peaks a little, the database just fails for some reason. Then it's unable to start it in any way.</p> <p>I couldn't afford to wait for your response so I ended up resetting the server all over, but service mysqld start doesn't work for sure.</p> <p>I'll take a note of your suggestion for the next possible crash. Thanks! </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2450 Wed, 20 Jul 2011 13:34:17 +0000 the_guv 2450@http://vpsbible.com/forums/ <p>Sounds like a socket issue Dan .. maybe just a missing symbolic link. First though:-</p> <p>service mysqld start</p> <p>??</p> <p>if not:-</p> <p>cd /var/lib/mysql/<br /> ln -s /var/run/mysqld/mysqld.sock mysql.sock</p> <p>Howzat? </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2447 Tue, 19 Jul 2011 20:48:16 +0000 Dan Ahn 2447@http://vpsbible.com/forums/ <p>I end up having to do a full reinstallation of the server because of this.</p> <p>Even if I try to remove mysql and reinstall, it gets stuck because of this message:</p> <p>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)</p> <p>In the past year, I've had to do this about four times, when the db randomly crashes with wordpress. I use the stackscript and I don't know why this happens so often </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2446 Tue, 19 Jul 2011 19:34:41 +0000 Dan Ahn 2446@http://vpsbible.com/forums/ <p>I get "lrwxrwxrwx 1 root root 21 May 5 02:33 /etc/init.d/mysql -&gt; /lib/init/upstart-job" and I can't even start the mysql manually, as it keeps saying "Job failed to start" when I try to start mysql.</p> <p>Please help. The databases crash at times and when I restart the server, mysql is like dead... </p> http://vpsbible.com/forums/topic/centos-mysql-cant-createwrite#post-2386 Tue, 05 Jul 2011 09:09:00 +0000 the_guv 2386@http://vpsbible.com/forums/ <p>Hi Soren, couple of things to try first .. can you or root create a file in the /tmp dir? </p> <p>Otherwise, I guess your disk isn't full? ..</p> <p>df -h </p> http://vpsbible.com/forums/topic/centos-mysql-cant-createwrite#post-2367 Sun, 03 Jul 2011 08:54:47 +0000 Søren Gjessing 2367@http://vpsbible.com/forums/ <p>Hello<br /> I have a huge issue on this error on mysql.<br /> Can't create/write to file '/tmp/#sql<br /> the full error message is<br /> Can't create/write to file '/tmp/#sql_4761_0.MYI' (Errcode: 30) </p> http://vpsbible.com/forums/topic/stackscript-manual-installation-neither-worked#post-2278 Tue, 14 Jun 2011 06:39:18 +0000 J Y 2278@http://vpsbible.com/forums/ <p>Change /etc/init/mysql.conf from this:</p> <pre><code>start on (net-device-up and local-filesystems and runlevel [2345]) stop on runlevel [016]</code></pre> <p>to</p> <pre><code>start on (local-filesystems and runlevel [2345]) stop on runlevel [016]</code></pre> http://vpsbible.com/forums/topic/setup-wordpress-3-for-single-sites-on-lemp-error-error-1064-42000-at-line-1#post-2273 Fri, 10 Jun 2011 09:23:56 +0000 Marcus West 2273@http://vpsbible.com/forums/ <p>mv: `/usr/local/nginx/sites-available/eclecticmedia.co.uk</p> <p>' and `/usr/local/nginx/sites-available/eclecticmedia.co.uk</p> <p>' are the same file<br /> ln: creating symbolic link `/usr/local/nginx/sites-enabled/eclecticmedia.co.uk</p> <p>': File exists<br /> ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '9*gFZOdZ^S@localhost IDENTIFIED BY '#FLUJO1dS^wBS9pMoIo^xpXO'' at line 1<br /> mv: `/home/jim/public_html/eclecticmedia.co.uk</p> <p>' and `/home/jim/public_html/eclecticmedia.co.uk</p> <p>' are the same file<br /> addgroup: The group `webmasters' already exists.<br /> mv: cannot stat `index.php': No such file or directory</p> <p>similar problems Guv..can you explain the remedy ? </p> http://vpsbible.com/forums/topic/how-do-you-make-a-database-server#post-2088 Tue, 15 Mar 2011 02:42:41 +0000 the_guv 2088@http://vpsbible.com/forums/ <p>hey Ollie .. yup, you can add another server later and call data or whatever you need from there. You'd just make a remote call to the db, rather like calling a remote db from a local db maintenance client or the terminal. You could use a second server for logging too, for a mail server and so on.</p> <p>.. you'd rarely need to do that for a db though, generally it's just more to think about. Personally I'd start with one and see how I went. </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2084 Tue, 15 Mar 2011 02:16:56 +0000 the_guv 2084@http://vpsbible.com/forums/ <p>safinrox .. what's the output of this:-</p> <p><code>ls -la /etc/init.d/mysql</code> </p> http://vpsbible.com/forums/topic/setup-wordpress-3-for-single-sites-on-lemp-error-error-1064-42000-at-line-1#post-2083 Tue, 15 Mar 2011 01:58:43 +0000 the_guv 2083@http://vpsbible.com/forums/ <p>yes, swap the $variables for your values </p> http://vpsbible.com/forums/topic/setup-wordpress-3-for-single-sites-on-lemp-error-error-1064-42000-at-line-1#post-2078 Mon, 14 Mar 2011 07:17:45 +0000 Duan Do 2078@http://vpsbible.com/forums/ <p>#<br /> #inc_scriptMySQLdb<br /> db="create database $WPDB;GRANT ALL PRIVILEGES ON $WPDB.* TO </p> <p>$WPDBUSER@localhost IDENTIFIED BY '$WPDBPASS';FLUSH PRIVILEGES;"<br /> mysql -u root -p$MYSQLPASSWORD -e "$db"</p> <p>problem</p> <p>Enter password:<br /> ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check </p> <p>the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1</p> <p>I'm trying to figure out what to do here; should I substitute the values of the variables in this code. Like put the user and password into the code.<br /> I did export the variables above where the Bible said to do it and thing worked so far up until this point.</p> <p>thanks. </p> http://vpsbible.com/forums/topic/mysql-never-autorestarts-after-reboot#post-2077 Mon, 14 Mar 2011 05:38:58 +0000 safinrox 2077@http://vpsbible.com/forums/ <p>Hello, I am still clueless about this. Guv, can you please tell. </p> <p>the mysql upstart service exists. I can go into root and do 'mysql start' and it does start up.<br /> But it does not do so automatically. </p> http://vpsbible.com/forums/topic/how-do-you-make-a-database-server#post-2065 Sat, 12 Mar 2011 06:58:28 +0000 Ollie H 2065@http://vpsbible.com/forums/ <p>Hello everyone, I am going to setup a linode server(s) soon and I plan to have a blog, forum and a bunch of php scripts running. I've been recommended to have 2 servers, one web and database. This way I can scale whichever that needs more resources. </p> <p>Now, I've google'd this and there doesn't seem to be a guide to do this. How hard is this? I'm a bit of linux noob so I hope you can bear with me. I really do want to learn and optimize my website. </p> <p>Also, can I follow your tutorials, base off of one server, but later, buy another server and make that server a database server? This way I can follow all your steps and not worry that I have to restart anything if I add a database server. </p> <p>Thank you! </p>