/ - rtt - IT Resource

  • 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........
  • hwloc-nox set CPU affinity in Linux


    sudo apt-get install  hwloc-nox Reading package lists... Done Building dependency tree       Reading state information... Done The following NEW packages will be installed:   hwloc-nox 0 upgraded, 1 newly installed, 0 to remove and 530 not upgraded. Need to get 151 kB of archives. After this operation, 453 kB of additional disk space will be used. Get:1 http://archive.ubuntu.com/ubunt........
  • 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........
  • Debian Mint Ubuntu compiling xmr-stak


    sudo apt-get install libcurl4-openssl-dev git build-essential autotools-dev autoconf libcurl3 sudo apt-get install libcurl4-gnutls-dev git clone https://github.com/wolf9466/cpuminer-multi sudo apt-get install cmake  libpthread-* libmicrohttpd-dev libssl-dev libhwloc-dev git clone https://github.com/fireice-uk/xmr-stak-cpu.git make install cd bin chmod +x xmr-stak-cpu ./xmr-stak -O xmr........
  • linux mint image convert menu option missing solution


    I already have the caja-image-converter option installed but it shows nothing. Weirdly enough if you install nemo and nautilus converter it does show and work inside caja: The solution is to install *-image-converter sudo apt-get install *-image-converter Reading package lists... Done Building dependency tree       Reading state information... Done Note, selecting 'n........
  • 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........
  • Linux Mint Black Screen after boot no graphics solution


    This is not the normal "black screen" issue and I was shocked to eventually find out why.  The normal advice of reconfiguring Xorg didn't work.  Even booting into "Recovery Mode" did not help. Here is the short end of the stick that fixed it: sudo apt-get install mdm mate-desktop-environment Yes you got it right, mdm and the mate-desktop-environment / gnome were somehow uninstalled.  This must be whe........
  • Mozilla Firefox Address Bar History Not Working places.sqlite corruption solution database repair


    Here is the only solution I found that works in Firefox: *Note you could basically just copy all of the commands in bold (the rest just shows the output)   Install sqlite3 sqlite3 places.sqlite sqlite> .clone places.sqlite-fixed moz_places... done moz_historyvisits... done moz_inputhistory..........
  • 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 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........
  • 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........
  • 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........
  • Linux Mint 17 How to Enable File Sharing Option in File Manager


    I still cannot understand how this would not be enabled by default and I struggled to find the reason why with manually installing samba etc.. wondering why the option for sharing was not in the menu.   On Linux Mint "MATE" the package is called "caja-share" and on Cinnamon it is called "nemo-share" so edit the below command as necessary: *Also note that the "samba" package is necessary as it is not inst........
  • 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........
  • Error: database disk image is malformed - yum error solution and fix


    I got this when running yum on a Centos 6 machine: Error: database disk image is malformed It was easily fixed with the following command: yum clean all........
  • 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.........
  • Virtualbox errors on Ubuntu/Debian/Mint


      The solution was to reinstall the vbox dkms package and do a manual modprobe of the modules it makes. I never sorted out the unable to start due to the USB issue, I did have the guest additions installed but the only way to boot was to change the pointing device from USB to PS2 and then to disable the USB controller (if your pointing device is set as USB, disabling USB will not work because it will re-enable by default when it sees your pointing device is USB, this is w........
  • 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........
  • 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 NoSQL implementations seem........
  • WHMCS Sending Blank E-mails Solution


    After the "latest" update one of our clients asked us to figure out the issue and it turns out it is related to the mail settings. Basically all e-mails were being sent with blank text/no body. The solution Go to "Setup -> General Settings -> Mail" and just click on "Save" and it will work again. Note that this assumes you didn't break things yourself by changing any settings.  WHMCS may tell y........
  • Wordpress Security Hole, Plug it by manually installing themes and plugins


    It's always bothered me how Wordpress basically forces the user to provide their hosting credentials to install themes and plugins.  How do know for sure the data is not being saved, intercepted and being provided backdoor access to the NSA or other agencies or even just being misused by others with access? Here's how to close the security hole above and if you're already given Wordpress your credentials make sure you change everything associated it with it.  Eg. change your........
  • yum error "Error: database disk image is malformed" solution


    yum -y install mathtools Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile  * base: centos.mirror.rafal.ca  * epel: mirror.steadfast.net  * extras: mirror.agmn.ca  * rpmforge: repoforge.mirror.constant.com  * updates: centosb5.centos.org extras                         ........
  • openssh-server has no installation candidate Debian/Ubuntu Solution


    I don't know why but some installations don't have this in the database by default. To fix it to an: sudo apt-get update;sudo apt-get install openssh-server and then it will work........
  • MySQL Allows blank user with no password to login


    I just realized I have some blank users which I deleted but I 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........
  • charat in PHP convert non-English characters into code


    This is basically URL decoding to the decimal code but nothing in PHP works how you'd expect it. Here are online tools to verify and check your work, it's important when querying databases with non-English characters: http://yehg.net/encoding/index.php# http://meyerweb.com/eric/tools/dencoder/ http://www.codetable.net/decimal/65398 Japanese: http://symbolcodes.tlt.psu.edu/bylanguage/japanesechartkatakana.html Charat code for PHP:........
  • mkdir(): Too Many Links - The Solution and Problem in ext3 filesystems


    The error itself "mkdir(): Too Many Links" is not very useful, but I'll translate it into plain English. It means you've reached the filesystem's limit of how many directories can be created in a single directory. In this case for ext3 the limit is 32000 and it was exceeded. What's the solution?  The simple solution is to move those directories into more subdirectories possibly sorting them by date, alphabet or numerically. ........
  • MySQL Show Print List of Field Names only without other data or attributes


    SELECT column_name FROM information_schema.columns W........
  • WD 20EARX Dead Again


    Another new drive bad from the start:   Jun  2 15:14:18 one-desktop kernel: [15895.386779] ata2.00: exception Emask 0x50 SAct 0x1 SErr 0x280900 action 0x6 frozen Jun  2 15:14:18 one-desktop kernel: [15895.386782] ata2.00: irq_stat 0x08000000, interface fatal error Jun  2 15:14:18 one-desktop kernel: [15895.386784] ata2: SError: { UnrecovData HostInt 10B8B BadCRC } Jun  2 15:14:18 one-desktop kernel: [15895.386788] ata2.00: cmd 60/0........
  • WD 20EARX 2TB Bad within days


    This is just trying to read 5GB off the drive with dd and the drive initially tested ok but shortly after I wondered why I was seeing 2MB/s read speeds.  Notice the "current_pending_sector", anytime I've seen it at anything above 0 even with no other bad fields/attributes, it means the drive is bad. ata1.00: exception Emask 0x0 SAct 0x3 SErr 0x0 action 0x0 ata1.00: irq_stat 0x40000008 ata1.00: failed command: READ FPDMA QUEUED ata1.00: cmd 60/00:00:........
  • 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........
  • Bad Hard Drive Slows Down Computer


    Here's a proven example of what a bad hard drive can do, it was technically functioning OK in a RAID array but the system became extremely low and the load become high and IOWAIT was even higher and I always thought it was a bad application.  The truth is that this failing 1TB Hitachi has slowly gotten worse and caused huge slowdowns, (eg. 100% load on Thunderbird waiting for e-mails to load etc..).  After swapping it out, tabs change instantly, emails are not lagged, and........
  • Hitachi Serial Numbers for Hard Drives without seeing the physical drive


    Here's what SMART tells me the serial number is: === START OF INFORMATION SECTION === Device Model:     Hitachi HDS721010CLA332 Serial Number:    JP2940HQ3ZY7KH Firmware Version: JP4OA3EA User Capacity:    1,000,204,886,016 bytes Device is:        Not in smartctl database [for details use: -P showall] ATA Version is:   8 ATA Standard is:&nb........
  • Thunderbird How-To Copy/Backup/Restore Accounts and Settings to Another Computer


    The best way is to use rsync, I've set it up so it doesn't copy unnecessary files, or at least ones I'm sure aren't needed. Here is the rsync command I used (adapt to your specific Thunderbird profile location): rsync -hazv user@remotehost.com:/home/user/.thunderbird/sbrer.default/* /home/user/.thunderbird/4nyb0.default/ --exclude=global* --exclude=Cache --exclude=ImapMail --exclude=Mail This is a great way to get your e-mail accounts going on a new c........
  • 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 IMHO on a production server). You may need to upgrade to PHP 5.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........
  • 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........
  • 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.........
  • How To Test If Your Hard Drive Is Good/Signs of dying hard drive


    I like dd, although it only reads it, usually a read test of the entire disk will uncover if your hard drive is bad in some parts.  This is a good thing to do at least once a month, a lot of times bizarre program behavior, laginess and crashing/unnmounting problems etc.. are due to a failing disc and SMART won't know it or indicate a problem: We must also remember there's never a guarantee, I've found that ever since we moved to larger and more platters per drive with 1TB drives........
  • smart is not smart, it thinks a dead drive is still good


    I had a dying drive that smart thought until it totally disappeared was a good drive, and actually all parameters did look fine but this system was causing my system to lockup and other bad behavior:   === START OF INFORMATION SECTION === Device Model:     WDC WD20EARS-00MVWB0 Serial Number:    WD-WMAZ20139 Firmware Version: 50.0AB50 User Capacity:    2,000,398,934,016 bytes Device........
  • Hitachi 2TB HDS5C3020ALA632 drive DOA


    I had one of these shipped and it was not recognized when plugged in, here's what a dead drive looks like (I assume it's teh circuit board which is dead):   ata1: link is slow to respond, please be patient (ready=0) ata1: softreset failed (device not ready) ata1: SATA link up 3.0 Gbps (SStatus 123 SControl 300) ata1: link online but device misclassified, retrying ata1: link is slow to respond, please be patient (ready=0) ata1: softreset f........
  • 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........
  • vnstat setup guide/tutorial


    yum -y install vnstat chown nobody.nobody -R /var/lib/vnstat/ #replace venet0 below with your desired interface sudo -u nobody vnstat -u -i venet0 #edit: vi /etc/sysconfig/vnstat #VNSTAT_OPTIONS="-i venet0" # only use the sed below if you are using venet0 instead of eth0 or replace accordingly sed -i 's/eth0/venet0/g' /etc/sysconfig/vnstat   [root@monitor]# yum install vn........
  • 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........
  • 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 DOES NOT exist but the database al........
  • Understanding /etc/aliases from sendmail when using with postfix or other MTA's


    understanding /etc/aliases *remember to apply changes you need to run "newaliases" after editing /etc/aliases one thing I don't get is that it doesn't allow you to specify the whole e-mail address on the left-hand side eg: yourfullemail@domain.com: someotheremail@domain.com postalias: warning: /etc/aliases, line 109: name must be local (if you try the above) It works more like this: your........
  • 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.........
  • 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........
  • Ubuntu/Debian DRBD 8.0 Setup Guide


    I've only used it on Centos, so I thought I'd make a quick Debian guide: Install the DRBD Package apt-get install drbd8-utils Reading package lists... Done Building dependency tree       Reading state information... Done The following packages were automatically installed and are no longer required:   libswfdec-0.8-0 Use 'apt-get autoremove' to remove them. The following........
  • WD (Western Digital) Advanced Format Drive Lagged/Slow Speed/Performance/Design Flaw EAD/EARS problem WDC WD20EARS-00S8B1


    Let the numbers speak for themselves, from what I read the Load_Cycle_Count which is very high (more than 500,000/half a million times) is the number of head parks.  What a stupid "Green" design and design flaw which will probably mean an early life for the drive. This is almost as silly as Seagate's new reputation for BSY/poor quality disks since the 7200.11 series. To make it worse this is also when Western Digital introduced "Advanced Format" o........
  • Wine stopped working/won't work Solution


    After an upgrade wine wouldn't open anything, not even the pre-installed notepad. There are no wine logs and nothing is mentioned in any standard log file about why. I finally decided to run wine from the shell and see what's going on: wine client error:0: version mismatch 398/402. Your wineserver binary was not upgraded correctly, or you have an older one somewhere in your PATH. Or maybe the wrong wineserver is still running?........
  • Local policy does not permit you to log on interactively. - Solution/Fix


    For a standalone system the solution is simple, just use the same version of Windows a copy a good version of: C:windowsSecurityDatabasesecedit.sdb from another computer. Then you should be able to login again without getting the nasty message "Local policy does not permit you to log on interactively." Of course you will probably need a way of accessing the filesystem off-line in order to get to it such as a Linux boot disc. Some........
  • 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........
  • Use rcconf to edit startup/init.d/init scripts on Debian/Ubuntu based distributions


    I've never understood how to enable and disable services for different run levels in Debian based distros, it's just weird, annoying and doesn't make sense.  I much prefer chkconfig from RHEL. Just install the package called 'rcconf' and be done with it.  rcconf makes things easy for you. apt-get install rcconf Reading package lists... Done Building dependency tree        Reading state information... Done........
  • Seagate Drive 500GB Drive Dying


    This drive is clearly on the way out, the Kernel knows it but I'm surprised that SMART is not concerned.  I didn't blame Seagate for their past issues until now.  This hard drive has hardly been used and has not even been powered on for a year according to SMART. Home page is http://smartmontools.sourceforge.net/ === START OF INFORMATION SECTION === Model Family:     Seagate Barracuda 7200.11 Device........
  • 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........
  • Seagate 7200.11 firmware defect in 500GB, 1000GB (1TB) and 1500GB (1.5TB) Hard Drives


    Seagate Inventory/Firmware Check I heard about this issue a long time ago but never looked into it.  I figured I wasn't affected since my 500GB drives were running for so long.  I've been using Seagate's since 2002 and to this day all of the drives I have are alive from Seagate. *Update the bad news is that I realize one of my 500GB's is about to die, it's not even a year old, but is also not affected by the recall according to Seagate! Seagate Inventory/Firm........
  • XMPP Chat Protocol using Jabber - Guide Tutorial Setup Linux Chat Server


    In Debian based distros: apt-get install jabber Reading package lists... Done Building dependency tree       Reading state information... Done The following packages were automatically installed and are no longer required:   fakeroot dkms Use 'apt-get autoremove' to remove them. The following extra packages will be installed:   jabber-common The following NEW packag........
  • 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   ........
  • 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........
  • locate: command not found (slocate database needed)


    locate: command not found (slocate database needed)For some versions especially older ones like 3.x they might not have the "slocate" database. Meaning a "locate somefile" command doesn't work. Just install "slocate" [code:1:d6d717421c]yum install slocate[/code:1:d6d717421c] Then run: [code:1:d6d717421c]updatedb[/code:1:d6d717421c] And you're good to go :)........
  • 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........
  • 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 <20 tcp/udp small services FTP 21 tcp file transfer SSH 22 tcp login service TELNET 23 tcp login service SMTP 25 tcp mail TIME 37 tcp/udp time synchronization WINS 42 tcp/udp WINS replication DNS 53 udp naming service........
  • Other Security Web Sites


    Other Security Web SitesSeveral websites actively track security issues. This list provides you with the major providers of security information on the Web. Many of these organizations also provide newsletters and mailings to announce changes or security threats: Center for Education and Research in Information Assurance and Security (CERIAS) CERIAS is an industry-sponsored center at Purdue University that is focused on technology and relate........
  • 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:........
  • yum error not working rpmdb: mmap: No such device TypeError: rpmdb open failed


    Loaded plugins: fastestmirror rpmdb: mmap: No such device error: db4 error(19) from dbenv->open: No such device error: cannot open Packages index using db3 - No such device (19) error: cannot open Packages database in /var/lib/rpm Traceback (most recent call last):   File "/usr/bin/yum", line 29, in ?     yummain.user_main(sys.argv[1:], exit_code=True)   File "/usr/share/yum-cli/yummain.py&qu........
  • Have an OpenVZ VPS/Linux Virtual Private Server and nothing works right?


    A VPS Server I had just wasn't working right, code that I migrated there just wasn't working.  For example, it kept telling me the connection to the database was unsuccessful, halfway through iterating through results it already had. Then I realized it wasn't my code.  I checked my /proc/user_beancounters and found this: cat /proc/user_beancounters Version: 2.5 uid resource held maxheld barrier limit failcnt........
  • 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........
  • Latest Articles

  • syntax error, unexpected T_SL in PHP Solution
  • grep regular expression match number range between specific numbers
  • bash how to print out lines of text within a range from the first occurrence
  • bash script how to to check LAN computers for open ports
  • MySQL Using mytop Debug Source of High IO and Slow Performance
  • How To Mathematically Convert and Calculate Binary Value To Decimal Value
  • systemd management using systemctl and journalctl to check systemd logs
  • css how to format code in the code tag
  • css br with extra blank line
  • What is /dev/pts and why do we need it in Linux?
  • Linux What is umask (user mask) for file and directory creation permissions and how to calculate umask and change the defaults
  • Linux Permissions and Groups Real Usecase for Group Access
  • Centos 7 python34 how to install the gi library
  • Centos 7 - Convert Minimal to Graphical GUI GNOME or KDE Desktop
  • AMD Set Fan Speed and Other Powerplay Memory/CPU Timings with a Linux script
  • Ethereum Mining Claymore Nanopool Error
  • genisoimage errors with long filenames and deep directory structures
  • Linux Kernel USB Export Errors
  • How to download gajim 0.16.9 XMPP/Jabber client so you can use OMEMO encryption
  • HP DL385 G7 Linux BIOS Update Flash