MySQL server has gone away


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.


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     |
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     |
4 | repo-debug-update                | openSUSE-11.4-Update-Debug       | No      | Yes     |
5 | repo-non-oss                     | openSUSE-11.4-Non-Oss            | Yes     | Yes     |
6 | repo-oss                         | openSUSE-11.4-Oss                | Yes     | Yes     |
7 | repo-source                      | openSUSE-11.4-Source             | No      | Yes     |

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’ 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” repo-12.1-oss
zypper addrepo –name “openSUSE-12.1 Non-OSS” repo-12.1-non-oss
zypper addrepo –name “openSUSE-12.1 Updates” repo-12.1-update


zypper ref

zypper dup


Depois disto dê reboot (no console mesmo):



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


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).


Vulnerabilidade do Opera Browser no Opensuse 11.x

Subject: [security-announce] openSUSE-SU-2011:0688-1: important: opera
Date: Fri, 24 Jun 2011 15:08:26 +0200 (CEST)
Message-ID: <>

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.


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



openSUSE 12.1 Milestone 2


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.

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”
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.

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! 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).