Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 144 Next 30 Older Entries

Displaying posts with tag: debian (reset)

libssl.so.6: cannot open shared object file with Debian/CentOS
+0 Vote Up -0Vote Down
Actually, I found this error many times, while installing MySQL/Percona servers with MySQL Sandbox. To resolve this issue, first, you have to make sure that, SSL is installed /update properly. sudo apt-get update sudo apt-get install libssl1.0.0 libssl-dev After installing Continue reading →   [Read more...]
MySQL related IRC discussion channels
+0 Vote Up -0Vote Down

There are many MySQL related IRC discussion channels as the ecosystem itself grows. I join the following. Are there any that I’m missing?

Freenode (irc.freenode.net):

  • #mysql – main channel for all kinds of end user MySQL related discussions (the noisiest of the lot, naturally)
  • #maria – main channel for all kinds of MariaDB related discussions
  • #webscalesql – for all kinds of WebScaleSQL discussions
  • #percona – main channel for all kinds of Percona related discussions
  • #tokutek – main channel for Tokutek discussions (TokuDB or TokuMX)
  • SkySQL-specific channels: #maxscale and #mariadb-mgr

OFTC (irc.oftc.net):

  • #debian-mysql – for all kinds of Debian MySQL related bits (packaging, bugs, etc.)
  [Read more...]
MariaDB 10.0.10 uploaded to Debian experimental
+2 Vote Up -0Vote Down

If you’re watching the NEW queue, you’ll notice that MariaDB 10.0.10 has been uploaded targeting Debian/experimental. Package description, and to think the bug was only opened on April 2nd – pretty quick turnaround.

Related posts:

  • MariaDB in Debian unstable
  • Debian releases Lenny, MySQL 5.1 soon
  • MariaDB in Gentoo; updates for Solaris/Debian SPARC
  • Really large NLP corpora
    +0 Vote Up -0Vote Down

    Jeeze people. You’re all noisy. I’m sure it was all done for posterity’s sake.

    23M     irclogs/MagNET/#perl.log
    29M     irclogs/freenode/#mysql.log
    36M     irclogs/freenode/#debian.log
    37M     irclogs/foonetic/#xkcd.log
    39M     irclogs/OFTC/#debian.log
    43M     irclogs/freenode/#jquery.log
    44M     irclogs/freenode/#perl.log
    
    $ for file in irclogs/MagNET/#perl.log irclogs/freenode/#mysql.log irclogs/freenode/#debian.log irclogs/foonetic/#xkcd.log irclogs/OFTC/#debian.log irclogs/freenode/#jquery.log irclogs/freenode/#perl.log; do echo -n "$file: " ; head -1 $file ; done
    irclogs/MagNET/#perl.log: --- Log opened Thu May 26 08:31:32 2011
    irclogs/freenode/#mysql.log: --- Log opened Wed Dec 28 09:03:49 2011
    irclogs/freenode/#debian.log: --- Log opened Tue Mar 12 12:52:40 2013
    irclogs/foonetic/#xkcd.log: --- Log opened Wed Dec 28 19:33:43 2011
    irclogs/OFTC/#debian.log: --- Log
      [Read more...]
    Correcting mysql.sock connection error
    +0 Vote Up -0Vote Down

    I write this post over to have a quick access to this tutorial than to promote the blog. The problem For Several times this has happened to me, always install a new server, or personal machine. I install mysql ,… Continue Reading →

    Continue reading Correcting mysql.sock connection error

    Related posts:
  • Corrigindo erro de conexão com mysql.sock
  • zend framework 2 with lighttpd
  • Main Subversion commands
  • MariaDB & distributions update, Dec 2013
    +1 Vote Up -0Vote Down

    A few things to note recently, amongst MariaDB in distributions. 

  • Ubuntu keeps MySQL 5.5 despite MariaDB’s success. There’s a lot of reasons for this, but remember the key takeaway here is MySQL 5.5 & the fact that MariaDB wasn’t even in Debian yet when the decision was made.
  • MariaDB is now inside of Debian/sid – check out the packages.
  • RHEL 7 comes with MariaDB 5.5 as a default; this is a good thing.
  • Now, from a distribution standpoint, we’re looking at starting to ship

      [Read more...]
    MariaDB in Debian unstable
    +3 Vote Up -0Vote Down

    There is a Debian MariaDB plan from the MySQL package team. There is good news as on September 30 2013, the upload to Debian unstable is complete with MariaDB 5.5 (5.5.32). It’s now only a matter of time before this becomes available in Debian. 

    Its great to see the work of Otto Kekäläinen finally make it into Debian. I would say this has been in the works for seven months. Much thanks to James Page (Canonical) and Clint Byrum (HP, Debian Developer) for reviewing and uploading.

    This joins the

      [Read more...]
    Percona celebrates its 7th anniversary by giving to open source ecosystem
    +3 Vote Up -0Vote Down

    Today we’re celebrating Percona’s 7th anniversary.  A lot has changed in these past 7 years – we have grown from a two-person outfit focused exclusively on consulting to a 100-person company with teammates in 22 different countries and 18 different states, now providing Support, Consulting, RemoteDBA, Server Development and

      [Read more...]
    Installing Apache2 With PHP5 And MySQL Support On Debian Wheezy
    +0 Vote Up -0Vote Down

    Installing Apache2 With PHP5 And MySQL Support On Debian Wheezy

    LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a Debian Wheezy server with PHP5 support (mod_php) and MySQL support.

    Set Up Rsnapshot, Archiving Of Snapshots And Backup Of MySQL Databases On Debian
    +0 Vote Up -0Vote Down

    Set Up Rsnapshot, Archiving Of Snapshots And Backup Of MySQL Databases On Debian

    This howto will show you how to install and set up Rsnapshot, enable archiving of snapshots and how to back up MySQL databases on Debian.

    Managing Multiple MySQL Servers From One phpMyAdmin Installation (Using SSL Encryption)
    +0 Vote Up -0Vote Down

    Managing Multiple MySQL Servers From One phpMyAdmin Installation (Using SSL Encryption)

    This tutorial explains how you can manage multiple MySQL servers from one phpMyAdmin installation. For security reasons, communication between phpMyAdmin and any remote MySQL server is using SSL encryption (this is not necessary for a local MySQL server since communication between phpMyAdmin and MySQL is not leaving the server). phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL.

    Virtual Hosting With vsftpd And MySQL On Debian Squeeze
    +0 Vote Up -0Vote Down

    Virtual Hosting With vsftpd And MySQL On Debian Squeeze

    Vsftpd is one of the most secure and fastest FTP servers for Linux. Usually vsftpd is configured to work with system users. This document describes how to install a vsftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine.

    Creating Advanced MySQL-Based Virtual Hosts On Lighttpd (Debian Squeeze)
    +0 Vote Up -0Vote Down

    Creating Advanced MySQL-Based Virtual Hosts On Lighttpd (Debian Squeeze)

    This guide explains how you can create advanced virtual hosts on a lighttpd web server on Debian Squeeze that are stored in a MySQL database. The method described here does not use the lighttpd mod_mysql_vhost module, and unlike mod_mysql_vhost (which allows you to store only the hostname and document root of a vhost in a database), this method allows to store individual configuration directives for each vhost in the MySQL database.

    Linus on Instantiation and Armadaification
    +0 Vote Up -1Vote Down

    I feel a sense of pride when I think that I was involved in the development and maintenance of what was probably the first piece of software accepted into Debian which then had and still has direct up-stream support from Microsoft. The world is a better place for having Microsoft in it. The first operating system I ever ran on an 08086-based CPU was MS-DOS 2.x. I remember how thrilled I was when we got to see how my friend’s 80286 system ran BBS software that would cause a modem to dial a local system and display the application as if it were running on a local machine. Totally sweet.

    When we were living at 6162 NE Middle in the nine-eight 292, we got an 80386 which ran Doom. Yeah, the original one, not the fancy new one with the double barrel shotgun, but it would probably run that one, too.

      [Read more...]
    The blog was down yesterday
    +0 Vote Up -0Vote Down

    The brief outage was due to a scheduled move of the servers to a separate rack and subnet dedicated to our work with the Center for Information Assurance & Cybersecurity (ciac) at the University of Washington Bothell (uwb), and a11y.com

    I am currently exercising the new (to us) equipment and hope to winnow the less than awesome equipment over the next quarter. I spent the last six months finding the best in breed of the surplussed DL385 and DL380 chassis we (work) were going to have recycled. The team and I were able to find enough equipment to bring up one of each with eight and six gigs of memory, respectively. These will make excellent hypervisors for provisioning embedded instances of Slackware, Fedora, RHEL, CentOS, Debian, FreeBSD, OpenSolaris, OpenIndiana, FreeDOS, etc.

    When I initially configured this xen paravirt environment, I failed to plan for integration with libvirt, so I am

      [Read more...]
    NIST::NVD::Store::SQLite3 1.00.00
    +0 Vote Up -0Vote Down

    It’s been released. Use this with NIST::NVD 1.00.00 and you will be able to perform immediate look-ups of CVE and CWE data given a CPE URN. For instance:

    cjac@foxtrot:/usr/src/git/f5/NIST-NVD-Store-SQLite3$ perl Makefile.PL ; make ; make test ; cjac@foxtrot:/usr/src/git/f5/NIST-NVD-Store-SQLite3$ perl -MNIST::NVD::Query -MData::Dumper -e '
    $q = NIST::NVD::Query->new(store    => q{SQLite3},database => q{t/data/nvdcve-2.0.db});
    $cve_list = $q->cve_for_cpe( cpe => q{cpe:/a:microsoft:ie:7.0.5730.11} );
    print Data::Dumper::Dumper { cve_list => $cve_list, first_cvss => $q->cve( cve_id => $cve_list->[0] )->{q{vuln:cvss}} }
    '
    $VAR1 = {
              'cve_list' => [
                              'CVE-2002-2435',
                              'CVE-2010-5071'
                            ],
              'first_cvss' => {
      [Read more...]
    NIST::NVD 1.00.00
    +0 Vote Up -0Vote Down

    I’m leaving myself some room for bug fixes. It works for us in house. I would love to help others to give it a try. especially those who could benefit from making nearly immediately answered queries to the NIST’s NVD database.

    The code in this release cannot by itself track the feed from the feds in real time. The nvd entry loader needs a little bit of love in the area of record merging before this starts working. It’s on my TODO list.

    I’m sorry for the outage of git.colliertech.org. I’ll get that back up here shortly. In the meantime, feel free to grab it from this location while the CPAN indexes and processes my submission.

    http://www.colliertech.org/federal/NIST/NIST-NVD-1.00.00.tar.bz2

    don’t forget to check the cryptographic signature:

      [Read more...]
    How To Back Up MySQL Databases With mylvmbackup On Debian Squeeze
    +0 Vote Up -0Vote Down

    How To Back Up MySQL Databases With mylvmbackup On Debian Squeeze

    mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the tables again. This article shows how to use it on a Debian Squeeze server.

    The Ubuntu Developer Summit
    Employee_Team +2 Vote Up -0Vote Down

    The Ubuntu Developer Summit takes place at The Oakland Marriott City Center, Oakland, California from 7–11 May 2012. 

    If your attending this event, you will have a few different MySQL opportunities to attend:

    Oracle is proud to also be a Sponsor of the Ubuntu Developer Summit. A full schedule of the event is available here.

     Join us as we help support and grow the MySQL Communities. 

    How do we control MySQL daemon in Linux, part1
    +0 Vote Up -0Vote Down

    As you may expect from open source world thingy, almost every Linux distribution has developed it’s own way to manage our favourite RDBMS service. Yet none is perfect, or even some of them seems to not work in real server scenario1.

    In this post I’m trying to compare and point out most annoying aspects of initialization scripts that I had to face in production.

    In ‘old days’ probably all Linux distributions used to start and stop services using so called init scripts usually written in Unix shell (sh or Bash). But situation is not so simple these days anymore.

    Folks started to think about improving things, like making

      [Read more...]
    NIST::NVD CWE development – follow along
    +0 Vote Up -0Vote Down

    I’m in the process of getting the tests passing for the 0.03 release of NIST::NVD::Store::SQLite3 wherein our hero imports the CWE data and cross-indexes it with CVEs and CPEs.

    Follow along and suggest some patches. I’m developing on Debian Wheezy, but I would very much like input from devs on other platforms.

    http://git.colliertech.org/?p=NIST-NVD-Store-SQLite3.git;a=summary

    cjac@foxtrot:/tmp$ time git clone http://git.colliertech.org/git/NIST-NVD-Store-SQLite3.git
    Cloning into 'NIST-NVD-Store-SQLite3'...
    
    real	0m32.757s
    user	0m0.200s
    sys	0m0.088s
    cjac@foxtrot:/tmp$ ls NIST-NVD-Store-SQLite3/t/data/
    cwec_v2.1.xml  nvdcve-2.0-test.xml
    

    Publish your patches and I’ll fetch them, or you can submit them in udiff format and I’ll review/apply. Thanks for playing

      [Read more...]
    Installing A Web, Email & MySQL Database Cluster On Debian 6.0 With ISPConfig 3
    +0 Vote Up -0Vote Down

    Installing A Web, Email & MySQL Database Cluster On Debian 6.0 With ISPConfig 3

    This tutorial describes the installation of a clustered web, email, database and DNS server to be used for redundancy, high availability and load balancing on Debian 6 with the ISPConfig 3 control panel. MySQL Master/Master replication will be used to replicate the MySQL client databases between the servers and Unison will be used to Sync the /var/www (websites) and /var/vmail (email account data) folders.

    Detecting and Removing Unused Indexes in MySQL
    +0 Vote Up -1Vote Down

    Preface: The following post is a backup from a post first published on the Moviepilot Techblog, which is going to be replaced by the Moviepilot Labs Blog. The content is a bit outdated, as the way to go today is using MariaDB instead of OurDelta. The very content about the UserStats plugin and using it for detecting and removing unused indexes is still valid, though – and a nice way of getting rid of performance killers…

    MySQL performance depends on a balanced usage of MySQL indexes. While it is easy to add an index and identify queries not using indexes via EXPLAIN during development or slow.log it is a lot harder to get rid of unused indexes. Finding and

      [Read more...]
    NIST::NVD::Store::SQLite3
    +0 Vote Up -0Vote Down

    I published an SQLite3 storage back-end to NIST::NVD on the CPAN. It’s pretty quick. About as fast as the DB_File one, but without the down side of being tied to DB_File. It shouldn’t be too difficult to re-factor this code to any DBI-based database. MariaDB anyone?

    I know it works on Debian. The nightly CPAN test results should come back shortly and I’ll find out how well it works on other platforms.

    MySQL and Debian Linux
    +4 Vote Up -1Vote Down
    It is available now ! MySQL 5.5.18 now offers Debian Linux (.deb) packages.

    They are available via the http://dev.mysql.com/downloads/mysql site !


    Finally the Debian community can upgrade easily to MySQL 5.5 !
    MySQL 5.5.18 Debian packaging now available
    Employee_Team +0 Vote Up -0Vote Down

    I am happy to announce that MySQL 5.5.18 is now available via Debian native packaging.  We have gotten many requests for this and our build and release teams have pulled together to ensure that our DEB packages are delivered with the highest quality. 

    You can download MySQL 5.5.18 Debian 5 and 6 packages from the MySQL Community Download page or from the My Oracle Support portal.

    As always, thanks for your continued support of MySQL!

    MySQL 5.5.18 Debian packaging now available
    Employee_Team +8 Vote Up -0Vote Down

    I am happy to announce that MySQL 5.5.18 is now available via Debian native packaging.  We have gotten many requests for this and our build and release teams have pulled together to ensure that our DEB packages are delivered with the highest quality. 

    You can download MySQL 5.5.18 Debian 5 and 6 packages from the MySQL Community Download page or from the My Oracle Support portal.

    As always, thanks for your continued support of MySQL!

    Running phpMyAdmin On Nginx (LEMP) On Debian Squeeze/Ubuntu 11.04
    +0 Vote Up -0Vote Down

    Running phpMyAdmin On Nginx (LEMP) On Debian Squeeze/Ubuntu 11.04

    The phpMyAdmin package from the Debian/Ubuntu repositories comes with configuration files for Apache and Lighttpd, but not for nginx. This tutorial shows how you can use the Debian Squeeze/Ubuntu 11.04 phpMyAdmin package in an nginx vhost. Nginx is a HTTP server that uses much less resources than Apache and delivers pages a lot of faster, especially static files.

    Open Query looking for new colleagues!
    +1 Vote Up -1Vote Down
    My colleagues and I are looking for extra talent – is that you? What we do:help clients prevent problems (rather than being the fire department), we work on a subscription basis although we also do some ad-hoc consulting, and training. Apart from MySQL/MariaDB query and DBA work, we do quite a bit of system administration. Mainly Red Hat and Debian based distros, and expect to see replication and the MySQL-MMM multi-master system. You’d work from home, whereever it might be, so you will need to be self-motivating (but we do keep in touch online). What we’re not: a full-time employer. With us, you make a life rather than a living. Everybody is contracted part-time. You can make enough to live comfortably, but that has nothing to do with hours. If you’re stressed about not filling all hours in your week with work-work-work, we’re not  [Read more...]
    Installing MySQL Administrator Tool To Connect To Remote Databases
    +0 Vote Up -3Vote Down

    Installing MySQL Administrator Tool To Connect To Remote Databases

    This tutorial provides step-by-step instructions on how to install MySQL Admin tool on an Ubuntu 11.04 system and how to connect to a remote host with it. This should also work on most Debian based operating systems.

    Showing entries 1 to 30 of 144 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.