# ZZ - Archief # Archief # Novell related - [enhancing the GroupWise Client on Linux](https://www.reeltoreel.nl/knowledgebase/books/archief/page/enhancing-the-groupwise-client-on-linux) # Enhancing the GroupWise Client on Linux How to speed-up and improve the GroupWise linux client appearance When you want to improve the GroupWise linux client appearance, make a launcher icon and enter the following command: `/opt/novell/groupwise/client/bin/groupwise -ui=gtk ` And now the java-look has been replaced by a (slightly better looking) GTK look! This tip will speed up the GroupWise Linux Client by switching it over to GTK. Give it a shot and see what you think. 1\. From the SLED10 console do the following: `SU {enter admin password}` `cd /opt/novell/groupwise/client/bin` `vi groupwise` 2\. Modify this: `/opt/novell/groupwise/client/bin/groupwise-bin "$@" ` so that it says this: `/opt/novell/groupwise/client/bin/groupwise-bin -ui=gtk "$@"` 3\. Save changes and exit. GroupWise will now run from the menus in GTK mode. # Enable suspend-to-ram on notebooks with ATI card Enable suspend to ram on notebooks with ATI card ATI driver and suspend-to-ram It appears that a lot of people (running openSUSE 10.2) are having issues with the last releases of the proprietary ATI fglrx Linux driver in combination with suspend to RAM. Especially version 8.33.6 but also 8.32.5 seem to hang up the system in most cases. At Moosy we wanted our beloved suspend function back and started to investigate. We found this document at AMD which simply stated: "ATI Engineering is aware of this issue and is investigating." Not very promising. When digging deeper into this, we found a solution that may work for you. This has been tested on some Dell Latitude and IBM Thinkpad laptops and has been found to work on those. YMMV. **openSUSE powermanagement** openSUSE works with s2ram and pm-utils as a framework for suspending. See the s2ram page on the openSUSE site. S2ram does the actual suspending and comes with several options for different machines. Pm-utils runs distro-specific scripts for preparing the system for suspend (unloading modules, etc.) We found that adding some options to s2ram and removing some SUSE scripts from pm-utils resulted in working suspend-to-ram with the latest fglrx drivers. Start: s2ram First see if you can get your machine to suspend using s2ram. To do this, open a terminal and become root. Type `   s2ram` and hope for the best. The command comes with several options and the one that does the trick for ATI cards seems to be -m which saves and sets the VBE mode. We found that on Dell machines, the following combination works: `   s2ram -f -m` while on IBM machines `   s2ram -f -s -m or even s2ram -f -s -m -a 3` was necessary. Experiment some, but keep the -m option. You may want to check the s2ram suggestions for you machine using `   s2ram -n` and checking the line starting with "Fixes". Add s2ram options to your setup The options that work for you need to be put into the suspend configuration. To do this, open the file /etc/pm/config as root and search for S2RAM\_OPTS="". Add the options that you needed to add for your machine here, preceded by a space, like this: `   S2RAM_OPTS=" -f -m"` Remove pm-utils scripts Now the not-so-funny part: we discovered that after this, suspending still did not work! It turned out that some of the scripts that are run by pm-utils cause this. The scripts are located in /etc/pm/hooks and we needed to remove at least the cpufreq and videobios scripts. So, to do this enter `   cd /etc/pm/hooks` and do a `   rm 80videobios 94cpufreq 99Zgrub` (the last one may not be necessary). Please note that removing these scripts may break things (like suspend to disk). After this, reboot to ensure that the changes are picked up by the powermanagement system. If this worked for you, let us know!! We tested on Dell D810, D600 and IBM t43, t60p systems. # Make .par files work in KDE A much eaiser way to verify and repair PAR2 files. This assumes you have par2 installed As a normal user: - Open konquer and select settings-->configure konqueor-->File associations--->Add--->par2--->Add - You should add \*.par2 and then in all caps \*.PAR2 - Click Add under application preference order---->type the word konsole------>command for konsole is `konsole --noclose -e par2 r` That will enable you to double click par2 files and a konsole window will open and verify and repair if needed. The window will stay open when finished so you can be sure all went well. # Installatie openftd in OpenSUSE 10.3 ## Installatie OpenFTD in OpenSUSE 10.3 '''De installatie bestaat uit 2 delen: - eerst de installatiebron toevoegen - de daadwerkelijke installatie De installatiebron toevoegen: 1. open YaST 2. klik op 'Software' en dan op 'Software repositories' 3. klik op 'Add' en dan op 'Specify URL' en 'Next' 4. vul bij 'Repository Name' b.v. 'OpenFTD' in 5. vul bij 'URL' in: '[http://openftd.org/releases/openSUSE\_10.3](http://openftd.org/releases/openSUSE_10.3)' 6. Finish. Om het pakket te installeren: 1. klik in YaST op 'Software Management' 2. Tijp in de 'Search'-box 'openftd' en klik op 'Search' 3. selecteer alle gevonden openFTD pakketten en klik op 'Accept' 4. accepteer evt. de Automatic changes die nog gevonden worden 5. de software wordt geïnstalleerd # Installatie openftp in OpenSUSE 10.3 1. REDIRECT [Installatie openftd in OpenSUSE 10.3](https://www.reeltoreel.nl/knowledgebase/books/mediawiki-import/page/installatie-openftd-in-opensuse-103) # Joomla migratie 1.x naar 1.5 ## Migratie Joomla vaan 1.5 1. d/l migratie component 2. maak nieuwe site aan naast de oude 3. admin -> installer -> components (install php-zlib) 4. installeer extra plugins? 5. start migratie 6. installeer nieuwe joomla 1. stap 6, kies voor load migration script, old table prefix "jos\_" 7. verwijder installatiemap # Install ATI/NVIDIA drivers in Opensuse 11 Or commandline friendly `   su -c “OCICLI `[`http://opensuse-community.org/ati.ymp`](http://opensuse-community.org/ati.ymp)`”` `   su -c “OCICLI `[`http://opensuse-community.org/nvidia.ymp`](http://opensuse-community.org/nvidia.ymp)`”` One more commandline way via zypper: NVIDIA: `   zypper sa `[`http://download.nvidia.com/opensuse/11.0`](http://download.nvidia.com/opensuse/11.0)` nvidia` `   zypper in x11-video-nvidiaG01` ATI: `   zypper sa `[`http://www2.ati.com/suse/11.0`](http://www2.ati.com/suse/11.0)` ati` `   zypper in  x11-video-fglrxG01` ### Other codecs etc Open terminal to run these commands or click on the link in web browser: Compiz Fusion with almost everything: su -c “OCICLI [http://download.opensuse.org/repositories/X11:/XGL/openSUSE\_11.0/compiz-fusion-all.ymp](http://download.opensuse.org/repositories/X11:/XGL/openSUSE_11.0/compiz-fusion-all.ymp)” Codecs pack for Gnome: su -c “OCICLI [http://opensuse-community.org/codecs-gnome.ymp](http://opensuse-community.org/codecs-gnome.ymp)” Codecs pack for KDE: su -c “OCICLI [http://opensuse-community.org/codecs-kde.ymp](http://opensuse-community.org/codecs-kde.ymp)” When NVIDIA and ATI drivers are available, they can be installed in a same way too. Note: Quotes are necessary, make sure there is no “wordpress effect” when you copy paste the above commands in shell # KDE4 - [kmail](https://www.reeltoreel.nl/knowledgebase/books/mediawiki-import/page/kmail) ## KDE4 has some new apps: - Dragon - MM player - Kscd - CD player - Ksystemlog - Handy system log viewer, also realtime! View syslog, X-server log, kernel & others - Dolphin - Filemanager. Check it out, awesome - Marble - Geo prog - Ksysguard - Processmonitor. Cool -> also displays output from progs NOT started from terminal!! - Libksane - scan library ## Other things to try: - kid3 - Kid3 easily tags multiple MP3, OGG/Vorbis, FLAC, MPC, MP4/AAC, MP2, Speex, TrueAudio and WAV. It supports ID3v1.1, ID3v2.3, ID3.2.4. This Package is available from the KDE:Community repository in the openSUSE Build Service. - [http://vavai.net/2008/10/28/making-a-local-copy-of-opensuse-repository-mirror-server/](http://vavai.net/2008/10/28/making-a-local-copy-of-opensuse-repository-mirror-server/) - [Fix suspend to RAM on a HP8530p EliteBook on OpenSUSE 11.2](https://www.reeltoreel.nl/knowledgebase/books/archief/page/fix-suspend-to-ram-on-a-hp8530p-elitebook-on-opensuse-112) - [clear recently used documents permanently in KDE4](https://www.reeltoreel.nl/knowledgebase/books/homelab/page/clear-recently-used-documents-permanently-in-kde4) # How to make a virtualBox window seamless 1. Install guest additions in windows guest 2. launch the software 3. make sure the window is neither fully maximized nor minimised 4. choose Machine, Seamless Mode To exit VitrualBox, you will need to exit seamless mode first: 1. press Hostkey - L # Fix suspend to RAM on a HP8530p EliteBook on OpenSUSE 11.2 Suspend to disk works out of the box, but for suspend to ram you need to modify /usr/lib/hal/scripts/linux/hal-system-power-suspend-linux: change: `#We only support pm-utils` `if [ -x "/usr/sbin/pm-suspend" ] ; then` `      export NUM_SECONDS_TO_SLEEP=$seconds_to_sleep` `      /usr/sbin/pm-suspend $QUIRKS` `      RET=$?` `else ` `      # TODO: add support` `      unsupported` `fi` to: `# We only support pm-utils` `#if [ -x "/usr/sbin/pm-suspend" ] ; then` `#       export NUM_SECONDS_TO_SLEEP=$seconds_to_sleep` `#       /usr/sbin/pm-suspend $QUIRKS` `#       RET=$?` `#else` `#       # TODO: add support` `#       unsupported` `#fi` `/usr/sbin/s2ram -f -p -s` - Or upgrade to openSUSE 11.3, for in this version the suspend and hybernate works flawlessly. Also the video (with radeon driver) is perfect. # IRC channel commands ⊙\_ʘ >.< ☺ ☹ – frowning face ☺ – smiley face ``` [11:15] Commands in admin: gc, gcs, join, memory and raw. [11:15] Commands in alias: addhelp, alias, list, lock, remove, removehelp, setcorealias, showalias and unlock. [11:15] Commands in blist: add, addfromfile, count, deletelist, deletematching, get and list. [11:15] Commands in calc: calc. [11:15] Plugin flood has no commands. [11:15] Commands in googleweather: weather. [11:15] Commands in help: blockhelp, commands, help, longhelp, plugins, summary and syntax. [11:15] Commands in miscmsg: 8ball, bugreport, ct, date, discordiandate, exchange, featurerequest, flipacoin, random, serveruptime, time, uptime and week. [11:15] Commands in nickserv: check and clearcache. [11:15] Commands in options: get, getgeneral, help, list, listgeneral, set and setgeneral. [11:15] Commands in plugin: detach, info, list, load, reload, setcore, source and unsetcore. [11:15] Commands in quote: add, count, create, get, info, karmamod, last, remove and summary. [11:15] Commands in security: addgroup, addtogroup, adduser, beginlink, deluser, findpermission, grant, link, removefromgroup and revoke. [11:15] Commands in see: bodyclock, firstseen, freshers, midday and pattern. [11:15] Commands in seen: seen. [11:15] Commands in susefactoids: delete, factinfo, forget, getchannellanguage, link, remember, search, setchannellanguage, unlink and whatis. [11:15] Commands in talk: describe, me, msg, privme, privmsg, reply, say and shout. [11:15] Commands in tell: get and send. [11:15] Commands in timedevents: at, in and last. [11:15] Commands in timezone: timein and whenis. [11:15] Commands in topic: diff and get. [11:15] Commands in vote: abstainall, activevotes, call, info and vote. ``` !alsa `ALSA (Advanced Linux Sound Architecture) provides your Linux sound drivers. For basic openSUSE sound concepts, check out: `[`http://en.opensuse.org/Sound-concepts`](http://en.opensuse.org/Sound-concepts) !sound `Basic openSUSE audio troubleshooting guide is at `[`http://en.opensuse.org/SDB:Audio_troubleshooting`](http://en.opensuse.org/SDB:Audio_troubleshooting)` ` !pulseaudio `PulseAudio is a sound server intended as replacement for !ESD. Some info on openSUSE pulseaudio: `[`http://en.opensuse.org/Pulseaudio`](http://en.opensuse.org/Pulseaudio)` Disable: `[`http://en.opensuse.org/Disabling_PulseAudio_HowTo`](http://en.opensuse.org/Disabling_PulseAudio_HowTo)` For detailed information on pulseaudio, please go here: `[`http://pulseaudio.org/wiki/AboutPulseAudio`](http://pulseaudio.org/wiki/AboutPulseAudio)`. See "perfect" setup `[`http://www.pulseaudio.org/wiki/PerfectSetup`](http://www.pulseaudio.org/wiki/PerfectSetup) !anybody `Please do not ask if anyone uses, knows, is good with, can help you with or is a guru/expert of ``. Instead, ask your real question. (If the real question _was_ "does anyone use ``?"  --- Also: !sicco !research !smartquestion !question` !ask `Don't ask to ask, just ask :) (and try to explain exactly what the problem is, which openSUSE version you're using, on what architecture, etc...) ---` !sicco `[20:52] `` Please ask sicco questions: questions that are Specific, Informative, Concise, Complete, and On-topic.` !ati `To install the proprietary ATI drivers see `[`http://en.opensuse.org/SDB:ATI_drivers`](http://en.opensuse.org/SDB:ATI_drivers)` - Note: ATi dropped support for the non-HD series in their proprietary fglrx driver, DO NOT install this driver if your card is legacy.` !best `There are often no "best" things, such as filesystems, window managers or Linux distributions. You pick the one you find most suitable/appealing and do not rely on people's "recommendation" as an excuse.` !beta `If you want a stable machine that is easy to setup and relatively problem free, DO NOT use a beta OS! If you are VERY comfortable with Linux/SuSE and wish to help the developers by submitting bug reports, don't mind instability, and understand that many features may not work correctly or at all, then go for it. For support post on the opensuse-factory mailing list` !chat `Offtopic chat (i.e., not related to openSUSE support) is in #opensuse-chat` !codecs `There are several multimedia formats that cannot be included on the openSUSE CDs/DVD because they are proprietary, patented, restricted formats. Some of these include MP3, MPEG-4, playing of encrypted DVDs, etc. Information on how to install proprietary codec support on openSUSE, please visit; `[`http://opensuse-community.org/Restricted_formats`](http://opensuse-community.org/Restricted_formats) !compiz !counter `openSUSE 11.4 countdown: `[`http://countdown.opensuse.org/large`](http://countdown.opensuse.org/large)`  - also see `[`http://en.opensuse.org/Portal:11.4`](http://en.opensuse.org/Portal:11.4)` for a list of some of the features` !dup `You can do a live distribution upgrade with openSUSE. Valid upgradeable releases are from 10.3 on. You can find the how-to here: `[`http://wiki.opensuse.org/SDB:System_upgrade`](http://wiki.opensuse.org/SDB:System_upgrade) !dvd `There are several multimedia formats that cannot be included on the openSUSE CDs/DVD because they are proprietary, patented, restricted formats. Some of these include MP3, MPEG-4, playing of encrypted DVDs, etc. Information on how to install proprietary codec support on openSUSE, please visit; `[`http://opensuse-community.org/Restricted_formats`](http://opensuse-community.org/Restricted_formats) !enter `Please don't use the `` key as punctuation!` !everygreen `The Evergreen project aims to provide Long Time Support for certain openSUSE versions, see `[`http://en.opensuse.org/openSUSE:Evergreen`](http://en.opensuse.org/openSUSE:Evergreen) !hclwlan `To check the compatibility of wlan cards take a look at: Network Adapters (Wireless) Hardware Compatibility List (HCL) `[`http://en.opensuse.org/HCL:Network_%28Wireless%29`](http://en.opensuse.org/HCL:Network_%28Wireless%29)` . (also `[`http://linux-wless.passys.nl/`](http://linux-wless.passys.nl/)`)` !hello !hi `Hello! Welcome to the English openSUSE support channel. Don't be shy. PLEASE don't ask if anyone can help; share which openSUSE version and state detailed questions. We hope you find support needed here. Enjoy your visit. Type: "/msg SUSEhelp !helpme" (no quotes) here for more info how to use our time-saving self-help bot!` !helpme `Welcome to an openSUSE irc support channel. To get help from me you can ask for keywords (factoids) in PRIVATE please with /msg SUSEhelp factoid. To search for keywords try /msg SUSEhelp search keyword.` !kotd `kotd; Kernel Of The Day (and mirrors) can be found at `[`http://download.opensuse.org/repositories/Kernel:/HEAD/`](http://download.opensuse.org/repositories/Kernel:/HEAD/)` (need support? see factoid !beta)` !lifetime !liveusb `For instructions on how to create an installable, persistent, openSUSE Live USB, see: `[`http://en.opensuse.org/SDB:Live_USB_stick`](http://en.opensuse.org/SDB:Live_USB_stick) !new2irc `If you are new to IRC take a look at Communicate/IRCforNewbies please at `[`http://en.opensuse.org/Communicate/IRCforNewbies`](http://en.opensuse.org/Communicate/IRCforNewbies) !ntfs !obs !packages `Search for packages on the openSUSE Build Service here: `[`http://software.opensuse.org/search`](http://software.opensuse.org/search)` - You can browse Packman packages here: `[`http://packman.links2linux.org/packages`](http://packman.links2linux.org/packages) !packman `Packman is the most popular third-party repository available for openSUSE and contains software that cannot be included in the distribution for legal reasons. Instructions on how to add Packman to your openSUSE installation can be found at `[`http://opensuse-community.org/Repositories`](http://opensuse-community.org/Repositories) !paste `Please don't paste more than 3 lines in the channel; instead, use one of `[`http://paste.opensuse.org/`](http://paste.opensuse.org/)` , `[`http://pastebin.com/`](http://pastebin.com/)` or `[`http://pastie.org/`](http://pastie.org/)` -- for pics, use `[`http://img.susepaste.org/`](http://img.susepaste.org/)` , `[`http://picpaste.com/`](http://picpaste.com/)` or `[`http://min.us/`](http://min.us/) !patience `Patience is a virtue. Double true in community open source distro support channels like #suse where UNpaid volunteers do their best to help. Please respect their time with your patience.` !pmthebot `Please use the SUSEhelp self help bot in private queries when not introducing new users in main channel to factoids & help us keep the channel cleaner by typing ' /msg SUSEhelp factoid' OR '/msg SUSEhelp search some keyword'. THANKS & know SUSEhelp bot is here for all ;-)` !redirector `TarDisk: download.opensuse.org is a redirector. It redirects to mirrors near you. Sometimes it will redirect you to bad mirror and sometimes the redirector itself is down` !repeat `please do not repeat yourself` !repos `See `[`http://opensuse-community.org/Repositories`](http://opensuse-community.org/Repositories)` for how to add the basic repositories.` !runlevel `for info on runlevels go here: `[`http://en.wikipedia.org/wiki/Runlevel`](http://en.wikipedia.org/wiki/Runlevel)` and `[`http://en.opensuse.org/System_Services_(runlevel)`](http://en.opensuse.org/System_Services_(runlevel)) !sax2 `SaX2 is dropped from 11.3 onwards and there's no xorg.conf by default. Auto-detection should "just work" in most cases. If you must configure X use xrandr, krandrtray, gnome display settings, nvidia-settings, ATI catalyst control center etc. depending on your card/driver, or manually edit /etc/X11/xorg.conf.d/ - or as last resort, manually create /etc/X11/xorg.conf` !skype !smartquestion !software !studio !support `General technical support is in #suse (/join #suse), please ask over there` !tumbleweed `The Tumbleweed project aims to provide a rolling updates version of openSUSE containing the latest stable versions instead of relying on rigid periodic release cycles. See `[`http://en.opensuse.org/Tumbleweed`](http://en.opensuse.org/Tumbleweed)` for details.` !usb !usb-install !vendorchange !vlc !wifi !wine !zypper `zypper is the easy to use commandline interface to the YaST (openSUSE PM pattern) package management. See `[`http://en.opensuse.org/Portal:Zypper`](http://en.opensuse.org/Portal:Zypper) # Icedtea error on starting java in browser Since the latest patch you get this error: ` "icedteanp plugin error: Failed to run /usr/lib/jvm/java-1.6.0-openjdk/jre/bin/java.  For more detail rerun "firefox -g" in a terminal window."` The resolution is this: In the following directory type the following for 32 bit: `host:/usr/lib/jvm # ln -s java-1.6.0-openjdk-1.6.0/ java-1.6.0-openjdk` 64 bit: `host:/usr/lib64/jvm # ln -s java-1.6.0-openjdk-1.6.0/ java-1.6.0-openjdk` See also bugzilla report #704814 on [bugzilla.novell.com](https://www.reeltoreel.nl/knowledgebase/books/mediawiki-import/page/bugzillanovellcom) # How to enter system recovery on HTC Hero Boot into system recovery by holding \[HOME\] & \[POWER\]. Then at the red triangle screen press \[VOLUP\] & \[POWER\] # Other WeTab sda6 android-2011-08-28/ initrd.img kernel ramdisk.img system.sfs # Vlc crashes when switching interface to qt4 On openSUSE 12.1, when you configure VLC to use the qt interface (this has to be done in the 'show settings: all' view) it simply crashes. When you start it again, it crashes again during start. Being unable to disable this again, this leaves you with an unworkable VLC. To disable qt interface, go to your ~/.config/vlc> directory, open vlcrc file and put an '#' before the line 'extraintf=qt4' # Gpsbabel `gpsbabel -t -i garmin -f usb: -o gpx -F test.gpx` # Garmin Forerunner 305, linux and Garmin Connect This article explains how I was able to get my Garmin Forerunner 305 working with linux, and upload my runs to the website of garmin connect. This is mainly a copy of the excellent article [here](http://braiden.org/?p=62). And this article is just my summary of the steps needed to get the stuff working. # Start recordings early and end late setup -> tv settings -> general : 4th page This way won't conflict with back to back recordings # How to rearrange the channel list To rearrange the channel list, use this shell script: ``` #!/bin/sh # # a small shell script for automatic ordering of TV channels in MythTV # # BIG FAT WARNING: this script was tested only with MythTV v0.23. # Future versions of mythtv possibly use an incompatible database layout. # # The following workflow is recommended: # 1) backup the current channel settings: # ./channel_sort_mythtv.sh dump >mythtv_channels_dump.sql # 2) retrieve the current list of channel names # ./channel_sort_mythtv.sh get >channels.list # 3) sort the channels in 'channels.list' with your favourite text editor # 4) upload the new channel order (starting from channum=1): # ./channel_sort_mythtv.sh set # # This script is free software: you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation, either version 2 of the License, or # (at your option) any later version. # # This script is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this script. If not, see . set -eu # you can override the mysql.txt location by providing it via an environment variable MYSQL_CONF_FILE=${MYSQL_CONF_FILE:-} # only used for "set" operation: # use this channel number for all channels, that are listed in stdin # set it to an empty string, if the channels, that are not listed, should remain untouched DEFAULT_CHANNEL=10000 # set DEBUG to a non-empty string to output the result sql statements instead of executing them # use something like "export DEBUG=true" before running this script to enable debug mode DEBUG=${DEBUG:-false} export DEBUG # read the mysql connection settings from the myth config # this exposes DBHostName, DBUserName, DBName and DBPassword for mysql_config in "$MYSQL_CONF_FILE" ~/.mythtv/mysql.txt /etc/mythtv/mysql.txt; do if test -n "$mysql_config" && test -r "$mysql_config"; then . "$mysql_config" break fi done # temporarily disable the "unset variable check" of bash set +u if test -z "$DBHostName" -o -z "$DBUserName" -o -z "$DBName" -o -z "$DBPassword"; then echo "Failed to read the mysql settings file of MythTV." >&2 echo "You can set the environement variable MYSQL_CONF_FILE to specify a custom location." >&2 fi set -u send_mysql_statement() { if test "$DEBUG" != "false"; then # only output the sql statements - don't execute them cat - else mysql -h "$DBHostName" -u "$DBUserName" --password="$DBPassword" --skip-column-names "$DBName" fi } show_syntax() { echo "Syntax: $(basename "$0") ACTION" echo "Possible actions:" echo " get - get all unsorted channel names from the database (to stdout)" echo " set - read the desired order of channels (by name) from stdin" echo " merge - output stdin and add all channel names (from the database)" echo " that were not listed before (to stdout)" echo " dump - dump the current state of the 'channel' table (as a backup)" echo " help - show this syntax description" echo "Hint: the 'get' operation does to same as 'merge' with empty stdin." } ACTION=invalid test $# -gt 0 && ACTION="$1" case "$ACTION" in get) # get distinct names and ignore empty lines echo "SELECT DISTINCT BINARY name FROM channel ORDER BY LPAD(channum, 3, 0) ASC;" \ | send_mysql_statement \ | grep -v "^$" ;; set) ( # reset all channel numbers to the default value if it is not empty test -n "$DEFAULT_CHANNEL" && echo "update channel set channum='$DEFAULT_CHANNEL';" current_num=1 cat - | grep -v "^$" | while read channel; do # escape single quotes channel=$(echo "$channel" | sed "s/'/\\\\'/g") echo "update channel set channum=$current_num where BINARY name='$channel';" current_num=$((current_num + 1)) done ) | send_mysql_statement ;; merge) input="$(cat -)" echo "$input" "$0" get | while read channel; do echo "$input" | grep -q "^$channel$" || echo "$channel"; done ;; dump) mysqldump -h "$DBHostName" -u "$DBUserName" --password="$DBPassword" "$DBName" channel ;; help|--help|invalid) if test "$ACTION" = "invalid"; then show_syntax >&2 exit 1 else show_syntax fi ;; esac exit 0 ``` # Linux - MythTV - Technotrend - DVB-C - Ziggo # [Linux - MythTV - Technotrend - DVB-C - Ziggo](http://pvdm.xs4all.nl/philip/index.php?categoryid=1&p2_articleid=7) Na de aanschaf van een mooie HD-TV, die overigens zijn eigen problemen heeft, maar daar zal ik het maar niet over hebben (-update: alles is ok, een firmware update doet wonderen!) is het toch wel een flinke stap terug om de opnamen van MythTV te bekijken, die zijn gemaakt met een analoge tv-tunerkaart. Ik weet dat het een **slangenkuil** is waarin ik me begeef, maar 'no guts, no glory!', dus we gaan het proberen. Wat zijn de problemen? Allereerst moet de backend (die de opnamen doet) draaien op linux, bij voorkeur op openSUSE. Dat is met MythTV geen enkel probleem, maar de keuze voor linux heeft wel heel veel implicaties voor de rest van de setup, en met name de hardware. Ik moet een DVB-C (Digital Video Broadcasting - Cable) setup zien te vinden die door de linux kernel gesupport wordt. Daar bovenop moet dit dan ook nog eens compatibel zijn met de digitale standaard waarin Ziggo uitzend, en dan OOK nog de gebruikte encryptie (Irdeto) ondersteunen! Op het internet zijn weinig (geen) succesvolle verhalen te vinden over deze combinatie van factoren, dus het wordt interessant, zeg maar. Het zou best kunnen dat het geheel niet gaat werken. Op deze pagina \[link is weg\] staat een overzicht van de kaarten die in de kernel zitten. Ik heb gekozen voor de Technotrend 1501, vanwege de beschikbaarheid in Nederland, en deze forumpost die beweert dat hij goed werkt met mijn 'omstandigheden'. Er zit een CAM module bij. Ik hoop dat mijn keuze voor een AlphaCrypt Light module in combinatie met de **Ziggo** smartcard ook goed gaat werken. Verder besluit ik om de nieuwste **MythTV** (0.24) te gaan gebruiken, want er wordt steeds meer en steeds betere ondersteuning voor DVB in MythTV ingebouwd. ## De eerste stap - het upgraden van openSUSE 11.2 naar 11.3 Eerst de server naar versie 11.3 gebracht, dit moest toch gebeuren. Dit is via de '#zypper dup' methode super makkelijk. Zie hiervoor de openSUSE wiki. Na de upgrade heb ik getest of alles nog werkt zoals hiervoor (website, MySQL, etc.), en dit bleek het geval. Al met al een succesvolle, simpele upgrade.Hierna heb ik nog een extra stap gedaan: ik heb de nieuwste kernel erin gehangen via een extra repo. Ik draai nu de 2.6.36 kernel i.p.v. de standaard 2.6.34. ## De tweede stap - MythTV upgraden naar 0.24 Het upgraden van MythTV heeft wat meer voeten in de aarde. Packman heeft het pakket in zijn repo, maar al met het versienummer \*in\* de pakketnaam, als in 'mythtv-0\_21-backend'. Een simpele '#zypper up' werkt hier dus niet, het zijn voor je packetmanager 2 verschillende pakketten. Dus ik moest de ene deinstalleren, en de andere installeren. Ik heb de volgende rpm's handmatig gedownload en in een directory gezet: ``` mytharchive-0_24-0.24-0.pm.5.1.x86_64 mythtv-0_24-setup-0.24-0.pm.5.1.x86_64 mythtv-0_24-backend-0.24-0.pm.5.1.x86_64 python-MythTV-0_21-0.21-29.pm.30.3.noarch mythtv-0_24-base-themes-0.24-0.pm.5.1.noarch mythtv-0_24-docs-0.24-0.pm.5.1.x86_64 mythtv-0_24-common-0.24-0.pm.5.1.x86_64 libmyth-0_24-0.24-0.pm.5.1.x86_64 mythtv-0_24-frontend-0.24-0.pm.5.1.x86_64 mythweb-0_24-0.24-0.pm.5.1.x86_64 ``` Mythbackend gestopt en de rpm's met '#zypper in \*.rpm' geinstalleerd. Ik moest een heleboel dependencies oplossen (natuurlijk). Ik koos steeds voor 'deinstallation of ...0.21 version' waardoor de 0.24 versie de 0.21 versie overschrijft. Het lijkt vervelend maar maakt allemaal sense en is ook wel logisch. Na afloop heb ik de nieuwe versie. Komende vanuit mijn versie 0.21 moest eerst de MySQL database geupgrade worden, voordat ik de backend weer kon starten, zie hiervoor de MythTV wiki. Dit is overigens nog een heel gedoe, maar daar ga ik hier niet over uitwijden.Toen dat succesvol gedaan was, heb ik de backend weer gestart en toen had ik de nieuwe MythTV! Nadat MythTV naar de laatste versie is gebracht heb ik dat getest door een opname te maken met de kaart die er dan nog in zat, de analoge Hauppauge PVR-350. Alles werkte nog gewoon, dus ik ging verder met de volgende stap. ## De derde stap - het installeren van de DVB kaart van Technotrend Computer uitgezet, PVR-350 eruit en Technotrend C-1501 + CAM module + Ziggo smartcard erin, Computer weer aan. Even kijken in dmesg of de kaard herkend wordt en jawel hoor, de kernel herkent hem gewoon. In MythTV kon ik gewoon een New Capture Card toevoegen: ``` Card Type: DVB DTV capture card (v3.x) DVB device number: /dev/dvb/adapter0/frontend0 <- dit werd automatisch ingevuld ``` Kies recording options: ``` Max recordings: 1 v wait for SEQ start header v open DVB card on demand v Use DVB card for active EIT scan  ``` Verder moest ik MythTV inrichten zoals bij elke andere kaart. Maar hierna kwam het scannen naar de zenders.Nadat ik een video source had toegevoegd, kon ik bij Input Connections kiezen voor deze videosource. Als je dat dan kiest kom je bij scan for channels.Scan configuration: ``` Desired Services: TV v unencrypted only Scan Type: Full Scan (Tuned) Frequency: 372000000 Symbol Rate 6875000 Modulation QAM 64 ``` Deze gegevens zijn overigens gewoon te vinden in het foldertje wat je bij je Ziggo smartcard krijgt. Nadat het kaartje alle zender gevonden had, ik geloof dat het er 166 waren, ben ik in de Channel Editor gedoken en heb alles goed afgeconfigureerd. Tip: ook via de mythweb interface kun je makkelijk de zendertabel editten! # mysql make database dump: `mysqldump -u root -p –all-databases > pvdm.sql` `mysqldump -u root -p wikidb > pvdm.sql` restore the dump: `#mysql -u root -p` `mysql> create database xyz;` `mysql> quit;` `#mysql -u root -p [dbname] < pvdm.sql` delete database: `#mysql -u root -p` `mysql> drop database xyz;` # update 18 feb 2015 Zodra u gaat zoeken naar zenders vraagt uw ontvanger of TV naar de frequentie en het netwerk-ID. Gebruik altijd frequentie 474.00 en netwerk-ID 5555. Overige gegevens zoals modulatie en symboolsnelheid hoeft u niet aan te passen. Sommige digitale ontvangers of CI+ televisies hebben een extra 0 of juist een 0 minder nodig. Bijvoorbeeld 474.000 of 05555. Uw apparaat laat dit zien zodra u gevraagd wordt om de gegevens in te vullen. Welke modellen dit precies zijn vindt op deze pagina. ## Wat zijn ongecodeerde kanalen? Wij versleutelen standaard onze digitale televisiekanalen. Uw smartcard zorgt ervoor dat de versleutelde kanalen in uw abonnement zichtbaar worden voor uw TV. Na de werkzaamheden verandert dit. Vanaf dat moment zijn meer dan 30 kanalen uit het standaardpakket beschikbaar zonder smartcard. We noemen dat ongecodeerde kanalen. Dit is bijvoorbeeld erg handig als u ook op uw tweede of derde televisie digitale TV wil kijken. U hoeft hier dan niet perse een nieuwe smartcard voor te kopen. In het zenderoverzicht ziet u om welke zenders het gaat. [https://www.ziggo.nl/televisie/zenderoverzicht-nieuw](https://www.ziggo.nl/televisie/zenderoverzicht-nieuw) ## update 27 februari 2015 Op Philips TV's met aankoopdatum 2010 t/m 2012 zal de HD zendervolgorde met het netnummer 5555 niet werken zoals het door Ziggo/UPC is ingevoerd en daarom hebben zij voor meerdere regio's alternatieve netnummers beschikbaar gesteld. Die meerdere regio's zijn: Alkmaar 43192 - Alphen a/d Rijn 43185 - Amersfoort 43195 - Breda 43191 - Capelle 43194 - Den Bosch 43198 - Den Haag 43186 - Driebergen 43189 -Emmen 43208 - Gorinchem 43190 - Gorredijk 43209 - Groningen 43206 - Hengelo 43211 - Hilversum 43196 - Hoogeveen 43205 - Mill 43197 - Utrecht 43187 - Roosendaal 43199 - Roermond 43202 - Sassenheim 43184 - Schoonbron 43203 - Sneek 43210 - Tilburg 43200 - Veenendaal 43188 -Velsen 43193 - Venlo 43201 - Winschoten 43207 - Zwolle 43204 # Installing spotify on openSUSE 12.3 This guide shows you how to install spotify client on openSUSE 12.3 As there is no native openSUSE rpm, we will have to make one ourselves. The big advantage of this method is, that we will always have the latest version, because when a new version is released, we can bake a new rpm ourselves and don't have to wait on others. Here are the steps: 1\. browse to [http://repository.spotify.com/pool/non-free/s/spotify/](http://repository.spotify.com/pool/non-free/s/spotify/)and download the appropriate 32- or 64 bit version. 2\. install the rpm package 'alien' to convert .deb to .rpm's. This can be found in the opensuse repos, to be exact here: [http://software.opensuse.org/package/alien](http://software.opensuse.org/package/alien) 3\. use alien to convert: `#alien -r spotify-clientxxxxx.deb` `spotify-client-0.8.4.103.g9cb177b.260-2.x86_64.rpm generated` 4\. then, install the rpm: `#zypper in spotify-client*.rpm` you will get a libcrypto dependency error, but you can ignore that, choose 2: `Solution 2: break spotify-client-0.9.0.133.gd18ed58.259-2.x86_64 by ignoring some of its dependencies` 5\. typ the following: ` ln -s /usr/lib64/libnss3.so /usr/lib64/libnss3.so.1d` ` ln -s /usr/lib64/libnssutil3.so /usr/lib64/libnssutil3.so.1d` ` ln -s /usr/lib64/libsmime3.so /usr/lib64/libsmime3.so.1d ` ` ln -s libplc4.so /usr/lib64/libplc4.so.0d` ` ln -s libnspr4.so /usr/lib64/libnspr4.so.0d` 6\. that should do it. Have fun! # Convert .pcd (PhotoCD) files `mogrify -colorspace RGB -format jpg -quality 100 img00*.pcd[5]` # Installing spotify on openSUSE 12.2 1. REDIRECT [Installing spotify on openSUSE 12.3](https://www.reeltoreel.nl/knowledgebase/books/mediawiki-import/page/installing-spotify-on-opensuse-123) # Bogomips ``` name 1 2 3 4 samsie 4589 23s 52s 28s nieuwe 5188 20s 35s 25s lapx 5787 18s 39s 22s amd64 6030 34s 43s 43s ams251 6933 23s 59s 29s ams008 6200 27 78 34 1-first column in bogomips. 2-second is time in seconds from this command: time echo "scale=5000; a(1)*4" | bc -l 3-third is this command time $(i=0; while (( i < 9999999 )); do (( i ++ )); done) 4-fourth is this command: echo '2^2^22' | time bc > /dev/null ``` # AIX cheatsheet `# topas` `# nmon        export TERM=aixterm` `# df (-m)                           : megabytes` `# du -mx` `# du -sm *                          :grootte van subdirs in megabytes` `# du -sk ./* | sort -rn             :sorteer huidige subdirs op grootte` `# lslv fslv04                       :laat eigenschappen zien logical volume (typ in zonder /dev/)` `# lsvg -l ontrodat                  :laat filesystems zien in ontrodat` `# lsvg ontrodat                     :laat physical size zien` `# chfs -a size=(+)1G /fsnw/local    :vergroot tot/met 1GB` Om fysieke disk te vinden: `# lsvg -p rhodat` > hdisk6 `# /net/beheer/script/get_disk_info` > hdisk5 6000000000...0...000 800GB 2e veld is de LUN dit gebruiken voor aanvraag lunresize Als er een lun vergroot is, dan moet je AIX inlichten: `# lspv hdisk6` `# chvg -g rhodat                     : scan lun, check dan of grootte gewijzigd is` `# lsvg rhodat                        : check` Nu filesysteem vergroten: `# chfs -a size=+25G /ont/data/DBGA/oracle/rho` `# df -g` # Glmark2 benchmark \_\_FORCETOC\_\_ # omni - tumbleweed ``` ======================================================= vkmark Score: 21180 ======================================================= op netstroom ======================================================= glmark2 Score: 14249 ======================================================= @omni:~> op batterijen ``` # envy - tumbleweed ``` 230901 @Envy:~> glmark2 ======================================================= glmark2 2021.12 ======================================================= OpenGL Information GL_VENDOR: NVIDIA Corporation GL_RENDERER: NVIDIA GeForce MX330/PCIe/SSE2 GL_VERSION: 4.6.0 NVIDIA 535.86.05 Surface Config: buf=32 r=8 g=8 b=8 a=8 depth=24 stencil=0 samples=0 Surface Size: 800x600 windowed ======================================================= ======================================================= glmark2 Score: 5096 ======================================================= 230625 # prime-run konsole # glmark2-wayland ======================================================= glmark2 2021.12 ======================================================= OpenGL Information GL_VENDOR: Intel GL_RENDERER: Mesa Intel(R) UHD Graphics (CML GT2) GL_VERSION: 4.6 (Compatibility Profile) Mesa 23.1.3 Surface Config: buf=32 r=8 g=8 b=8 a=8 depth=24 stencil=0 samples=0 Surface Size: 800x600 windowed ======================================================= [build] use-vbo=false: FPS: 10414 FrameTime: 0.096 ms [build] use-vbo=true: FPS: 10491 FrameTime: 0.095 ms [texture] texture-filter=nearest: FPS: 10216 FrameTime: 0.098 ms [texture] texture-filter=linear: FPS: 10029 FrameTime: 0.100 ms [texture] texture-filter=mipmap: FPS: 10562 FrameTime: 0.095 ms [shading] shading=gouraud: FPS: 8441 FrameTime: 0.118 ms [shading] shading=blinn-phong-inf: FPS: 8086 FrameTime: 0.124 ms [shading] shading=phong: FPS: 7001 FrameTime: 0.143 ms [shading] shading=cel: FPS: 6635 FrameTime: 0.151 ms [bump] bump-render=high-poly: FPS: 4716 FrameTime: 0.212 ms [bump] bump-render=normals: FPS: 10871 FrameTime: 0.092 ms [bump] bump-render=height: FPS: 9692 FrameTime: 0.103 ms [effect2d] kernel=0,1,0;1,-4,1;0,1,0;: FPS: 4881 FrameTime: 0.205 ms [effect2d] kernel=1,1,1,1,1;1,1,1,1,1;1,1,1,1,1;: FPS: 1661 FrameTime: 0.602 ms [pulsar] light=false:quads=5:texture=false: FPS: 8999 FrameTime: 0.111 ms [desktop] blur-radius=5:effect=blur:passes=1:separable=true:windows=4: FPS: 1833 FrameTime: 0.546 ms [desktop] effect=shadow:windows=4: FPS: 5159 FrameTime: 0.194 ms [buffer] columns=200:interleave=false:update-dispersion=0.9:update-fraction=0.5:update-method=map: FPS: 808 FrameTime: 1.239 ms [buffer] columns=200:interleave=false:update-dispersion=0.9:update-fraction=0.5:update-method=subdata: FPS: 1344 FrameTime: 0.744 ms [buffer] columns=200:interleave=true:update-dispersion=0.9:update-fraction=0.5:update-method=map: FPS: 975 FrameTime: 1.026 ms [ideas] speed=duration: FPS: 6467 FrameTime: 0.155 ms [jellyfish] : FPS: 4973 FrameTime: 0.201 ms [terrain] : FPS: 310 FrameTime: 3.236 ms [shadow] : FPS: 5495 FrameTime: 0.182 ms [refract] : FPS: 669 FrameTime: 1.495 ms [conditionals] fragment-steps=0:vertex-steps=0: FPS: 7606 FrameTime: 0.131 ms [conditionals] fragment-steps=5:vertex-steps=0: FPS: 7685 FrameTime: 0.130 ms [conditionals] fragment-steps=0:vertex-steps=5: FPS: 7589 FrameTime: 0.132 ms [function] fragment-complexity=low:fragment-steps=5: FPS: 7639 FrameTime: 0.131 ms [function] fragment-complexity=medium:fragment-steps=5: FPS: 7812 FrameTime: 0.128 ms [loop] fragment-loop=false:fragment-steps=5:vertex-steps=5: FPS: 7628 FrameTime: 0.131 ms [loop] fragment-steps=5:fragment-uniform=false:vertex-steps=5: FPS: 7625 FrameTime: 0.131 ms [loop] fragment-steps=5:fragment-uniform=true:vertex-steps=5: FPS: 7756 FrameTime: 0.129 ms ======================================================= glmark2 Score: 6425 ======================================================= 220817 ======================================================= glmark2 2021.12 ======================================================= OpenGL Information GL_VENDOR: NVIDIA Corporation GL_RENDERER: NVIDIA GeForce MX330/PCIe/SSE2 GL_VERSION: 4.6.0 NVIDIA 515.65.01 Surface Config: buf=32 r=8 g=8 b=8 a=8 depth=24 stencil=0 Surface Size: 800x600 windowed ======================================================= glmark2 Score: 4729 ======================================================= 220525 pvdm@Envy:~> glmark2 ======================================================= glmark2 2021.12 ======================================================= OpenGL Information GL_VENDOR: NVIDIA Corporation GL_RENDERER: NVIDIA GeForce MX330/PCIe/SSE2 GL_VERSION: 4.6.0 NVIDIA 515.43.04 Surface Config: buf=32 r=8 g=8 b=8 a=8 depth=24 stencil=0 Surface Size: 800x600 windowed ======================================================= glmark2 Score: 4617 ======================================================= 20220514 pvdm@Envy:~> glmark2 ======================================================= glmark2 2021.12 ======================================================= OpenGL Information GL_VENDOR: Intel GL_RENDERER: Mesa Intel(R) UHD Graphics (CML GT2) GL_VERSION: 4.6 (Compatibility Profile) Mesa 22.0.3 Surface Config: buf=32 r=8 g=8 b=8 a=8 depth=24 stencil=0 Surface Size: 800x600 windowed ======================================================= glmark2 Score: 3100 ======================================================= 20220514 pvdm@Envy:~> glmark2-wayland ======================================================= glmark2 2021.12 ======================================================= OpenGL Information GL_VENDOR: Intel GL_RENDERER: Mesa Intel(R) UHD Graphics (CML GT2) GL_VERSION: 4.6 (Compatibility Profile) Mesa 22.0.3 Surface Config: buf=32 r=8 g=8 b=8 a=8 depth=24 stencil=0 Surface Size: 800x600 windowed ======================================================= glmark2 Score: 4053 ======================================================= pvdm@Envy:~> glmark2 ======================================================= glmark2 2020.04 ======================================================= OpenGL Information GL_VENDOR: Intel Open Source Technology Center GL_RENDERER: Mesa DRI Intel(R) UHD Graphics (CML GT2) GL_VERSION: 3.0 Mesa 20.3.3 ======================================================= glmark2 Score: 2866 ======================================================= pvdm@Envy:~> ``` # lapx - tumbleweed ``` pvdm@tumbleweed:~> glmark2 ======================================================= glmark2 2014.03 ======================================================= OpenGL Information GL_VENDOR: X.Org GL_RENDERER: Gallium 0.4 on AMD TURKS (DRM 2.49.0 / 4.11.8-2-default, LLVM 4.0.1) GL_VERSION: 3.0 Mesa 17.1.5 ======================================================= [build] use-vbo=false: FPS: 1942 FrameTime: 0.515 ms [build] use-vbo=true: FPS: 2046 FrameTime: 0.489 ms [texture] texture-filter=nearest: FPS: 1927 FrameTime: 0.519 ms [texture] texture-filter=linear: FPS: 1914 FrameTime: 0.522 ms [texture] texture-filter=mipmap: FPS: 2008 FrameTime: 0.498 ms [shading] shading=gouraud: FPS: 1749 FrameTime: 0.572 ms [shading] shading=blinn-phong-inf: FPS: 1730 FrameTime: 0.578 ms [shading] shading=phong: FPS: 1740 FrameTime: 0.575 ms [shading] shading=cel: FPS: 1736 FrameTime: 0.576 ms [bump] bump-render=high-poly: FPS: 1261 FrameTime: 0.793 ms [bump] bump-render=normals: FPS: 2028 FrameTime: 0.493 ms [bump] bump-render=height: FPS: 2057 FrameTime: 0.486 ms [effect2d] kernel=0,1,0;1,-4,1;0,1,0;: FPS: 1774 FrameTime: 0.564 ms [effect2d] kernel=1,1,1,1,1;1,1,1,1,1;1,1,1,1,1;: FPS: 1034 FrameTime: 0.967 ms [pulsar] light=false:quads=5:texture=false: FPS: 1870 FrameTime: 0.535 ms [desktop] blur-radius=5:effect=blur:passes=1:separable=true:windows=4: FPS: 699 FrameTime: 1.431 ms [desktop] effect=shadow:windows=4: FPS: 1070 FrameTime: 0.935 ms [buffer] columns=200:interleave=false:update-dispersion=0.9:update-fraction=0.5:update-method=map: FPS: 746 FrameTime: 1.340 ms [buffer] columns=200:interleave=false:update-dispersion=0.9:update-fraction=0.5:update-method=subdata: FPS: 1123 FrameTime: 0.890 ms [buffer] columns=200:interleave=true:update-dispersion=0.9:update-fraction=0.5:update-method=map: FPS: 811 FrameTime: 1.233 ms [ideas] speed=duration: FPS: 1459 FrameTime: 0.685 ms [jellyfish] : FPS: 1145 FrameTime: 0.873 ms [terrain] : FPS: 133 FrameTime: 7.519 ms [shadow] : FPS: 591 FrameTime: 1.692 ms [refract] : FPS: 179 FrameTime: 5.587 ms [conditionals] fragment-steps=0:vertex-steps=0: FPS: 1723 FrameTime: 0.580 ms [conditionals] fragment-steps=5:vertex-steps=0: FPS: 1730 FrameTime: 0.578 ms [conditionals] fragment-steps=0:vertex-steps=5: FPS: 1730 FrameTime: 0.578 ms [function] fragment-complexity=low:fragment-steps=5: FPS: 1730 FrameTime: 0.578 ms [function] fragment-complexity=medium:fragment-steps=5: FPS: 1691 FrameTime: 0.591 ms [loop] fragment-loop=false:fragment-steps=5:vertex-steps=5: FPS: 1730 FrameTime: 0.578 ms [loop] fragment-steps=5:fragment-uniform=false:vertex-steps=5: FPS: 1730 FrameTime: 0.578 ms [loop] fragment-steps=5:fragment-uniform=true:vertex-steps=5: FPS: 1027 FrameTime: 0.974 ms ======================================================= glmark2 Score: 1450 ======================================================= ``` # lapx - Leap 42.3 ``` pvdm@lapx:~> glmark2 ======================================================= glmark2 2014.03 ======================================================= OpenGL Information GL_VENDOR: X.Org GL_RENDERER: Gallium 0.4 on AMD TURKS (DRM 2.49.0 / 4.4.76-1-default, LLVM 3.8.0) GL_VERSION: 3.0 Mesa 17.0.5 ======================================================= [build] use-vbo=false: FPS: 1949 FrameTime: 0.513 ms [build] use-vbo=true: FPS: 2050 FrameTime: 0.488 ms [texture] texture-filter=nearest: FPS: 1909 FrameTime: 0.524 ms [texture] texture-filter=linear: FPS: 1896 FrameTime: 0.527 ms [texture] texture-filter=mipmap: FPS: 1993 FrameTime: 0.502 ms [shading] shading=gouraud: FPS: 1749 FrameTime: 0.572 ms [shading] shading=blinn-phong-inf: FPS: 1741 FrameTime: 0.574 ms [shading] shading=phong: FPS: 1727 FrameTime: 0.579 ms [shading] shading=cel: FPS: 1740 FrameTime: 0.575 ms [bump] bump-render=high-poly: FPS: 1259 FrameTime: 0.794 ms [bump] bump-render=normals: FPS: 2089 FrameTime: 0.479 ms [bump] bump-render=height: FPS: 2066 FrameTime: 0.484 ms [effect2d] kernel=0,1,0;1,-4,1;0,1,0;: FPS: 1773 FrameTime: 0.564 ms [effect2d] kernel=1,1,1,1,1;1,1,1,1,1;1,1,1,1,1;: FPS: 1035 FrameTime: 0.966 ms [pulsar] light=false:quads=5:texture=false: FPS: 1880 FrameTime: 0.532 ms [desktop] blur-radius=5:effect=blur:passes=1:separable=true:windows=4: FPS: 681 FrameTime: 1.468 ms [desktop] effect=shadow:windows=4: FPS: 1069 FrameTime: 0.935 ms [buffer] columns=200:interleave=false:update-dispersion=0.9:update-fraction=0.5:update-method=map: FPS: 743 FrameTime: 1.346 ms [buffer] columns=200:interleave=false:update-dispersion=0.9:update-fraction=0.5:update-method=subdata: FPS: 1186 FrameTime: 0.843 ms [buffer] columns=200:interleave=true:update-dispersion=0.9:update-fraction=0.5:update-method=map: FPS: 815 FrameTime: 1.227 ms [ideas] speed=duration: FPS: 1511 FrameTime: 0.662 ms [jellyfish] : FPS: 1140 FrameTime: 0.877 ms [terrain] : FPS: 133 FrameTime: 7.519 ms [shadow] : FPS: 587 FrameTime: 1.704 ms [refract] : FPS: 181 FrameTime: 5.525 ms [conditionals] fragment-steps=0:vertex-steps=0: FPS: 1698 FrameTime: 0.589 ms [conditionals] fragment-steps=5:vertex-steps=0: FPS: 1712 FrameTime: 0.584 ms [conditionals] fragment-steps=0:vertex-steps=5: FPS: 1702 FrameTime: 0.588 ms [function] fragment-complexity=low:fragment-steps=5: FPS: 1716 FrameTime: 0.583 ms [function] fragment-complexity=medium:fragment-steps=5: FPS: 1710 FrameTime: 0.585 ms [loop] fragment-loop=false:fragment-steps=5:vertex-steps=5: FPS: 1703 FrameTime: 0.587 ms [loop] fragment-steps=5:fragment-uniform=false:vertex-steps=5: FPS: 1708 FrameTime: 0.585 ms [loop] fragment-steps=5:fragment-uniform=true:vertex-steps=5: FPS: 1018 FrameTime: 0.982 ms ======================================================= glmark2 Score: 1450 ======================================================= ``` # tecra - tumbleweed ``` pvdm@tecra:~> glmark2 ======================================================= glmark2 2014.03 ======================================================= OpenGL Information GL_VENDOR: Intel Open Source Technology Center GL_RENDERER: Mesa DRI Intel(R) HD Graphics 520 (Skylake GT2) GL_VERSION: 3.0 Mesa 17.1.5 ======================================================= [build] use-vbo=false: FPS: 966 FrameTime: 1.035 ms [build] use-vbo=true: FPS: 1050 FrameTime: 0.952 ms [texture] texture-filter=nearest: FPS: 1001 FrameTime: 0.999 ms [texture] texture-filter=linear: FPS: 1006 FrameTime: 0.994 ms [texture] texture-filter=mipmap: FPS: 990 FrameTime: 1.010 ms [shading] shading=gouraud: FPS: 987 FrameTime: 1.013 ms [shading] shading=blinn-phong-inf: FPS: 981 FrameTime: 1.019 ms [shading] shading=phong: FPS: 990 FrameTime: 1.010 ms [shading] shading=cel: FPS: 991 FrameTime: 1.009 ms [bump] bump-render=high-poly: FPS: 770 FrameTime: 1.299 ms [bump] bump-render=normals: FPS: 1065 FrameTime: 0.939 ms [bump] bump-render=height: FPS: 1058 FrameTime: 0.945 ms [effect2d] kernel=0,1,0;1,-4,1;0,1,0;: FPS: 814 FrameTime: 1.229 ms [effect2d] kernel=1,1,1,1,1;1,1,1,1,1;1,1,1,1,1;: FPS: 666 FrameTime: 1.502 ms [pulsar] light=false:quads=5:texture=false: FPS: 1033 FrameTime: 0.968 ms [desktop] blur-radius=5:effect=blur:passes=1:separable=true:windows=4: FPS: 486 FrameTime: 2.058 ms [desktop] effect=shadow:windows=4: FPS: 607 FrameTime: 1.647 ms [buffer] columns=200:interleave=false:update-dispersion=0.9:update-fraction=0.5:update-method=map: FPS: 483 FrameTime: 2.070 ms [buffer] columns=200:interleave=false:update-dispersion=0.9:update-fraction=0.5:update-method=subdata: FPS: 450 FrameTime: 2.222 ms [buffer] columns=200:interleave=true:update-dispersion=0.9:update-fraction=0.5:update-method=map: FPS: 509 FrameTime: 1.965 ms [ideas] speed=duration: FPS: 948 FrameTime: 1.055 ms [jellyfish] : FPS: 896 FrameTime: 1.116 ms [terrain] : FPS: 146 FrameTime: 6.849 ms [shadow] : FPS: 695 FrameTime: 1.439 ms [refract] : FPS: 255 FrameTime: 3.922 ms [conditionals] fragment-steps=0:vertex-steps=0: FPS: 903 FrameTime: 1.107 ms [conditionals] fragment-steps=5:vertex-steps=0: FPS: 909 FrameTime: 1.100 ms [conditionals] fragment-steps=0:vertex-steps=5: FPS: 904 FrameTime: 1.106 ms [function] fragment-complexity=low:fragment-steps=5: FPS: 906 FrameTime: 1.104 ms [function] fragment-complexity=medium:fragment-steps=5: FPS: 889 FrameTime: 1.125 ms [loop] fragment-loop=false:fragment-steps=5:vertex-steps=5: FPS: 841 FrameTime: 1.189 ms [loop] fragment-steps=5:fragment-uniform=false:vertex-steps=5: FPS: 886 FrameTime: 1.129 ms [loop] fragment-steps=5:fragment-uniform=true:vertex-steps=5: FPS: 886 FrameTime: 1.129 ms ======================================================= glmark2 Score: 817 ======================================================= ``` # AMD64 with AMD K8 6600 ``` @amd64:.../~> glmark2 ======================================================= glmark2 2014.03 ======================================================= OpenGL Information GL_VENDOR: X.Org GL_RENDERER: Gallium 0.4 on AMD ARUBA (DRM 2.49.0 / 4.4.76-1-default, LLVM 3.8.0) GL_VERSION: 3.0 Mesa 17.0.5 ======================================================= [build] use-vbo=false: FPS: 2017 FrameTime: 0.496 ms [build] use-vbo=true: FPS: 2523 FrameTime: 0.396 ms [texture] texture-filter=nearest: FPS: 2134 FrameTime: 0.469 ms [texture] texture-filter=linear: FPS: 2117 FrameTime: 0.472 ms [texture] texture-filter=mipmap: FPS: 2285 FrameTime: 0.438 ms [shading] shading=gouraud: FPS: 2001 FrameTime: 0.500 ms [shading] shading=blinn-phong-inf: FPS: 2028 FrameTime: 0.493 ms [shading] shading=phong: FPS: 2026 FrameTime: 0.494 ms [shading] shading=cel: FPS: 2018 FrameTime: 0.496 ms [bump] bump-render=high-poly: FPS: 1560 FrameTime: 0.641 ms [bump] bump-render=normals: FPS: 5105 FrameTime: 0.196 ms [bump] bump-render=height: FPS: 5021 FrameTime: 0.199 ms [effect2d] kernel=0,1,0;1,-4,1;0,1,0;: FPS: 3158 FrameTime: 0.317 ms [effect2d] kernel=1,1,1,1,1;1,1,1,1,1;1,1,1,1,1;: FPS: 1684 FrameTime: 0.594 ms [pulsar] light=false:quads=5:texture=false: FPS: 4463 FrameTime: 0.224 ms [desktop] blur-radius=5:effect=blur:passes=1:separable=true:windows=4: FPS: 1009 FrameTime: 0.991 ms [desktop] effect=shadow:windows=4: FPS: 1508 FrameTime: 0.663 ms [buffer] columns=200:interleave=false:update-dispersion=0.9:update-fraction=0.5:update-method=map: FPS: 690 FrameTime: 1.449 ms [buffer] columns=200:interleave=false:update-dispersion=0.9:update-fraction=0.5:update-method=subdata: FPS: 859 FrameTime: 1.164 ms [buffer] columns=200:interleave=true:update-dispersion=0.9:update-fraction=0.5:update-method=map: FPS: 825 FrameTime: 1.212 ms [ideas] speed=duration: FPS: 1663 FrameTime: 0.601 ms [jellyfish] : FPS: 1703 FrameTime: 0.587 ms [terrain] : FPS: 183 FrameTime: 5.464 ms [shadow] : FPS: 1091 FrameTime: 0.917 ms [refract] : FPS: 227 FrameTime: 4.405 ms [conditionals] fragment-steps=0:vertex-steps=0: FPS: 5619 FrameTime: 0.178 ms [conditionals] fragment-steps=5:vertex-steps=0: FPS: 5596 FrameTime: 0.179 ms [conditionals] fragment-steps=0:vertex-steps=5: FPS: 5607 FrameTime: 0.178 ms [function] fragment-complexity=low:fragment-steps=5: FPS: 3519 FrameTime: 0.284 ms [function] fragment-complexity=medium:fragment-steps=5: FPS: 2909 FrameTime: 0.344 ms [loop] fragment-loop=false:fragment-steps=5:vertex-steps=5: FPS: 3469 FrameTime: 0.288 ms [loop] fragment-steps=5:fragment-uniform=false:vertex-steps=5: FPS: 3468 FrameTime: 0.288 ms [loop] fragment-steps=5:fragment-uniform=true:vertex-steps=5: FPS: 3284 FrameTime: 0.305 ms ======================================================= glmark2 Score: 2526 ======================================================= ``` # AMD64 with Ryzen R5 5500 with NVIDIA GT730 ``` 20230312 @amd64:~> glmark2 ======================================================= glmark2 2021.02 ======================================================= OpenGL Information GL_VENDOR: NVIDIA Corporation GL_RENDERER: NVIDIA GeForce GT 730/PCIe/SSE2 GL_VERSION: 4.6.0 NVIDIA 470.161.03 ======================================================= ======================================================= glmark2 Score: 1483 ======================================================= ``` # Enable 3d acceleration Re: How to turn on OpenGL on RPi 3B (Solved) Quote Sun Oct 14, 2018 11:04 pm [https://www.reddit.com/r/openSUSE/comme](https://www.reddit.com/r/openSUSE/comme)... \_question/ OP sdoconnell "3 months ago", 2018-07-xx. He found the solution in [https://www.suse.com/documentation/suse](https://www.suse.com/documentation/suse)... rry-pi.pdf the SuSE documention for SLES-12 SP3 on Raspberry Pi (PDF). I did the following procedure with no problems on two different Raspberry Pi 3B's: 1\. Since Eric Anholt's accelerated vc4 driver is "experimental", SuSE ships it with 3D acceleration suppressed. Edit /etc/X11/xorg.conf.d/20-kms.conf and comment out Option "AccelMethod" "none". 2\. Install package Mesa-dri-vc4 which provides the direct rendering module for the X-Server. 3\. In /boot/efi/extraconfig.txt you need dtoverlay=vc4-kms-v3d or dtoverlay=vc4-fkms-v3d ("fake" KMS). Other forum posts suggest that the latter one works better for streaming video, so I'm using that one. 4\. The kernel command line needs a nonzero cma allocation. Based on another forum post I'm using cma=300M (unit of megabytes is required). Different people recommend different values. I suspect without proof that this is an upper bound; the driver is known to expand and contract video RAM dynamically. While other distros use /boot/cmdline, SuSE uses Grub (yay) which obeys /boot/grub2/grub.cfg which is overwritten on each update with material from /etc/default/grub. For this driver gpu\_mem is irrelevant and can be left at the default (32 on SuSE, 16 on Gentoo, in megabytes). 5\. Reboot, to get the changed dtoverlay=vc4-fkms-v3d and/or cma=300M. I installed glmark2 from the SuSE repo and it got an overall score of 74, which looks like the average frames per sec of the 33 sub-tests. Comparing the overall score on different graphics platforms: - 17 fps for a RPi 3B with software rendering. - 74 fps for a RPi 3B with the GPU enabled, 4.4x faster. - 1831 fps for an Intel Core i5-5200U @2.2GHz with Intel HD Graphics 5500. - And a real gaming GPU would be faster than that. So you won't be playing modern video games, but this is very promising for my goal of video playback. The next step is to purchase the codec licenses and install Kodi. Thank you to all who helped out on this issue and special credit to sdoconnell. --- `sdoconnell solved the problem! He has what he describes as a stuipdly simple solution, which he found in section 1.2.5 of the SLES documentation for Raspberry Pi. Jimc's paraphrase and extension of his solution:` - Edit /etc/X11/xorg.conf.d/20-kms.conf and hide (comment out) 'Option "AccelMethod" "none"' to de-suppress direct rendering. SuSE turns it off by default because the vc4.ko driver by Eric Anholt is "experimental". An issue is described below, and as of 2018-09-xx to present (2018-12-xx), GPU acceleration with this problem really would not be acceptable in the SLES context. \[Update: comments from a SuSE distro manager indicate that since Mesa-dri-vc4 is also not installed by default, they may or may not be going to get rid of 20-kms.conf.\] - You also need to install package Mesa-dri-vc4 which provides the direct rendering module for the X-Server. It also is kept off the SLES installation and has to be installed explicitly by the user. - In extraconfig.txt you need dtoverlay=vc4-kms-v3d . Other forum posts suggest that dtoverlay=vc4-fkms-v3d ("fake" KMS) works better for streaming video and that's what jimc is using. - Comments on Gentoo say that the accelerated vc4 driver should not have a big gpu\_mem allocation; they give gpu\_mem=16 (no unit, megabytes is implicit). SuSE default is 32. This is in config.txt. - On SuSE, put local hacks in extraconfig.txt because config.txt gets altered in updates. It includes extraconfig.txt at the end. - The kernel command line needs cma=256M. The unit (megabytes) is required. This lets the GPU acquire memory dynamically, and jimc suspects without proof that this is an upper bound. Various amounts are seen in different forum posts. 256M is what Gentoo uses, and 300M is from a forum post that appears fairly authoritative to jimc. On SuSE the kernel command line is provided by Grub and the origin, editable by the sysadmin, is /etc/default/grub, which gets propagated to /boot/grub2/grub.cfg which you can tweak for experiments but which gets rebuilt in updates. Other distros get the kernel command line from /boot/cmdline.txt . - Look for CmaTotal and CmaFree at the end of /proc/meminfo. The default (on Gentoo without dtoverlay=vc4-kms-v3d) appears to be cma=8M. Limited experience suggests that dtoverlay=vc4-fkms-v3d sets a default of cma=256M, so you don't really need to set it explicitly on the kernel command line. In Gentoo. But in OpenSuSE if you leave it off you get zero CmaTotal and no GPU acceleration. # Rootvg won't resize ``` parted /dev/sda resizepart 2 100%  fdisk -l /dev/sda  partprobe /dev/sda  pvresize /dev/sda2  ``` # Lesie # When hanging like a ........ `$ rm .config/session/kwin...........` # to get into bootmenu Fn+F12 # Update etherpad 1. su to etherpad user 2. go to dir: /opt/etherpad/etherpad-lite 3. \# git pull origin 4. # Recover mybb account goto mysql; ga naar database; execute: `UPDATE `mybb_users` SET `salt` = ' ', `password` = 'YOUR_PASSWORD' WHERE `uid` = '1'; ` waarbij mybb\_users de usertabel is en hopelijk de admin account id 1 heeft (en let op de backticks!!) # Partitions WeTab 32GB ``` sda1 200MB ext3 /boot WeTabOS sda2 2GB swap sda3 12,5GB ext3 / WeTabOS sda4 ==== extended partition ======= sda6 200mb /boot plasma sda7 9GB / plasma sda5 7GB ext2 androidx86 / \ | LETOP ``` # Bootloader WeTab # huidig 14 okt 2011 ``` default=0 timeout=6 root (hd0,5) splashimage=/grub/android-x86.xpm.gz title Android-x86 2011-08-28 kernel /android-2011-08-28/kernel quiet root=/dev/ram0 androidboot_hardware=tegav2 SRC=/android-2011-08-28 # kernel /android-2011-08-28/kernel quiet root=/dev/ram0 androidboot_hardware=tegav2 acpi_sleep=s3_bios,s3_mode SRC=/android-2011-08-28 initrd /android-2011-08-28/initrd.img title Wetab OS root (hd0,0) kernel /extlinux/vmlinuz quiet root=/dev/sda3 ro title KDE Plasma Active root (hd0,4) kernel /boot/vmlinuz-2.6.38.2-8.26-adaptation-pinetrail quiet root=/dev/sda5 title Android-x86 2011-08-28 (Debug mode) kernel /android-2011-08-28/kernel root=/dev/ram0 androidboot_hardware=tegav2 acpi_sleep=s3_bios,s3_mode DEBUG=1 SRC=/android-2011-08-28 initrd /android-2011-08-28/initrd.img ``` # ter info ``` [root@localhost pvdmatten]# cat /etc/extlinux.conf prompt 1 timeout 5000 default vesamenu.c32 menu autoboot menu hidden menu master passwd $1$psPEZQzt$FckzDRpSCbSdUsTDwk22f1 menu title Welcome to WeTab! menu resolution 1024 768 menu background splash1024.png menu color border 0 #ffffffff #00000000 menu color sel 7 #ffffffff #ffffcc00 menu color title 0 #ffffffff #00000000 menu color tabmsg 0 #ffffffff #00000000 menu color unsel 0 #ffffffff #00000000 menu color hotsel 0 #ffffffff #ffffcc00 menu color hotkey 7 #ffFFCC00 #00000000 menu color timeout_msg 0 #ffffffff #00000000 menu color timeout 0 #ffffffff #00000000 menu color cmdline 0 #ffffffff #00000000 menu color cmdmark 0 #ffffcc00 #00000000 menu color pwdborder 0 #ffffcc00 #00000000 menu color pwdheader 0 #ff393837 #ffffcc00 menu color pwdentry 0 #ffffcc00 #00000000 label wetab-os menu label ^WeTab OS kernel vmlinuz append ro root=/dev/sda3 quiet vga=current console=ttyUSB99 menu default label pvdm menu label ^PvdM kernel chain.c32 append boot 6 label android menu label ^Android kernel android-2011-08-28/kernel # append ro root=/dev/sda6 quiet vga=current console=ttyUSB99 append initrd=android-2011-08-28/initrd.img root=/dev/sda6 rw # menu default label bios menu label ^BIOS Update menu hide kernel memdisk append initrd=biosup.img floppy c=8 s=32 h=64 label Meego kernel vmlinuz-2.6.38.2-8.26-adaptation-pinetrail append ro root=/dev/sda5 quiet vga=current menu default ``` # grub ``` default=0 timeout=6 splashimage=/grub/android-x86.xpm.gz title Android-x86 2011-08-28 root (hd1,0) kernel /android-2011-08-28/kernel quiet root=/dev/ram0 androidboot_hardware=tegav2 acpi_sleep=s3_bios,s3_mode SRC=/android-2011-08-28 initrd /android-2011-08-28/initrd.img title Wetab Os root (hd0,0) kernel /extlinux/vmlinuz root=/dev/sda3 ro title Android-x86 2011-08-28 (Debug mode) kernel /android-2011-08-28/kernel root=/dev/ram0 androidboot_hardware=tegav2 acpi_sleep=s3_bios,s3_mode DEBUG=1 SRC=/android-2011-08-28 initrd /android-2011-08-28/initrd.img ``` # HC-608 Dit is de 2e webcam. [`rtsp://192.168.1.34/iphone/11?admin:pw&`](rtsp://192.168.1.34/iphone/11?admin:pw&) werkt goed in vlc ``` SOURCE: RTSP RTP/RTSP 192.168.1.34 554 /iphone/11?admin:PASSWD& 24bit 1280 720 use rtsp responce media url v CONTROL: controllable v ONVIF Camera usr=admin&pwd=PASSWD 192.168.1.34:8080 hieronder geen idee? http://192.168.1.34/cgi-bin/view.cgi?chn=1&u=admin&p=password deze ook ``` # Edup dit is de 'grote' usb wifi stick ``` Product: 802.11n NIC usb 1-1.2: Manufacturer: Realtek usb 1-1.2: SerialNumber: E84E0642F576 RTL8192EU rev B (SMIC) 2T2R, TX queues 3, WiFi=1, BT=0, GPS=0, HI PA=0 usb 1-1.2: RTL8192EU MAC: e8:4e:06:42:f5:76 usb 1-1.2: rtl8xxxu: Loading firmware rtlwifi/rtl8192eu_nic.bin usb 1-1.2: Firmware revision 19.0 (signature 0x92e1) usb 1-1.2: rtl8192eu_rx_iqk_path_b: Path B RX IQK failed! usbcore: registered new interface driver rtl8xxxu rtl8xxxu 1-1.2:1.0 wlp0s26u1u2: renamed from wlan0 IPv6: ADDRCONF(NETDEV_UP): wlp0s26u1u2: link is not ready ``` # Aida screen - 7 iNch standaard display, 1024 × 600 Hardware resolutie, tot 1920x1080 Software configuratie resolutie. ●.Capacitieve touchscreen, maximale ondersteuning 5 punt touch. ●.Ondersteuning backlight controle alleen, de achtergrondverlichting kan worden uitgeschakeld om stroom te besparen. ●. Ondersteuning Raspberry Pi, BB Zwart, Banana Pi en andere mainstream mini PC. ●.Kan worden gebruikt als algemene doeleinden gebruiken HDMI monitor, bijvoorbeeld: verbinden met een computer HDMI als de sub-display. ●.Gebruikt als een raspberry pi display dat ondersteunt Raspbian, Ubuntu, Kali-Linux, Kodi, win10 IOT, single-touch, gratis drive. ●.Werken als een PC monitor, ondersteuning win7, win8, win10 systeem 5 punt touch (XP en oudere versie systeem: single-point touch), Gratis drive. ●.CE, RoHS certificering ``` Na de programmering van Step1 is voltooid, open de config.txt bestand van TF card root directory en Voeg de volgende code op het einde van het bestand, opslaan en eject Micro Sd-kaart veilig: max_usb_current = 1 Hdmi_force_hotplug = 1 Config_hdmi_boost = 7 Hdmi_group = 2 Hdmi_mode = 87 Hdmi_drive = 1 Display_rotate = 0 Hdmi_cvt 1024 600 60 6 0 0 0 ``` # OLD:How to secure an initial MySQL installation How to secure an initial installation of Mysql **!!this is the old version, please use the other wiki page!!** PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: `/usr/bin/mysqladmin -u root password 'new-password'` `/usr/bin/mysqladmin -u root -h server.wonen.amsterdam.nl password 'new-password'` See the manual for more instructions. You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: `cd sql-bench ; perl run-all-tests` --- After installing MySQL on Unix, you need to initialize the grant tables, start the server, and make sure that the server works satisfactorily. You may also wish to arrange for the server to be started and stopped automatically when your system starts and stops. You should also assign passwords to the accounts in the grant tables. On Unix, the grant tables are set up by the mysql\_install\_db program. For some installation methods, this program is run for you automatically: `   *      If you install MySQL on Linux using RPM distributions, the server RPM runs mysql_install_db.` `   *      If you install MySQL on Mac OS X using a PKG distribution, the installer runs mysql_install_db. ` Otherwise, you will need to run mysql\_install\_db yourself. The following procedure describes how to initialize the grant tables (if that has not previously been done) and then start the server. It also suggests some commands that you can use to test whether the server is accessible and working properly. For information about starting and stopping the server automatically, see Section 2.3.15.2.2, “Starting and Stopping MySQL Automatically”. After you complete the procedure and have the server running, you should assign passwords to the accounts created by mysql\_install\_db. Instructions for doing so are given in Section 2.3.15.3, “Securing the Initial MySQL Accounts”. In the examples shown here, the server runs under the user ID of the mysql login account. This assumes that such an account exists. Either create the account if it does not exist, or substitute the name of a different existing login account that you plan to use for running the server. 1.Change location into the top-level directory of your MySQL installation, represented here by BASEDIR: `     shell> cd BASEDIR ` BASEDIR is likely to be something like /usr/local/mysql or /usr/local. The following steps assume that you are located in this directory. 2.If necessary, run the mysql\_install\_db program to set up the initial MySQL grant tables containing the privileges that determine how users are allowed to connect to the server. You'll need to do this if you used a distribution type for which the installation procedure doesn't run the program for you. Typically, mysql\_install\_db needs to be run only the first time you install MySQL, so you can skip this step if you are upgrading an existing installation, However, mysql\_install\_db does not overwrite any existing privilege tables, so it should be safe to run in any circumstances. To initialize the grant tables, use one of the following commands, depending on whether mysql\_install\_db is located in the bin or scripts directory: `     shell> bin/mysql_install_db --user=mysql` `     shell> scripts/mysql_install_db --user=mysql ` The mysql\_install\_db script creates the server's data directory. Under the data directory, it creates directories for the mysql database that holds all database privileges and the test database that you can use to test MySQL. The script also creates privilege table entries for root and anonymous-user accounts. The accounts have no passwords initially. A description of their initial privileges is given in Section 2.3.15.3, “Securing the Initial MySQL Accounts”. Briefly, these privileges allow the MySQL root user to do anything, and allow anybody to create or use databases with a name of test or starting with test\_. It is important to make sure that the database directories and files are owned by the mysql login account so that the server has read and write access to them when you run it later. To ensure this, the --user option should be used as shown if you run mysql\_install\_db as root. Otherwise, you should execute the script while logged in as mysql, in which case you can omit the --user option from the command. mysql\_install\_db creates several tables in the mysql database, including user, db, host, tables\_priv, columns\_priv, func, and others. See Section 5.8, “The MySQL Access Privilege System”, for a complete listing and description of these tables. If you don't want to have the test database, you can remove it with mysqladmin -u root drop test after starting the server. If you have trouble with mysql\_install\_db at this point, see Section 2.3.15.2.1, “Problems Running mysql\_install\_db”. 3. Start the MySQL server: `     shell> bin/mysqld_safe --user=mysql & ` It is important that the MySQL server be run using an unprivileged (non-root) login account. To ensure this, the --user option should be used as shown if you run mysql\_safe as system root. Otherwise, you should execute the script while logged in to the system as mysql, in which case you can omit the --user option from the command. Further instructions for running MySQL as an unprivileged user are given in Section 5.7.5, “How to Run MySQL as a Normal User”. If you neglected to create the grant tables before proceeding to this step, the following message appears in the error log file when you start the server: `     mysqld: Can't find file: 'host.frm'` If you have other problems starting the server, see Section 2.3.15.2.3, “Starting and Troubleshooting the MySQL Server”. `  4.     Use mysqladmin to verify that the server is running. The following commands provide simple tests to check whether the server is up and responding to connections:` `     shell> bin/mysqladmin version` `     shell> bin/mysqladmin variables ` The output from mysqladmin version varies slightly depending on your platform and version of MySQL, but should be similar to that shown here: `     shell> bin/mysqladmin version` `     mysqladmin  Ver 14.12 Distrib 5.0.28, for pc-linux-gnu on i686` `     Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB` `     This software comes with ABSOLUTELY NO WARRANTY. This is free software,` `     and you are welcome to modify and redistribute it under the GPL license` `     Server version          5.0.28-Max` `     Protocol version        10` `     Connection              Localhost via UNIX socket` `     UNIX socket             /var/lib/mysql/mysql.sock` `     Uptime:                 14 days 5 hours 5 min 21 sec` `     Threads: 1  Questions: 366  Slow queries: 0` `     Opens: 0  Flush tables: 1  Open tables: 19` `     Queries per second avg: 0.000` To see what else you can do with mysqladmin, invoke it with the --help option. 5. Verify that you can shut down the server: `     shell> bin/mysqladmin -u root shutdown ` 6\. Verify that you can start the server again. Do this by using mysqld\_safe or by invoking mysqld directly. For example: `     shell> bin/mysqld_safe --user=mysql --log & ` If mysqld\_safe fails, see Section 2.3.15.2.3, “Starting and Troubleshooting the MySQL Server”. 7. Run some simple tests to verify that you can retrieve information from the server. The output should be similar to what is shown here: `     shell> bin/mysqlshow` `     +-----------+` `     | Databases |` `     +-----------+` `     | mysql     |` `     | test      |` `     +-----------+` `     shell> bin/mysqlshow mysql` `     Database: mysql` `     +---------------------------+` `     |          Tables           |` `     +---------------------------+` `     | columns_priv              |` `     | db                        |` `     | func                      |` `     | help_category             |` `     | help_keyword              |` `     | help_relation             |` `     | help_topic                |` `     | host                      |` `     | proc                      |` `     | procs_priv                |` `     | tables_priv               |` `     | time_zone                 |` `     | time_zone_leap_second     |` `     | time_zone_name            |` `     | time_zone_transition      |` `     | time_zone_transition_type |` `     | user                      |` `     +---------------------------+` `     shell> bin/mysql -e "SELECT Host,Db,User FROM db" mysql` `     +------+--------+------+` `     | host | db     | user |` `     +------+--------+------+` `     | %    | test   |      |` `     | %    | test_% |      |` `     +------+--------+------+` 8\. There is a benchmark suite in the sql-bench directory (under the MySQL installation directory) that you can use to compare how MySQL performs on different platforms. The benchmark suite is written in Perl. It requires the Perl DBI module that provides a database-independent interface to the various databases, and some other additional Perl modules: `     DBI` `     DBD::mysql` `     `[`Data::Dumper`](Data::Dumper) `     `[`Data::ShowTable`](Data::ShowTable) These modules can be obtained from CPAN (http://www.cpan.org/). See also Section 2.3.19.1, “Installing Perl on Unix”. The sql-bench/Results directory contains the results from many runs against different databases and platforms. To run all tests, execute these commands: `     shell> cd sql-bench` `     shell> perl run-all-tests ` If you don't have the sql-bench directory, you probably installed MySQL using RPM files other than the source RPM. (The source RPM includes the sql-bench benchmark directory.) In this case, you must first install the benchmark suite before you can use it. There are separate benchmark RPM files named mysql-bench-VERSION-i386.rpm that contain benchmark code and data. If you have a source distribution, there are also tests in its tests subdirectory that you can run. For example, to run auto\_increment.tst, execute this command from the top-level directory of your source distribution: `     shell> mysql -vvf test < ./tests/auto_increment.tst ` The expected result of the test can be found in the ./tests/auto\_increment.res file. 9. At this point, you should have the server running. However, none of the initial MySQL accounts have a password, so you should assign passwords using the instructions found in Section 2.3.15.3, “Securing the Initial MySQL Accounts”. The MySQL 5.0 installation procedure creates time zone tables in the mysql database. However, you must populate the tables manually using the instructions in Section 5.11.8, “MySQL Server Time Zone Support”. 2.3.15.2.1. Problems Running mysql\_install\_db This section does not apply to MySQL Enterprise Server users. The purpose of the mysql\_install\_db script is to generate new MySQL privilege tables. It does not overwrite existing MySQL privilege tables, and it does not affect any other data. If you want to re-create your privilege tables, first stop the mysqld server if it's running. Then rename the mysql directory under the data directory to save it, and then run mysql\_install\_db. Suppose that your current directory is the MySQL installation directory and that mysql\_install\_db is located in the bin directory and the data directory is named data. To rename the mysql database and re-run mysql\_install\_db, use these commands. shell> mv data/mysql data/mysql.old shell> bin/mysql\_install\_db --user=mysql When you run mysql\_install\_db, you might encounter the following problems: `     mysql_install_db fails to install the grant tables` You may find that mysql\_install\_db fails to install the grant tables and terminates after displaying the following messages: `     Starting mysqld daemon with databases from XXXXXX` `     mysqld ended` In this case, you should examine the error log file very carefully. The log should be located in the directory XXXXXX named by the error message and should indicate why mysqld didn't start. If you do not understand what happened, include the log when you post a bug report. See Section 1.8, “How to Report Bugs or Problems”. `There is a mysqld process running` This indicates that the server is running, in which case the grant tables have probably been created already. If so, there is no need to run mysql\_install\_db at all because it needs to be run only once (when you install MySQL the first time). `     Installing a second mysqld server does not work when one server is running` This can happen when you have an existing MySQL installation, but want to put a new installation in a different location. For example, you might have a production installation, but you want to create a second installation for testing purposes. Generally the problem that occurs when you try to run a second server is that it tries to use a network interface that is in use by the first server. In this case, you should see one of the following error messages: `     Can't start server: Bind on TCP/IP port:` `     Address already in use` `     Can't start server: Bind on unix socket...` `     For instructions on setting up multiple servers, see Section 5.13, “Running Multiple MySQL Servers on the Same Machine”.` `   *` `     You do not have write access to the /tmp directory` `     If you do not have write access to create temporary files or a Unix socket file in the default location (the /tmp directory), an error occurs when you run mysql_install_db or the mysqld server.` `     You can specify different locations for the temporary directory and Unix socket file by executing these commands prior to starting mysql_install_db or mysqld, where some_tmp_dir is the full pathname to some directory for which you have write permission:` `     shell> TMPDIR=/some_tmp_dir/` `     shell> MYSQL_UNIX_PORT=/some_tmp_dir/mysql.sock` `     shell> export TMPDIR MYSQL_UNIX_PORT ` `     Then you should be able to run mysql_install_db and start the server with these commands:` `     shell> bin/mysql_install_db --user=mysql` `     shell> bin/mysqld_safe --user=mysql & ` `     If mysql_install_db is located in the scripts directory, modify the first command to scripts/mysql_install_db.` `     See Section B.4.5, “How to Protect or Change the MySQL Unix Socket File”, and Appendix I, Environment Variables.` There are some alternatives to running the mysql\_install\_db script provided in the MySQL distribution: `   *` `     If you want the initial privileges to be different from the standard defaults, you can modify mysql_install_db before you run it. However, it is preferable to use GRANT and REVOKE to change the privileges after the grant tables have been set up. In other words, you can run mysql_install_db, and then use mysql -u root mysql to connect to the server as the MySQL root user so that you can issue the necessary GRANT and REVOKE statements.` `     If you want to install MySQL on several machines with the same privileges, you can put the GRANT and REVOKE statements in a file and execute the file as a script using mysql after running mysql_install_db. For example:` `     shell> bin/mysql_install_db --user=mysql` `     shell> bin/mysql -u root < your_script_file ` `     By doing this, you can avoid having to issue the statements manually on each machine.` `   *` `     It is possible to re-create the grant tables completely after they have previously been created. You might want to do this if you're just learning how to use GRANT and REVOKE and have made so many modifications after running mysql_install_db that you want to wipe out the tables and start over.` `     To re-create the grant tables, remove all the .frm, .MYI, and .MYD files in the mysql database directory. Then run the mysql_install_db script again.` `   *` `     You can start mysqld manually using the --skip-grant-tables option and add the privilege information yourself using mysql:` `     shell> bin/mysqld_safe --user=mysql --skip-grant-tables &` `     shell> bin/mysql mysql ` `     From mysql, manually execute the SQL commands contained in mysql_install_db. Make sure that you run mysqladmin flush-privileges or mysqladmin reload afterward to tell the server to reload the grant tables.` `     Note that by not using mysql_install_db, you not only have to populate the grant tables manually, you also have to create them first.` 2.3.15.2.2. Starting and Stopping MySQL Automatically Generally, you start the mysqld server in one of these ways: `   *` `     By invoking mysqld directly. This works on any platform.` `   *` `     By running the MySQL server as a Windows service. This can be done on versions of Windows that support services (such as NT, 2000, XP, and 2003). The service can be set to start the server automatically when Windows starts, or as a manual service that you start on request. For instructions, see Section 2.3.8.11, “Starting MySQL as a Windows Service”.` `   *` `     By invoking mysqld_safe, which tries to determine the proper options for mysqld and then runs it with those options. This script is used on Unix and Unix-like systems. See Section 5.4.1, “mysqld_safe — MySQL Server Startup Script”.` `   *` `     By invoking mysql.server. This script is used primarily at system startup and shutdown on systems that use System V-style run directories, where it usually is installed under the name mysql. The mysql.server script starts the server by invoking mysqld_safe. See Section 5.4.2, “mysql.server — MySQL Server Startup Script”.` `   *` `     On Mac OS X, you can install a separate MySQL Startup Item package to enable the automatic startup of MySQL on system startup. The Startup Item starts the server by invoking mysql.server. See Section 2.3.10, “Installing MySQL on Mac OS X”, for details. ` The mysqld\_safe and mysql.server scripts and the Mac OS X Startup Item can be used to start the server manually, or automatically at system startup time. mysql.server and the Startup Item also can be used to stop the server. To start or stop the server manually using the mysql.server script, invoke it with start or stop arguments: shell> mysql.server start shell> mysql.server stop Before mysql.server starts the server, it changes location to the MySQL installation directory, and then invokes mysqld\_safe. If you want the server to run as some specific user, add an appropriate user option to the \[mysqld\] group of the /etc/my.cnf option file, as shown later in this section. (It is possible that you will need to edit mysql.server if you've installed a binary distribution of MySQL in a non-standard location. Modify it to cd into the proper directory before it runs mysqld\_safe. If you do this, your modified version of mysql.server may be overwritten if you upgrade MySQL in the future, so you should make a copy of your edited version that you can reinstall.) mysql.server stop stops the server by sending a signal to it. You can also stop the server manually by executing mysqladmin shutdown. To start and stop MySQL automatically on your server, you need to add start and stop commands to the appropriate places in your /etc/rc\* files. If you use the Linux server RPM package (MySQL-server-VERSION.rpm), the mysql.server script is installed in the /etc/init.d directory with the name mysql. You need not install it manually. See Section 2.3.9, “Installing MySQL on Linux”, for more information on the Linux RPM packages. Some vendors provide RPM packages that install a startup script under a different name such as mysqld. If you install MySQL from a source distribution or using a binary distribution format that does not install mysql.server automatically, you can install it manually. The script can be found in the support-files directory under the MySQL installation directory or in a MySQL source tree. To install mysql.server manually, copy it to the /etc/init.d directory with the name mysql, and then make it executable. Do this by changing location into the appropriate directory where mysql.server is located and executing these commands: shell> cp mysql.server /etc/init.d/mysql shell> chmod +x /etc/init.d/mysql Older Red Hat systems use the /etc/rc.d/init.d directory rather than /etc/init.d. Adjust the preceding commands accordingly. Alternatively, first create /etc/init.d as a symbolic link that points to /etc/rc.d/init.d: shell> cd /etc shell> ln -s rc.d/init.d . After installing the script, the commands needed to activate it to run at system startup depend on your operating system. On Linux, you can use chkconfig: shell> chkconfig --add mysql On some Linux systems, the following command also seems to be necessary to fully enable the mysql script: shell> chkconfig --level 345 mysql on On FreeBSD, startup scripts generally should go in /usr/local/etc/rc.d/. The rc(8) manual page states that scripts in this directory are executed only if their basename matches the \*.sh shell filename pattern. Any other files or directories present within the directory are silently ignored. In other words, on FreeBSD, you should install the mysql.server script as /usr/local/etc/rc.d/mysql.server.sh to enable automatic startup. As an alternative to the preceding setup, some operating systems also use /etc/rc.local or /etc/init.d/boot.local to start additional services on startup. To start up MySQL using this method, you could append a command like the one following to the appropriate startup file: /bin/sh -c 'cd /usr/local/mysql; ./bin/mysqld\_safe --user=mysql &' For other systems, consult your operating system documentation to see how to install startup scripts. You can add options for mysql.server in a global /etc/my.cnf file. A typical /etc/my.cnf file might look like this: \[mysqld\] datadir=/usr/local/mysql/var socket=/var/tmp/mysql.sock port=3306 user=mysql \[mysql.server\] basedir=/usr/local/mysql The mysql.server script understands the following options: basedir, datadir, and pid-file. If specified, they must be placed in an option file, not on the command line. mysql.server understands only start and stop as command-line arguments. The following table shows which option groups the server and each startup script read from option files: Script Option Groups mysqld \[mysqld\], \[server\], \[mysqld-major\_version\] mysqld\_safe \[mysqld\], \[server\], \[mysqld\_safe\] mysql.server \[mysqld\], \[mysql.server\], \[server\] \[mysqld-major\_version\] means that groups with names like \[mysqld-4.1\] and \[mysqld-5.0\] are read by servers having versions 4.1.x, 5.0.x, and so forth. This feature can be used to specify options that can be read only by servers within a given release series. For backward compatibility, mysql.server also reads the \[mysql\_server\] group and mysqld\_safe also reads the \[safe\_mysqld\] group. However, you should update your option files to use the \[mysql.server\] and \[mysqld\_safe\] groups instead when using MySQL 5.0. See Section 4.3.2, “Using Option Files”. 2.3.15.2.3. Starting and Troubleshooting the MySQL Server This section provides troubleshooting suggestions for problems starting the server on Unix. If you are using Windows, see Section 2.3.8.13, “Troubleshooting a MySQL Installation Under Windows”. If you have problems starting the server, here are some things to try: `   *` `     Check the error log to see why the server does not start.` `   *` `     Specify any special options needed by the storage engines you are using.` `   *` `     Make sure that the server knows where to find the data directory.` `   *` `     Make sure that the server can access the data directory. The ownership and permissions of the data directory and its contents must be set such that the server can read and modify them.` `   *` `     Verify that the network interfaces the server wants to use are available. ` Some storage engines have options that control their behavior. You can create a my.cnf file and specify startup options for the engines that you plan to use. If you are going to use storage engines that support transactional tables (InnoDB, BDB, NDB), be sure that you have them configured the way you want before starting the server: `   *` `     If you are using InnoDB tables, see Section 14.2.3, “InnoDB Configuration”.` `   *` `     If you are using BDB (Berkeley DB) tables, see Section 14.5.3, “BDB Startup Options”.` `   *` `     If you are using MySQL Cluster, see Section 15.4, “MySQL Cluster Configuration”. ` Storage engines will use default option values if you specify none, but it is recommended that you review the available options and specify explicit values for those for which the defaults are not appropriate for your installation. When the mysqld server starts, it changes location to the data directory. This is where it expects to find databases and where it expects to write log files. The server also writes the pid (process ID) file in the data directory. The data directory location is hardwired in when the server is compiled. This is where the server looks for the data directory by default. If the data directory is located somewhere else on your system, the server will not work properly. You can determine what the default path settings are by invoking mysqld with the --verbose and --help options. If the default locations don't match the MySQL installation layout on your system, you can override them by specifying options to mysqld or mysqld\_safe on the command line or in an option file. To specify the location of the data directory explicitly, use the --datadir option. However, normally you can tell mysqld the location of the base directory under which MySQL is installed and it looks for the data directory there. You can do this with the --basedir option. To check the effect of specifying path options, invoke mysqld with those options followed by the --verbose and --help options. For example, if you change location into the directory where mysqld is installed and then run the following command, it shows the effect of starting the server with a base directory of /usr/local: shell> ./mysqld --basedir=/usr/local --verbose --help You can specify other options such as --datadir as well, but --verbose and --help must be the last options. Once you determine the path settings you want, start the server without --verbose and --help. If mysqld is currently running, you can find out what path settings it is using by executing this command: shell> mysqladmin variables Or: shell> mysqladmin -h host\_name variables host\_name is the name of the MySQL server host. If you get Errcode 13 (which means Permission denied) when starting mysqld, this means that the privileges of the data directory or its contents do not allow the server access. In this case, you change the permissions for the involved files and directories so that the server has the right to use them. You can also start the server as root, but this raises security issues and should be avoided. On Unix, change location into the data directory and check the ownership of the data directory and its contents to make sure the server has access. For example, if the data directory is /usr/local/mysql/var, use this command: shell> ls -la /usr/local/mysql/var If the data directory or its files or subdirectories are not owned by the login account that you use for running the server, change their ownership to that account. If the account is named mysql, use these commands: shell> chown -R mysql /usr/local/mysql/var shell> chgrp -R mysql /usr/local/mysql/var If the server fails to start up correctly, check the error log. Log files are located in the data directory (typically C:\\Program Files\\MySQL\\MySQL Server 5.0\\data on Windows, /usr/local/mysql/data for a Unix binary distribution, and /usr/local/var for a Unix source distribution). Look in the data directory for files with names of the form host\_name.err and host\_name.log, where host\_name is the name of your server host. Then examine the last few lines of these files. On Unix, you can use tail to display them: shell> tail host\_name.err shell> tail host\_name.log The error log should contain information that indicates why the server couldn't start. For example, you might see something like this in the log: 000729 14:50:10 bdb: Recovery function for LSN 1 27595 failed 000729 14:50:10 bdb: warning: ./test/t1.db: No such file or directory 000729 14:50:10 Can't init databases This means that you did not start mysqld with the --bdb-no-recover option and Berkeley DB found something wrong with its own log files when it tried to recover your databases. To be able to continue, you should move the old Berkeley DB log files from the database directory to some other place, where you can later examine them. The BDB log files are named in sequence beginning with log.0000000001, where the number increases over time. If you are running mysqld with BDB table support and mysqld dumps core at startup, this could be due to problems with the BDB recovery log. In this case, you can try starting mysqld with --bdb-no-recover. If that helps, you should remove all BDB log files from the data directory and try starting mysqld again without the --bdb-no-recover option. If either of the following errors occur, it means that some other program (perhaps another mysqld server) is using the TCP/IP port or Unix socket file that mysqld is trying to use: Can't start server: Bind on TCP/IP port: Address already in use Can't start server: Bind on unix socket... Use ps to determine whether you have another mysqld server running. If so, shut down the server before starting mysqld again. (If another server is running, and you really want to run multiple servers, you can find information about how to do so in Section 5.13, “Running Multiple MySQL Servers on the Same Machine”.) If no other server is running, try to execute the command telnet your\_host\_name tcp\_ip\_port\_number. (The default MySQL port number is 3306.) Then press Enter a couple of times. If you don't get an error message like telnet: Unable to connect to remote host: Connection refused, some other program is using the TCP/IP port that mysqld is trying to use. You'll need to track down what program this is and disable it, or else tell mysqld to listen to a different port with the --port option. In this case, you'll also need to specify the port number for client programs when connecting to the server via TCP/IP. Another reason the port might be inaccessible is that you have a firewall running that blocks connections to it. If so, modify the firewall settings to allow access to the port. If the server starts but you can't connect to it, you should make sure that you have an entry in /etc/hosts that looks like this: 127.0.0.1 localhost This problem occurs only on systems that do not have a working thread library and for which MySQL must be configured to use MIT-pthreads. If you cannot get mysqld to start, you can try to make a trace file to find the problem by using the --debug option. See Section H.1.2, “Creating Trace Files”. Previous / Next / Up / Table of Contents User Comments Posted by \[name withheld\] on June 8 2004 9:49pm \[Delete\] \[Edit\] You must run mysqld\_install\_db as the user that mysqld will run under, for example: shell> su mysql -c mysql\_install\_db Otherwise, the daemon will not be able to look in the mysql directory, and will not be able to find the file 'host.frm' inside it. Posted by A. Johan on July 16 2004 2:38pm \[Delete\] \[Edit\] if you didn't run the mysql\_install\_db as the mysql user and you are unable to start the mysql daemon with an error such as "Can't find file ... host.frm", all you need to check is see if the dir and files belong to the user mysql. /var/lib/mysql/mysql and files in it should belong to the user mysql. just do chown and you should be ok. cheers. aj Posted by Sheldon Plankton on August 25 2004 4:29pm \[Delete\] \[Edit\] I am confused Step 6 says ... 6\. Verify that you can restart the server. Do this by using mysqld\_safe or by invoking mysqld directly. For example: shell> bin/mysqld\_safe --user=mysql --log & If mysqld\_safe fails, see section 2.4.2.3 Starting and Troubleshooting the MySQL Server. ... is it mysqld\_safe or safe\_mysqld ??? Posted by José Manuel Ciges Regueiro on December 3 2004 10:04am \[Delete\] \[Edit\] In opposition at what is said in the docs the minimun version of the Perl module MySQL::DBD for MySQL 4.1 is the 2.9004. The compilation of MySQL::DBD version 2.9003 gives the following error: mysql.xs: In function `XS\_DBD\_\_mysql\_\_dr\_\_admin\_internal': mysql.xs:100: too few arguments to function `mysql\_shutdown' This is because from MySQL version 4.1.3 the function mysql\_shutdown has an extra parameter. As I told before the problem is solved in the version 2.9004. Posted by \[name withheld\] on January 26 2005 8:57pm \[Delete\] \[Edit\] Thanks to \[name withheld\] for the advice on running the mysql\_install\_db script as the mysql user! This appears to be **crucial**, but I didn't find that tip anywhere but in her/his comment. Posted by \[name withheld\] on February 6 2005 3:20pm \[Delete\] \[Edit\] Have your server up and running but can't get a connection to it over your network? Try commenting out the poorly documented "bind-address = 127.0.0.1" in my.cnf. While you're there, make sure that "skip-networking" is commented out. Posted by Todd Trimble on February 11 2005 3:54pm \[Delete\] \[Edit\] It's worth noting that the package install for OpenBSD creates the "\_mysql" user account. One little underscore that can really confuse readers... Posted by Coyote Osborne on April 6 2005 9:02pm \[Delete\] \[Edit\] I just spent what would have been a hair-pulling two hours (if I had hair) trying to install mySQL on a mac running osx 10.3.8 I downloaded the nice "easy" installer package from this site, and ran both that installer and the startup item installer. The install seemed to go fine, however, the mysql\_install\_db would not set up the access tables no matter what I did. My solution was to activate the root account via netinfo manager, and do a complete reinstall as root, and then manually run mysql\_install\_db via su as root. Everything worked flawlessly after that. I then deactivated the root account (for the system, not mySQL). I try not to leave a root account active on these systems. I'm only mentioning this simply because I couldn't find any tips that worked for me, and this seemed to solve the problem. Posted by Andy Canfield on May 2 2005 6:05am \[Delete\] \[Edit\] I had a problem with step 1: 'cd BASEDIR'. My MySQL was installed with the Linux system, so where is BASEDIR? I studied the script "mysql\_install\_db" and figured this out: Use 'locate' or 'find' for the file "my\_print\_defaults". That should be BASEDIR/bin/print\_my\_defaults or BASEDIR/extra/print\_my\_defaults. In my case BASEDIR was "/usr". Posted by Matthew Bennett on May 14 2005 12:10pm \[Delete\] \[Edit\] Under Unix/Linux, if you have already run mysql\_install\_db as root, you may find that running it as the mysql user still doesn't fix the problem - mainly because, as mentioned above, the mysql\_install\_db utility won't write over databases that are already there (and probably wouldn't be able to even if it tried) The solution then is to go to wherever your databases are stored (mine are in /var/lib/mysql) and, as root, type: chown -R mysqluser mysql where "mysqluser" is the name of whatever user uses the database (most systems have a "mysql" user specifically set up for this purpose) and "mysql" refers to the directory (in my case, /var/lib/mysql/mysql) Note: I'm no security expert, I'm only using mysql on a small test system... this may be unsafe to do in a deployment system. If someone could advise, please do...) Posted by Kees Hink on June 22 2005 11:47am \[Delete\] \[Edit\] On OpenBSD, after running bin/mysqld\_safe --user=\_mysql & mysql used to stop immediately. Logfiles showed the message 050622 13:29:53 mysqld started 050622 13:29:53 Can't start server : Bind on unix socket: Permission denied 050622 13:29:53 Do you already have another mysqld server running on socket: /var/run/mysql/mysql.sock ? Turns out root was owner of /var/run/mysql, so i turned ownership over to \_mysql: chown \_mysql /var/run/mysql/ Posted by Keisy bui on October 17 2005 12:30am \[Delete\] \[Edit\] Restart MySQL I installed MySQL-server-4.1.14-0.glibc23.i386.rpm on Linux. After running rpm -i MySQL-server-4.1.....rpm the server started straight away. Then i realised that mysql is installed in /usr and /usr was my BASEDIR. Then under /usr, i set up the password for the root: /bin/mysqladmin -u root password 'somepass' Then i tried to view all databases using bin/mysqlshow i got the access denied message, then i tried: bin/mysqlshow -u root -p the system then asked me for the password, then 2 databases mysql and test showed up :) After that, i decided to stop and restart MySQL bin/mysqladmin -u root shutdown -p (and typed in the password) bin/safe\_mysqld -user root -p somepass but i could not restart it, i dont know if the command was incorrect. then i did a series of chown: cd /var/lib/mysql chown -R root mysql chown -R myusername mysql chown -R mysql mysql I then restarted MySQL using: cd /usr bin/safe)mysqld --user=root & and the server started. Note: so far i run everything as 'root' user of the OS. Posted by Fausto Rodriguez Zapata on November 18 2005 1:26pm \[Delete\] \[Edit\] After installing the mysql-debug-5.0.15-osx10.4-powerpc.pkg package and running the mysql server through installed preference pane I got the following error when I tried to set the anonymous passwords: shell> mysql -u root Access denied for user 'root'@'localhost' (using password: NO) So I first followed the directions in A.4.1. How to Reset the Root Password to reset the root password and then I modified the anonymous and root passwords as in this section. Posted by Cameron Spitzer on April 16 2006 10:49pm \[Delete\] \[Edit\] Watch out when you run perl run-all-tests. I got a 270 MB log file. You might want to turn query logging off. Posted by Shane Crawford on May 9 2006 2:45am \[Delete\] \[Edit\] OS X: 10.4.6 Installed via Darwin Ports ('port install mysql5') $sudo /opt/local/lib/mysql5/bin/mysql\_install\_db --user=mysql $cd /opt/local/var/db $ ls -l drwx------ 9 mysql admin 306 May 8 21:19 mysql5 $cd /opt/local/share/mysql5/mysql $sudo ./mysql.server start $mysqladmin ping mysqld is alive Posted by \[name withheld\] on August 15 2006 9:04pm \[Delete\] \[Edit\] Using RedHat Enterprise Linux 4: You need to disable selinux to start the service. So do the following: 1\. /usr/sbin/setenforce 0 2. /etc/init.d/mysql start 3. /usr/sbin/setenforce 1 # XBMC - [connect MythTV and XBMC](https://www.reeltoreel.nl/knowledgebase/books/archief/page/connect-mythtv-and-xbmc) - [configuring the Zotac HD-ID11](https://www.reeltoreel.nl/knowledgebase/books/archief/page/configuring-the-zotac-hd-id11) # OpenSUSE 11.1: enable the KDE4.2 repos When you're running openSUSE 11.1, and you want to use the KDE 4.2, just add these repo's and do a full update: `zypper ar --refresh `[`http://download.opensuse.org/repositories/KDE:/42/openSUSE_11.1/`](http://download.opensuse.org/repositories/KDE:/42/openSUSE_11.1/)` kde42` `zypper ar --refresh `[`http://download.opensuse.org/repositories/KDE:/KDE4:/Community/openSUSE_11.1_KDE_42/`](http://download.opensuse.org/repositories/KDE:/KDE4:/Community/openSUSE_11.1_KDE_42/)` kde42-community` `zypper ar --refresh `[`http://download.opensuse.org/repositories/KDE:/KDE4:/Playground/openSUSE_11.1_KDE_42/`](http://download.opensuse.org/repositories/KDE:/KDE4:/Playground/openSUSE_11.1_KDE_42/)` kde42-playground` After that you can do a full refresh and update all: `zypper ref -f && zypper up -t package` Sometimes a distro upgrade is needed (only in rare cases) `zypper dup` # Overview of repos At this moment the collection of repos is as follows. Remember that this may change over time. `#  | Alias                                  | Name                                   | Enabled | Refresh | Priority | Type   | URI                                                                                       | Service` `---+----------------------------------------+----------------------------------------+---------+---------+----------+--------+-------------------------------------------------------------------------------------------+--------` `1  | Libdvdcss repository                   | Libdvdcss repository                   | Yes     | No      |   99     | rpm-md | `[`http://suse.linuxin.dk/repo/11.1/`](http://suse.linuxin.dk/repo/11.1/)`                                                         |` `2  | Packman Repository                     | Packman Repository                     | Yes     | Yes     |   99     | rpm-md | `[`http://ftp.skynet.be/pub/packman/suse/11.1/`](http://ftp.skynet.be/pub/packman/suse/11.1/)`                                               |` `3  | Wine                                   | Wine                                   | Yes     | Yes     |   99     | rpm-md | `[`http://download.opensuse.org/repositories/Emulators:/Wine/openSUSE_11.1/`](http://download.opensuse.org/repositories/Emulators:/Wine/openSUSE_11.1/)`                  |` `4  | openSUSE_BuildService_-_OpenOffice.org | openSUSE BuildService - OpenOffice.org | Yes     | Yes     |   99     | rpm-md | `[`http://download.opensuse.org/repositories/OpenOffice.org%3a/UNSTABLE/openSUSE_11.1/`](http://download.opensuse.org/repositories/OpenOffice.org%3a/UNSTABLE/openSUSE_11.1/)`       |` `5  | pvdm-games                             | pvdm-games                             | Yes     | Yes     |   99     | rpm-md | `[`http://download.opensuse.org/repositories/games/openSUSE_11.1/`](http://download.opensuse.org/repositories/games/openSUSE_11.1/)`                            |` `6  | pvdm-kde4.2                            | pvdm-kde4.2                            | Yes     | Yes     |   99     | rpm-md | `[`http://download.opensuse.org/repositories/KDE:/42/openSUSE_11.1/`](http://download.opensuse.org/repositories/KDE:/42/openSUSE_11.1/)`                          |` `7  | pvdm-kde42-community                   | pvdm-kde42-community                   | Yes     | Yes     |   99     | rpm-md | `[`http://download.opensuse.org/repositories/KDE%3a/KDE4%3a/Community/openSUSE_11.1_KDE_42/`](http://download.opensuse.org/repositories/KDE%3a/KDE4%3a/Community/openSUSE_11.1_KDE_42/)`  |` `8  | pvdm-kde42-playground                  | pvdm-kde42-playground                  | Yes     | Yes     |   99     | rpm-md | `[`http://download.opensuse.org/repositories/KDE%3a/KDE4%3a/Playground/openSUSE_11.1_KDE_42/`](http://download.opensuse.org/repositories/KDE%3a/KDE4%3a/Playground/openSUSE_11.1_KDE_42/)` |` `9  | pvdm-localopensuse11.1                 | pvdm-localopensuse11.1                 | Yes     | No      |   99     | yast2  | `[`http://pvdm.xs4all.nl/opensuse11.1_32/`](http://pvdm.xs4all.nl/opensuse11.1_32/)`                                                    |` `10 | pvdm-localupdate_1                     | pvdm-localupdate                       | YES     | Yes     |   99     | rpm-md | `[`http://pvdm.xs4all.nl/update/11.1`](http://pvdm.xs4all.nl/update/11.1)`                                                         |` `11 | pvdm-openftd                           | pvdm-openftd                           | Yes     | Yes     |   99     | rpm-md | `[`http://www.openftd.org/releases/openSUSE_11.1`](http://www.openftd.org/releases/openSUSE_11.1)`                                             |` `12 | pvdm-qt44                              | pvdm-qt44                              | Yes     | Yes     |   99     | rpm-md | `[`http://download.opensuse.org/repositories/KDE:/Qt44/openSUSE_11.1/`](http://download.opensuse.org/repositories/KDE:/Qt44/openSUSE_11.1/)`                        |` `13 | repo-non-oss                           | openSUSE-11.1-Non-Oss                  | Yes     | No      |  100     | yast2  | `[`http://download.opensuse.org/distribution/11.1/repo/non-oss/`](http://download.opensuse.org/distribution/11.1/repo/non-oss/)`                              |` `14 | vlc                                    | vlc                                    | Yes     | Yes     |   99     | rpm-md | `[`http://download.videolan.org/pub/vlc/SuSE/11.1`](http://download.videolan.org/pub/vlc/SuSE/11.1)`                                            |` # Codecs issues 11.1 SUSEhelp: vlc-conflicts is (should be solved nowadays) Do \*not\* use the Videolan repo in conjunction with the Packman repo, as this will break your ability to play video. To fix your video problem, disable the Videolan repo and replace any Videolan packages with those from the Packman repo. The only "safe" Videolan package is libdvdcss. List: `rpm -qa --qf '%{VENDOR} %{NAME}-%{VERSION}-%{RELEASE}\n'|grep videolan` # Upgrade openSUSE 10.3 to 11.1 while the system is running using zypper dup How to upgrade openSUSE 10.3 to openSUSE 11.1 while the system is running. This document describes the steps necessary to update a running computer with openSUSE 10.3 to openSUSE11.1. You need a working internet connection for this procedure. So how does it work? The new openSUSE 11.x has the 'zypper dup' (distribution upgrade) option. The version of zypper in openSUSE 10.3 does not have the 'zypper dup' option. We can use this option however, if we first upgrade zypper to the version that does support 'dup'.This method differs from the recommended way of upgrading, which is to boot the PC from the DVD and choose the 'upgrade' option. Then why is this document written? There are reasons to choose this upgrade method. Possibly the DVD just isn't available. Or, you want to keep your system intact as much as possible, instead of using the official update process with the DVD and all of it's update scripts that might mess up things....... There are some issues when using this procedure. Take note. There have been some structural changes in package management (zypper, libzypp, rpm, etc.) between versions 10.x and 11.x. Therefore it is not possible to install 11.x rpm's in 10.3 directly. They simply won't unzip, for instance. So it is necessary to upgrade the entire package management system to the version used in openSUSE 11.x first, and when that is done, we can do the rest of the system. However I ran into some (too much dependency) problems going straight to version 11.1, so I upgraded the management stack to 11.0 first, and from there on I went to 11.1. This worked ok. Here are the steps that worked for me. I can not guarantee that it will work for you. The starting point is a system running openSUSE 10.3, fully up-2-date with the latest patches, so first run 'on-line update' or 'zypper up -t package'. I have included instruction for 32 and 64 bit systems. I tested both. **1. Back up your data.** This is always good advice. Use an external hard disk, an USB stick, or copy the data over the network to another computer or burn it onto a CD/DVD. **2. If you want to be absolutely sure, have the DVD at hand.** This is just in case. If the update fails at a certain point for whatever reason the package management stack might be in a state that you can neither continue nor go back. Then the way to go is: boot from it and choose the upgrade option. This is a good fall-back. **3. Disable the old repositories:** `#mv /etc/zypp/repos.d/ /etc/zypp/repos.d.old` **4. Delete the repository cache:** `#rm /var/cache/zypp/zypp.db` **5. Download the RPM from version 11.0:** 32 bit: `#rpm -Uhv '`[`http://download.opensuse.org/distribution/11.0/repo/oss/suse/i586/rpm-4.4.2-199.1.i586.rpm`](http://download.opensuse.org/distribution/11.0/repo/oss/suse/i586/rpm-4.4.2-199.1.i586.rpm)`' ` 64 bit: `#rpm -Uhv '`[`http://download.opensuse.org/distribution/11.0/repo/oss/suse/x86_64/rpm-4.4.2-199.1.x86_64.rpm`](http://download.opensuse.org/distribution/11.0/repo/oss/suse/x86_64/rpm-4.4.2-199.1.x86_64.rpm)`'` **6. Add the main openSUSE 11.0 repository:** `#zypper ar `[`http://download.opensuse.org/distribution/11.0/repo/oss`](http://download.opensuse.org/distribution/11.0/repo/oss)` openSUSE11.0` **7. install the new zypper:** `#zypper in zypper` (This was a 50+MB download). **8. Change the repository from 11.0 to 11.1:** `#vi /etc/zypp/repos.d/openSUSE11.0.repo` `and change all occurrences of 11.0 into 11.1` **9. Refresh the cache:** `#zypper ref -f` **10. Install the zypper from 11.1:** `#zypper in zypper` (This was a several MB's download). **11. At his point zypper won't work. We need to manually download some supporting files:** 32 bit: `#wget `[`http://download.opensuse.org/distribution/11.1/repo/oss/suse/i586/libcurl4-7.19.0-11.1.i586.rpm`](http://download.opensuse.org/distribution/11.1/repo/oss/suse/i586/libcurl4-7.19.0-11.1.i586.rpm) `#wget `[`http://download.opensuse.org/distribution/11.1/repo/oss/suse/i586/libldap-2_4-2-2.4.12-5.3.i586.rpm`](http://download.opensuse.org/distribution/11.1/repo/oss/suse/i586/libldap-2_4-2-2.4.12-5.3.i586.rpm) 64 bit: `#wget `[`http://download.opensuse.org/distribution/11.1/repo/oss/suse/x86_64/libcurl4-7.19.0-11.1.x86_64.rpm`](http://download.opensuse.org/distribution/11.1/repo/oss/suse/x86_64/libcurl4-7.19.0-11.1.x86_64.rpm) `#wget `[`http://download.opensuse.org/distribution/11.1/repo/oss/suse/x86_64/libldap-2_4-2-2.4.12-5.3.x86_64.rpm`](http://download.opensuse.org/distribution/11.1/repo/oss/suse/x86_64/libldap-2_4-2-2.4.12-5.3.x86_64.rpm) and install these files: `#rpm -Uvh ......` **12. At this point zypper should work again. So, if you had Packman and/or 'non-oss' as a repository, add them here:** `#zypper ar `[`http://download.opensuse.org/distribution/11.1/repo/non-oss`](http://download.opensuse.org/distribution/11.1/repo/non-oss)` non-oss` `#zypper ar `[`http://packman.iu-bremen.de/suse/11.1/`](http://packman.iu-bremen.de/suse/11.1/)` packman` **13. When you have arrived here, you can start the actual upgrade: (and get ready for a 1GB+ download)** `#zypper ref -f` `#zypper dup` **14. reboot!** Congratulations! You now have a working openSUSE 11.1 system! If there was an error somewhere in the procedure, and you cannot resolve it, you can always revert to the fall-back routine described earlier using the boot-from-DVD option. There are some additional steps to do. First, **15. Configure an update repository:** `#zypper ar `[`http://download.opensuse.org/update/11.1/`](http://download.opensuse.org/update/11.1/)` updates` Now run: `# zypper up -t package` **16. You probably want to install the new KDE4 desktop environment:** goto Yast → Software → Software Management → filter box: select 'Patterns' → check KDE4 Base System and KDE4 Desktop Environment → accept. **17. Add other repositories that are of interest to you:** From Yast you can choose: Software Repositories → Add → Community Repositories → next. That's it. I hope I have helped you upgrading your system to the latest and greatest openSUSE! # Backup MediaWiki ## Database dump For downloadable dumps of Wikipedia's article database, see [Wikipedia:Database download](w:Wikipedia:Database_download "wikilink"). For a description of the database format and fields, see [database layout](mw:Manual:Database_layout "wikilink"). To create your own dump of a local MediaWiki site, you can use the *dumpBackup.php* script found in the maintenance directory of your MediaWiki installation tree. Make sure that AdminSettings.php has been configured. By default, MediaWiki ships with an AdminSettings.sample file that needs to be edited to suit your configuration and renamed to AdminSettings.php An example invocation to a full backup might look like: ` php maintenance/dumpBackup.php --full > full.xml` Command line options for dumpBackup.php are explained by running it with no parameters, i.e. ` php maintenance/dumpBackup.php` However, there are some extra undocumented options in its source code. # OpenSUSE 11.2 MP3 playback in Amarok How to get MP3 support in Amarok: `#zypper in libxine1-codecs` # ATI graphic chipset overview From Phoronix forum: The proprietary drivers are developed internally and released as a single package. Open source drivers, on the other hand, are developed in public repositories with one repository (and driver) for each of the four main components. You need an appropriate version of each component to get a working driver stack. Normally your distros will take care of packaging an appropriate set of open source driver components:: 1\. X driver - xorg/driver/xf86-video-ati aka "radeon" 2\. kernel driver aka drm - in the Linux kernel tree 3\. kernel usermode library aka libdrm - mesa/drm 4\. 3D driver - mesa/mesa Your card belongs to the evergreen family, which people like to call r800 even though we don't call it r800 ourselves For the X and kernel drivers a single driver covers all radeon products from rv100 to Evergreen. The 3D driver has 4 different versions depending on the GPU generation - radeon (r100 family), r200 (r200 family), r300 (r300-r500 families) and r600 (r600-evergreen families). There are also "classic" and "gallium" implementations of the 3D drivers but I suggest you ignore that distinction for now. What should you do ? Basically there are two options : \- experiment with some settings to get rid of the black boxes on Firefox etc.. (look for "force XAA") \- uninstall the fglrx driver and start building the right versions of open source drivers for your hardware (normally they would ship in the distro but evergreen support in the open source drivers is fairly recent). There are "xorg-edgers" packages available for Ubuntu/Debian distros which give you the very latest open source driver components in an easy-to-use form but I don't know if there is an equivalent offered for SuSE. I would start by forcing XAA with the fglrx driver and see how that works for you. # old The radeonhd driver supports video cards based on the following ATI chips: 1. RV505: Radeon X1550, X1550 64bit 2. RV515: Radeon X1300, X1550, X1600; FireGL V3300, V3350 3. RV516: Radeon X1300, X1550, X1550 64-bit, X1600; FireMV 2250 4. R520: Radeon X1800; FireGL V5300, V7200, V7300, V7350 5. RV530: Radeon X1300 XT, X1600, X1600 Pro, X1650; FireGL V3400, V5200 6. RV535: Radeon X1300, X1650 7. RV550: Radeon X2300 HD 8. RV560: Radeon X1650 9. RV570: Radeon X1950, X1950 GT; FireGL V7400 10. R580: Radeon X1900, X1950; AMD Stream Processor 11. R600: Radeon HD 2900 GT/Pro/XT; FireGL V7600/V8600/V8650 12. RV610: Radeon HD 2350, HD 2400 Pro/XT, HD 2400 Pro AGP; FireGL V4000 13. RV620: Radeon HD 3450, HD 3470 14. RV630: Radeon HD 2600 LE/Pro/XT, HD 2600 Pro/XT AGP; Gemini RV630; FireGL V3600/V5600 15. **RV635: Radeon HD 3650, HD 3670** 16. RV670: Radeon HD 3850, HD 3870, FireGL V7700 17. RV680: Radeon HD 3870 X2 18. M52: Mobility Radeon X1300 19. M54: Mobility Radeon X1400; M54-GL 20. M56: Mobility Radeon X1600; Mobility FireGL V5200 21. M58: Mobility Radeon X1800, X1800 XT; Mobility FireGL V7100, V7200 22. M62: Mobility Radeon X1350 23. M64: Mobility Radeon X1450, X2300 24. M66: Mobility Radeon X1700, X1700 XT; FireGL V5250 25. M68: Mobility Radeon X1900 26. M71: Mobility Radeon HD 2300 27. M72: Mobility Radeon HD 2400; Radeon E2400 28. M74: Mobility Radeon HD 2400 XT 29. M76: Mobility Radeon HD 2600; (Gemini ATI) Mobility Radeon HD 2600 XT 30. M82: Mobility Radeon HD 3400 31. M86: Mobility Radeon HD 3600 32. RS690: Radeon X1200, X1250, X1270. # How to check the MythTV database You can check the MythTV database for errors with the following command: `# mysqlcheck --check -u mythtv -p mythconverg` Remember, this is just a check, no fix. # KDE openSUSE repositories explained READ THIS SUMMARY If all you want is a workable version of KDE, stick with what came with the distro when you installed it. Everything else can break your system at any time with no warning because it \*will\* always be changing. If you want the latest released version of just the applications (e.g. amarok, digikam) use just **KDE:Backports.** If you want the latest released version (including betas and RCs) of the KDE **Desktop \_and\_ application**s use **KDE:KDE4:Factory:Desktop**. If KDE makes a release when KDE:KDE4:Factory:Desktop is busy, the KDE team may choose to create an additional repository (e.g. KDE:42, KDE:43) in order to package that latest release. Once KDE:KDE4:Factory:Desktop is free again, these additional temporary repositories \*will disappear\*. If you decide you absolutely must have the latest version and switch to the version specific repos, be aware that they will disappear again in a few months. That means if you absolutely must have the latest KDE at all times you WILL have to change your repositories occasionally, there is no way around that. Development for the next release, not current users takes priority in these repositories. To keep up with upstream you have to switch from KKFD to KDE:{version} and back to KKFD every few months. \* If you want to keep it simple just stick with KKFD until it starts moving again. That is all you should need to know. Normally the only available versions of the KDE desktop you can expect to be available will be 1) The version that was in the last released distro in STABLE 2) The latest released version in FACTORY 3) The bleeding edge in UNSTABLE Any other repository is temporary and there is no guarantee it will still be there tomorrow, if you use one of them it is your job to keep alert of any changes to it. Just stick to the above and you’ll be fine. If you choose to use the temporary repositories because you \*must\* have the latest version please don’t complain about the repository layout, the alternative is not to provide the extra repositories at all. END OF SUMMARY If you must know the details: The layout for the KDE \*desktop\* package repositories is: STABLE (what was released in current openSUSE) what you’ve already got in 11.2 plus some extra fixes which are being currently tested e.g. for online update FACTORY (going into next version of openSUSE) what is going into the next version of openSUSE and will most likely be the latest released version from KDE (except very close to a openSUSE distro release). UNSTABLE (absolutely bleeding edge straight from KDE trunk, doesn’t even build half the time) not for normal users As you can see, there is not much reason to use STABLE (you’ve already got it if you are running 11.2) or UNSTABLE (it will eat your children). As I said above, if KDE has a release when a) openSUSE Factory is in version freeze in preparation for a distro release b) KKFD has already moved on to the next major beta release (e.g. it is now on KDE4.4 beta/rc) the KDE team may create a temporary version specific repository (e.g. KDE:42, KDE:43). The reason we have these is because people wanted for packages of the latest released KDE, not because the KDE team is masochistic or sadistic. Now that FACTORY is moving again (release of 11.2) (and also KDE has said that there will not be another 4.3.x release) \*these repositories will disappear\*. Their purpose was to provide the latest released version while FACTORY was busy, that reason is gone, there is no more reason to keep them hanging around. Meanwhile, applications which are released separately (amarok, digikam) have their own repositories because they are not related to the KDE desktop\*. 1\) KDE:Backports contains the newest released versions of these apps built against the base distribution. No KDE upgrade needed to run these. 2) KDE:KDE4:Community contains applications/utilities e.g. from kde-look.org that people outside the SuSE KDE team package. 3) KDE:KDE4:Playground contains experimental/bleeding edge/unstable versions of the apps in Community and Backports. Regards, Tejas FWIW, all of this information could have been gotten by a thorough reading of the wiki pages. P.S. I suggest that at some point the KDE4: prefix needs to be dropped from the repository names like it has been from Backports. # How to check the channel list Issue the following command: `# mysql -u mythtv -p mythconverg -e 'SELECT chanid, channum, callsign, name, sourceid, freqid, xmltvid FROM `channel` ';` You get: ``` +--------+---------+----------+---------------------+----------+--------+---------+ | chanid | channum | callsign | name | sourceid | freqid | xmltvid | +--------+---------+----------+---------------------+----------+--------+---------+ | 1131 | | PRISP | Private Spice | 1 | | 105 | | 1153 | | TVDRE | TV DRENTHE | 1 | | 110 | | 1130 | | AT5 | AT 5 | 1 | | 40 | | 1111 | 56 | BBC2 | BBC2 | 1 | 751250 | 8 | | 1 | 22 | NED1 | Nederland 1 | 1 | 479250 | 1 | | 1065 | 25 | NED2 | Nederland 2 | 1 | 503250 | 2 | | 1068 | 28 | RTL4 | RTL4 | 1 | 527250 | 4 | | 1110 | 46 | DISC | Discovery | 1 | 671250 | 29 | | 1109 | 43 | KETCAN | Ketnet/Canvas | 1 | 647250 | 6 | | 1076 | 36 | RTL5 | RTL5 | 1 | 591250 | 31 | | 1078 | 38 | RTL7 | RTL7 | 1 | 607250 | 46 | | 1079 | 39 | Veronica | Veronica | 1 | 615250 | 34 | | 1081 | 41 | Tien | Tien | 1 | 631250 | 92 | | 1082 | 42 | Een | Een | 1 | 639250 | 5 | | 1084 | 44 | TVNH | TVNH | 1 | 655250 | 103 | | 1108 | 40 | NET5 | NET5 | 1 | 623250 | 37 | | 1087 | 47 | NatGeo | National Geographic | 1 | 679250 | 18 | | 1088 | 48 | ANIMAL | Animal Planet | 1 | 687250 | 65 | | 1090 | 50 | MTV | MTV | 1 | 703250 | 25 | | 1093 | 53 | TMF | TMF | 1 | 727250 | 35 | | 1094 | 54 | EUROS | Eurosport | 1 | 735250 | 19 | | 1095 | 55 | BBC1 | BBC1 | 1 | 743250 | 7 | | 1098 | 58 | TV5 | TV5 | 1 | 767250 | 17 | | 1107 | 37 | SBS6 | SBS6 | 1 | 599250 | 36 | | 1102 | 62 | ARD | ARD | 1 | 799250 | 9 | | 1103 | 63 | ZDF | ZDF | 1 | 807250 | 10 | | 1105 | 65 | WDR | WDR | 1 | 823250 | 12 | | 1106 | 26 | NED3 | Nederland 3 | 1 | 511250 | 3 | | 1149 | | OMRFR | OMROP FRYSLAN | 1 | | 109 | | 1112 | | OMRZE | OMROEP ZEELAND | 1 | | 116 | | 1113 | | TVGEL | TV GELDERLAND | 1 | | 112 | | 1114 | | 3SAT | 3Sat | 1 | | 50 | | 1115 | | VT4 | VT4 | 1 | | 60 | | 1116 | | TVRIJ | TV RIJNMOND | 1 | | 102 | | 1117 | | NICKE | Nickelodeon | 1 | | 89 | | 1118 | | TVOOS | TV OOST | 1 | | 111 | | 1119 | | TVFLE | TV FLEVOLAND | 1 | | 113 | | 1120 | | BVN | BVN | 1 | | 90 | | 1121 | 68 | BBCWO | BBC World | 1 | 847250 | 86 | | 1122 | | TVE | TV E | 1 | | 87 | | 1123 | | FILM1 | Film1.1 | 1 | | 24 | | 1124 | | CNN | CNN | 1 | | 26 | | 1125 | | RAIUN | Rai Uno | 1 | | 27 | | 1126 | | TCM | TCM | 1 | | 20 | | 1127 | | CARNE | Cartoon Network | 1 | | 21 | | 1128 | | VTM | VTM | 1 | | 49 | | 1129 | | SAT1 | Sat 1 | 1 | | 28 | | 1132 | | L1TV | L1 TV | 1 | | 115 | | 1133 | | FILM1 | Film1.2 | 1 | | 39 | | 1134 | | SPORT | Sport1.1 | 1 | | 99 | | 1135 | | TVNOO | TV NOORD | 1 | | 108 | | 1136 | | ARTE | ARTE | 1 | | 38 | | 1137 | | MEZZO | Mezzo | 1 | | 73 | | 1138 | | THEBO | The Box | 1 | | 91 | | 1139 | | KANA2 | Kanaal 2 | 1 | | 59 | | 1140 | | REGTV | REGIO TV UTRECHT | 1 | | 100 | | 1141 | | FILM1 | Film1.3 | 1 | | 107 | | 1142 | | BBCPR | BBC Prime | 1 | | 104 | | 1143 | | PRO7 | PRO 7 | 1 | | 58 | | 1144 | | RTL | RTL | 1 | | 11 | | 1145 | | NDRFE | NDR Fernsehen | 1 | | 13 | | 1146 | | RTBLA | RTBF La 1 | 1 | | 15 | | 1147 | | SUDFE | Sudwest Fernsehen | 1 | | 14 | | 1148 | | RTBLA | RTBF La 2 | 1 | | 16 | | 1150 | | TVWES | TV WEST | 1 | | 101 | | 1151 | | TRTIN | TRT int. | 1 | | 32 | | 1152 | | OMRBR | OMROEP BRABANT TV | 1 | | 114 | +--------+---------+----------+---------------------+----------+--------+---------+ ``` # KDE4.4 issues openSUSE 11.2 # error: nepomukservice not registered at DBus change the file .kde4/share/config/nepomukserverrc to: ``` [Basic Settings] Configured repositories=main Start Nepomuk=true [Service-nepomukmigration1] autostart=false [Service-nepomukstrigiservice] autostart=true [main Settings] Maximum memory=200 Storage Dir[$e]=$HOME/.kde4/share/apps/nepomuk/repository/main/ //Used Soprano Backend=redland Used Soprano Backend='''virtuosobackend''' index version=2 rebuilt index for type indexing=true ``` # Speedtouch commands show timeservers `sntp list` show dns servers `dns server route list` `dns server route add dns=1.1.1.1 metric=5` add route `ip rtadd` `dst=0.0.0.0` `dstmask=255.255.255.255` `label=` `gateway=192.168.1.254` `intf=` `srcintf` `metric=0` # ip rtadd Add a route to the routing table. SYNTAX: `ip rtadd` ` dst = ` ` [dstmsk = ]` ` [label = ``]` ` [gateway = ``]` ` [intf = ``]` ` [srcintf = ``]` ` [metric = ]` # Upgrading to KDE 4.5.0 on OS11.3 If you want to upgrade your existing openSUSE installation to KDE SC 4.5.0, follow these steps for the best experience. They assume you are using 11.3, substitute 11.2 in all URLs below if necessary. 1\) Remove any old KDE:KDE4:\* repositories and KDE:Qt\* repositories 2\) Add the repository containing 4.5.0: KDE:Distro:Factory : `zypper ar -f `[`http://download.opensuse.org/repositories/KDE:/Distro:/Factory/openSUSE_11.3`](http://download.opensuse.org/repositories/KDE:/Distro:/Factory/openSUSE_11.3)` KDF` 3\) Add the Extra repository (optional): `zypper ar -f `[`http://download.opensuse.org/repositories/KDE:/Extra/openSUSE_11.3_KDE_Distro_Factory/`](http://download.opensuse.org/repositories/KDE:/Extra/openSUSE_11.3_KDE_Distro_Factory/)` KDEExtra` 4\) Upgrade all packages from KDE:Distro:Factory and KDE:Extra (omit if not using): `zypper dup --from KDF --from KDEExtra` 5\) If you are using knetworkmanager, replace it with the Network Management plasmoid due to a bug in KNM with 4.5.0 that hides all connections, before you upgrade or you may be stuck without a connection! `zypper in plasmoid-networkmanagement` and allow it to deinstall NetworkManager-kde4. 6\) logout and login again. # DVB-C MythTV Ziggo - TECHNOTREND BUDGET C-1501 INCL. CI-INTERFACE 80 euro. [http://www.satellitecity.nl/technotrend-budget-c1501-incl-ciinterface-ttviewer-p-1702.html](http://www.satellitecity.nl/technotrend-budget-c1501-incl-ciinterface-ttviewer-p-1702.html) Dit is een DVB PCI card met CI interface. Dus nog nodig een CAM module en smartcard - CAM module ong. 100 euro [http://tweakers.net/pricewatch/209827/mascom-alphacrypt-classic.html](http://tweakers.net/pricewatch/209827/mascom-alphacrypt-classic.html) of de 'light' versie ong. 90 euro [http://www.satellitecity.nl/alphacrypt-lightplus-p-1811.html](http://www.satellitecity.nl/alphacrypt-lightplus-p-1811.html) - Smartcard Ziggo, ong 25 euro. # Online diagrameditors - Cacoo - Creately - Gliffy - Graphity # Connect MythTV and XBMC ## XBMCMythTV script: How to make your XBMC connect to the MythTV MySQL database: Method 1) it doesn't seem to work if you use the PHPmyadmin interface, so do it just hardcore from the CLI: `UPDATE mysql.user ` `SET password=OLD_PASSWORD('mythtv') ` `WHERE user='mythtv' ` `AND host='someip'; ` --- Method 2) This allows the xbox to connect remotely to the server running the mythtv backend. Run it on the backend in mysql command line. `GRANT ALL PRIVILEGES ON *.* TO root@"192.168.1.60" identified by "MyPassword"; ` The IP is that of the XBOX. Remember that XBMC does not support the DB-connection interface version of the latest MythTV versions, yet..... # Configuring the Zotac HD-ID11 - sound: My system plays mp4 fine using this LiveCD. I am on a Zotac ID11 and have mine set to 7.1 and set all output choices to Nvidia HDMI. - remote: I had the remote working after reboot. I also had a double the button press being sent through. Fixed it by: [http://ubuntuforums.org/archive/index.php/t-1594799.html](http://ubuntuforums.org/archive/index.php/t-1594799.html)1. Install input-utils package `#sudo apt-get install input-utils` 2\. Find your remote input event# and make note `#lsinput` 3\. Reconfigure lirc. `#dpkg-reconfigure lirc` On the remote select “Linux input layer (/dev/input/eventX) Then select the /dev/input/event that matches your remote. 4\. run irw `#irw` 5\. You should see you remote button press show up, and you are done. Note that the remote has a different lirc profile and remote key names are different, but the kernel source drivers are more universal. I have single button presses now. But looks like my key mapping is off. - remote2: those of you that when you do wake up from s3 the mce remote wont respond do this and it will fix that issue you will need to reconfigure lirc run this command `sudo dpkg-reconfigure lirc` then pick mce remote for the first one and then none for the second option… then reboot and all should be well thats how i got my hd-id11 to work sweetly