Date: 10/22/07 (Java Web)    Keywords: mysql, database, sql, java

Openfire is a cross-platform java based free Instant Messaging server which implements the XAMPP (Jabber) protocol with extensions. It is very well suited as corporate instant messaging solution. Here is how you can recover the admin password, in case you forget it. How to recover Openfire admin password 1. Login to MySQL and use openfire database. I [...]

Source: http://blog.taragana.com/index.php/archive/how-to-recover-openfire-admin-password/

Date: 10/23/07 (Code WTF)    Keywords: php, mysql, sql

Прелюдия: есть товарищ, который имеет программистское образование, умеет C++, любит порассуждать о том, что php не язык, mysql не субд и т.д. И ему дана простая задача: есть переменная, которая может содержать значения от 1 до 10 - рейтинг определенного объекта. Есть картинки с названиями 1.gif, 2.gif, 3.gif и т.д. Как это сделал бы я? (в конечном итоге и сделал): А как поступит хардкорный сишник, для которого php - говноязык?

                                                                    switch ($rres['karma']) {
                                                                    case '':?>
            
            
            
            
            
            
            
            
            
            
            
            
            
            
            
            
            
            
            
            
            
            

сохранено форматирование оригинала.

Source: http://community.livejournal.com/code_wtf/108965.html
	

Date: 11/02/07 (SQL Server)    Keywords: database, sql

Does anyone know a decent freeware for data modeling from SQL Server database? Like ERWin Data Modeler but free. I don't need one that's on steroids, just something that will allow me to pull data models from existing tables in SQL Server 2000/2005 and Oracle.

If I'm asking too much for a freebie, can anyone suggest a good one as alternative to ERWin? I'm curious to see what people are using. We're looking for one that's cheaper in cost than ERWin.

Thanks!

Source: http://community.livejournal.com/sqlserver/64005.html

Date: 11/03/07 (PHP Community)    Keywords: xml, sql

I'm having some problems parsing an XML file. For instance, I have a tag that looks like this:




The function that reads the data from the tag assembles an SQL statement out of all the various tags. The code for this TITLE tag looks like this:

$SQL.= 'and title="'.$data.'" ';

If the data contains " it parses fine, since the data is surrounded with single quotes, but when ' comes through, it truncates the string.
As I write all this out and think about the problem, my initial idea is to check the $data for either " or ' and then use a properly formatted SQL statement for the corresponding single or double quote. Anyone have a better idea?
Thanks

Source: http://community.livejournal.com/php/593589.html

Date: 11/05/07 (SQL Server)    Keywords: sql

I joined the group this morning, but sorta feel stupid in that I've no idea how it works and you guys seem well, out of my league. I just got a job offer last Friday to go and help migrate/admin stuff from MS Access over to SQL Server 2005. I know Access, I know SQL, but damned if I can figure out how to do anything on the server thing. The only advice I got from my friend was to just hook it up to some VB thing and do it that way. Are there any tutorial sites that you'd recommend or just fetch myself SQL Server for Dummies?
I already downloaded Server 2005 Express and the configuration manager stuff.

Source: http://community.livejournal.com/sqlserver/64489.html

Date: 11/05/07 (PHP Community)    Keywords: php, mysql, sql, google

I've already scoured google in relation to this issue and so far have found many solutions, none of which seems to work.

PHP 4
MySQL 4.1.20

The script I'm working on at the moment returns a MySQL error : Unknown column 'column_name' in 'field list' Where column_name can be any valid column for the table. I've changed the order and the query insert style several times, restarted the MySQL server, and various other rain dances, all with the same results.

Here's a brief overview of the query that the script generates, it works fine when run directly in MySQL so I'm guessing there's something funny going on with the PHP/MySQL interface.


INSERT INTO table (area, type, city, state, cost, status, capacity, allowed, description, link, startdate, regclose, enddate, over18, gender, level1, level2, level3) VALUES ('East', 'eryery', 'sdfaf', 'CA', '1', 'C', '1', 'N', 'ewt', 'yerr', '2007-05-04 01:00:00', '2010-01-01 01:00:00', '2011-01-01 01:00:00', '1', 'M', '1', '1', '1')Error in query: INSERT INTO table (area, type, city, state, cost, status, capacity, allowed, description, link, startdate, regclose, enddate, over18, gender, level1, level2, level3) VALUES ('East', 'eryery', 'sdfaf', 'CO', '1', 'C', '1', 'N', 'ewt', 'yerr', '2007-05-04 01:00:00', '2010-01-01 01:00:00', '2011-01-01 01:00:00', '1', 'M', '1', '1', '1'). Unknown column 'area' in 'field list'


Any ideas anyone? I generally try and hammer these things out on my own but this one's just too busy givnig me a migraine after working on it for so long. Still with no idea how to start on it.

Source: http://community.livejournal.com/php/594338.html

Date: 11/05/07 (PHP Community)    Keywords: php, mysql, sql

ok, still banging my head against this one. Here's some more information.

Output from PHP/MySQL on attempted insert:
Error in query: INSERT INTO regTable (area) VALUES ('West_Coast'). Unknown column 'area' in 'field list'

However, when I run that query on its own in the CLI or phpMyAdmin it works fine. It can be any valid column in that table and it still creates the same error.

Here's the PHP/MySQL code, maybe the issue is with how I'm using the $_REQUEST array or concatenating the string for the query. In addition and just to eliminate possibilities I tried copying the output query from the script and putting it in as a static query in the same script and it works fine that way as well.

Still at a loss.

$query = "INSERT INTO regTable (area)
VALUES
('".$_REQUEST['area']."')";

// $query = "INSERT INTO regTable (area) VALUES ('West_Coast')";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

Source: http://community.livejournal.com/php/594655.html

Date: 11/06/07 (SQL Server)    Keywords: database, sql

I need to produce a report with cummulative stats each each month & year in the database.

The data is stored as follows:

11/05/2007 Dave FXR1200
11/05/2007 Frank FXR1200
10/31/2007 Tom Fatboy
10/30/2007 Dave Fatboy
10/30/2007 Paul TZ250

I need to produce a report that shows:

November 2007 2
October 2007 3

My SQL is poor (hence my post). The only query I can come up with is the one below that produces yearly stats.

SELECT year(logdate) as LogMonth, COUNT(id) AS Prospects
FROM calllogs
GROUP BY year(logdate)
order by year(logdate) asc

Can anyone suggest the approach I need to produce the correct stats ?

Source: http://community.livejournal.com/sqlserver/64541.html

Date: 11/08/07 (PHP Community)    Keywords: mysql, sql

I’m thinking about that:

What about using DBA (db4) before connecting to MySQL for speed-up and reduction server loading.

I want to store document last-modified time and select it by URI-key. Then compare it with request header “If-Modified-Since” and if visitor have actual cache — send status code 304 (Not Modified) and don’t connect to MySQL.

I just interesting, what about DBA perfomance in compare with MySQL? Will it have a matter?

Source: http://community.livejournal.com/php/595432.html

Date: 11/09/07 (Computer Help)    Keywords: software, html, database, sql, java, web, yahoo, microsoft

Sorry for using a whole other post, but the log is over 19k characters and doesn't fit into a comment.



Logfile of Trend Micro HijackThis v2.0.0 (BETA)
Scan saved at 5:13:17 PM, on 11/9/2007
Platform: Windows XP SP2 (WinNT 5.01.2600)
Boot mode: Normal

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\Program Files\Lavasoft\Ad-Aware 2007\aawservice.exe
C:\WINDOWS\system32\spoolsv.exe
C:\WINDOWS\system32\nvsvc32.exe
c:\Program Files\Microsoft SQL Server\90\Shared\sqlwriter.exe
C:\Program Files\Viewpoint\Common\ViewpointService.exe
C:\WINDOWS\system32\wscntfy.exe
C:\WINDOWS\Explorer.EXE
C:\Program Files\CyberLink\PowerDVD\PDVDServ.exe
C:\Program Files\NVIDIA Corporation\NvMixer\NVMixerTray.exe
C:\Program Files\Java\jre1.6.0_02\bin\jusched.exe
C:\WINDOWS\system32\RUNDLL32.EXE
C:\WINDOWS\system32\ctfmon.exe
C:\Program Files\Spybot - Search & Destroy\TeaTimer.exe
C:\Program Files\Logitech\Desktop Messenger\8876480\Program\LogitechDesktopMessenger.exe
C:\Program Files\Last.fm\LastFMHelper.exe
C:\Program Files\Logitech\SetPoint\SetPoint.exe
C:\Program Files\NETGEAR\WG311T\wlancfg5.exe
C:\Program Files\OpenOffice.org 2.3\program\soffice.exe
C:\Program Files\Common Files\Logitech\KHAL\KHALMNPR.EXE
C:\Program Files\OpenOffice.org 2.3\program\soffice.BIN
C:\Program Files\Winamp\winamp.exe
C:\Program Files\Last.fm\LastFM.exe
C:\Program Files\Java\jre1.6.0_02\bin\jucheck.exe
C:\WINDOWS\system32\rundll32.exe
C:\Program Files\Mozilla Firefox\firefox.exe
C:\Program Files\Soulseek\slsk.exe
C:\Documents and Settings\Me\Desktop\Diagnostics\HiJackThis_v2.exe

R0 - HKCU\Software\Microsoft\Internet Explorer\Main,Start Page = http://www.discogs.com/release/581816
R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Default_Page_URL = http://www.yahoo.com/
R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Default_Search_URL = http://us.rd.yahoo.com/customize/ie/defaults/su/msgr8/*http://www.yahoo.com
R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Search Bar = http://us.rd.yahoo.com/customize/ie/defaults/sb/msgr8/*http://www.yahoo.com/ext/search/search.html
R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Search Page = http://us.rd.yahoo.com/customize/ie/defaults/sp/msgr8/*http://www.yahoo.com
R0 - HKLM\Software\Microsoft\Internet Explorer\Main,Start Page = http://www.yahoo.com/
O2 - BHO: Adobe PDF Reader Link Helper - {06849E9F-C8D7-4D59-B87D-784B7D6BE0B3} - C:\Program Files\Common Files\Adobe\Acrobat\ActiveX\AcroIEHelper.dll
O2 - BHO: (no name) - {437DF732-8651-4144-AB4E-AC80310C4797} - C:\WINDOWS\system32\vtstt.dll
O2 - BHO: Spybot-S&D IE Protection - {53707962-6F74-2D53-2644-206D7942484F} - C:\PROGRA~1\SPYBOT~1\SDHelper.dll
O2 - BHO: SSVHelper Class - {761497BB-D6F0-462C-B6EB-D4DAF1D92D43} - C:\Program Files\Java\jre1.6.0_02\bin\ssv.dll
O2 - BHO: (no name) - {89032A20-4370-487E-AB80-2251EC374249} - C:\WINDOWS\system32\opnmjgf.dll
O4 - HKLM\..\Run: [NeroFilterCheck] C:\WINDOWS\system32\NeroCheck.exe
O4 - HKLM\..\Run: [RemoteControl] "C:\Program Files\CyberLink\PowerDVD\PDVDServ.exe"
O4 - HKLM\..\Run: [NVMixerTray] "C:\Program Files\NVIDIA Corporation\NvMixer\NVMixerTray.exe"
O4 - HKLM\..\Run: [WinampAgent] C:\Program Files\Winamp\winampa.exe
O4 - HKLM\..\Run: [SunJavaUpdateSched] "C:\Program Files\Java\jre1.6.0_02\bin\jusched.exe"
O4 - HKLM\..\Run: [Adobe Reader Speed Launcher] "C:\Program Files\Adobe\Reader 8.0\Reader\Reader_sl.exe"
O4 - HKLM\..\Run: [NvCplDaemon] RUNDLL32.EXE C:\WINDOWS\system32\NvCpl.dll,NvStartup
O4 - HKLM\..\Run: [nwiz] nwiz.exe /install
O4 - HKLM\..\Run: [NvMediaCenter] RUNDLL32.EXE C:\WINDOWS\system32\NvMcTray.dll,NvTaskbarInit
O4 - HKLM\..\Run: [Logitech Hardware Abstraction Layer] KHALMNPR.EXE
O4 - HKCU\..\Run: [ctfmon.exe] C:\WINDOWS\system32\ctfmon.exe
O4 - HKCU\..\Run: [SpybotSD TeaTimer] C:\Program Files\Spybot - Search & Destroy\TeaTimer.exe
O4 - HKCU\..\Run: [LDM] C:\Program Files\Logitech\Desktop Messenger\8876480\Program\LogitechDesktopMessenger.exe
O4 - HKUS\S-1-5-21-436374069-507921405-839522115-1004\..\Run: [ctfmon.exe] C:\WINDOWS\system32\ctfmon.exe (User 'Allison')
O4 - HKUS\S-1-5-21-436374069-507921405-839522115-1004\..\Run: [Aim6] "C:\Program Files\AIM6\aim6.exe" /d locale=en-US ee://aol/imApp (User 'Allison')
O4 - HKUS\S-1-5-21-436374069-507921405-839522115-1004\..\Run: [Yahoo! Pager] "C:\PROGRA~1\Yahoo!\MESSEN~1\YAHOOM~1.EXE" -quiet (User 'Allison')
O4 - HKUS\S-1-5-21-436374069-507921405-839522115-1004\..\Run: [LDM] C:\Program Files\Logitech\Desktop Messenger\8876480\Program\LogitechDesktopMessenger.exe (User 'Allison')
O4 - Startup: OpenOffice.org 2.3.lnk = C:\Program Files\OpenOffice.org 2.3\program\quickstart.exe
O4 - Startup: PowerReg Scheduler.exe
O4 - Global Startup: Last.fm Helper.lnk = C:\Program Files\Last.fm\LastFMHelper.exe
O4 - Global Startup: Logitech Desktop Messenger.lnk = C:\Program Files\Logitech\Desktop Messenger\8876480\Program\LDMConf.exe
O4 - Global Startup: Logitech SetPoint.lnk = C:\Program Files\Logitech\SetPoint\SetPoint.exe
O4 - Global Startup: NETGEAR WG311T Smart Wizard.lnk = C:\Program Files\NETGEAR\WG311T\wlancfg5.exe
O9 - Extra button: (no name) - {08B0E5C0-4FCB-11CF-AAA5-00401C608501} - C:\Program Files\Java\jre1.6.0_02\bin\ssv.dll
O9 - Extra 'Tools' menuitem: Sun Java Console - {08B0E5C0-4FCB-11CF-AAA5-00401C608501} - C:\Program Files\Java\jre1.6.0_02\bin\ssv.dll
O9 - Extra button: PokerStars - {3AD14F0C-ED16-4e43-B6D8-661B03F6A1EF} - C:\Program Files\PokerStars\PokerStarsUpdate.exe
O9 - Extra button: (no name) - {DFB852A3-47F8-48C4-A200-58CAB36FD2A2} - C:\PROGRA~1\SPYBOT~1\SDHelper.dll
O9 - Extra 'Tools' menuitem: Spybot - Search & Destroy Configuration - {DFB852A3-47F8-48C4-A200-58CAB36FD2A2} - C:\PROGRA~1\SPYBOT~1\SDHelper.dll
O9 - Extra button: Messenger - {FB5F1910-F110-11d2-BB9E-00C04F795683} - C:\Program Files\Messenger\msmsgs.exe
O9 - Extra 'Tools' menuitem: Windows Messenger - {FB5F1910-F110-11d2-BB9E-00C04F795683} - C:\Program Files\Messenger\msmsgs.exe
O16 - DPF: {30528230-99f7-4bb4-88d8-fa1d4f56a2ab} (Installation Support) - C:\Program Files\Yahoo!\Common\Yinsthelper.dll
O16 - DPF: {6414512B-B978-451D-A0D8-FCFDF33E833C} (WUWebControl Class) - http://www.update.microsoft.com/windowsupdate/v6/V5Controls/en/x86/client/wuweb_site.cab?1187749151468
O18 - Protocol: bw+0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw+0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw-0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw-0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw00 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw00s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw10 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw10s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw20 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw20s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw30 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw30s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw40 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw40s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw50 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw50s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw60 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw60s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw70 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw70s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw80 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw80s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw90 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bw90s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwa0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwa0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwb0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwb0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwc0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwc0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwd0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwd0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwe0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwe0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwf0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwf0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwfile-8876480 - {9462A756-7B47-47BC-8C80-C34B9B80B32B} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\GAPlugProtocol-8876480.dll
O18 - Protocol: bwg0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwg0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwh0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwh0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwi0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwi0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwj0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwj0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwk0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwk0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwl0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwl0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwm0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwm0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwn0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwn0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwo0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwo0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwp0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwp0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwq0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwq0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwr0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwr0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bws0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bws0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwt0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwt0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwu0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwu0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwv0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwv0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bww0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bww0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwx0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwx0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwy0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwy0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwz0 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: bwz0s - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O18 - Protocol: offline-8876480 - {ECCEA4F7-12A0-49EC-A3E5-A3870313B82F} - C:\Program Files\Logitech\Desktop Messenger\8876480\Program\BWPlugProtocol-8876480.dll
O20 - Winlogon Notify: opnmjgf - C:\WINDOWS\SYSTEM32\opnmjgf.dll
O22 - SharedTaskScheduler: Browseui preloader - {438755C2-A8BA-11D1-B96B-00A0C90312E1} - C:\WINDOWS\System32\browseui.dll
O22 - SharedTaskScheduler: Component Categories cache daemon - {8C7461EF-2B13-11d2-BE35-3078302C2030} - C:\WINDOWS\System32\browseui.dll
O23 - Service: Ad-Aware 2007 Service (aawservice) - Lavasoft AB - C:\Program Files\Lavasoft\Ad-Aware 2007\aawservice.exe
O23 - Service: Atheros Configuration Service (ACS) - Unknown owner - C:\WINDOWS\system32\acs.exe (file missing)
O23 - Service: NVIDIA Display Driver Service (NVSvc) - NVIDIA Corporation - C:\WINDOWS\system32\nvsvc32.exe
O23 - Service: SiSoftware Database Agent Service (SandraDataSrv) - SiSoftware - C:\Program Files\SiSoftware\SiSoftware Sandra Lite XII\Win32\RpcDataSrv.exe
O23 - Service: SiSoftware Sandra Agent Service (SandraTheSrv) - SiSoftware - C:\Program Files\SiSoftware\SiSoftware Sandra Lite XII\RpcSandraSrv.exe
O23 - Service: Viewpoint Manager Service - Viewpoint Corporation - C:\Program Files\Viewpoint\Common\ViewpointService.exe

--
End of file - 19422 bytes



I'm 99.9% sure the problem is opnmjgf.dll, which pops up in both O2 and O20. Unfortunately, no matter what I do, including flagging it to delete on reboot in HT, it keeps coming back, and I've no idea how to get it to go away permanently. Any help would be greatly appreciated.

Source: http://community.livejournal.com/computer_help/837511.html

Date: 11/12/07 (Java Web)    Keywords: php, mysql, sql

We are having 2-3 reports of users seeing warnings (not error) using Translator Pro with the latest version of WordPress while posting a comment or publishing a post: Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) in …/wp-content/plugins/translator/translator.php(15) : eval()’d code on line 1080 Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server [...]

Source: http://blog.taragana.com/index.php/archive/how-to-address-translator-pro-warnings/

Date: 11/12/07 (Data Management)    Keywords: technology, sql, microsoft

Microsoft will roll out on November 12 some time later in November a third Community Technology Preview (CTP) test build of SQL Server 2008, the next-to-last CTP before finalizing the product in time for shipment in the second calendar quarter of next year. CTP 3 of SQL...

Source: http://blogs.zdnet.com/microsoft/?p=937

Date: 11/12/07 (Code WTF)    Keywords: php, sql, web

Пожаловались мне в аську давеча на чужой код...

$sql = "UPDATE " . USERS_TABLE . "SET  . $username_sql . $passwd_sql . "
user_email = '" . str_replace("\'", "''", $email) . "', 
user_icq = '" . str_replace("\'", "''", $icq) . "', 
user_website = '" . str_replace("\'", "''", $website) . "', 
user_occ = '". str_replace("\'", "''", $occupation) . "', 
user_from = '" . str_replace("\'", "''", $location) . "', 
user_interests = '" . str_replace("\'", "''", $interests) . "', 
user_sig = '" . str_replace("\'", "''", $signature) . "', 
user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", $aim) . "', 
...
WHERE user_id = $user_id";

Source: http://community.livejournal.com/code_wtf/112766.html

Date: 11/14/07 (Data Management)    Keywords: software, database, sql, security, microsoft

A survey by renowned database hacker David Litchfield has found a whopping 492,000 Microsoft SQL and Oracle database servers directly accessible to the Internet without firewall protection. Litchfield (right), co-founder of Next Generation Security Software, ran port scans against 1,160,000 random IP addresses -- TCP port 1433...

Source: http://blogs.zdnet.com/security/?p=663

Date: 11/15/07 (Data Management)    Keywords: database, sql, microsoft

Company says licensing is weak spot in Oracle's armory, and it hopes to use it to woo database customers to SQL Server 2008. The forthcoming launch of SQL Server 2008 will see Microsoft focus its considerable resources on the issue of licensing, to win customers from rivals Oracle...

Source: http://news.zdnet.com/2100-9584_22-6218777.html

Date: 11/16/07 (Java Web)    Keywords: mysql, sql

When you try MySQL master-master replication with two (or more) servers you may often find that in the process of configuring the original master to also act as a slave server (start slave), it fails with the following error: mysql> start slave; ERROR 1200 (HY000): The server is not configured as slave; fix in config file or [...]

Source: http://blog.taragana.com/index.php/archive/solution-mysql-master-master-replication-fails-with-error-1200-hy000-on-master/

Date: 11/16/07 (PHP Community)    Keywords: php, mysql, html, sql, web

Hello Friends

I want to add a search functionality to a project I am working on. I'd like the search function to index text held in several MySQL tables and then generate a list of keywords to be stored in another table. I do not want a web crawler or an indexing function that indexes files on the filesystem.

The search function will then access this table of keywords in order to find matching documents, and hopefully return them in order of relevance.

I know of this project: http://www.phpguru.org/static/PorterStemmer.html However, it is PHP5 only. The PHP4 project it borrows from, http://www.chuggnutt.com/stemmer.php may or may not work, but it seems to perhaps be buggy.

Anyone have any recommendations for such a project?

Thanks!

Source: http://community.livejournal.com/php/596534.html

Date: 11/18/07 (Java Web)    Keywords: mysql, database, sql

Replicating on two or more MySQL master database servers 1. MySQL Master-Master Replication Fails With ERROR 1200 (HY000) on Master 2. Password problem are solved by carefully checking your grant statements 3. When you have more than two master servers, you must use log-slave-updates option to ensure that changes are propagated in a chain. Beware of infinite looping [...]

Source: http://blog.taragana.com/index.php/archive/6-mysql-database-replication-tips/

Date: 11/18/07 (Java Web)    Keywords: mysql, sql

Monitoring MySQL queries is a favorite pastime of MySQL administrators especially for performance reasons. Here is a simple bash script to monitor long running MySQL queries in realtime using the ubiquitous ’show processlist’: #!/bin/bash while [ 1 ] do mysql -N -u root -ppassword -e 'show processlist' |grep -v 'show processlist' [...]

Source: http://blog.taragana.com/index.php/archive/monitoring-mysql-queries-using-bash-script/

Date: 11/19/07 (Data Management)    Keywords: technology, sql, microsoft

Microsoft made available for download on November 18 the promised November Community Technology Preview (CTP) build of SQL Server 2008. The SQL Server 2008 November CTP bits can be downloaded directly from the Microsoft Download site. Microsoft has been working to deliver more frequent,...

Source: http://blogs.zdnet.com/microsoft/?p=972