Skip to content

MySQL and a known bug since 2003 about the auto_increment value

We detected a bug that is known since 2003.

The value of an auto increment column is set back to zero when you are having an empty table and restarting the MySQL DBMS. We run into this issue by using the auto increment value as a history id into a second table.

How can you work around this issue?

The easiest way is to order by id descending on the second table or to setup a "start up" shell script that calculates and sets the auto increment value.

Translate to de es fr it pt ja

Debian 8 owncloud client signature verification NO_PUBKEY 4ABE1AC7557BEFF9

You have a Debian 8 installation and get an error like the following when you want to install or update the owncloud client?

W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: http://download.opensuse.org  Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 4ABE1AC7557BEFF9

W: Failed to fetch http://download.opensuse.org/repositories/isv:/ownCloud:/desktop/Debian_8.0/Release  

W: Some index files failed to download. They have been ignored, or old ones used instead.

Execute the following command and try it again.

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 4ABE1AC7557BEFF9
Translate to de es fr it pt ja

disable automatic selected "Allow comments to this entry" for each entry in serendipity (s9y) blog system

For real, I was searching for this option for a year now and couldn't find an answer in a readme.

By disabling users in an other setup and restricting other users right, I found the magic checkbox I was searching for. Following the clickpath: Settings->Users->Edit User->Default settings for new entries->Allow comments to this entry Choose the radio button "no" and everything is working as expected :-).

Translate to de es fr it pt ja
Categories: others
Defined tags for this entry: ,
Vote for articles fresher than 7 days!
[0] 355 hits

How to upgrade the bios of a lenovo x250 on linux (and other not windows systems)

So, you want to update the bios of your lenovo x250 by downloading this iso from that page?

Read this readme. But also read the following lines. Lenovo missed "just some little facts".

First of all, I was not able to dump that iso to an usb stick by using dd. Secondly and most importatn, you have to go in your bios setup and change your boot up way from "legacy" to "uefi". After you have done that, your burned optical disk will boot up and you can finally upgrade your bios.

Translate to de es fr it pt ja
Categories: os
Defined tags for this entry: , , ,
Vote for articles fresher than 7 days!
[0] 1077 hits

Wie wird man Terrorist? Durch HTTPS und Tails

[...]
The charge sheet includes one count of preparation of terrorism "by researching an encryption programme, developing an encrypted version of his blog site, and publishing the instructions around the use of [the] programme on his blog site."
[...]

HTTPS

Tails

Translate to de es fr it pt ja

simple bash function to prefix any given command with sudo if needed

The title of this entry tells it all. I've create a simple bash function to prefix any given command expression with sudo if needed. If needed means, if you are not root. It is totally simple but to be true, it took me time to use my bash skills to write it. Imagine you now how to draw a cloud, the sun, a tree and a house and once you figure out how to concatenate all of that elements to draw a picture for your parents ;-).

if [[ $# -lt 1 ]];
then
    echo "Invalid number of arguments provided"
    echo "${FUNCNAME[0]} <command to execute>"
    return 1
fi

if [[ $(whoami) == "root" ]];
then
    $@
else
    sudo $@
fi

Looks like Chuck Norris is using github right now. Github is down, otherwise I would add a link to the fitting repository commit. Github is back online, here is the promised link to the commit.

Übersetze nach en fr

serendipity command line update released

I am happy to announce the initial and 1.0.0 of the serendipity command line update script. It is designed to do the boring work of updating against the latest release. The workflow is dead simple.

  • fetch latest version
  • check if latest version is installed
  • make a backup of the existing installation
  • update

Enjoy using it. If you find an error, feel free to open an issue or a pull request.

Translate to de es fr it pt ja

Vim 8.0 released

This the first major Vim release in ten years. There are interesting new features, many small improvements and lots of bug fixes.

Among the new features are:
- Asynchronous I/O support, channels, JSON
- Jobs
- Timers
- Partials, Lambdas and Closures
- Packages
- New style testing
- Viminfo merged by timestamp
- GTK+ 3 support
- MS-Windows DirectX support
[...]

Quelle

Translate to de es fr it pt ja

Kirigami official released

Das KDE-Framework Kirigami steht in einer ersten Veröffentlichung bereit, um Qt-Entwickler bei der Erstellung konvergenter Apps für Desktop und Mobilgeräte plattformübergreifend zu unterstützen.

Quelle
[...]
Kirigami currently officially supports Android, Desktop GNU/Linux (both X11 and Wayland), Windows, and the upcoming Plasma Mobile. iOS support is currently in an experimental stage, support for Ubuntu Touch is being worked on. The plan is to eventually become part of KDE Frameworks 5, but is currently released standalone in KDE Extragear. Since it is aimed to be a Tier 1 framework, it has no other dependencies apart from Qt, and therefore will not increase your application’s size any more than necessary. [...]

Quelle
kirigami design principles, ui patterns and styleguide
kirigami api documentation

Translate to de es fr it pt ja

web - a beautiful transfer of agil coding to building a house to show you how bad this approach can be

Miles English has published a beautiful text to demonstrate how bad agil development can be if you are doing things totally wrong (and at the end, sadly this is the common way of building software :-(). He illustrates the agil approach by start building a house without knowing how this should look like.
The sad truth is, that dishonesty is build up from this approach. The development team starts doing things secretly to fix the flaws they had to build. The consequence of this is, that even simple task are taking more time then expected (because of the hidden refactoring) which in turn disgusts the management.
At the end, both side are talking but no one is listening because no one is trusting the other sides words.

Translate to de es fr it pt ja

For the future, you simple have to believe in the car industry

A few days ago, I saw that japan wants to replace the analog mirrors for the cars and I thought "WTF?".
Today a Zero-day exploit was released which lets hackers attack your bmw car via their web portal.
With the second news in mind, I was forced to write this article - especially because of the last sentence.

Getting back to the titel, for me as a person who as to deal with technology day in and day out, it is hard to accept that people with less amount of knowledge about this stuff simple believe into technology. A mirror can not break. If it breaks, you are in serious issue anyway. But a camera, as well as a monitor can simple stop working. Especially the second post is something a whole industry simple does not want so accept that this will happen. What about hackers? What about a worm or a virus you just have to put into a mashed network of cars? What happens to the video records the camera will do? Don't think the so called "intelligence organizations" are not using this free mass surveillance option. And all in all, where are the real benefits for getting a bit more enslaved by technology?
Right now, it looks like only the industry who builds the camera system benefits from this. The car won't get cheaper if you add more and more stuff. The car also won't use less gas if it has to power and move more stuff. Last but not least, the car won't be easier to recycle with all that complicated materials inside.

Last sentences: Open source community, it looks like the magical hand of the market failed again on the car sector. Instead of building useful products, they simple try to add technology everywhere. They destroyed our cars, so lets start building our own ones, reliable, safe and with a small footprint for mother nature.

Translate to de es fr it pt ja

X11 freezes and system total hang up on an Lenovo X250 i7-5600U since kernel 4.6.2 (arch linux)

Hey folks, since kernel 4.6.2 I got a lot of X11 freezes as well as unusable gui tools (delayed inputs, scrolling and broken display rendering). Also all the virtual box clients are behaving the same. Only the chromium gui and xterm were usable (well, xterm only on my host, not on the virtual box clients).
I tried my best and here are the changes I made that stopped the system from a total freeze since four days:

run as root

cat /etc/X11/xorg.conf.d/20-intel-graphics.conf < DELIM Section "Device" Identifier "Intel Graphics" Driver "intel" Option "AccelMethod" "uxa" Option "NoAccel" "True" EndSection DELIM

I am crossing fingers it is working on your machine also.

Translate to de es fr it pt ja

migration from owncloud 9 to nextcloud 9.0.50

I just migrated my installation from owncloud 9 to nextcloud 9.0.50.
Only one thing is not working, the notes application simple shows me an empty list of notes. beside that, it is more like a new theme.

At the moment we only support manual migrations from ownCloud 8.2 and 9.0 to Nextcloud 9.

To do that please follow the usual upgrading steps:

* Delete everything from the ownCloud folder except data and config
* Download the Nextcloud 9 release from https://nextcloud.com/install/43
* Put the files into the folder where the ownCloud files where before
* Trigger the update either via OCC or via web.

source

I did the following steps.

make a backup of your database

log into your server and cd to the owncloud path

#

assuming your installation is in the directory "cloud"

./occ maintenance:repair cd .. wget https://download.nextcloud.com/server/releases/nextcloud-9.0.50.zip unzip nextcloud-9.0.50.zip cp -rv cloud/config nextcloud/ cp -rv cloud/data nextcloud/ mv cloud owncloud mv nextcloud cloud cd cloud ./occ upgrade ./occ app:list

enable the apps you want

Update from 2016-06-26
I created a small upgrade.sh script. Here it is.

!/bin/bash

@author stev leibelt artodeto@bazzline.net

@since 2016-06-26

begin of runtime environment validation

if [[ $# -lt 1 ]]; then
echo "invalid number of variables provided"
echo "upgrade.sh "
exit 1
fi

if [[ -d backup ]]; then
echo "backup directory sill exists"
exit 1
fi

end of runtime environment validation

begin of local runtime variables

LOCALCURRENTDATE=$(date +'%Y-%m-%d')
LOCALURLTOTHENEXTVERSION="$1"
LOCAL
PUBLICBACKUPPATH="public$LOCALCURRENT_DATE"

end of local runtime variables

begin of downloading new version

wget $LOCALURLTOTHENEXT_VERSION
unzip *.zip

end of downloading new version

begin of making backups

cd public
tar --ignore-failed-read -zcf "public.$LOCALCURRENTDATE.tar.gz" public
./occ maintenance:singleuser --on
cd ../
mkdir backup
cp -rv public/config backup/
cp -rv public/data backup/
mv public $LOCALPUBLICBACKUP_PATH

end of making backups

begin of upgrade

mv nextcloud public
cp -rv backup/config public
cp -rv backup/data public
cd public
./occ upgrade
./occ maintenance:singleuser --off
echo "enable the apps you need with ./occ app:enable "
./occ app:list

end of upgrade

Translate to de es fr it pt ja

Propel, the PropelOnDemandFormatter, self loaded runtime properties and your special reload data if needed usecase- howto

Propel column representation offering the option to add some business logic inside. We are making this from time to time by enriching the existing object with more data, but only when a method is called explicit.


class MyTable extends BaseMyTable
{
    /** @var null|\My\Enriched\MyTable\Data */
    protected $enrichedData;

/**
 * @return null|\My\Enriched\MyTable\Data
 */
public function getEnrichedData()
{
    //prevent reloading enriched data if this method is called more than once
    if ($this->noEnrichedDataYetLoaded()) {
        //do something heavy data lifting
        $this->enrichedData = $this->tryToLoadEnrichedData();
    }

    return $this->enrichedData;
}

/**
 * @return bool
 */
private function noEnrichedDataYetLoaded()
{
    return (is_null($this->enrichedData));
}

}

If you would use the corrosponding MyTableQuery object in combination with a PropelOnDemandFormatter and iterating over an collection after calling find(), you would get the same enriched data for different MyTable objects.
Why? Because the PropelOnDemandFormatter does a smart thing by reusing the on MyTable object and "just" updating the properties.
Following is a workaround I am using to fix this (totally right) behaviour. Anyways, be caution if you do things like that. This should not be your regular way of doing it.


class MyTable extends BaseMyTable
{
    /** @var null|\My\Enriched\MyTable\Data */
    protected $enrichedData;

/** @var int */
protected $myId;

/**
 * @return null|\My\Enriched\MyTable\Data
 */
public function getEnrichedData()
{
    //prevent reloading enriched data if this method is called more than once
    if ($this->noEnrichedDataYetLoaded()) {
        //do something heavy data lifting
        $this->enrichedData = $this->tryToLoadEnrichedData();
        $this->myId         = $this->getId();
    }

    return $this->enrichedData;
}

/**
 * @return bool
 */
private function noEnrichedDataYetLoaded()
{
    return (
        ($this->myId == $this->getId())
        &&amp; (is_null($this->enrichedData))
    );
}

}

Translate to de es fr it pt ja

Reminder of the Propel Bug 734 - update() with limit() and a workaround

Just because we ran into this issue again. There is known and serious bug in propel whenever you use "update()" in combination with "limit()".
Our workaround right now is to replace the code.


//this will update all entry with the content "bar" in the column "foo"
MyQuery::create()
    ->filterByFoo('bar')
    ->limit(100)
    ->update(
        array(
            'Foo' => 'baz'
        )
    );

//this will only update 100 rows $ids = (array) MyQuery::create() ->filterByFoo('bar') ->limit(100) ->select( array( 'Id' ) ) ->find();

MyQuery::create() ->filterById($ids) ->update( array( 'Foo' => 'baz' ) );

Translate to de es fr it pt ja

roundcube 1.2.0 released - now with PGP encryption

We proudly announce the stable version 1.2.0 of Roundcube Webmail which is now available for download. It introduces new features since version 1.1 covering security and PGP encryption topics:

* PHP7 compatibility
* PGP encryption
* Drag-n-drop attachments from mail preview to compose window
* Mail messages searching with predefined date interval
* Improved security measures to protect from brute-force attacks
[...]

Quelle

Translate to de es fr it pt ja

Junge sind besser, wenn man ihnen Aufgaben als Spiel verkauft, Mädchen sind besser, wenn es sich um eine Benotung handelt

[...]
The research, in the Journal of Experimental Social Psychology, showed that boys outscored girls on reading tests if they were told the tests were a game. But boys scored significantly lower than girls when told the tests were assessments of their reading skills.
[...]
In classes given reading evaluations, boys made an average of 33.3 correct answers compared with 43.3 by the girls. But when the tests were framed as animal games, boys’ average scores were significantly higher: 44.7 compared with 38.3 for the girls.
[...]

Quelle.

Translate to de es fr it pt ja

web - The Panama Papers prove it: America can afford a universal basic income

[...]
Roads and transportation infrastructure. Educated workforces. Courts and legal systems. Innovations sparked by government funding, such as the internet. No one – no matter how smart or hard working – joins the American or global elite without making use of these shared resources.

But while working and middle-class families pay their taxes or face consequences, the Panama Papers remind us that the worst of the 1% have, for years, essentially been stealing access to Americans’ common birthright, and to the benefits of our shared endeavors.
[...]

source

My two cents.
First of all, not only the united states of america have this tax problem, European nations have the same issue, as well as Russia, I guess even Africa. So this is still the fundamental issue we have to face.
Secondly, I am a bit afraid that know everyone is saying the "universal basic income" is something we need. I still think this would be a great idea, but you know you are getting fooled when hardliners are stating thinking loudly about that topic in a positiv way. History proofed this to often, to badly :-(.

Translate to de es fr it pt ja

web - Killer Mike Educates Stephen Colbert - Killer Mike tells you what you should do with your free time

A friend of mine forwarded me a video link with an interview from Killer Mike where he explain that he is talking to kids what life is all about and why Bernie Sanders should be the next president of the United States of America.
Well, president is something else, but what he said about "what to do with your life" and how I got it is pretty cool and fitting to my beliefs.
Go out of your community, especially when you earn enough money to pay your bills and buy stuff you are not need. Spend time with other people. You don't have to gave them money, but show them how to get things done and teach them things. This will give you more than money can buy. Whatever you want to buy will became irrelevant because your heart will be filled up with love.

Translate to de es fr it pt ja

howto - php composer - File(/etc/pki/tls/certs) is not within the allowed path(s) - on arch linux

Since a few days (or weeks?), I discovered the following issue on one of my Arch Linux system.
Whenever I try to use PHP's composer, I got the following issue:


[ErrorException]
is_dir(): open_basedir restriction in effect. File(/etc/pki/tls/certs) is not within the allowed path(s): (/srv/http/ [...]

Well, it didn't hurt that much since I am using (like every cool webkiddy is doing) docker or vagrant for my development. But this time, I needed to solve it since it is a customer edge case - so I solved it.
The how to I will show you is not the perfect way. I had two things in mind, try to minimize the place I have to adapt the php.ini. And try to keep the system as normal as possible. Until now, I can not estimate the security holes I opened with this setting. I will let you know if this how to turns out to be a "don't try this at home" thing.

So, what have I done?
First of all, I asked curl to tell me where it is looking for certificates by executing:


curl-config --ca

output: /etc/ssl/certs/ca-certificates.crt


After that I had a look what this path is:

ls -halt /etc/ssl/certs/ca-certificates.crt

output: [...] /etc/ssl/certs/ca-certificates.crt -> ../../ca-certificates/extracted/tls-ca-bundle.pem


So, with that knowledge it turned out that the following steps are reflecting my requirements mention above.

sudo mkdir -p /etc/pki/tls/certs
sudo ln -s /etc/ssl/certs/ca-certificates.crt /etc/pki/tls/certs/ca-certificates.crt
sudo vi /etc/php/php.ini

add following lines to "open_basedir" configuration section

:/etc/pki/tls/certs:/etc/ssl/certs


And that is it, composer should now be back in business.

Translate to de es fr it pt ja

web - Human Rights Advocates: U.S.-Backed Saudi Offensive in Yemen a "Dark Mark" on Obama's Presidency

Hundreds of thousands took to the streets in Yemen this week to protest the first anniversary of the U.S.-backed, Saudi-led offensive against Houthi rebels. The protests were said to be the largest in Yemen since demonstrations in 2011 forced the resignation of President Ali Abdullah Saleh. Since last March, more than 6,000 people have been killed in Yemen, about half of them civilians. "Yemenis are asking me, ’Why is there no global outrage when our schools, our universities, our hospitals, our clinics, when football fields, when playgrounds are bombed with U.S. bombs?" says Sarah Leah Whitson, executive director of Human Rights Watch’s Middle East and North Africa Division. Her recent piece for the Los Angeles Times is headlined "The U.S. is quietly helping Saudi Arabia wage a devastating aerial campaign in Yemen." Meanwhile, the U.S. launched air attacks on al-Qaeda in southern Yemen, killing 14 people described by local sources as suspected militants. We also get response from Farea Al-Muslimi, a visiting scholar at the Carnegie Middle East Center in Beirut. He is also the co-founder and chairman of the Sana’a Center for Strategic Studies. In 2013, he testified before the Senate Judiciary Subcommittee hearing on the U.S. secret drone program.
[...]

source

Translate to de es fr it pt ja

Categories: political
Defined tags for this entry: , ,
Vote for articles fresher than 7 days!
[0] 366 hits

web - The International Criminal Court recognises rape as a war crime

FOR the first time since it started to function in 2002, the International Criminal Court at The Hague has passed a guilty verdict on a warlord for perpetrating, among other things, rape as an act of war. It is also the first time that the court has secured a conviction for “command responsibility”, meaning that a commander can be found guilty even if he did not himself take direct part in such crimes as rape, murder and pillage but allowed them to be committed.
[...]

Source

Translate to de es fr it pt ja