apache2 httpd apache server will not start [pid 22449:tid 139972160445760] AH00052: child pid 23248 exit signal Aborted (6) solution Mint Debian Ubuntu Redhat

If you get this error, it is often because you have configured Apache with modules that weren't actually installed. Eg. you try to load the PHPmodule but didn't actually install the apache2 php module, so the server can't start. In general, this error can often be caused by issues with problematic modules and/or Apache being configured for modules that have not actually be installed (eg. libapache2-mod-php) is missing. The above results in this less than obv........

How to install and configure haproxy on Linux Ubuntu Debian

haproxy is one of the best known and widely used Open Source load balancers out there and a strong competitor to nginx. haproxy is used by many large sites per Wikipedia: HAProxy is used by a number of high-profile websites including GoDaddy, GitHub,........

Docker Tutorial HowTo Install Docker, Use and Create Docker Container Images Clustering Swarm Mode Monitoring Service Hosting Provider

The Best Docker Tutorial for Beginners We quickly explain the basic Docker concepts and show you how to do the most common tasks from starting your first container, to making custom images, a Docker Swarm Cluster Tutorial, docker compose and Docker buildfiles.........

Ansible Tutorial - Playbook How To Install From Scratch and Deploy LAMP + Wordpress on Remote Server

1. Let's work from an environment where we can install Ansible on. If you are using an older version of Linux based on Mint 18 or Ubuntu 16, you may want to get the PPA and get the latest version of Ansible that way: sudo apt install gpg sudo add-apt-repository ppa:ansible/ansible sudo apt update........

How To Install NextCloud on Centos 7 and Centos 8

yum -y install wget unzip wget https://download.nextcloud.com/server/releases/nextcloud-18.0.2.zip unzip nextcloud-18.0.2.zip yum -y install php php-mysqlnd php-json php-zip php-dom php-xml php-libxml php-mbstring php-gd mysql mysql-server Last metadata expiration check: 0:58:02 ago on Fri 13 Mar 2020 02:12:49 PM EDT. Dependencies resolved. ===================================================================........

MySQL 5.7 on Debian and Ubuntu - How To Reset Root Password

MySQL on Debian versions is configured differently than the native local MySQL plugin so you will be disappointed when your password on the mysql client fails by default. Here is how you reset the MySQL root password the proper and "working way" #first we gracefully stop mysql sudo systemctl stop mysql; #then we forcefully kill any mysqld process just in case sudo killall -9 mysqld mysqld_safe;........

Wordpress Reset Blog User Password from MySQL Using Linux Bash and not PHPMyadmin

The reason we use the command below is because we need the md5sum value hash of the password. This means that we cannot use the md5sum Change "yournewpass" to the pass you want to set echo -n "yournewpass" | md5sum Then you get the md5sum hash of whatever you entered eg. in this case "yournewpass" 5a9351ed00c7d484486c571e7a78c913 ........

MariaDB / MySQL Reset Root Forgotten Password on Centos 7

mysql reset root password. Oops I can't remember my MySQL root password! [root@centos7test etc]# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) First we need to stop mariadb: systemctl stop mariadb Now we need to restart it with skip-grant-tables whic........

Centos 7 How to install Mysql/Mariadb

yum -y install mariadb-server systemctl start mariadb mysql_secure_installation Now we need to secure our install and set the MariaDB root password: The lines you need to act on are marked in bold shown with the answer you need. mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SER........

PHP 7.2, Apache and Centos 7 How To Install

yum install centos-release-scl yum install rh-php72 rh-php72-php rh-php72-php-mysqlnd Symlink PHP binary: ln -s /opt/rh/rh-php72/root/usr/bin/php /usr/bin/php Symlink Apache and PHP module config: ln -s /opt/rh/httpd24/root/etc/httpd/conf.d/rh-php72-php.conf /etc/httpd/conf.d/ ln -s /opt/rh/httpd24/root/etc/httpd/conf.modules.d/15-rh-php........

Apache Cannot Start Listening Already on 0.0.0.0

A lot of times busy servers will have this issue and you cannot even force kill -9 the apachectl or httpd process: [root@apachebox stats]# ps aux|grep httpd root 1547 0.0 0.2 495452 32396 ? Ds Sep08 3:23 /usr/sbin/httpd root 3543 0.0 0.0 6448 724 pts/1 S+ 13:11&nbs........

MySQL Bash Query to pipe input directly without using heredoc trick

Most of us know the heredoc method but what if you need a basic query done repeatedly and manually while working from bash? It is a pain to manually type mysql and login each time. With this command below you can semi-automate those queries: echo "use somedb; select * from auctions" | mysql -u root --password="yourpassword" Just modify the above to suit your needs and you can add more queries by adding a sem........

MySQL Cheatsheet Guide and Tutorial

Create Database: create database yourdbname; Show All Databases: show databases; Change Database: use mysql; Drop / Delete a MySQL Database: drop database nameofyourdatabase;........

python 3 pip cannot install mysql module

python3 testserver.com-car-scraping.py html.txt Traceback (most recent call last): File "testserver.com-car-scraping.py", line 5, in import mysql.connector ImportError: No module named 'mysql' For some reason it won't install properly even though I have the mysql client on this machine installed too. Solution: You need the mys........

Centos 7 PHP MySQL Not Working Solution

PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/pdo_mysql.so' - /usr/lib64/php/modules/pdo_mysql.so: symbol mysql_options, version libmysqlclient_18 not defined in file libmysqlclient.so.18 with link time reference in Unknown on line 0 #not sure what is wrong with php-mysql but I removed it and installed mysqlnd yum -y remove php-mysql yum -y install php-mysqlnd........

MySQL Using mytop Debug Source of High IO and Slow Performance

mytop is one of my favorite tools and it is fairly simple aside from a few caveats and issues that persist to this day. To install it on Centos: yum -y install centos Configure ~/.mytop vi ~/.mytop user=root host=localhost db=test #port=3306 socket=/var/lib/mysql/mysql.sock header=1 color=1 Try runni........

MySQL change for Antelope format to Barracuda error solution

Your database uses Antelope as the file format. Full UTF-8 support in MySQL and MariaDB requires the Barracuda file format. Please switch to the Barracuda file format. See the documentation MySQL full unicode support for details. In /etc/my.cnf under [mysqld] 180827 21:43:14 InnoDB: 5.5.59 started; log sequence number 1589339 180827 21:43:14 [ERROR] /usr/libexec/mysqld: unknown variable 'db_file_format=Ba........

moodle install error Error reading from database

Error reading from database More information about this error It is usually not possible to recover from errors triggered during installation, you may need to create a new database or use a different database prefix if you want to retry the installation. Solution: This happened when I was running MySQL 5.1. Assuming your database details are right and the DB is up then make sure you are usin........

Database Error One or more of the WHMCS database tables appear to be either missing or corrupted. Please check and repair. - WHMCS Solution

Database Error One or more of the WHMCS database tables appear to be either missing or corrupted. Please check and repair. This error can be misleading especially if you know you are using a known good backup or restoration of the WHMCS database. The error can also be that the user lacks permissions to read and write to the database. To check to this in MySQL shell: GRANT read,write to dbusername@localhost on dbna........

Duplicate entry '2147483647' for key 'PRIMARY' MySQL Error Solution

This usually happens when you are using something like an INT and try to insert a larger valuethan the maximum which is larger than "2147483647" On a practical term I have seen this and been guilty of this error when using scripts like PHPand generating large random numbers: $hash = mt_rand(5,9999999999999); Obviously that many 9's are more digits than the maximum of an INT resulting in that error. Change your code accord........

SMF Forums / Simple Machines Forums Not Displaying Images Theme or Styles Properly using 127.0.0.1

This is one thing that has me wondering about SMF. It is apparently a known issue but in the latest version and new install nothing looked right because it was using http://127.0.0.1 to find everything! How on earth would it ever do this or think it is normal? Excerpt of crazy html code it produces that causes the issue: ........

solution mysqldump: Got error: 1044: Access denied for user 'user'@'localhost' to database 'thedb' when using LOCK TABLES

It is simple the user just needs to be given the "LOCK TABLES" privilege. As root run this command: GRANT LOCK TABLES ON yourdatabase.* TO yourmysqluser@localhost;........

MySQL How To Grant Access To ALL Databases For Export and Backup Purposes

GRANT SELECT, LOCK TABLES ON *.* TO yourmysqluser@localhost; All you need to do a full MySQL dump on all databases is the SELECT and LOCK TABLES privileges. This way you don't have to use the mysql root user. Data could be compromised this way but at least no harm from manipulation, changes or deletion are possible by locking down the privileges to the minimum for a full MySQL dump and backup.........

MySQL Adding New Field to Existing Database Table

ALTER TABLE existingtable ADD newfieldname VARCHAR(255);........

MySQL Cannot Update/Write to any database table solution

This happened on Centos for no apparent reason with no obvious issue in the logs. Data could be read fine but not written (possibly due to some corruption or out of memory issue in the OpenVZ container is the best guess). All mysql update and insert queries failed freezing without any error log on any database and table. Tried to restart: service mysqld restart Timeout error occurred trying to stop MySQL........

MySQL Maximum INT Size Truncation Issue/Warning

MySQL will silently truncate a larger INT than capable. Check MySQL's own documentation here: As we can see the maximum size of INT (which is the most commonly used) is 2147483647 A lot of coders make this mistake by using very large values such as 9999999999 but it would actually truncate to 2147483647 which is the maximum size of an INT. This is dangerous beca........

MySQL How To Add New Field Column To Existing Table

ALTER TABLE thetable ADD newfield VARCHAR(255) It's very simple just specify "the table" and then the newfield type........

mysql how to reset passwords with a few commands

The commands below will help you reset any mysql user password. use mysql; update user set password=PASSWORD('thenewpass') where User='theusername'; flush privileges; The first line says to use the "mysql" database which contains all the user info. the second update line sets the new password "thenewpass" for the u........

mysqld in Linux hacked

Check for crap in /var/lib/mysql like this ls -al /var/lib/mysql/ total 20888 drwxr-xr-x 24 mysql mysql 4096 Oct 3 18:30 . drwxr-xr-x 20 root root 4096 Oct 3 04:23 .. -rw-rw-rw- 1 mysql mysql 11776 Oct 3 17:10 c:exp.exe -rw-rw-rw- 1 mysql mysql 48128 Oct 3 17:10 c:exp1.exe........

PHP Migration from 5.3 to 5.4+ and dealing with deprecated functions

Upgrading from PHP 5.3 to 5.4+ there are many challenges basic things like mysql_connect() do not work anymore.........

ERROR 2006 (HY000) at line 567: MySQL server has gone away

mysqldump or mysql query of a larger file/table ERROR 2006 (HY000) at line 567: MySQL server has gone away Add this to /etc/my.cnf max_allowed_packet=64M service mysqld restart........

MySQL: table is marked as crashed solultion

myisamchk can fix it But be careful and use the right options to avoid losing data. In fact if you haven't you should make a backup or at least manually copy /var/lib/mysql. Replace "YourDB" with the name of your database Replace "yourcrashedtable" with the name of your crashed table. The -o option is the safest and should avoid dataloss whereas -r is more aggressive and is a last option (I have lost data using -r and........

Apache SSL very slow response with Firefox Freezes/Loads Very slow when checking self-signed SSL certificate

I was sure this was a Centos bug with OpenSSL, Apache, MySQL or even PHP. I tried everything but nothing helped. One clue is that if you check the Apache logs you will see nothing in the access logs until minutes later (this means Firefox has not even passed your request to the remote Apache/htttpd server). When even accepting the invalid certificate message that would show up minutes later when trying to "View the Certificate" Firefox would freeze. This bu........

MySQL Add multiple IPs for remote user including root howto

To grant the IP 192.168.2.4 to user mysqlguy GRANT ALL ON *.* TO 'mysqlguy'@'192.168.2.4'; To allow any IPfor mysqlguy just use the wildcard % character GRANT ALL ON *.* TO 'mysqlguy'@'%'; Also note it is normal and fine to have multiple entries in the mysql table.........

cPanel error Access denied for user 'root'@'localhost' when adding remote MySQL IP address solution

Error while connecting to MYSQL: (XID 4ea7s9) Access denied for user 'root'@'localhost' (using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 181 Solution This error occurs because the /root/.my.cnf has the wrong/outdated password for MySQL root user. Simply edit /root/.my.cnf with the correct user. This normally happens if you update outside of cPanel.........

yum Packages skipped because of dependency problems:

Solution: yum -y install --skip-broken package-you-want-to-install Packages skipped because of dependency problems: php56w-mysql-5.6.30-1.w6.x86_64 from webtatic Error: Multilib version problems found. This often means that the root cause is something else and multilib version checking is just pointing out that there is........

ERROR 2013 (HY000): Lost connection to MySQL server during query

The solution is simple but strange, if you copy your /var/lib/mysql directory to another server and think it will work, be sure to check if you have /var/log/mysql and binary log files. If you do, the server will not work and will give you errors like below and crash without the proper log files. UPDATE user SET password=password("newpass") WHERE user='root'; flush privileges; ERROR 2013 (HY000): Lost connection to MySQL server durin........

if script bash check if socket file (mysql.sock) exists

The "-S" switch is important as it works with sockets if you use "-f" it will not detect the socket file is there. if [ ! -S "/var/lib/mysql/mysql.sock" ]; then echo "Socket does not exist, restarting" service mysqld restart fi........

MySQLD Server shutdown remotely unexpectedly

170110 5:35:23 [Note] /usr/libexec/mysqld: Normal shutdown 170110 5:35:23 [Note] Event Scheduler: Purging the queue. 0 events 170110 5:35:23 InnoDB: Starting shutdown... 170110 5:35:24 InnoDB: Shutdown completed; log sequence number 0 12765401 170110 5:35:24 [Note] /usr/libexec/mysqld: Shutdown complete 170110 05:35:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended........

MySQL Allow Access from Remote Host IP and Update All Users

Change Host="192.168.5.99" with the remote IP allowed(this is of course more secure but also cumbersome if your IP changes). You could also have a single layer of protection that specifies the IP via firewall or both (of course both are far mor secure). UPDATE user SET Host="192.168.5.99" where Host="localhost" or for any/wildcard UPDATE user SET Host="%" where Host="localhost&qu........

MySQL [ERROR] /usr/libexec/mysqld: Table './eximstats/sends' is marked as crashed and last (automatic?) repair failed solution

You are checking your MySQL logs in /var/log/mysqld.log and come across an error like this: 161222 18:03:40 [ERROR] /usr/libexec/mysqld: Table './eximstats/sends' is marked as crashed and last (automatic?) repair failed The Solution: cd /var/lib/mysql/eximstats myisamchk -r sends.MYI - recovering (with sort) MyISAM-table 'sends.MYI' Data records: 71129........

mysql_real_escape_string returns an empty string solution

This is a common mistake but many people do not realize this function comes from mysql itself, so therefore you need an active mysql connection open. Usually the string will be empty and null when you call it from outside of the database connection portion of your code. eg. an example of the wrong way and creating a null/empty string $var = mysql_real_escape_string($myself) mysql_connect(); // returns n........

MySQL PHP adding a backslash/escaping apostrophes Solution

The first thing to diagnose is what is actually in the database (use PHPMyAdmin or CLI). You will of course either find that the backslash is either in the database or not. If the backslash is in the database you probably have magic quotes gpc/runtime on and/or are calling the "addslashes()" function which does this. If you are escaping your data with mysql_real_escape_string() then think again, you probably have magic quotes gpc enabled either in php.ini or........

Mysql how to backup/copy row from one table to another

INSERT INTO articles_backup SELECT * FROM articles WHERE articleID="118" It is so simple we always recommend people do this when updating their database so you always have a backup. The above inserts the copy into the table "articles_backup" which has an identical structure. It selects the entry from "articles" where the articleID is "118" but of course you can adapter yours to whatever the situation is.........

Installing zoneminder on Ubuntu/Debian Linux Howto

sudo apt-get install zoneminder [sudo] password for one: Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: libuser-perl python-evince kdebase-apps kwrite unixodbc libgnomeprint2.2-data python-soappy vgabios python-metacity hddtemp python-mediaprof........

Lost connection to MySQL server during query [2013]

This happened while trying to delete several thousand users from phpBB and basically corrupted the innoDB tables. InnoDB: Page lsn 3 881164362, low 4 bytes of lsn at page end 881164362 InnoDB: Page number (if stored to page already) 86920, InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0 InnoDB: Page may be an index page where index id is 700 InnoDB: (index "tid_post_time" of table "phpBBdb2005"."phpbb3_p........

/usr/libexec/mysqld: The table 'session' is full solution

First of all if you're getting this error it is a result of extreme database activity. If you aren't expecting it or it doesn't make sense to you 99% of the time this is a database driven script being exploited (some common examples I see often are things like phpBB being hit by dozens, hundreds or thousands of bots making constant DB write requests). The easiest way to identify this is to restart MySQL and then run the third party tool "mtop" and you'll see all........

CPanel Link to all of the command line options

CPanel says you can access 98% of the functions through CLI which experienced Unix/Linux admins prefer for simplicity and for scripting. I've never found CPanel easy to use from the admin panel, it seems everything is hard to find and a simple task becomes a series of hunts. So for people like me here's the list: http://cpanel.net/system-administrators/command-line-scrip........

phpBB create new email hash manually when modifying or adding user manually directly through MySQL

Many may ask why would you need to do this? When upgrading from phpBB 2 to 3 the conversion does not keep the admin user you create. If your old admin user has an email address associated that no longer works or is accessible this makes it impossible to reset the admin password. Some may just say "I'll just manually edit the e-mail address" but it won't work and phpBB will fail to find that user if you don't update the "user_email_hash" field but how do........

The Best NoSQL Solution

To first start off, there are many misconceptions about NoSQL and especially its strengths and weaknesses. Even the popular NoSQL solution MongoDB is fraught with issues that no one seems to be concerned about aside from a few but there are serious issues with database integrity and verified writes. MySQL was considered dangerous or incomplete at one point without having the transactional safety features of Oracle for example. However the NoSQLimplementations seem........

mysql how to kill individual process/query

Enter the console as root mysql -u root -p Then kill the process (where 1234 = the thread ID) kill 1234 It's also a good idea to use a tool like "mtop" to monitor which processes and queries are slow, killing them is a temporary fix while you try to isolate the actual problem.........

CPanel mysql root password location how to find

It is located in /root/.my.cnf This is truly a horrible idea and a security flaw and on top of that MySQL port 3306 is wide open by default with CPanel.........

Centos Howto Upgrade to PHP 5.3 from 5.2

It's not as simple as "yum install" as you can see below and it doesn't stop there. yum install php53 Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * rpmforge: mirror.us.leaseweb.net * extras: centos.mirror.rafal.ca * updates: centos.mirror.nexicom.net * base: centos.mirror.nexicom.net * addons: centos.mirror.nexicom.net Setting up Install Process........

MySQL How to add a field/column using alter

ALTER TABLE yourtable ADD COLUMN info VARCHAR(255)........

CPanel Log File Locations for access_log,error_log, mysql

All Errors (CPanel does not report by domain, but puts everything in a single log which Ithink is a bit silly and annoying): /usr/local/apache/logs/error_log Access_Logs They are found within the home directory of the site user eg.: /home/admin/access-logs/yoursite.com MySQL Logs /var/lib/mysql/yourhostname.err........

MySQL DELETE all but specific items or records howto

DELETE FROM `wp_comments` WHERE NOT comment_author_email IN ('user@hotmail.com','another@hotmail.com') The above is an example of specific records you type out, but you could also base it on a subquery.........

MySQL Error : Table 'datastore' is read only Error Number : 1036 solution

This happens because of a permissions or ownership issue. Generally /var/lib/mysql should be all owned by mysql.mysql (check that). To fix it use chown -R mysql.mysql /var/lib/mysql Also make sure the files are at least readable and writable by mysql (eg. 700).........

[ERROR] Fatal error: Can't open and lock privilege tables: Incorrect key file for table 'user'; try to repair it - Solution

service mysqld start MySQL Daemon failed to start. Starting mysqld: [FAILED] mysqld_safe cat /var/lib/mysql/server.err 130917 17:57:09 InnoDB: Started; log sequence number 0 0 13091........

MySQL Allows blank user with no password to login

I just realized I have some blank users which I deleted butI can still login to this dummy account without a password for some reason. mysql -u -p Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 5 Server version: 5.1.69 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation an........

MySQL HowTo Copy Duplicate a Table for backup purposes

This is a great way to test and experiment without risking your current table, or to make a backup of your current table to avoid corruption or dataloss due to malicious activity eg. deletion etc.. There are two steps and two commands 1.)Copy Table Structure "cars_backup" is the new table and it will be a copy of the table called "cars"........

MySQL Show Print List of Field Names only without other data or attributes

SELECT column_name FROM information_schema.columns W........

MySQL my.cnf Server How To Secure/Bind to Localhost and Prevent Outside Connections Solutions

[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 bind-address=127.0.0.1 The key is "bind-address", set that to 127.0.0.1 and no one from outside the server can connect.........

mysqldump: Couldn't execute 'show create table `general_log`': SHOW command denied to user 'user'@'localhost' for table 'general_log' (1142) - Solution

mysqldump: Couldn't execute 'show create table `general_log`': SHOW command denied to user 'user'@'localhost' for table 'general_log' (1142) One of my clients almost found out the hard way, here is an unlikely situation that happened. 1.) Years ago the client had another VPS to which they backed up a BLOG nightly to an .sql file, what they forgot is that the file also contained all databases (they used the --all-databases option but forgot). So imagi........

Solution ERROR 1146 (42S02): Table ‘mysql.servers’ doesn’t exist - when running flush privileges

flush privileges; ERROR 1146 (42S02): Table ‘mysql.servers’ doesn’t exist This happened to me on a system running Centos with the REMI repo and a new version of Mysql 5 (which the official Centos/RHEL does not support on version 5). The solution is just to run this program "mysql_upgrade", after that flush privileges will work. mysql_upgrade........

mysql how to execute script from the bash prompt .sql

mysql -u username --password='yourpassword' ........

Starting MySQL. ERROR! Manager of pid-file quit without updating file. - Solution/How To Fix

service mysql start Starting MySQL. ERROR! Manager of pid-file quit without updating file. Solution killall -9 mysqld_safe killall -9 mysqld service mysql start Starting MySQL SUCCESS!........

Directadmin Log File Locations

This is a handy link and list of all the relevant Directadmin log files and related servers. http://help.directadmin.com/item.php?id=11 DirectAdmin: /var/log/directadmin/error.log /var/log/directadmin/errortaskq.log /var/log/directadmin/system.log /var/log/directadmin/security.log Apache:........

Centos how to upgrade from PHP 5.2 to 5.3 without downtime

This may sound silly but there will be conflicts/issues with the default Centos repository so you have to use a third party like remi (I prefer not to do this but it's the only option unless you migrate your sites/data to another server or can stand some downtime-not an option IMHOon a production server). You may need to upgrade to PHP5.3 to run Joomla or many other reasons. Your host needs to use PHP 5.2.4 or higher to run this version of Jo........

MySQL Authentication fails after Upgrade to Version 5.5

ERROR 1045 (28000): Access denied for user 'contentmanager'@'localhost' (using password: YES) For fun I thought I'd reset the password: GRANT ALL ON thecontent.* TO contentmanager IDENTIFIED by 'dfdfsdfdsfsdfsd'; ERROR 1470 (HY000): String 'contentmanager' is too long for user name (should be no longer than 16) This is ridiculous that this new version has some bizarre 16 character username limit and not only that but i........

MySQL how to copy/duplicate a table

CREATE TABLE articles_backup LIKE articles The code above creates a new table called "articles_backup" which has the exact same structure and attributes as the original articles table. CREATE TABLE articles_backup SELECT * FROM articles; The above code does the same thing as the first example, BUT it also copies all of the data.........

Ubuntu 10 Nvidia Drivers Not Updated After Kernel Update Solution/How-To Manually Rebuild nvidia kernel modules for Ubuntu

I dread updating the kernel and rebooting to find the Ubuntu graphics aren't working and you have to manually intervene. This is usually because Ubuntu for whatever reason didn't update the drivers you need (eg. the manually compiled Nvidia Kernel driver that MUST be recompiled for each and every kernel update unfortunately). The most common reason may be that "linux-source" hasn't been installed automatically on my system. I tried to manually reinstall the........

postfix lopback error solution

This is the mail system at host mail.postmail.com. I'm sorry to have to inform you that your message could not be delivered to one or more recipients. It's attached below. For further assistance, please send mail to If you do so, please include this problem report. You can delete your own text from the attached returned message. &........

Drupal/MySQL database error: PDOException: SQLSTATE[42000] [1044] Access denied for user 'db_user'@'localhost' to database 'dbname' in lock_may_be_available() (line 167 of /home/user/public_html/includes/lock.inc).

PDOException: SQLSTATE[42000] [1044] Access denied for user 'db_user'@'localhost' to database 'dbname' in lock_may_be_available() (line 167 of /home/user/public_html/includes/lock.inc). The username and password were correct but some reason CPanel added the user with no permissions! Edit the user's permissions to include "All" from Cpanel or MySQL and that is the solution.........

MySQL Import CSV data tutorial guide

It's actually fairly straight forward: load data local infile 'billpayments-payments.csv' into table payments fields terminated by ',' enclosed by '"' lines terminated by 'n' The above assumes that your fields are terminated by a comma (some programs like OpenOffice change this to a semi-colon ;) and that they are enclosed with " The above will insert the data from billpayments-payments.csv into the table payments.........

Mysql Solution - Timeout error occurred trying to stop MySQL Daemon. Stopping MySQL: [FAILED]

Timeout error occurred trying to stop MySQL Daemon. Stopping MySQL: [FAILED] [root@devbox stats]# Solution (force kill mysqld - warning you do risk table corruption here but there's no choice i........

mysql enable slow query logging/Query Cache Solution - find/track cause of slow mysqld/high IO/CPU usage

If you have a webserver and find you have high IO/lagginess MySQL is one of the first things to check. It turns out MySQL was my problem and it was creating a high load on my server, especially for IO. How to Enable MySQL Slow Query Logging To Find Slow Performance/Queries vi /etc/my.cnf Add this anywhere under [mysqld] #slow queries log-slow-queries = /var/log/mysql/mysqlslowqueries.log long_query_time = 1........

MYSQL Error Can't find file: './wf/Sessions.frm' (errno: 13) Solution

mysql errors even though these files do exist: 110405 13:21:37 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 110405 13:26:15 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means my........

Drupal 6.2 Install and how to move install to root/non-subdirectory

drup 6.2 install $cd drupgoodinst3883/ [ drupgoodinst3883]$ ls CHANGELOG.txt cron.php index.php INSTALL.pgsql.txt INSTALL.txt MAINTAINERS.txt modules robots.txt sites update.php xmlrpc.php COPYRIGHT.txt includes INSTALL.mysql.txt install.php LICENSE.txt misc&........

Plesk Get List of E-mail Users & Aliases

When migrating away from Plesk I couldn't figure out an easy way to get a straight list of all e-mails, but here is where I found the solution: http://nakuls77.wordpress.com/2008/08/30/details-of-email-ftp-database-users-from-psa-database/ mysql> SELECT mail.mail_name, accounts.password, domains.name FROM mail, accounts, domains WHERE domains.id=mail.dom_id AND mail.account_id=accounts.id; mysql> SELECT CONCAT(mail.mail_name,’@’,domains.name) AS Em........

MySQL NEVER delete ib_logfile0 or ibdata1 or you'll lose data

don't delete /var/lib/mysql/ib_logfile0 or ibdata1 or mysql won't restart I didn't realize they were internal and not part of replication like the relay files! /usr/libexec/mysqld: ready for connections. Version: '4.1.22-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 110127 16:31:00 [Note] /usr/libexec/mysqld: Normal shutdown 110127 16:31:00 InnoDB: Starting shutdown...........

MySQL Out of Range Solution for DATETIME field

Affected rows: 0 Warning: #1264 Out of range value adjusted for column 'deleteon' at row 1 SQL query: UPDATE `custtable`.`custinfo` SET `deleteon` = '2011-02-29 00:00:00' WHERE `custinfo`.`custid` =105 LIMIT 1 ; This happened after a migration to a new SQL database due to user error. The old database server MySQL 3.23 or 4 allowed an impossible date to be entered by a user. As we know February 29th DOESNOT exist but the database al........

MySQL Replication/Dual-Master vs Clustering

Many people aren't aware but recently Dual-Master Replication setups have become increasingly popular. That's because you get similar features and benefits of having a full-blown cluster (difficult to setup and maintain and requires I believe 3 servers just as controllers). With a dual-master you just have a different off-set for the keys and you should be good, but of course there is the chance that at some point replication will halt because of an unexpected or unforseen error........

mysqldump does not include CREATE DATABASE statement

mysqldump does not include CREATE DATABASE statement you need the --databases option "--databases" is misleading, it implies in the documentation that this is a list of databases to be dumped, it should be clear that uses this command in conjuction with dumping a single database also adds CREATE DATABASE and is the only way to get the database to automatically create itself.........

ERROR! MySQL manager or server PID file could not be found! ERROR! Manager of pid-file quit without updating file.

I found the cause of this issue was from all the diskspace being used but clearing it was not enough. Iguess the tables became inconsistent when space ran out and myisamchk is what fixed the rest. service mysqld restart ERROR! MySQL manager or server PID file could not be found! ....................................................................................... ERROR! Manager of pid-file quit without updating file. se........

PHP Fatal error: Call to undefined function mysql_connect()

PHP Fatal error: Call to undefined function mysql_connect() yum install php-*........

mysql backup/dump all databases with mysqldump command

mysqldump --all-databases > allDB.sql The above dumps ALL the mysql databases to "allDB.sql". If you want to compress with gzip you could do this instead: mysqldump --all-databases > gzip > ALLDB.sql.gz........

MySQL Insert Statement ONLY IF a duplicate entry does not exist

This is a great way to reduce MySQL code/mistakes/annoyance when doing things, take for example this statement: INSERT IGNORE INTO sometable(CatName) VALUES("someitem"); Notice the "IGNORE", that is what does the magic. Normally if the entry "someitem" existed you'd get an error message back such as "Duplicate entry for whatever". What I have normally done in PHP or whatever language is manually coded or made a........

Linux Centos/RHEL can't find php/apache/httpd/mysql/ftp/exim/sendmail ?

I wasted a lot of time wondering why I could never find those packages. Check the /etc/yum.conf file and at the bottom look for the "exclude=" line. Below is what I found in mine exclude=apache* httpd* mod_* mysql* MySQL* da_* *ftp* exim* sendmail* php* bind-chroot* Just remove those entries or uncomment that line and you'll get access to the missing applications.........

MySQL Recover/Reset Lost/Forgotten root Password

One note is to secure MySQL, I don't know for sure but I believe you could login to MySQL remotely with no password during this operation (I'm not sure, maybe it doesn't accept blank passwords but I firewall MySQL port anyway and recommend you do the same). First edit /etc/my.cf Under the [mysqld] field add the following line somewhere: skip-grant-tables Now restart mysql: service mysql restart or on Debian sty........

Compile PHP 5.3.2 on Centos 5 and CPanel/WHM because of error - Fatal error: Call to > undefined function imagecreatefromjpeg()

This function and others may not work with the stock PHPinstall on Centos/CPanel: Fatal error: Call to > undefined function imagecreatefromjpeg() Even with libjpeg-devel installed it won't work because PHP was not compiled with jpeg support, so we have to do the dirty work ourselves :) Here is the command/yum's I did to install missing libraries for PHP that configure will complain about (yes it is a one by one process). yum install bzip2-........

MySQL TEXT field size length limit reminder, don't truncate your data!

I thought there would be an error message or warning from MySQL in the case that the text you submit is greater than the allowed limit based on the field. So essentially I submitted text that was about 120,000 characters long, whereas the limit of TEXT is just 65,535 characters! I almost lost half of my data/what I typed without knowing it! I just altered the field type in my database from TEXT to LONGTEXT. I can't see how LONGTEXT wouldn't be long enough for MOST........

Picking an FTPD (vsftpd) Server in Linux Centos/Debian

I decided on using yum to help me decide even though I normaly use proftpd I decided to see what else I could find. yum search ftp Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * rpmforge: ftp-stud.fht-esslingen.de * base: mirrors.netdna.com * updates: updates.interworx.info * addons: yum.singlehop.com * extras: mirrors.netdna.com rpmforge........

PHP cannot access /usr/bin/openssl

PHP cannot access /usr/bin/opensslI have verified the username that runs the process is able to access /usr/bin/openssl and it does exist but the PHP script is saying it doesn't exist: [code:1:1fd0f3abbe] if (!file_exists($OPENSSL)) { //echo "ERROR: OPENSSL $OPENSSL not foundn"; }[/code:1:1fd0f3abbe] I don't get itI can clearly see the contents of /usr/bin by using the PHP system fu........

Asterisk FreeBSD compile problems

Asterisk FreeBSD compile problemsI couldn't get it to compile without using the following options at compile time: [b:b7d672ee28] make install WITHOUT_ZAPTEL=YES WITHOUT_MYSQL=YES WITHOUT_FAX=YES WITHOUT_ODBC=YES WITHOUT_H323=YES[/b:b7d672ee28]Some problems you might have with copying over your Linux config files to FreeBSD is different paths. [b:f044931f41]For example the etc path for Asterisk on BSD will now be:[/b:f044931f41] [qu........

CREATE Database/Granting Privileges

CREATE Database/Granting PrivilegesCREATE your first database Code: [code:1:0668cd8e74]CREATE database myfirstdb; [/code:1:0668cd8e74] CREATE a user for your first database This one creates the user 'sqladmin' and gives them 'usage' on your new database 'myfirstdb' Code: [code:1:0668cd8e74]mysql> GRANT usage on myfirstdb.* to sqladmin@localhost; Query OK, 0 rows affected (0.00 sec)[/code:1:0668........

MySQL Server wouldn't start

MySQL Server wouldn't startStart MySQL Server with the following script that would have installed with the port. /usr/local/etc/rc.d/mysql-server.sh start........

MySQL root password

MySQL root passwordWhen I installed MySQL I didn't set a root password nor do I know what it is![/b]........

MySQL Server 3.23 won't start after switching from 4.1

MySQL Server 3.23 won't start after switching from 4.1I was using a 4.1 alpha version of mysql-server and some how version 3.23 of the client and 4.1 of the client were also both installed! So I forced uninstalled everything because after trying and trying even though MySQL server was using the short 16byte password authentication I got some other errors. After trying with the ports and having it fail because I had existing database data I force installe........

Backup Shell Script

Backup Shell Script[quote:aaa4b0b165]#!/bin/sh date=`date -I` mysqldump --all-databases | gzip > /var/backup/backup-$date.sql.gz [/quote:aaa4b0b165] Something like that could be useful as a cronjob to locally or remotely backup your databases........

MySQL Reserved Words

MySQL Reserved Wordshttp://dev.mysql.com/doc/mysql/en/reserved-words.html You should familiarize yourself with these because you will have unexpected results if you use any of them. Eg. try creating a table with what you think is valid syntax like this: CREATE Table Order( .......); The word 'Order' is a reserved word and used to ORDER the results so you will get a syntax error from this one and you would think everything is........

MySQL SELECT with multiple where conditions

MySQL SELECT with multiple where conditionsI can get a match on rows for now apparent reason [quote:09cf04e097]SELECT * FROM TABLE WHERE field = 'value' & value = 'field' [/quote:09cf04e097] To make it work as expected use 'AND' instead of '&' they seem to have a completely different and unexpected effect. [quote:09cf04e097]SELECT * FROM TABLE WHERE field = 'value' AND value = 'field' [........

MySQL SubQuery

MySQL SubQueryI was trying to do a sub-query here but it wouldn't work (Syntax Error) in MySQL for some reason even though based on the SQL standards it should be ok. [i:1268bfa39e][b:1268bfa39e]I found the reason this doesn't work. I am using MySQL 3.23 and I read on the MySQL web site that versions before 4.1 DO NOT SUPPORT SUB-QUERIES so it showed me how to rewrite the following as a LEFT join instead of a sub-query. [/b:1268bfa39e][/i:1268bfa39e]........

Create Table with structure of another existing table

Create Table with structure of another existing tableOk, this has many valid uses such as if you need to create backups or the ability to undo changes, you would want to create new tables with the same structure as another. Here is how you do it. [i:7ed9581493] Also remember Indexes such as PRIMARY KEYS [b:7ed9581493]will not be preserved[/b:7ed9581493] so you will have to readd them manually.[/i:7ed9581493] [code:1:7ed9581493]CREATE TABLE NewName AS SEL........

Basic Port Listing

Basic Port ListingHopefully someone finds this useful or at least interesting. http://www.sans.org/top20/#u9 Name Port Protocol Description Small services ........

MySQL Error "ERROR 1045 (28000): Access denied for user"

This happened with a select statement which writes the result to an external file. I didn't remember the privilege "FILE" must be granted on *.* for this to work successfully, it wasn't actually an authentication issue as it implies since I was already in the SQL prompt and doing the query. SELECT some_id FROM sometable INTO OUTFILE '/tmp/result.txt'........

MySQL "Got error 28 from storage engine"

I've gotten this error enough to bother posting about it, because I've come across so many servers where this happens, so what could "Error 28" possibly mean? Is your database corrupt, or is this a sign of a RAID failure/corruption or even worse, bad blocks on a clients system who has no RAID and never took backups? No, check your free blocks, it simply means you have no space. This was the result of a script that was overzealous and backed up the entire database........

Mysqld Solution - Can't init databases /usr/libexec/mysqld: Can't read dir of '/tmp/' (Errcode: 13) /usr/libexec/mysqld: Can't create/write to file '/tmp/ibyP1qUC' (Errcode: 13) 100215 7:02:24 InnoDB: Error: unable to create temporary file; errno

100215 07:02:24 mysqld started /usr/libexec/mysqld: Can't read dir of '/tmp/' (Errcode: 13) /usr/libexec/mysqld: Can't create/write to file '/tmp/ibyP1qUC' (Errcode: 13) 100215 7:02:24 InnoDB: Error: unable to create temporary file; errno: 13 100215 7:02:24 [ERROR] Can't init databases 100215 7:02:24 [ERROR] Aborting 100215 7:02:24 [Note] /usr/libexec/mysqld: Shutdown complete 100215 07:02:........

MySQL Restoring And Dumping/Backing UP MySQL Data/Tables/Databases

Backing MySQL Databases Backing Up/Dumping All Mysql Databases To A Single File mysqldump --all-databases -u admin -p > allmysqldatabases.sql The "-all-databases" clause is pretty obvious isn't it? It means that it will backup all databases. The "-u admin" means login using the user "admin", if you h........