General discussion

  • Creator
    Topic
  • #2179283

    Technology, Programming, Management and more with Frank Mash

    Locked

    by softwareengineer99 ·

    blog root

All Comments

  • Author
    Replies
    • #3116179

      Programming one liners – Sophisticated, Productive, Time Saving – Programming at the Extreme

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      I have been addicted to programming one liners ever since I first discovered them. Sometimes I find myself writing more than 200 one liners in a day. To keep a record of these one liners I started this blog.

      If you are passionate about one liners, I invite you to join my blog. Simply post a comment to any post on this programming one liners blog and I will respond promptly. Please provide a

    • #3116180

      Disk usage human readable – Programming One Liner 1 – Linux

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      df -h
      This programming one liner allows you to view disk usage in human readable format
      Programming “One Liner” lookup terms:
      man df
      USE THIS PROGRAMMING ONE LINER AT OWN RISK AS AUTHOR CLAIMS NO RESPONSIBILITY.
      For more information on this one liner programming code, lookup the programming terms displayed above, visit my Linux and network security blog, external programming blogs on Technorati,

    • #3116181

      Server Backup – Programming One Liner 2

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Server directory backup
      cd /user/backups; ls -1 /oldb2/home/virtual/ | grep site | grep -v ‘-‘ | while read i; do bkdir=/oldb2/home/virtual/$i; echo $i; echo $bkdir; tar -cf $i-www.tar $bkdir/fst/var/www; echo “Gunzip $i”; gzip $i-www.tar; ls -l $i-www.tar.gz; done
      This programming one liner allows you to backup directories. First it makes a tarball of a directory and then uses gzip to

      • #3137150

        Server Backup – Programming One Liner 2

        by espionage ·

        In reply to Server Backup – Programming One Liner 2

        Hello,

        It seems to me boring and un-convenient method.

        As I prefer good-looking wizard with plain prompts. And most important time and people tested. Acronis Server backup solution meets all my requirements.

        It creates the exact server disk image for complete server backup, this backup file includes all the server disk data including system, programs, databases, and the like.

        I entrust to this program whole my system! 

         

      • #3119196

        Server Backup – Programming One Liner 2

        by softwareengineer99 ·

        In reply to Server Backup – Programming One Liner 2

        It will be boring if you don’t understand it. You are probably
        promoting your own URL as the software you mentioned is for Windows and
        my post is about Linux.

    • #3116173

      Things not making sense? Want to improve your productivity? Let me help you with your programming projects

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Dear reader,

      If you would like more information on any of the programming commands on this site, or need help with your programming projects, please feel free to contact me by posting a comment on any of these post. I will help you understand any one liner in complete detail to help increase your productivity and programming knowledge for a very economical fee.

      In addition, if you have any

    • #3116174

      Remove Server Directory – Programming One Liner 3

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Removing a directory on server
      rm -r -f /tmp/directory
      This programming one liner allows you to recursively, completely and forcefully remove the directory.
      Programming “One Liner” lookup terms:
      rm unlink
      USE THIS PROGRAMMING ONE LINER AT OWN RISK AS AUTHOR CLAIMS NO RESPONSIBILITY.
      If you would like more information on any of the commands, please feel free to contact me with your programming

    • #3116175

      Total Disk used by a file or directory server – Programming One Liner 4

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Directory Disk Usage
      du -h -s site6-www.tar.defunct
      This programming one liner allows you to view total disk used by a folder or file on a server in a summarized and readable format.
      Programming “One Liner” lookup terms:
      df du
      USE THIS PROGRAMMING ONE LINER AT OWN RISK AS AUTHOR CLAIMS NO RESPONSIBILITY.
      If you would like more information on any of the commands, please feel free to contact me

    • #3116176

      Files and folders in a directory with ls and dir – Programming One Liner 5 – 10

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Contents of a directory
      This programming one liner allows you to see what files and directories are available within a folder on your Linux web server. Upon invocation of this one liner, the contents of your current directory (pwd) will be displayed.
      ls
      If you believe your ls binary is corrupt (due to a server hack) or just to use an alternate command, you can use the following command on Linux

    • #3116177

      Restoring files from an old hard drive to new drive – Programming One Liner 11

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Using rsync to restoring directories between two drives
      rsync -vrplogDtH /olda/dir /home/dir
      This programming one liner allows you to restore / copy files from one hard drive to another. This can be useful in cases when you have a hacked hard drive as slave attached to your web server and now you want to restore files.
      Programming “One Liner” lookup terms:
      rsync rcpBrief explanation of options

    • #3116167

      Process Information – Programming One Liner 12 – 13

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      ps – process information
      ps 316
      For a currently running process, you can use ps with the process id (pid) to see information about the process and to verify that its still running.

      Programming “One Liner” lookup terms:
      ps

      Programming One Liner 13
      See all processing currently running (started by you)
      [root@plain html]# ps
      PID TTY TIME CMD
      20056 pts/5 00:00:05 bash
      316 pts/5

    • #3116168

      Create and verify a tarball for a directory – Programming One Liner 14

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      tar – working with tarballs
      /designerz/backups/log.site6.fst.bk
      This programming one liner allows you to create a verified archive. The command generates all files processed to the screen.
      Programming “One Liner” lookup terms:
      tar
      USE THIS PROGRAMMING ONE LINER AT OWN RISK AS AUTHOR CLAIMS NO RESPONSIBILITY.
      If you would like more information on any of the commands, please feel free to contact

    • #3116169

      Send a message to all users – Programming One Liner 15

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Broadcasting a message
      wall
      This programming one liner allows you to everyone connected to a
      terminal. Simply type wall, enter the message and press Ctrl-d to send
      it. [root@plain user]# wall
      fixed
      Broadcast message from root (pts/0) (Sat Oct 29 22:52:36 2005):
      fixed
      Programming “One Liner” lookup terms:
      wall
      USE THIS PROGRAMMING ONE LINER AT OWN RISK AS AUTHOR CLAIMS NO
      RESPONSIBILITY.
      If
    • #3116170

      Query RPM packages for information – Programming One Liner 16

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Get information about a RPM
      [root@plain home]# rpm -qip gnome-desktop-2.2.2-2.2E.src.rpm
      Name : gnome-desktop Relocations: (not relocatable)
      Version : 2.2.2 Vendor: Red Hat, Inc.
      Release : 2.2E Build Date: Wed 20 Jul 2005 04:12:27 PM CDT
      Install Date: (not installed) Build Host:

    • #3116171

      Watch /var/log/messages for SSH intruders – Programming One Liner 17

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Monitoring
      /var/log/messages /user/security/ssh-intruders.log ; cat
      /user/security/ssh-intruders.log
      This programming one liner allows you to query /var/log/messages files
      for break-in attempts. Prints the total count of attempts by each
      intruder. The following output (sample) is produced 3 attempts by
      163.27.207.193 2 attempts by 84.243.73.25 14 attempts by ali.2kads.cz
    • #3116172

      Investigating all open ports on Linux web server – Programming One Liner 18 – 21

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Unneeded open ports can be costly for your business!
      If you have unneeded and unexplained ports open on your server, you are calling for trouble.
      nmap -p 1-65535 localhost

      This programming one liner allows you to look for all open ports (ports that are currently listening) on your Linux server.
      Programming “One Liner” lookup terms:
      nmap fuser
      Output of running the above command will produce
      • #3135622

        Investigating all open ports on Linux web server – Programming One Liner 18 – 21

        by justame@work ·

        In reply to Investigating all open ports on Linux web server – Programming One Liner 18 – 21

        Although I’m sure your intentions are well ment, reality
        is unless the physical box is shared by those other than a few trusted people, either directly or indirectly, the need
        for concern with open ports on “localhost” (which usually resolves to
        the local loopback, that is 127.0.0.1) is limited.  I’d be more inclined
        to offer:  nmap -sS -p 1-65535 (your_IP), and do this from a few remote
        boxes (presuming you have root access on them (required to run “-sS” option):

        • A – one from the same local subnet
        • B – one from a remote subnet but
          internal to your IP address space
        • C – one from a location outside your
          address space.

        It’s possible that there is a service that is running, and is needed by the lo
        interface, but is not accessible to the ingress interface (such as when AmavisD and SpamAssassin are set up), either due to a
        local filter, of via a local firewall or router, in which case, your concern is
        greatly reduced if not all but eliminated.

    • #3116166

      gunzip multiple files – Programming OneLiner 22

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Gunzip
      gunzip site*.gz
      This programming one liner allows you to unzip / gunzip all files
      beginning with site and ending with .gz within the current directory
      Programming “One Liner” lookup terms:
      gunzip gzip
      USE THIS PROGRAMMING ONE LINER AT OWN RISK AS AUTHOR CLAIMS NO
      RESPONSIBILITY.
      If you would like more information on any of the commands, please feel
      free to contact me with your programming
    • #3114756

      Upgrading MySQL – Upgrade MySQL to 5.0

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      This guide will show you how to upgrade to MySQL 5.0 on a Linux Box.

      Also see MySQL 5.0 article.

    • #3114757

      MySQL 5.0 is “capable of meeting our customers’ toughest requirements” : Rick Bernard – SSA Global.

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      MySQL 5.0 Released for Production

      MySQL 5.0 Now Available for Production Use Enterprise Platform Vendors Express Enthusiastic Support for World’s Most Popular Open Source Database Major New Version Delivers Advanced SQL Standard-Compliant Features Such as Stored Procedures, Triggers, Views & New Pluggable Storage Engines

      UPPSALA, Sweden & CUPERTINO, California. — October 24, 2005 — MySQL AB, developer of the world’s most popular open source database, today announced the general availability of MySQL 5.0, the most significant product upgrade in the company’s ten-year history. Starting today, MySQL 5.0 can be downloaded under the open source GPL license at http:/dev.mysql.com.

      “We are quite proud to deliver this new version of MySQL — as it includes the most-requested features from our users, customers and partners,” said Marten Mickos, CEO of MySQL AB. “With their feedback, we have been able to provide important enterprise-class features while staying true to MySQL’s renowned heritage of high-performance, reliability and ease-of-use.”
      MySQL 5.0’s Enterprise Database Features

      The new MySQL 5.0 combines enterprise-grade reliability and performance with advanced SQL 2003 standard-compliant features, making it the most cost-effective database solution for business-critical applications. The product’s new functionality will be especially familiar to database developers and DBAs of proprietary relational database systems — allowing IT departments to ease the integration and transition of their data, applications and skill-sets.

      MySQL 5.0 delivers dozens of new enterprise features, including:

      * Stored Procedures and SQL Functions — to embed business logic in the database and improve performance;
      * Triggers — to enforce complex business rules at the database level;
      * Views — to ensure protection of sensitive information;
      * Cursors — to allow easier database development and reference of large datasets;
      * Information Schema — to provide easy access to metadata;
      * XA Distributed Transactions — supports complex transactions across multiple databases in heterogeneous environments;
      * SQL Mode — provides server-enforced data integrity for new and existing data;
      * New Federated and Archive Storage Engines — MySQL’s unique pluggable storage engine architecture allows greater flexibility, functionality and performance by making it easy to swap database engines in and out, based on users’ application requirements;
      * New Migration Toolkit — A new graphical toolkit that completely migrates all data and objects from Oracle, Microsoft SQL Server, Microsoft Access and other database platforms to MySQL;
      * Instance Manager — new management assistant that allows remote starting/stopping of any MySQL Server, as well as remote editing of configuration files, reading of error and query logs, and more;
      * Updated Connectors and Visual Tools — new high-performance versions of MySQL’s ODBC, Java and .NET database drivers are now available, along with updated versions of the MySQL Query Browser and MySQL Administrator.

      “MySQL 5.0 represents a huge leap in features and functionality for the MySQL database,” said Gunter Rombauts, European IT manager for Chicago Metallic. “As a worldwide leader in metal ceiling systems, it’s critical that our database supports heavy-duty enterprise applications with speed and reliability. We are looking forward to using MySQL 5.0 as a key component of Chicago Metallic’s global IT infrastructure.”
      Industry Support for MySQL 5.0

      Over 30 enterprise software and database tool vendors have expressed support for MySQL 5.0. These third-party partners’ products and platforms will be certified for MySQL Network, the company’s commercial database subscription service. They include Acronis, ActiveGrid, Actuate BIRT, Agresso, Alphasoftware, Arkeia, Business Objects, Embarcadero Technologies, Emic Networks, Four J’s, GoldenGate Software, HP, IBM, Informatica, Jaspersoft, NEC System Technologies, Nomura Research Institute, Novell, Pentaho, Quest Software, Red Hat, Samsung SDS, SAP, SourceLabs, SpikeSource, SSA Global, Steeleye, Sumisho Computer Systems Corporation, Sun Microsystems, SugarCRM, Zend, and Zimbra.

      SSA Global, a leading global provider of extended enterprise solutions and services, will certify SSA ERP LN 6.1 with MySQL Network 5.0 before the end of this year. “MySQL 5.0, with its enterprise-class features, represents a very cost-effective and proven database alternative capable of meeting our customers’ toughest requirements,” said Rick Bernard, vice president Solutions Management, SSA Global. “SSA Global is committed to Open Source solutions, and support for MySQL is the next significant step in delivering value to our customers.”

      Ton Dobbe, product marketing manager for Agresso, states, “Apart from being the most popular open source database with over 6 million active installations worldwide, MySQL 5.0 also provides our clients with a robust, viable alternative to traditional offerings in the market at total cost of ownership savings of up to 90 percent.”
      Platforms and Availability

      The production version of MySQL 5.0 is available now for Linux, Windows, Solaris, Mac OS X, FreeBSD, HP-UX, IBM AIX 5L and a range of other operating systems.All MySQL database software is available under a dual licensing model. Developers and organizations can choose between an open source (GPL) or a commercial MySQL license, depending on their deployment requirements. End-user enterprises can also subscribe to MySQL Network, a comprehensive set of certified software and premium support services.For software downloads and additional information, visit http://www.mysql.com/products/.
      About MySQL

      MySQL AB develops and supports a family of high performance, affordable database products. The company’s flagship product is MySQL, the world’s most popular open source database, with more than 6 million active installations. Many of the world’s largest organizations, including Yahoo!, Sabre Holdings, The Associated Press, Suzuki and NASA are realizing significant cost savings by using MySQL to power high-volume Web sites, business-critical enterprise applications and packaged software.

      With headquarters in Sweden and the United States — and operations around the world — MySQL AB supports both open source values and corporate customers’ needs in a profitable, sustainable business. For more information about MySQL, please visit http://www.mysql.com.

      # # #

      MySQL is a registered trademark of MySQL AB in the USA and other countries. Other products mentioned may be trademarks of their respective companies.

      Source: MySQL.com

      Information for MySQL Database Administrators (DBA)
      See MySQL 5.0 Changes and
      MySQL upgrading from 4.1

    • #3114758

      MySQL 5.0 DBA – Review

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Today, I launched this blog and became aware of MySQL 5.0 being released. I have decided to upgrade MySQL from 3.23.56 to 5.0. This post will contain my review and the next post will include my upgrade to MySQL 5.0 details.

      First some exciting stuff about MySQL

      QUICK LOOKS: (MySQL 5.0 Whitepaper)

      • MySQL has six million active installations worldwide
      • 40,000 MySQL downloads occur every day.

      Countless corporations, educational facilities, and government agencies rely on MySQL to manage their critical data assets and service anywhere from hundreds to billions of requests per day. With over six million active installations worldwide and 40,000 downloads occurring every day, the popularity and prominence of MySQL continue to rise.

      reliability, performance and ease-of-use are “the three priorities of the MySQL database server.”

      ACID Transactions ? MySQL supports ACID (Atomic, Consistent, Isolated, Durable) transaction model that ensures the integrity and validity of every entered transaction. Full COMMIT and ROLLBACK, with redo logs and undo (rollback) segment areas to ensure data consistency during crash recovery operations.
      ? Server-Based Data Integrity ? Invalid data (bad dates, invalid numbers, etc.) can be automatically rejected at the server, with column-level rules enforcement being possible. In addition, full foreign-key support is provided so that complete data referential integrity is guaranteed.
      ? Low Contention Issues ? Unlimited row-level locking is provided within InnoDB as is automatic deadlock detection, custom isolation levels (READ COMMITTED, etc.), to virtually eliminate locking issues. In addition, InnoDB supports multi-version concurrency control so that those reading data see a snapshot of the requested information as it existed at the moment their query was issued. This ability ensures that readers don?t block writers and vice-versa, and leads to extremely high levels of data availability.

      • Support for stored procedures
      • Fast performance
      • Easier Security Administration
      • Fast Performance
      • Reduced Network Traffic

      Using MySQL 5.0 Stored procedures

      • very easy to use
      • adhere to the ANSI SQL 2003 specification
      • standoutput ability for SELECT statements

      Creating MySQL Stored Procedure


      delimiter //
      create procedure myproc()
      select * …..;
      //
      delimiter;
      call top_broker();


      delimiter //
      create function broker_name(id int)
      returns varchar(50)
      deterministic
      begin
      declare broker_name(VARCHAR (50)
      select * into broker_name from broker …..;
      return broker_name;
      end
      //
      delimiter;
      select top_broker(1);

      • “SHOW PROCEDURE STATUS ” is now possible
      • mysql.proc can be queried
      • 5.0 INFORMATION_SCHEMA data dictionary
      • SHOW CREATE PROCEDURE function (to create DDL)

      • #3123431

        MySQL 5.0 DBA – Review

        by fleveneur ·

        In reply to MySQL 5.0 DBA – Review

        I think Mysql 5 is going to take a big piece into Oracle and Microsoft
        DB Market. Mysql will become what Apache became for web server and PHP
        for SSP (Server Side programming). Besides, Mysql is available on all
        platforms unlike Microsoft.
        Microsoft has became that big enormous fat beast that cannot move and
        turn around quickly and easily and it is now depending on huge revenu
        that they will have trouble to maintain.

        Mysql is definitely a database DBAs must learn.

    • #3114752

      Upgrade to MySQL5 1 – Upgrading MySQL3 to MySQL4 – Red Hat Enterprise Linux 3 RHEL

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Here comes the time to upgrade from MySQL 3.23 to the latest MySQL 5.0. In the first part, I will guide you through the MySQL 3 to MySQL 4 upgrade.

      MySQL recommends we upgrade to next series available.

      As a general rule, we recommend that when upgrading from one release series to another, you should go to the next series rather than skipping a series. For example, if you currently are running MySQL 3.23 and wish to upgrade to a newer series, upgrade to MySQL 4.0 rather than to 4.1 or 5.0.

      • Read upgrading section for the release series to which you are upgrading, change notes to learn about new features.
      • Backup your databases.
      • Making changes to the grant tables. Read ?Upgrading the Grant Tables?.
      • Read MySQL replication upgrade info
      • MySQL-Max distribution: According to MySQL, you will need to ” upgrade later to a non-Max version of MySQL, mysqld_safe still attempts to run the old mysqld-max server. If you perform such an upgrade, you should manually remove the old mysqld-max server to ensure that mysqld_safe runs the new mysqld server.”


      Moving data files and Table Character Sets


      For this MySQL says that you can move MySQL format and data files “between different versions on the same architecture as long as you stay within versions for the same release series of MySQL”. If character set of a table needs to be changed, then run

      charsetmyisamchk -r -q –set-character-set=

      on all MyISAM tables. The character sets need to be changed because other indexes that you created on MySQL may not work because the sort order can be changed if the character set is changed.

      Renaming old MySQL

      At this point you may want to rename MySQL directory for backup. mysqldump can be used to do this job. Then mysql or mysqlimport can be invoked to read the database dumps created by MySQL.

      MySQL says

      If, after an upgrade, you experience problems with recompiled client programs, such as Commands out of sync or unexpected core dumps, you probably have used old header or library files when compiling your programs.
      ….
      If problems occur, such as that the new mysqld server does not want to start or that you cannot connect without a password, verify that you do not have some old

      my.cnf

      file from your previous installation. You can check this with the

      –print-defaults

      option (for example, mysqld –print-defaults). If this displays anything other than the program name, you have an active

      my.cnf

      file that affects server or client operation.

      It is a good idea to rebuild and reinstall the Perl

      DBD::mysql

      module whenever you install a new release of MySQL. The same applies to other MySQL interfaces as well, such as the PHP

      mysql and mysqli extensions or the Python MySQLdb module.

      Convert old ISAM tables to MyISAM

      format

      You have the following options:

      1. Use mysql_convert_table_formatscript as described here. Then use the following command only if

        all

        tables in the database are ISAM or MyISAM tables

        shell>mysql_convert_table_format database db_name

      2. To convert tables individually, use
        mysql> ALTER TABLE tbl_name TYPE=MyISAM;

      To know the table type for any MySQL table, use

      mysql> SHOW TABLE STATUS LIKE 'tbl_name';

      Make sure you are not using shared MySQL libraries (Perl DBD::mysql module, MySQLdb). Otherwise according to MySQL, “you should recompile them, because the data structures used in libmysqlclient.so.”

      MySQL UPGRADE GUIDE 1

      MySQL Server Changes with MySQL4 onwards

      1. server by default no longer loads user-defined functions. ?User-Defined Function Security Precautions?.
      2. many new privileges in the

        mysql.user

        table : ?Privileges Provided by MySQL?.

      3. safe_mysqld has been renamed to mysqld_safe
      4. “InnoDB support is included by default” (binary)
      5. mysqld option –temp-pool enabled by default(better performance with Linux).
      6. Startup options –skip-locking and –enable-locking have been renamed to –skip-external-locking and–external-locking
      7. External system locking of MyISAM/ISAM files is turned off by default. To turn it on, use

        -external-locking

      Renamed startup variables and options:


      Name in 3.23

      Name in 4.0 (and above)

      myisam_bulk_insert_tree_size

      bulk_insert_buffer_size

      query_cache_startup_type

      query_cache_type

      record_buffer

      read_buffer_size

      record_rnd_buffer

      read_rnd_buffer_size

      sort_buffer

      sort_buffer_size

      warnings

      log-warnings

      –err-log

      –log-error

      (for mysqld_safe)

      Why should you use truncate instead of delete

      You should use TRUNCATE TABLE when you want to delete all rows from a table and you do not need to obtain a count of the number of rows that were deleted. (DELETE FROM tbl_name returns a row count in 4.0 and does not reset the AUTO_INCREMENT counter, and TRUNCATE TABLE is faster.)

      For Full Text indexes


      To use MATCH … AGAINST (… IN BOOLEAN MODE) full-text searches, you must rebuild existing table indexes using REPAIR TABLE tbl_name USE_FRM. If you attempt a boolean full-text search without rebuilding the indexes in this manner, the search returns incorrect results. See ?Fine-Tuning MySQL Full-Text Search?.

      Also see: ?How to Make a Threaded Client?

      Comments and Errors

      .
      Download MySQL from here.

      wget http://dev.mysql.com/…./MySQL-server-5.0.15-0.i386.rpm

      Now lets verify the integrity of the package using md5sum

      [root@plain install]# md5sum MySQL-server-5.0.15-0.i386.rpm
      13971fd27ff2dc38537ff157ef6b715a MySQL-server-5.0.15-0.i386.rpm

      Now verify that the MD5 checksum listed matches the MD5 Checksum on MySQL site.

      In our case the md5 checksums do match.

      13971fd27ff2dc38537ff157ef6b715a == 13971fd27ff2dc38537ff157ef6b715a

      Therefore we can continue with the installation.

      MySQL won’t let you have both servers on one machine as we get the following error when installing MySQL 5 on top of MySQL 3

      [root@plain install]# rpm -ivh MySQL-server-5.0.15-0.i386.rpm
      warning: MySQL-server-5.0.15-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
      error: Failed dependencies:
      MySQL conflicts with mysql-3.23.58-2.3
      MySQL-server conflicts with mysql-server-3.23.58-1

      We get the following errors when trying to uninstall MySQL

      [root@plain install]# rpm -ev mysql
      error: Failed dependencies:
      libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3
      libmysqlclient.so.10 is needed by (installed) libdbi-dbd-mysql-0.6.5-5
      libmysqlclient.so.10 is needed by (installed) MySQL-python-0.9.1-6
      libmysqlclient.so.10 is needed by (installed) MyODBC-2.50.39-12
      libmysqlclient.so.10 is needed by (installed) mysql-server-3.23.58-1
      mysql = 3.23.58 is needed by (installed) mysql-devel-3.23.58-2.3
      mysql is needed by (installed) MySQL-python-0.9.1-6
      mysql = 3.23.58 is needed by (installed) mysql-server-3.23.58-1

      To fix this, we need to uninstall MySQL 3.23 and all dependencies

      rpm -ev mysql perl-DBD-MySQL-2.1021-3 libdbi-dbd-mysql-0.6.5-5 MySQL-python-0.9.1-6 MyODBC-2.50.39-12 mysql-server-3.23.58-1 mysql-devel-3.23.58-2.3 MySQL-python-0.9.1-6 mysql-server-3.23.58-1

      Now lets get the other MySQL utilities

      Benchmark suits

      Downloading

      wget http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-server-standard-5.0.15-0.rhel3.i386.rpm/from/ftp://ftp.orst.edu/pub/mysql/

      wget http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-client-standard-5.0.15-0.rhel3.i386.rpm/from/ftp://ftp.orst.edu/pub/mysql
      wget http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-shared-standard-5.0.15-0.rhel3.i386.rpm/from/pick/ftp:/ftp.orst.edu/pub/mysql
      wget http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-devel-standard-5.0.15-0.rhel3.i386.rpm/from/pick/ftp:/ftp.orst.edu/pub/mysql/

      You should have the following RPMs now for MySQL

      [root@plain mysql]# ls
      MySQL-bench-5.0.15-0.i386.rpm MySQL-server-standard-5.0.15-0.rhel3.i386.rpm
      MySQL-client-standard-5.0.15-0.rhel3.i386.rpm MySQL-shared-standard-5.0.15-0.rhel3.i386.rpm

      Calculate MD5

      Verify all the packages using MD5

      [root@plain mysql]# md5sum MySQL-*
      3b02c71d5d5354bcd8ce9a534a999d74 MySQL-bench-5.0.15-0.i386.rpm
      c7a0047f24d2ba0494829eb5a9c572bf MySQL-client-standard-5.0.15-0.rhel3.i386.rpm
      b13df3d95bb8fca02d23546b84931140 MySQL-server-standard-5.0.15-0.rhel3.i386.rpm
      109ca0273a6a7c460e4afaef3def88b3 MySQL-shared-standard-5.0.15-0.rhel3.i386.rpm
      51772ca969fa08a13064410469d79191 MySQL-devel-standard-5.0.15-0.rhel3.i386.rpm



      Now lets install the MySQL 5 RPM


      [root@plain mysql]# rpm -ivh MySQL-client-standard-5.0.15-0.rhel3.i386.rpm
      warning: MySQL-client-standard-5.0.15-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
      Preparing… ########################################### [100%]
      1:MySQL-client-standard ########################################### [100%]
      [root@plain mysql]# rpm -ivh MySQL-server-standard-5.0.15-0.rhel3.i386.rpm
      warning: MySQL-server-standard-5.0.15-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
      Preparing… ########################################### [100%]
      1:MySQL-server-standard ########################################### [100%]
      PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
      To do so, start the server, then issue the following commands:
      /usr/bin/mysqladmin -u root password ‘new-password’
      /usr/bin/mysqladmin -u root -h server password ‘new-password’
      See the manual for more instructions.

      Please report any problems with the /usr/bin/mysqlbug script!

      The latest information about MySQL is available on the web at
      http://www.mysql.com
      Support MySQL by buying support/licenses at https://order.mysql.com
      Starting MySQL.[ OK ]
      [root@plain mysql]# rpm -ivh MySQL-devel-standard-5.0.15-0.rhel3.i386.rpm
      warning: MySQL-devel-standard-5.0.15-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
      Preparing… ########################################### [100%]
      1:MySQL-devel-standard ########################################### [100%]
      [root@plain mysql]#
      [root@plain mysql]# rpm -ivh MySQL-shared-standard-5.0.15-0.rhel3.i386.rpm
      warning: MySQL-shared-standard-5.0.15-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
      Preparing… ########################################### [100%]
      1:MySQL-shared-standard ########################################### [100%]
      [root@plain mysql]# rpm -ivh MySQL-bench-5.0.15-0.i386.rpm
      warning: MySQL-bench-5.0.15-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
      error: Failed dependencies:
      MySQL-client is needed by MySQL-bench-5.0.15-0
      [root@plain mysql]#

      Notice we got an error for the benchmarks one. We will investigate this later.

      Now we can confirm that the MySQL RPMs have been installed.

      [root@plain mysql]# rpm -qa | grep -i mysql
      MySQL-client-standard-5.0.15-0.rhel3
      MySQL-server-standard-5.0.15-0.rhel3
      MySQL-shared-standard-5.0.15-0.rhel3
      MySQL-devel-standard-5.0.15-0.rhel3

      END


      EV1 – MySQL4

    • #3114753

      MySQL5 – PHP4 – Troubleshooting – Call to undefined function: mysql_connect()

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Earlier, I showed you how to install MySQL 5 (MySQL5) on a Red Hat Enterprise Linux server. The MySQl 5 installation went just fine for us, however today when I tried to run a test script incorporating a MySQL 5 client to MySQL 4 server connection, I received the following errors

      PHP Fatal error: Call to undefined function: mysql_connect()

      I was aware that mysql_connect has been discontinued in C API, but why am I getting this error? I found that mysql_connect has been deprecated in favor of mysql_real_connect(). While that doesn’t solve our issue at hand, I do want to take a moment to point out that Ingo Tomahogh has a good tip posted on http://dev.mysql.com about migrating your code from using mysql_connect() to mysql_real_connect function. To put it in Ingo’s words:

      If you need to compile old programs still using this function, you might want to add the following macro definition to your programs (possibly via the compiler’s command line) so you needn’t change all calls to mysql_connect() :

      #define mysql_connect(m,h,u,p) mysql_real_connect((m),(h),(u),(p),NULL,0,NULL,0)

      You should also make sure the MYSQL pointer is never NULL in these calls, though.

      Thanks to David Phillips for pointing out the following

      In response to the mysql_connect() macro, also make sure to call mysql_init() before using it. You didn’t need to (or at least it worked) with older versions of the library. You will immediately crash if you don’t.

      Another thing worth noting here is that the errors and return values for mysql_real_connect() are the same as mysql_connect(). More information on mysql_connect function in available from dev.mysql.com.

      Now, back to troubleshooting our “Call to undefined function: mysql_connect()“. Some other MySQL error messages:

      PHP Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client

      The issue PHP is complaining about here is threefold.

      1. missing mysql.so extension definition in /etc/php.ini, and/or
      2. missing mysql.so file on system
      3. missing lib*mysql.so* files on your system

      First, get a copy of mysql.so and put it in /usr/lib/php4 or equivalent.

      cp -p /old/usr/lib/php4/mysql.so /usr/lib/php4/

      Now, put the following line in /etc/php.ini

      extension=mysql.so

      After restarting httpd (Apache), I got

      PHP Warning: Unknown(): Unable to load dynamic library ‘/usr/lib/php4/mysql.so’ – libmysqlclient.so.10: cannot open shared object file: No such file or directory in Unknown on line 0

      To fix this, get a copy of libmysqlclient.so.10. Assuming you have got a copy on your hard drive

      cp -p /old/usr/lib/libmysqlclient.so.10 /usr/lib/

      Now, restart Apache, and voila! you should be able to connect. To verify, load phpinfo() and you should see a section similar to the following:

      mysql

      MySQL Support enabled
      Active Persistent Links 0
      Active Links 0
      Client API version HIDDEN
      MYSQL_MODULE_TYPE external
      MYSQL_SOCKET /var/lib/mysql/mysql.sock
      MYSQL_INCLUDE -I/usr/include/mysql
      MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient

      Related MySQL troubleshooting tips from fellow webmasters online.
      Resolving a Fatal error: Call to undefined function mysql_connect() in RedHat
      PHP works, but not with mysql
      could not connect mysql5 from php5
      Call to undefined function: mysql_connect()
      MySQL on Technorati
      MySQL on Del.icio.us

    • #3114754

      Planet MySQL – Are you in?

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      For any MySQL DBA, PlanetMySQL is an indispensable community resource pulling latest information about MySQL from blogs targeted towards MySQL users.
      If your blog is about MySQL, consider submitting it to PlanetMySQL.org. An aggregated RSS feed is available at PlanetMySQL. If your blog is accepted to this MySQL community, you can be sure that your voice is being heard in the MySQL community.

      Thanks to everyone at MySQL and PlanetMySQL for providing such an excellent resource and for listing MySQL Database Administration blog as a contributor blog.

    • #3114755

      First Open Source Enterprise CMS Integrates with MySQL

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Standards-Based System Enables Developers to Easily Build Custom Applications; Lowers Cost and Complexity of Deploying True Enterprise Content Management

      MySQL developers can “gain access to the latest technology and develop against a certified, supported version of the product”

      From: Open Source Business Conference 2005

      BOSTON–October. 31, 2005–

      Enterprises and developers can now download the first enterprise-class content management system that utilizes the power of open source. Traditional Enterprise Content Management (ECM) systems were designed a decade ago, leaving them with cumbersome interfaces and legacy technology. Alfresco is built on modern, service oriented technologies and standards from this decade, such as Spring, Hibernate, Lucene and Web Services, JSR-168, JSR-170 and MyFaces. These help to dramatically bring down the cost and complexity of both implementation and use of these systems. The company is lead by a team of content management veterans including the co-founder of Documentum.

      The Alfresco ECM solution is designed for small to mid-sized enterprises and departments in Global 1000 organizations that want a system that is easy for end-users to use while also being simple-to-install and flexible for developers to create new and customized content applications.

      Alfresco has benefited from support from MySQL and JBoss and integrates to MySQL, JBoss Portal, JBoss Application Server, JBoss Cache, JBoss Application Server and Hibernate.

      “Informa has over 7000 employees in 159 offices in 40 countries. We were looking for a flexible, cost-effective system that could meet the diverse requirements of our business,” said Bob Hecht, VP – Content Strategy for Informa. “The success of the current project will hinge on ease-of-use and configurability. We determined that the Alfresco approach is an excellent fit for our user requirements and it’s cutting edge technical architecture will provide us the flexibility and power to out-perform the traditional ECM market.”

      Alfresco ECM: Already in Use Worldwide

      Alfresco has already logged tens of thousands of downloads since releasing a preview of the repository in June. The company has benefited from support from JBoss and MySQL. Alfresco integrates to the JBoss Portal, JBoss Application Server, JBoss Cache, JBoss Application Server, Hibernate and MySQL. Customers across all sectors in both the US and Europe have started to benefit from Alfresco. A number of hosting partners are being announced highlighting the strength of the product in this environment. The Alfresco software is true zero footprint ECM whereby no ActiveX or Java Applets are required on the client. It is easy to setup and users can be invited to groups without costly administration. As the system is not proprietary and uses standards such as JSR-170 and Web Services, a client can use the same system both internally and externally.

      “Thanks to the increasing corporate regulation as well as the exponential growth of electronic documents, content management has emerged as a ‘must have’ application,” said Alfresco CEO John Powell. “The problem is, those companies that have installed complex content management systems in the past, today find that they are underutilized thanks to complex interfaces and large feature-sets that do not meet the needs of today’s enterprise. We built Alfresco to fix those problems.”

      Easy-to-use Interface Ensures User Adoption

      Alfresco uses the Microsoft CIFS interface, which enables users to treat content just as they would a Microsoft Windows shared file drive. Unlike other interfaces, CIFS enables users to take work offline and synchronize it when reconnecting. It also allows applications that will only work with mounted drives or non-networked file systems to work natively with the Alfresco repository. These can include a user’s native editing tool or a corporate application.

      “In most companies today, even those with long-standing content management systems, you find a shared drive is where people place their information, eschewing central management. Since that’s a process people are comfortable using, we made Alfresco work within that structure,” said Alfresco CTO John Newton. “This ease-of-use extends beyond the product functionality making the product easy to install and rollout throughout a company with minimal training.”

      Additional product benefits include:

      • Developer Productivity and Portability – Developers can easily customize the system through wizards or the language of their choice. This can include customization through Aspect-Oriented Programming, Web Services, simple Templating, XML, Java and JCR-170. These customizations are portable across multiple operating systems and clients. They can also be used between a hosted and an internal environment.– Scalable and Fault Tolerant Architecture – The server offers high levels of scalability through a fully distributed, clustered cache. High availability is offered through replication and failover management.
      • Compliance/Secure Document Lifecycle Management – Alfresco’s Aspect-Oriented approach allows document lifecycle rules to be configured quickly and easily. Here, for example, “author, review, approve and distribute” workflows can be simply set-up with rules to both change the security and format of the document with a full audit trail.

      Multiple Levels of Network Support

      Also today, Alfresco announced the availability of both a free open source “Community Network” and a series of fee-based support networks. Alfresco has designed several levels of network support to meet the specific needs of the organization and enterprise using the product.

      These include:

      • Community Network: Free open source downloadable Enterprise Content Management system supported by a large and active community of open source developers;
      • Developer Network: Enables developers to gain access to the latest technology and develop against a certified, supported version of the product;
      • Professional Network: Designed for small enterprises or departments in Global 1000 organizations and layers in additional security functionality and support;
      • Enterprise Network: Designed for the Global 1000 offering support and functionality that includes advanced security features such as single sign-on and mission critical features such as clustering, failover and advanced caching. This is priced to allow for unlimited seats.

      Pricing and Availability

      The Community Network is free and is available for download today at http://www.alfresco.org.

      The Developer Network is $4.99 monthly per user and the Professional Network is $9.99 monthly per user. The Enterprise Network offers unlimited users for a monthly fee of $625. For a limited period all customers taking out a support subscription to the Alfresco Professional Network will receive the Alfresco Enterprise Network product capabilities free of charge. The Professional and Enterprise Network’s are available for download today at http://www.alfrescosoftware.com.

      About Alfresco

      Alfresco Software Inc. is the leading open source alternative for enterprise content management. It is the first company to bring the power of open source to the enterprise content management market, enabling unprecedented scale and a much lower total cost of ownership than proprietary systems. Founded by a team of content management veterans that includes the co-founder of Documentum, John Newton, and former COO of Business Objects, John Powell, Alfresco is based in London. For more information, visit http://www.alfrescosoftware.com.

      Alfresco Software Inc.
      Ian Howells, +44 1628 860 639

      Sources: Alfrescosoftware.com , BUSINESS WIRE
      Editor: Frank Mash
      Tags: MySQL CMS ECM Open Source

    • #3137893

      Network Security Blacklist for November 1, 2005

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      I have started a new blog about Network Security – Blacklists to publish blacklists of IP addresses involved in attacks.

      View today’s blacklists

      Network Security blacklists

    • #3137888

      Sony rootkit and viruses – Think again before installing that music cd from Sony

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Sony is installing rootkit and viruses on computers? I could have never believed it just a couple of years ago. But today seeing how greedy corporations are getting, I have no choice but to believe it.
      GameShout reports
      Sony is using spyware and rootkit technologies to prevent unauthorized copying of its music CDs. It has become the basis of a dispute that once again pits comptuer advocates

    • #3137889

      For System Administrators

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Just some notes for system administrators

      1. Checking logs for previous break-in attempts.
      2. Checking server for existence of rootkits (used to hack and change programs on server without making them detectable to the admin) using multiple tools.
      3. Create an alternate account (userKabacha) or (userDRM) which will act as the root account.
      4. Changing the root login shell so even if a hacker

    • #3137890

      “Sony knows … what you listen to” – Internal techincal support says, “So sue us”

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      According to a comment posted on SysInternals:
      Btw, I checked with a sniffer. The DRM system connects to connected.sonymusic.com and http://www.sonymusic.com and tells them an id number, apparently identifying the album. So, sony knows your ip address and what you listen to.
      So, Sony is spying on you. Really sickening stuff. In related news, Amazon users are calling for a complete Sony Boycott.

      QUOTES

    • #3137891

      Sony rootkit update

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      I am just amazed at how fast Sony rootkit talk has encompassed the web. Although Sony has released a patch, using the patch may make the CD unplayable.

      Mark Russinovich: Sony, Rootkits and Digital Rights Management Gone Too Far
      Inquirer also has a story on Sony’s DRM being worse than we think. Inquirer comments about the discrimnation Sony has put in place.

      IMO, F-Secure has tried to downplay

    • #3119262

      Restoring drives on a RHEL server

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      – Restore server A .
      – Slave the hard drives of server A on restored server.
      – Slave the /home (primary hard drive) of server A

      After restore the server A witll have 4 drvies:
      1. New Drive
      2. New Drive
      3. Slaved Drive (Primary) of server B
      4. Slaved Drive (Secondary) of server B

      In 72 hours we would like the following changes:

      1. Remove Drive (Primary) of server A from server B
      2. Slaved

    • #3118564

      AJAX and Web 2.0

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      I made a post on my AJAX blog about AJAX, Web 2.0 and SOAP, including a latest AJAX tutorial on how to build SOAP client using AJAX from a software engineer of IBM.

      In the coming days, I will post more on AJAX and Web 2.0, so please keep an eye on my blog.

      Thanks
      Frank Mash

      More blogs about web 2.0 AJAX XML SOAP

    • #3117974

      audit.d crashing – Auditd save files consuming large amount of disk space in /var/log/audit.d/save

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Today, as I was about to copy over some directories from an old drive on a Linux web server, I was shocked to notice that my SCSI hard disk dive was 90% full. BTW, it is a good system administration practice to always check for disk space before you copy over large directories. To quickly view disk usage statistics in human readable form, use the following command.
      df -h

      So I was really amazed

    • #3130770

      hostname – Changing server host name

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Before starting ensure that your desired hostname is resolving to the server and read the disclaimer below. Steps in changing the hostname on a plain Red Hat Enterprise Linux server are:

      1. Modifying /etc/sysconfig/network (replace XXX.XXX.XXX.XXX with your gateway IP )
      NETWORKING=yes
      HOSTNAME=”plain.ev1servers.net”
      GATEWAY=”XXX.XXX.XXX.XXX”
      GATEWAYDEV=”eth0″
      FORWARD_IPV4=”yes”

      2. Modify

    • #3130771

      SMART Disks – Controlling and monitoring SMART SCSI disks with smartctl

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      What are SMART disks?
      SMART is an abbreviation for Self-Monitoring, Analysis and Reporting Technology (SMART). SMART system is built into many ATA-3, ATA, IDE and SCSI-3 hard drives.

      What is smartctl?
      According to manual entry for smartctl,
      smartctl is a command line utility designed to perform SMART tasks such as printing the SMART self-test and error logs, and enabling and disabling

    • #3130772

      How to Install / Upgrade Apache 2.0 (Apache2)

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      While I prepare a detailed how-to guide about installing and upgrading Apache, checkout How to upgrade to Apache 2.0 on EV1 forums.

      apache apache+2.0

    • #3130773

      Linux Cool Commands

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Linux Conversion: Tutorial – Convert from Red Hat to Debian Remotely.

      CPU Information: View CPU Information including processor, vendor_id, cpu family, model, model name, stepping, cpu MHz, cache size, physical id and much more
      cat /proc/cpuinfoMemory Information: View memory information
      cat /proc/meminfo
      total: used: free: shared: buffers: cached:
      Mem: 2104721408 1756086272

    • #3130485

      sysctl – Kernel Optimization – /etc/sysctl.conf

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      IP Forwarding:
      Is IP forwarding currently on?
      /sbin/sysctl net.ipv4.ip_forward
      Turn IP forwarding on manually
      /sbin/sysctl -w net.ipv4.ip_forward=1
      Turning IP packet forwarding off manually

      [root@plain scripts]# /sbin/sysctl -w net.ipv4.ip_forward=1
      net.ipv4.ip_forward = 1
      [root@plain scripts]# /sbin/sysctl -w net.ipv4.ip_forward=0
      net.ipv4.ip_forward = 0

      The following command will do the same

    • #3131621

      Turn off php signature

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      To turn off PHP information signature, you can modify /etc/php.ini file and change the following (turns PHP signature on)

      expose_php = On

      to (turns PHP signature Off

      expose_php = Off

      Note from PHP.ini file:

      ; Decides whether PHP may expose the fact that it is installed on the server
      ; (e.g. by adding its signature to the Web server header). It is no security
      ; threat in any way, but it makes it possible to determine whether you use PHP
      ; on your server or not.

      Also see, Find and Replace

      PHP Internet

    • #3131620

      CSS – Cool pre formatting effect

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      On PlanetMySQL, I noticed a cool pre style. You can also try by placing CSS code similar to following for pre HTML tags.

      .phpcode, pre {
      overflow: auto;
      padding-left: 15px;
      padding-right: 15px;
      font-size: 11px;
      line-height: 15px;
      margin-top: 10px;
      width: 93%;
      display: block;
      background-color: #eeeeee;
      color: #000000;
      max-height: 300px;
      }

      Long text of code that never ends cause we just want to demonstrate the css effect here on this very very very long line.

      css

    • #3131619

      Apache ServerTokens

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      In /etc/httpd.conf file, you can change the ServerTokens value to control how much information about Apache is displayed in the headers. By default the settings are

      ServerTokens OS

      Apache/2.0.46 (Red Hat or Windows) Server at 192.168.0.1 Port 80

      By changing ServerTokens to Prod, you can have only Apache displayed in the headers.

      ServerTokens Prod

      Apache Server at 192.168.0.1 Port 80

      If the ServerTokens line is commented out, the output is similar to:

      Apache/2.0.XX (Red Hat) mod_perl/XXX Perl/vXXX DAV/2 mod_python/XXX Python/2.2.3 mod_ssl/2.0.46 OpenSSL/0.9.7a Server at servername.com Port 80

      apache linux

    • #3131618

      Optimize Apache 2.0 (Apache2) on RHEL – Track users using Clickstream

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      First, make a backup and then modify /etc/httpd.conf and change settings as follows

      # change Timeout 300 to
      Timeout 45
      # change KeepAlive Off to
      KeepAlive On
      # MaxKeepAliveRequests: The maximum number of requests to allow
      # during a persistent connection. Set to 0 to allow an unlimited amount.
      # We recommend you leave this number high, for maximum performance.
      # — change MaxKeepAliveRequests 100

    • #3131577

      Address already in use: make_sock: could not bind to address – Apache – HTTPD Error

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      So I was getting the following error on one of my servers.
      Starting httpd: (98)Address already in use: make_sock: could not bind to address 0.0.0.0:443
      no listening sockets available, shutting down
      Unable to open logs!

      The fix is as follows. Run the following command
      netstat -lnp | grep ‘0.0.0.0:80’
      # output
      tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN

    • #3131578

      Apache – HTTPD – Extended Server Status with server-status and ExtendedStatus

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      HTTPD (Apache 2) comes with really cool server status monitoring module that is often loaded by default. To start using it, you need to place code similar to following in the httpd.conf file.
      # FM 11/16/05 server-status module enabled
      ExtendedStatus On

      SetHandler server-status

      Order Deny,Allow
      Deny from all
      Allow from .domain.com

      Remember to modify .domain.com to the domain from where you

    • #3131849

      eBay Developers Program – Open source patents search

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Open Source Development Labs (OSDL) launches open-source patents search.

      Ray Ozzie, CTO of Microsoft, starts a new blog.

      Microsoft eyes supercomputer market.

      eBay makes changes to its developers program. API access now free.

      UPS and eBay allow eBay sellers to ship globally.

      eBay’s developer challenge announces some cool prizes.

      More from open source patents post.

      Technorati Tags: eBay

    • #3132471

      Yahoo small business merchants: Get Firefox search plugin to help users search your Yahoo store

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      If you are a Yahoo! Small Business merchant (Yahoo! store owner), then you may like to know that you can provide your users with a search plugin that can be installed by your customers using Mozilla Firefox browser.

      Near holiday shopping season, many Yahoo! store owners start experiencing explosive growth in traffic, espcially from Yahoo! shopping. By giving your customers a plugin that they can

    • #3127830

      Mayday Mayday

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      When you notice a comment similar to the following in an open-source application, it’s better not to use it 😉

      // we are in trouble !

      mayday open source

    • #3128136

      Hunting down spammers

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      In this work-in-process guide, I aim to show you to hunt down bastard spammers who have been using your server.

      Once again we will start with log files in /var/log/, especially /var/log/secure

      Dec 4 05:59:07 ensim xinetd[1556]: START: pop3 pid=25338 from=216.12.192.107

      #A start session will look something like:
      4 06:23:35 ensim xinetd[1556]: START: pop3 pid=29758 from=216.12.192.107

      # Log

    • #3126201

      Ensim Webppliance – Domain Resolving to Admin Panel – Domain not working

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Sometimes a domain on ensim starts going to the webppliance admin panel instead of the domain. Here we will investigate that case.

      Make sure the site exists #Check
      tail -f /var/log/httpd/access_log # Check
      tail -f /var/log/httpd/error_log # Find
      sitelookup -s siteX
      sitelookup -d domain.org
      Verify /etc/httpd/conf/virtual/site12 exists. If not create it. A demo file (not for

    • #3124675

      SSL on RHEL – SSL Certificate on working – Domain not resolving

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Recently after migrating data from an older hard drive, I needed to transfer SSL configuration for a domain. The domain was not working with the SSL. Pinging the domain was returning the following error message
      ping: unknown host
      So here we had two main issues. One is that domain isn’t resolving to the server and other one being that SSL isn’t working. After running some grep operations, I found

    • #3124526

      ping: sendmsg: Operation not permitted

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      I wasn’t able to ping a machine on my PNET. When pinging I was getting the following message
      ping: sendmsg: Operation not permitted
      The reason was my firewall was not allowing any traffic on eth1. So I modified the following
      IFACE_TRUSTED=”eth1″
      and after restarting AFP using
      service apf restart
      everything started working fine.

    • #3124349

      Securing Apache with mod_security

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Abusing bots are a problem for all successful sites. When dealing with abusive bots, you can take the WebmasterWorld’s senseless route to block all user agents or you can be a bit smart, and install mod_security. That way you won’t have to block all the indexing bots and no one will call you stupid. In this post, I will show you how to secure your Apache 2 installation with mod_security

      First, we

    • #3124213

      Yahoo! acquires Delicious

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Yahoo! has acquired Del.icio.us as of yesterday. For more read the article Yahoo! is Delicious on SearchMarketingAmbassador.com
      Now Yahoo! only needs to acquire Technorati to become the champ of web 2.0.

      In related news, Bill Gates says that MSN may start providing some sort of incentive to its users.

      web 2.0 Yahoo Microsoft Delicious Yahoo

    • #3125815

      Do Not Call List – Disclaimer/Permission to call

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      An interesting disclaimer about Do Not Call List:
      By providing your phone number on this form, you give us permission to call you in response to this request, even if this/your phone number is in the State and/or National Do Not Call Registry. Your privacy is very important to us. We never sell, trade or share your personal information with any third party or organization, and only one of our

    • #3125814

      Johnny Knoxville The Ringer-

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      I honestly think Johnny Knoxville’s ‘The Ringer’ is a crap movie. I can’t even watch it’s commercials. I don’t know why some people do this just for money and fame? Dare to differ?

      johnny knoxville the ringer

    • #3126016

      Linux Tips

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      A friend of mine was having issues using wget. He said that when trying to download images, wget just “hangs”. Upon investigation I found that he was not properly quoting the URL and the ampersand character was causing the “hanging up”. When using wget to download images that have dynamic URLs (include “?” or “&” in the URL) you must quote the URLs using single or double quotes.

      #WRONG
      wget http://frankmash.blogspot.com/?i=1&o=2
      # RIGHT WAY
      wget ‘http://frankmash.blogspot.com/?i=1&o=2’

      As a rule of thumb, always quote parameters that include special characters such as space, question mark, ampersand.

    • #3120829

      SMTP on Port 26

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      To open up a new port (26) and redirect all packets to port 25, use
      iptables -t nat -A PREROUTING -p tcp -d 192.168.0.1 –dport 26 -j DNAT –to 192.168.0.1:25
      –dport 26 does the redirection job. pblinux pointed the following for Ensim Pro 4.0.1 on RHEL
      /sbin/iptables -t nat -A PREROUTING -p tcp –dport 20025 -i eth0 -j DNAT –to xxx.xxx.xxx.xxx:25

    • #3120828

      .htaccess

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      RedHat has some good reference information on how to use .htaccess

    • #3120801

      Forums

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Here are some of the forums I visit from time to time.North Georgia Business Forums
      Home Business Online
      Small Business Brief
      WebmasterWorld
      PHP BBStyles
      Able2Know
      Technorati Tags: forums

    • #3083138

      Notes on Apache tuning

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Some random personal notes:

      Enable the following in php.ini because even your server generates the file quickly, it may still take a lot of time for a user behind a slow connection
      output_handler = ob_gzhandler No matter what you do with PHP, PHP files are still served slower than static HTML filesPass objects and arrays by reference when dealing with functions (PHP 4+) Use ps and top to

    • #3080198

      Mod_security CheckURLEncoding – 100th post – Valentines day

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      I had a weird problem today. When attempting to add a resource using my toolbar to one of my projects, I noticed that I kept getting a 500 error. Upon investigation, I found that the error was due to mod_security installed recently. Further investigation revealed that the following configuration directive was causing issues.
      SecFilterCheckURLEncoding On

      My question now is, does anyone know about

    • #3097256

      Freelance Work

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Looking for Freelance work?
      The following web sites can help you find freelance work.

      ScriptLance

    • #3133514

      Using DocBook on Windows

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Long time ago, I bookmarked Jim Crafton’s tutorial Documentation with Docbook on Windows to follow later in the hopes of installing (and using) docbook on my Windows box. Today I finally decided to download Cygwin

      Following his instructions I installed the following:
      bash make libxslt sed tar gzip find and ofcouse Docbook-xsl-* and HTML Help Workshop Cygwin Bash Shell) and was greeted

    • #3133513

      People, please don’t post illegal projects

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      I saw this project today on a popular Software house:

      I sell 3rd party utilites for an online game. Recently the game developers have found a way to detect my applications. I inject code, hook etc. I use rootkit technology to hide my applications. If you are an expert with this kind of technology and think you can figure out how they detect my applications please bid on this project.

      I will

    • #3134192

      Upgrading APF (Advanced Policy Firewall) – and random thoughts

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

    • #3134193

      Innodb or MyISAM?

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

    • #3091138

      Hacked this AM – ServerBeach Forums

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Today I came across the following discussion where one of my tutorials was mentioned:

      Hacked this AM – ServerBeach Forums: “Someone used a PHP exploit to take down several of our sites this morning.

      Replaced the homepages with their hacker page ~DESTROYER~We had backups but they actually took the time to delete one of our databases, leaving the rest untouched.

      We traced it to the hosting

    • #3091139

      Banning abusing bots using mod_rewrite, .htaccess and modsecurity

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Here are the currently blocked user agents as per my /etc/modsecurity/useragents.conf file:
      # http://www.gotroot.com/mod_security+rules
      # Gotroot.com ModSecurity rules
      #
      # Created by The Prometheus Group (http://www.prometheus-group.com)
      #
      # User Agent Security Rules
      #
      # Download from: http://www.gotroot.com/downloads/ftp/mod_security/useragents.conf
      # Copyright 2005, all rights reserved.
      #
      #

    • #3090949

      “RadioShack Saves Millions of Dollars by Choosing Windows over Linux”: Microsoft

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Case Study: “RadioShack is one of the best-known electronics retailers in the world, with approximately 5,100 company-owned stores and 1,800 dealer-franchise locations that people turn to for batteries, toys, telephones, PCs, and more. However, the company’s 11-year-old, UNIX-based point-of-sale systems had reached the end of their useful life and had to be updated. After an extensive evaluation

    • #3253442

      RadioShack CEO lied on resume: USATODAY.com

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      This story caught my eye:

      USATODAY.com – RadioShack CEO lied on resume: “RadioShack (RSH) Chief Executive David Edmondson said he lied about his academic record, leading the electronics retailer’s board to hire a lawyer to advise it on the matter, according to statements released by the company late Wednesday.

      The questions about Edmondson’s education ? and the revelation that he has been

    • #3090644

      Test Post Tagged

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      I want to tag this test post as mrrrrrareportaddsd

    • #3090300

      Linux commands: The funny linux commands

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Hope you enjoy these funny Linux commands as much as I did:

      % cat “food in cans”
      cat: can’t open food in cans

      % nice man woman
      No manual entry for woman.

      % “How would you rate Quayle’s incompetence?
      Unmatched “.

      % Unmatched “.
      Unmatched “.

      % [Where is Jimmy Hoffa?
      Missing ].

      % ^How did the sex change operation go?^
      Modifier failed.

      % If I had a ( for every $ the Congress spent, what would I

    • #3088933

      Automatically check for /var/log/secure for intruders: Auto Spell for Directories

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Here’s what I like to keep in my .bash_profile to automatically tell me about intruders upon login

      = 5 ){print i “Total Failed Attempts: ” count[i] “”} }}’;
      echo “End of Security Report. (/designerz/security/log/intruder.ssh.log, /designerz/security/log/frankly.messages) “;
      #cat /designerz/security/log/frankly.messages
      #tail -10 /designerz/security/log/intruder.ssh.log;

      alias rm=’rm -i’
      alias

    • #3267564

      CSS two column layout

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Here is a CSS two column layout for you to enjoy

    • #3147876

      Exit Status Code of a Program on Unix / Linux

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Depending on the shell you are using, you can find the exit status code of a program on Unix/Linux using

      in bash

      $?

      or in csh,

      $status

      A non-zero exit code states that the program terminated with an error whereas an exit code of zero states that the program /script terminated normally.

    • #3147877

      Social Bookmarking

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Social bookmarking has literally changed the way people bookmark. While there are many great social bookmarking services, they leave a lot to be desired. For that reason, I have been working on a social bookmarking application that is currently in Alpha. There are many cool features of this social bookmarking application about which I will talk in near future. For right now, a user can get their own subdomain where all their bookmarks can be accessed conveniently. For instance, my subdomain featuring my bookmarks is at frank.socialbookmarking.org. Another cool thing is that you can not only post your bookmarks socially, you can also blog about them right from within your control panel.

      Obviously, you can share your favorites with your friends and even subscribe to a friend or user’s favorites (great to stay in touch via bookmarks 😉 )

      SocialBookmarking.org is my third project written in Ruby on Rails (Official site of Ruby on Rails).

      It’s pretty late at night but I promise I will be blogging more about the features of socialbookmarking.org.

      Till then stay tuned, or better yet, start bookmarking socially.

      Frank

      See the definition of social bookmarking at Wikipedia
      Also see social bookmarking tools

      Things you should know about social bookmarking

    • #3156760

      Viewing a specific version of a man page

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      These days, I have been blogging mostly on Adoppt. You can check out my blog at adoppt.com/blog/frank

      I just posted a small note on how you can view the specific version of a man page. For instance: crontab(5)

    • #3144606

      Hard Disk

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Notes and clips about the workings of a hard disk drive.
      Hard disk platterhttp://en.wikipedia.org/wiki/Hard_disk_platter A spindle mounts several plattersMade of aluminum or glass substrateA typical bit on a hard disk platter (in 2006) is about 200-250 nanometers wide (in the radial direction of the platter) and extends about 25-30 nanometers in the down-track direction (the

    • #3144521

      Buffer Management API

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      The buffer management API, or the buffer management system, is an API that allows computer programs to interact with the operating system to transfer data from the hard disk to RAM and vice versa.

    • #3268630

      Installing Firefox 1.5 on Solaris 10

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      Today is my second day at my new job (more on this later). For right now my default work station is Solaris 10 and today I needed to install Firefox 1.5. Here’s how I did it

      wget http://releases.mozilla.org/pub/mozilla.org/firefox/releases/1.5.0.1/contrib/solaris_pkgadd/firefox-1.5.0.1.en-US.solaris2.10-i386-pkg.tar.bz2
      bunzip2 firefox-1.5.0.1.en-US.solaris2.10-i386-pkg.tar.bz2
      tar xf

    • #3268631

      Misc commands

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      What server I am on
      bash-3.00# uname
      SunOS
      bash-3.00# uname -a
      SunOS frank 5.10 Generic_118844-26 i86pc i386

      To view ypcat

      [root@polland:/var/yp] ypcat -k passwd

      to push changes to polland
      /usr/ccs/bin/make

      Find packages matching criteria
      pkginfo | grep moz

      Install package remotely
      pkgadd -r packagename

    • #3269272

      RAID: Redundant Array of Inexpensive Disks

      by softwareengineer99 ·

      In reply to Technology, Programming, Management and more with Frank Mash

      RAID 0
      not an original RAID level aka striped set (data is striped across multiple disks)
      data is splitted evenly across multiple (two or more) disks not redundant uses increases performance can create a large virtual disk from many small physical disks disks of multiple size can be used only the size of the smallest disk will be added to the array I/O

Viewing 78 reply threads