Coder Social home page Coder Social logo

wikimatze.de's People

Contributors

wikimatze avatar

Stargazers

 avatar

Watchers

 avatar

wikimatze.de's Issues

Issues with installing mysql

sudo apt-get install mysql-server-5.5

start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: Fehler beim Bearbeiten des Paketes mysql-server-5.5 (--configure):
Unterprozess installiertes post-installation-Skript gab den Fehlerwert 1 zurück
Trigger für libc-bin (2.19-0ubuntu6.6) werden verarbeitet ...
Trigger für ureadahead (0.100.0-16) werden verarbeitet ...
Fehler traten auf beim Bearbeiten von:
mysql-server-5.5
E: Sub-process /usr/bin/dpkg returned an error code (1)

sudo apt-get purge mysql-server mysql-client mysql-common mysql-client-5.5 mysql-server-5.5
sudo apt-get remove libdbd-mysql-perl libmysqlclient18 mysql-client-5.5 mysql-common mysql-server-5.5
sudo apt-get autoremove
sudo rm -R /var/lib/mysql
sudo rm -R /etc/mysql

And install it, I got the same error:

  1. MySQL Server im Safe Mode ohne Passworteingabe und ohne Netzwerk starten

MySQL wird nun im Safe Mode ohne Passwortabfrage gestartet. Da nun ohne Passwort auf die Datenbank zugegriffen werden
kann wird zusätzlich mit –skip-networking der Netzwerkzugriff unterbunden (kein muss aber zu empfehlen).

Then running:

sudo mysqld_safe --skip-grant-tables
160219 08:13:05 mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error
configuration options for --syslog to take effect.
160219 08:13:05 mysqld_safe Logging to '/var/log/mysql/error.log'.
160219 08:13:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160219 08:13:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

And looking into /var/log/mysql/error.log:

160219 08:13:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160219 8:13:05 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and
will be removed in a future release. Please use the full name instead.
160219 8:13:05 [Note] /usr/sbin/mysqld (mysqld 5.5.47-0ubuntu0.14.04.1) starting as process 22033 ...
160219 8:13:05 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is
deprecated and will be removed in a future release. Please use the full name instead.
160219 8:13:05 [Note] Plugin 'FEDERATED' is disabled.
160219 8:13:05 InnoDB: The InnoDB memory heap is disabled
160219 8:13:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160219 8:13:05 InnoDB: Compressed tables use zlib 1.2.8
160219 8:13:05 InnoDB: Using Linux native AIO
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibGu3YIt' (Errcode: 13)
160219 8:13:05 InnoDB: Error: unable to create temporary file; errno: 13
160219 8:13:05 [ERROR] Plugin 'InnoDB' init function returned error.
160219 8:13:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160219 8:13:05 [ERROR] Unknown/unsupported storage engine: InnoDB
160219 8:13:05 [ERROR] Aborting

160219 8:13:05 [Note] /usr/sbin/mysqld: Shutdown complete

160219 08:13:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

The important thing was: /usr/sbin/mysqld: Can't create/write to file '/tmp/ibGu3YIt' (Errcode: 13) and yeah, I don't know why, but /tmp belonged not to the root group. After fixing this, I could work again.

Solving git issues

Linux, OSX user: input changes CR/LF to LF on commit

git config --global core.autocrlf input

On Windows Mashines:

git config --global core.autocrlf true 

Pimp making Firefox as fast as Chrome article

network.http.pipelining = True
network.http.pipelining.max-optimistic-requests = 8
network.http.pipelining.maxrequests = 64
network.http.max-persistent-connections-per-proxy = 64
network.http.max-persistent-connections-per-server = 8
network.dns.disableIPv6 = true

Use preload

Intending to save overuse of any SSDs, probably a bit out of date by now though :

browser.cache.disk.enable false
browser.cache.memory.max_entry_size 51200
browser.pagethumbnails.capturing_disabled with a value of true prevents thumbnails from appearing on the New Tab page grid and from being saved in ~/.cache/mozilla/firefox/profile_name/thumbnails.

This setting doesn't exist by default and is to be created.

Reference: https://developer.mozilla.org/en-US/...uring_disabled 

More config information: http://kb.mozillazine.org/Firefox_:_FAQs_:_About%3Aconfig_Entries

More reference links:

Encoding problem with csv file [Idea for blog-post]

Got a CSV from windows with the following content:

ssen<81>berdachung ;;),
477508;2;2;6518;0;Terrassen<81>berdachung ;;),
477509;2;2;6518;0;Terrassen<81>berdachung ;;),
477510;2;2;6518;0;Terrassen<81>berdachung ;;),
477511;2;2;6518;0;Terrassen<81>berdachung ;;),
477513;2;2;6518;0;Terrassen<81>berdachung ;;),

Checking the file with file gave me the following output:

Non-ISO extended-ASCII text, with CRLF line terminators

There is the tool icconf tool:

iconv -f ASCII -t utf-8//IGNORE < Raumausstatter_Bilderdatenbank.csv > escaped_file.csv

Checking the file with file gave me the following output:

escaped_file.csv: ASCII text, with CRLF line terminators

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.