MySQL server has gone away

Standard

Seu mysql anda estranho quando você está tentando fazer upload de um arquivo enorme via console (na verdade o restore, ou seja, mysql -u usuario -p nomedobdprarestaurar < arquivo.sql)???

Bem, se a mensagem de erro for esta -> MySQL server has gone away NÃO precisa entrar em pânico, só existem 2 coisas que são feitas e sanam tranquilamente o erro:

1 – entre no /etc/my.cnf (ou arquivo de configuração do mysql) e informe set-variable = max_connections=1500

Isto vai liberar para 1500 conexões concorrentes no mysql.

2 – Se o erro persistir, no mesmo arquivo informe:

max_allowed_packet = 5000000000

Você estará liberando uploads/restore/dumps de 1gb de tamanho.

Depois disso, reinicie o mysql (normalmente service mysql restart) e corra para o abraço.

 

Ah, se quiser ver qual valor ficou setado (só para conferir depois do restart use):

mysql> SHOW VARIABLES LIKE ‘max_allowed_packet’;

Como atualizar seu OpenSuse 11.4 para 12.1 sem problemas.

Standard

Bom pessoal, antemão queremos ressaltar que o procedimento é rápido (só depende do seu link de internet) e simples de proceder. Bora simbora?

Vamos analisar os repositórios ativos (no meu caso tinham MUUUUUUUUUUUUUUUUUITOS, abaixo seguem somente os default), para isso use o comando:

zypper repos –uri

A resposta deverá ser:

# | Alias                            | Name                             | Enabled | Refresh | URI
--+----------------------------------+----------------------------------+---------+---------+------------------------------------------------------------------------------------------------
1 | Updates-for-openSUSE-11.4-11.4-0 | Updates for openSUSE 11.4 11.4-0 | Yes     | Yes     | http://download.opensuse.org/update/11.4/
2 | openSUSE-11.4-11.4-0             | openSUSE-11.4-11.4-0             | Yes     | No      | cd:///?devices=/dev/disk/by-id/ata-VMware_Virtual_IDE_CDROM_Drive_10000000000000000001,/dev/sr0
3 | repo-debug                       | openSUSE-11.4-Debug              | No      | Yes     | http://download.opensuse.org/debug/distribution/11.4/repo/oss/
4 | repo-debug-update                | openSUSE-11.4-Update-Debug       | No      | Yes     | http://download.opensuse.org/debug/update/11.4/
5 | repo-non-oss                     | openSUSE-11.4-Non-Oss            | Yes     | Yes     | http://download.opensuse.org/distribution/11.4/repo/non-oss/
6 | repo-oss                         | openSUSE-11.4-Oss                | Yes     | Yes     | http://download.opensuse.org/distribution/11.4/repo/oss/
7 | repo-source                      | openSUSE-11.4-Source             | No      | Yes     | http://download.opensuse.org/source/distribution/11.4/repo/oss/

Vamos ativar o repositório updates for opensuse 11.4 11.4-0 com o seguinte comando:

zypper modifyrepo –enable Updates-for-openSUSE-11.4-11.4-0

Logo em seguida, validar o repositório (URI):

zypper addrepo –check –name ‘openSUSE-11.4-Update’ http://download.opensuse.org/update/11.4/ repo-update

Hora de deixar tudo novinho antes da upgrade:

zypper refresh

zypper update

 

Depois que tudo estiver atualizado na atual versão deveremos fazer o seguinte:

zypper modifyrepo –all –disable

Isso vai desativar tudo quanto for repositório antigo (11.4).

Hora de ativar todos os repositórios novos:

zypper addrepo –name “openSUSE-12.1 OSS” http://download.opensuse.org/distribution/12.1/repo/oss/ repo-12.1-oss
zypper addrepo –name “openSUSE-12.1 Non-OSS” http://download.opensuse.org/distribution/12.1/repo/non-oss/ repo-12.1-non-oss
zypper addrepo –name “openSUSE-12.1 Updates” http://download.opensuse.org/update/12.1/ repo-12.1-update

Hora do FATALITY:

zypper ref

zypper dup

 

Depois disto dê reboot (no console mesmo):

reboot

 

Quando inicializar já virá com gnome-shell.
Aqui está ok (brilho, som), mas a wifi foi para o espaço.
Iremos fazer um artigo com a correção.

openSUSE 12.1 Beta Lançado

Standard

Confira a nota de lançamento do OpenSuse 12.1 beta pela DistroWatch:

Bryen Yunashko has announced the availability of the beta release of openSUSE 12.1: “The much-awaited beta release of openSUSE 12.1 is here. If you’ve been following us, you know this release was originally called Milestone 6. However, the release team and its testers agreed that this round of testing showed milestone 6 to be so stable and ready for general testing, they decided to call it beta. And that means that if you’ve been thinking about taking a pre-release of 12.1 for a spin before our final release in November, there’s no time like the present.” Read the short release announcement for more information and relevant links. Download (mirrors): openSUSE-KDE-LiveCD-Build0315-i686.iso (677MB, MD5, torrent), openSUSE-GNOME-LiveCD-Build0315-i686.iso (664MB, MD5, torrent), openSUSE-KDE-LiveCD-Build0315-x86_64.iso (690MB, MD5, torrent), openSUSE-GNOME-LiveCD-Build0315-x86_64.iso (677MB, MD5, torrent).

Fonte: http://distrowatch.com/6913

Vulnerabilidade do Opera Browser no Opensuse 11.x

Standard
From: opensuse-security@opensuse.org
To: opensuse-security-announce@opensuse.org
Subject: [security-announce] openSUSE-SU-2011:0688-1: important: opera
Date: Fri, 24 Jun 2011 15:08:26 +0200 (CEST)
Message-ID: <20110624130826.38F8A32350@maintenance.suse.de>

openSUSE Security Update: opera ______________________________________________________________________________ Announcement ID: openSUSE-SU-2011:0688-1 Rating: important References: #694567 Affected Products: openSUSE 11.4 openSUSE 11.3 ______________________________________________________________________________ An update that contains security fixes can now be installed. It includes one version update.

Description: opera 11.11 fixes a security vulnerability.

Citing http://www.opera.com/support/kb/view/992/:

Framesets allow web pages to hold other pages inside them.

Certain frameset constructs are not handled correctly when the page is unloaded, causing a memory corruption.

To inject code, additional techniques will have to be employed. Patch Instructions:

To install this openSUSE Security Update use YaST online_update.

Alternatively you can run the command listed for your product:

– openSUSE 11.4: zypper in -t patch opera-4588 – openSUSE 11.3: zypper in -t patch opera-4588 To bring your system up-to-date, use “zypper patch”. Package List: – openSUSE 11.4 (i586 x86_64) [New Version: 11.11]: opera-11.11-1.2.1 opera-gtk-11.11-1.2.1 opera-kde4-11.11-1.2.1

– openSUSE 11.3 (i586 x86_64) [New Version: 11.11]: opera-11.11-1.2.1 opera-gtk-11.11-1.2.1 opera-kde4-11.11-1.2.1

References: https://bugzilla.novell.com/694567

Fonte: http://lwn.net/Articles/449150/

openSUSE 12.1 Milestone 2

Standard

Jos Poortvliet Anunciou recentemente o lançamento do OpenSuse 12.1 Milestone 2.

Confira as notas de lançamento:

About 3 weeks after the first milestone for openSUSE 12.1, today the second milestone has been made available. Following the Roadmap, this is the second of 6 milestone until the openSUSE 12.1 release in November.
Milestones

openSUSE is developed in a repository called Factory. Packages flow from the devel projects into Factory upon OK from the release team following the Factory Development Model. During the development cycle (more detailed model) periodic releases are made available for testing – these are the milestones. Six of them become available. After some several freezes go into effect, the component freeze just before the fourth milestone for instance. And about a couple of weeks after the last milestone the first of two Release Candidates is made ready for testing. The final openSUSE 12.1 release is expected on November 11th.
Progress since the previous milestone

The first milestone had a huge number of changes and improvements on top of the latest openSUSE release. Again, many packages have been updated. You can check the latest package versions on this page. What are the major changes?

Firefox 5 RC
Horde4 packages (php5-pear-horde)
“The Board”
rawstudio
llvm/clang 3.0 snapshot
many smaller updates to KDE and GNOME applications and desktops

Also nspluginwrapper is now updated which will allow a more stable Flash plugin on 64bit platforms. With this change you can now watch two flash videos at the same time. And over 100 new packages have been added, including extensions for Banshee, some small tools like DDS2tar and brainfuck interpreter, Cdecl (turns C/C++ gibberish into English), cint (small C/C++ interpreter) and a number of other devel and language tools.
systemd

On the openSUSE project and factory mailing lists a discussion is taking place centered around the new systemd init system. After the introduction of the road to systemd for openSUSE 12.1 by Frederic Crozat, issues, complaints and limitations of systemd are being discussed and dissected. Changing an init system is an invasive change and systemd has ambitions beyond just replacing sysV not everyone always agrees with. Work will be needed to ensure a stable and usable init system for 12.1 and the team welcomes help and bugreports!
Helping out easier than ever!

As expected from a development release, there is still a lot of work to do, so your input at this early stage will be a huge help in making the final release into the beautifully polished work that we aim for. openSUSE 12.1 Milestone 2 has a list of most annoying bugs here, please add issues you find and help fix them. As Will Stephenson recently blogged, fixing an issue is a matter of BURPing on build.opensuse.org! Find a how-to here.

So go and see for yourself what the next version of openSUSE has in store for you at our download center.

Para baixar veja abaixo às versões:

Download (mirrors): openSUSE-KDE-LiveCD-Build0072-i686.iso (671MB, MD5, torrent), openSUSE-GNOME-LiveCD-Build0072-i686.iso (668MB, MD5, torrent), openSUSE-KDE-LiveCD-Build0072-x86_64.iso (672MB, MD5, torrent), openSUSE-GNOME-LiveCD-Build0072-x86_64.iso (685MB, MD5, torrent).