Entries tagged as windowsRelated tags .net ajax apache framework iphone linux mac Microsoft mvc mysql oracle osx performance php tools usability webdevelopment administration database development security webdesign css google java java script regular expressions vermischtes benchmarking commandline zend beta masterbootrecord MasterBootRecord.de microsoft office software virtualisierung vista domains perl Webdevelopment Datenbanken MySQL PostgreSQL SQLite Mac Vermischtes firefox gmail fun onlinebanking push AJAX safari stumbleupon 10a432 apple appletv bugfix samsung snow leopard sync torrent troubleshooting Windows pocket pc joomla postgresql Oracle spam shareware symbian wiki fussball vlc vuvuzela wm news regensburg semantic web seo pythonFriday, June 8. 2007Parallels Desktop 3 ist da!Sunday, May 27. 2007Eine vorhandene Serendipity Installation von MySQL auf Postgres migrieren"1. dump the mysql database with some special magic options. I'm not sure about the encoding part of all this, I assumed the mysql database was unicode but may have been wrong. mysqldump --skip-comments \ --complete-insert --default-character-set=UTF8 \ --no-create-info --skip-add-locks --skip-opt \ --compatible=postgresql \ $yourdbname > mysql-pg-compat.sql 2. create a temporary postgres database to work in createdb -O $someuser -E UTF8 s9ytemp 3. point a test s9y installation at that new database you created and run through the installation process to get it to install all your schema. 4. make sure at this point you also install all the plugins you want 5. the s9y installation process does put data into those tables, so get pg_dump to create you just the schema part: pg_dump -Fc -f pg-schema.sql s9ytemp 6. drop and recreate your temporary postgres database dropdb s9ytemp - repeat step 2. 7. restore the schema you just created into your new temp database pg_restore -s -v -Fc -d s9ytemp pg-schema.sql 8. start munging some stuff in the mysql dump 8a. add transactions around it echo "BEGIN;" > mysql-pg-compat-tx.sql cat mysql-pg-compat.sql >> mysql-pg-compat.sql echo "COMMIT;" >> mysql-pg-compat-tx.sql 8b. fix up weird table name sensitivity issue cat mysql-pg-compat-tx.sql | perl -pe 's/pluginPath/pluginpath/g' > mysql-pg-compat-tx-fixed.sql (you could do this in place with perl -pi -e 's/pluginPath/pluginpath/g' mysql-pg-compat-tx.sql too. 9. Restore the data from the mysql dump into the postgres database psql -f mysql-pg-compat-tx(-fixed).sql -d s9ytemp Watch the output.. as soon as you see errors, ctrl-c it and check the error & fix it. Repeat all necessary steps until this completes with no errors This took me about 6 goes to get right, at which point I found a few instances of 4, and 8b. You might find others ![]() important ![]() 10. Fix up the sequences Create a file called fixsequencesgen.sql containing: SELECT 'SELECT setval(' || quote_literal(relname) || ', (SELECT MAX(id) FROM ' || substring(relname from 1 for octet_length(relname) - 7) || '), true);' FROM pg_class WHERE relkind = 'S' AND relname like '%_id_seq' AND relnamespace IN ( SELECT oid FROM pg_namespace WHERE nspname NOT LIKE 'pg_%' AND nspname != 'information_schema' ) and then do: psql -d s9ytemp -f fixsequencesgen.sql -o fixsequencestemp.sql cat fixsequencestemp.sql | grep SELECT > fixsequences.sql (again, you could do this in place) open up fixsequences.sql and change these lines: - SELECT setval('s9yauthors_authorid_seq', (SELECT MAX(id) FROM s9yauthors_autho), true); - SELECT setval('s9ycategory_categoryid_seq', (SELECT MAX(id) FROM s9ycategory_categor), true); + SELECT setval('s9yauthors_authorid_seq', (SELECT MAX(authorid) FROM s9yauthors), true); + SELECT setval('s9ycategory_categoryid_seq', (SELECT MAX(categoryid) FROM s9ycategory), true); This is because the above script I stole from another project mysql -> pg migration I did (moodle) which always uses 'id' as the field name for the primary key. It could probably be smarter, but changing the two lines works fine too. Apply that file to the database: psql -d s9ytemp -f fixsequences.sql 11. Do a pgdump of your new s9y postgres database: pg_dump -Fc s9ytemp > s9y.pgdump 12. Copy it to your production server, and do createdb -E UTF8 $yours9ydbuser s9y pg_restore -Fc -d s9y s9y.pgdump 13. Switch over your production s9y to use postgres (by editing serendipity_config_local.inc.php) 14. Done! Go and have something strong to drink! Other miscellaneous things I found: - - I couldn't get the spamblocklog table to create itself .. I ended up commenting out the if ($versioncomparison) { line above the CREATE TABLE part in the plugin ... - - Running postgres 8.1 on the computer I was working on and then trying to restore into a 7.4 production postgres was an unhappy experience that I don't recommend. I didn't realise this until I got to step 12 ![]() In case that happens, try 11 and 12 like: pg_dump -Fp s9ytemp (rather than Fc) and then you can just do psql -d s9y < s9y.pgdump" Wednesday, May 16. 2007Auf der Suche nach dem perfekten PHP Application Framework
Ich habe mich in letzter Zeit etwas nach Frameworks für die Applikationsentwicklung in PHP umgesehen. Hintergrund ist
die anstehende Entwicklung einer etwas grösseren Anwendung. Das Framework sollte den MVC-Pattern umsetzen, eventuell
Hilfestellungen bei Routine-Tasks geben, aktuell sein (weiterentwickelt werden) und vor allem sollte die verfügbare
Dokumentation umfangreich sein.
Nach kurzer Zeit musste ich feststellen, dass die Auswahl sehr gross und unübersichtlich ist. Bisher habe ich mich nicht entschieden. Vielleicht hat der eine odere andere Leser Erfahrungen mit einem dieser Frameworks und möchte sie mit mir teilen? Ausserdem mag ich mit diesem Überblick die Leute unterstützen, die vor einer Ähnlichen Entscheidung stehen. Es handelt sich hierbei wirklich nur um einen Überblick und keine Bewertung. Es werden die mir bekannten Frameworks mit der Beschreibung von ihrer Webseite verlinkt. Continue reading "Auf der Suche nach dem perfekten PHP Application Framework" Monday, February 26. 2007DMT (DSL-Modem Tool)
"Mit dieser Software für Windows können bestimmte DSL-Modems oder Router ausgelesen werden.
Zusätzlich kann die DSL-Verbindung analysiert, optimiert und automatisch überwacht werden. " DMT (DSL-Modem Tool) Defined tags for this entry: windows
Monday, February 19. 2007toolbarless StumbleUpon BookmarkletsAdmiral - Exposé for Windows
"Some of the new features relative to 1.0.1 include:
Support for drag-and-drop in miniature Miniature related windows Show desktop Switching through windows using mouse wheel or tab/shift-tab Improved hotkey support (e.g. win space) Quick-open of custom files Improved stability Live-update of miniatured windows * Color coded miniatured windows" Admiral - Exposé for Windows My Exposé - Exposé for Vista
"Many improvements in this version:
More natural thumbnails placement (no more grid) Tray icon with configuration dialog No more configuration file in ProgramFiles folder New object model for triggers (better resource freeing, new trigger methods, informations about the state of "MyExpose"...) Support for non-96 dpi screen settings Support of Windows Speech Recognition (open the configuration dialog, add a trigger, choose VoiceTrigger and configure it) * Beautyful icons from Mauricio Diaz (thanks a lot Mauricio ^^)" My Exposé - Exposé for Vista Wednesday, February 14. 2007ScreenRecycler
"Use any networked computer as additional display in Mac OS X.
Recycle your old iMac, Powerbook or even Windows PC." ScreenRecycler Tuesday, April 18. 2006TrueCrypt Version 4.2 veröffentlicht
Gestern wurde die Version 4.2 von der Verschlüsselungssoftware TrueCrypt
veröffentlicht. Der Changelog findet sich hier.
Die Highlights der neuen Version: Ability to create a ‘dynamic’ container whose physical size (actual disk space used) grows as new data is added to it. (Dynamic containers are pre-allocated NTFS sparse files). New Mount Option: 'system'. It is possible to place paging (swap) files on a TrueCrypt volume that is mounted with this option enabled. Thus, it is possible to use TrueCrypt to on-the-fly encrypt a paging file. It is now possible to mount a single TrueCrypt volume from multiple operating systems at once (for example, a volume shared over network), provided that the volume is mounted as read-only under each system Command line argument buffer is now wiped upon exit Thursday, April 6. 2006Apple Bootcamp - Offiziell XP auf Intel Macs installieren
"More and more people are buying and loving Macs. To make this choice simply irresistible, Apple will include technology
in the next major release of Mac OS X, Leopard, that lets you install and run the Windows XP operating system on your
Mac. Called Boot Camp (for now), you can download a public beta today." - Na toll: Nachdem der Wettkampf vorbei ist
zückt Apple eine fertige Lösung aus dem Ärmel... Das hätten sie auch eher machen können
![]() Apple Bootcamp - Offiziell XP auf Intel Macs installieren Apple Bootcamp - Offiziell XP auf Intel Macs installieren Saturday, March 18. 2006Windows XP Bootloader for Intel Macs Version 0.1 Download
"Download the bootloader
Windows XP on the Intel Mac version 0.1 - Download Now! Further questions? Go get some support! " - Finally: Done! Download Page Windows XP Bootloader for Intel Macs Version 0.1 Download Friday, March 17. 2006Hardening Windows TCP/IP-Stack
"Summary: You can configure various TCP/IP parameters in the Windows registry in order to protect against network-level
denial of service attacks including SYN flood attacks, ICMP attacks and SNMP attacks. You can configure registry keys
to:
Enable SYN flood protection when an attack is detected. Set threshold values that are used to determine what constitutes an attack. This How To shows an administrator which registry keys and which registry values must be configured to protect against network-based denial of service attacks." Hardening Windows TCP/IP-Stack Hardening Windows TCP/IP-Stack Monday, March 13. 2006Neue Version 1.94 von UPX
Neue Version 1.94 von UPX:
"Changes in 1.94 beta (11 Mar 2006): UNSTABLE BETA VERSION - DO NOT USE EXCEPT FOR TESTING new format: added support for arm/pe (ARM executables running on WinCE) new format: added support for linux elf/amd64 new format: added support for linux elf/ppc32 new format: added support for mach/ppc32 (Apple Mac OS X) win32/pe: hopefully working "load config" support win32/pe: R6002 runtime errors worked around win32/pe: the stub now clears the dirty stack" Neue Version 1.94 von UPX Neue Version 1.94 von UPX Neue Version 1.94 von UPX Wednesday, February 22. 2006VMware under Linux on the Intel-based Macintosh
"We now have Windows XP running on the Intel-based Macintosh -- as a guest operating system under the Linux version of
VMware. This is quite exciting and promising, especially since the performance of Windows XP seems quite amazing (based
on our limited test run so far) -- mind you, the kernel and the environment we are using experimental and unoptimized,
so it would not be unreasonable to expect even better performance.
To anybody who has used Windows XP under Virtual PC on the PowerPC version of Mac OS X: you will simply be blown away by how fast Windows XP runs under VMware on the new hardware. " - Es tut: Windows XP unter VMWare unter Linux auf dem Intel iMac! ![]() VMware under Linux on the Intel-based Macintosh VMware under Linux on the Intel-based Macintosh Saturday, February 18. 2006Mstsc.exe - RDP Client
"Mstsc
Creates connections to terminal servers or other remote computers, edits an existing Remote Desktop Connection (.rdp) configuration file, and migrates legacy connection files that were created with Client Connection Manager to new .rdp connection files. Syntax mstsc.exe {ConnectionFile | /v:ServerName[:Port]} [/console] [/f] [/w:Width/h:Height] mstsc.exe/edit"ConnectionFile" mstsc.exe/migrate Parameters ConnectionFile Specifies the name of an .rdp file for the connection. /v:ServerName[ :Port] Specifies the remote computer and, optionally, the port number to which you want to connect. /console Connects to the console session of the specified Windows Server 2003 family operating system. /f Starts Remote Desktop connection in full-screen mode. /w:Width/h:Height Specifies the dimensions of the Remote Desktop screen. /edit"ConnectionFile" Opens the specified .rdp file for editing. /migrate Migrates legacy connection files that were created with Client Connection Manager to new .rdp connection files. Remarks You must be an administrator on the server to which you are connecting to create a remote console connection. default.rdp is stored for each user as a hidden file in My Documents. User created .rdp files are stored by default in My Documents but can be moved anywhere." Mstsc.exe - RDP Client Mstsc.exe - RDP Client Thursday, February 2. 2006"Windows Vista booting on an Intel iMac" (fast)
"Windows Vista booting on an Intel iMac" - Das dürfte der Erste sein, der's geschafft hat - allerdings ohne
grafische Oberfläche...
"Windows Vista booting on an Intel iMac" "Windows Vista booting on an Intel iMac" (fast) Wednesday, February 1. 2006Nmap 4.00 veröffentlicht
Seit gestern gibt es eine neue Version des Portscan-/Fingerprinting-/Host-Discovery-Tools. Die Änderungen von Version
4.0 werden ausführlichst hier
beschrieben. Für den Gebrauch unter Windows XP äusserst interessant ist vor allem der Fix für SP2, um wieder mit
RAW-Packets arbeiten zu können.
Download gibts auf dieser Seite Friday, January 20. 2006Einladungen für Windows Live Messenger Beta zu vergeben
Ich habe hier noch ein gutes Dutzend Einladungen für das Beta-Programm des neuen Microsoft Windows Live Messengers 8.0
zu vergeben. Wer Interesse hat, soll bitte einen Kommentar mit seiner E-Mail-Adresse hinterlassen.
Update (26.01.2006): Die Einladungen sind alle vergeben. Sobald es wieder neue gibt, wird es hier bekannt gegeben. Wednesday, December 21. 2005Neue Version von PearPC veröffentlicht
Von PearPC wurde gestern eine neue Version 0.4.0
veröffentlicht.
« previous page
(Page 2 of 3, totaling 53 entries)
» next page
|
Show tagged entries.net administration advertising ajax apache beta commandline css database development firefox framework fun gmail google google earth iphone java java script java server faces linux Mac masterbootrecord MasterBootRecord.de microsoft mvc mysql news office onlinebanking oracle osx performance php pocket pc postgresql regensburg regular expressions security seo software spam tools usability vermischtes vista webdesign webdevelopment windows
Blog AdministrationQuicksearch |
Kommentare