Re: datetime question

2013-11-11 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 11:11 μμ, ο/η Νίκος Αλεξόπουλος έγραψε: Is there someway to write the following line even better with the ability to detect daylight saving time by itself so i don't have to alter the line manually when time changes? lastvisit = ( datetime.utcnow() + timedelta(hours=2) ).str

Re: To whoever hacked into my Database

2013-11-11 Thread Νίκος Αλεξόπουλος
Στις 6/11/2013 5:25 μμ, ο/η Νίκος Γκρ33κ έγραψε: Okey let the hacker try again to mess with my database!!! He is done it twice, lets see if he will make it again! I'am waiting! I can't believe your ignorance. You're actually telling a huge group of developers from all over the globe that you

Re: To whoever hacked into my Database

2013-11-10 Thread Νίκος Αλεξόπουλος
Στις 10/11/2013 9:16 μμ, ο/η Petite Abeille έγραψε: On Nov 10, 2013, at 7:46 PM, Νίκος Αλεξόπουλος wrote: You are a moron Rumor has it you are the head of ELSTAT, the Hellenic Statistical Authority. Any truth to that? Perhaps i'm working for NSA too and i was assigned to keep a

Re: To whoever hacked into my Database

2013-11-10 Thread Νίκος Αλεξόπουλος
Στις 10/11/2013 7:57 μμ, ο/η Petite Abeille έγραψε: On Nov 10, 2013, at 4:28 PM, Antoon Pardon wrote: You are a perfect example of the arrogance of the ignorant. Finally! The Dunning–Kruger effect proven beyond a doubt. You are a moron, no doubt! Freddy Kruger Effect! -- https://mail.p

Re: To whoever hacked into my Database

2013-11-10 Thread Νίκος Αλεξόπουλος
Στις 10/11/2013 5:28 μμ, ο/η Antoon Pardon έγραψε: Op 10-11-13 16:01, Νίκος Αλεξόπουλος schreef: Στις 10/11/2013 3:49 μμ, ο/η Antoon Pardon έγραψε: Op 10-11-13 11:32, Νίκος Αλεξόπουλος schreef: Ha, ha ha! I'm safe now!! No breaks in this time! You just can't help yourself,

Re: To whoever hacked into my Database

2013-11-10 Thread Νίκος Αλεξόπουλος
Στις 10/11/2013 4:45 μμ, ο/η Mark Lawrence έγραψε: On 10/11/2013 10:32, Νίκος Αλεξόπουλος wrote: Ha, ha ha! I'm safe now!! No breaks in this time! She's just biding her time again. Or was it the little fingers of my team? Tell your female friend to polish her nails or d

Re: To whoever hacked into my Database

2013-11-10 Thread Νίκος Αλεξόπουλος
Στις 10/11/2013 3:49 μμ, ο/η Antoon Pardon έγραψε: Op 10-11-13 11:32, Νίκος Αλεξόπουλος schreef: Στις 10/11/2013 12:20 πμ, ο/η Chris Angelico έγραψε: There are two major problems with what you did here, Nikos, and they are: 1) Starting with a hopelessly insecure system and then trying to

Re: To whoever hacked into my Database

2013-11-10 Thread Νίκος Αλεξόπουλος
Στις 10/11/2013 12:20 πμ, ο/η Chris Angelico έγραψε: On Sun, Nov 10, 2013 at 2:32 AM, Antoon Pardon wrote: And i had until i made some new changes last night, which i think i have corrected now as we speak. Continuing the arrogance. Just to put that in perspective, by the way: *EVERYONE* w

Re: To whoever hacked into my Database

2013-11-09 Thread Νίκος Αλεξόπουλος
Στις 9/11/2013 5:07 μμ, ο/η Steven D'Aprano έγραψε: On Sat, 09 Nov 2013 09:05:51 +0200, Νίκος Αλεξόπουλος wrote: Its probably unwise to post the following snippet of code that validates user input so an attacker wouldn't pass arbitrary values to my script but what the heck

Re: To whoever hacked into my Database

2013-11-09 Thread Νίκος Αλεξόπουλος
Στις 9/11/2013 5:07 μμ, ο/η Steven D'Aprano έγραψε: On Sat, 09 Nov 2013 09:05:51 +0200, Νίκος Αλεξόπουλος wrote: Its probably unwise to post the following snippet of code that validates user input so an attacker wouldn't pass arbitrary values to my script but what the heck

Re: datetime question

2013-11-09 Thread Νίκος Αλεξόπουλος
Στις 9/11/2013 2:45 μμ, ο/η Mark Lawrence έγραψε: On 08/11/2013 23:02, Νίκος Αλεξόπουλος wrote: Στις 9/11/2013 12:49 πμ, ο/η Denis McMahon έγραψε: On Sat, 09 Nov 2013 00:01:37 +0200, Νίκος Αλεξόπουλος wrote: I saw the link and i'm wondering if it can be written in 1-liner. Yes, bu

Re: To whoever hacked into my Database

2013-11-09 Thread Νίκος Αλεξόπουλος
Στις 9/11/2013 10:39 πμ, ο/η Chris Angelico έγραψε: On Sat, Nov 9, 2013 at 7:31 PM, Νίκος Αλεξόπουλος wrote: if page and os.path.isfile( cgi_path + page ) in os.listdir( cgi_path ): Try pass bogus values again into my database! Well done! *slow clap* In the interests of security, you have

Re: To whoever hacked into my Database

2013-11-09 Thread Νίκος Αλεξόπουλος
Στις 9/11/2013 10:39 πμ, ο/η Chris Angelico έγραψε: On Sat, Nov 9, 2013 at 7:31 PM, Νίκος Αλεξόπουλος wrote: if page and os.path.isfile( cgi_path + page ) in os.listdir( cgi_path ): Try pass bogus values again into my database! Well done! *slow clap* In the interests of security, you have

Re: To whoever hacked into my Database

2013-11-09 Thread Νίκος Αλεξόπουλος
Στις 9/11/2013 9:54 πμ, ο/η Νίκος Αλεξόπουλος έγραψε: Στις 9/11/2013 9:05 πμ, ο/η Νίκος Αλεξόπουλος έγραψε: Στις 9/11/2013 8:37 πμ, ο/η Chris Angelico έγραψε: On Sat, Nov 9, 2013 at 5:32 PM, Νίκος Αλεξόπουλος wrote: I'am not saying out of arrogance but i was really under the impression

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 9/11/2013 9:05 πμ, ο/η Νίκος Αλεξόπουλος έγραψε: Στις 9/11/2013 8:37 πμ, ο/η Chris Angelico έγραψε: On Sat, Nov 9, 2013 at 5:32 PM, Νίκος Αλεξόπουλος wrote: I'am not saying out of arrogance but i was really under the impression i had secure my script. And i had until i made som

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 9/11/2013 9:19 πμ, ο/η Chris Angelico έγραψε: On Sat, Nov 9, 2013 at 6:11 PM, Νίκος Αλεξόπουλος wrote: These 4 are yours for sure: mail14.ess.barracuda.com mail0.ess.barracuda.com 209.133.77.167.T01713-01.above.net 209.133.77.164.T01713-01.above.net This one '89-145-108-205.as2901

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 9/11/2013 8:45 πμ, ο/η Chris Angelico έγραψε: On Sat, Nov 9, 2013 at 5:35 PM, Νίκος Αλεξόπουλος wrote: I believe these hostnames belong to you: mail14.ess.barracuda.com mail0.ess.barracuda.com 89-145-108-205.as29017.net 209.133.77.167.T01713-01.above.net 209.133.77.164.T01713-01

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 9/11/2013 8:37 πμ, ο/η Chris Angelico έγραψε: On Sat, Nov 9, 2013 at 5:32 PM, Νίκος Αλεξόπουλος wrote: I'am not saying out of arrogance but i was really under the impression i had secure my script. And i had until i made some new changes last night, which i think i have corrected n

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 9/11/2013 8:20 πμ, ο/η Chris Angelico έγραψε: On Sat, Nov 9, 2013 at 4:54 PM, Νίκος Αλεξόπουλος wrote: Στις 6/11/2013 5:25 μμ, ο/η Νίκος Γκρ33κ έγραψε: Okey let the hacker try again to mess with my database!!! He is done it twice, lets see if he will make it again! I'am waiting!

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 9/11/2013 8:20 πμ, ο/η Chris Angelico έγραψε: On Sat, Nov 9, 2013 at 4:54 PM, Νίκος Αλεξόπουλος wrote: Στις 6/11/2013 5:25 μμ, ο/η Νίκος Γκρ33κ έγραψε: Okey let the hacker try again to mess with my database!!! He is done it twice, lets see if he will make it again! I'am waiting!

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 9/11/2013 7:54 πμ, ο/η Νίκος Αλεξόπουλος έγραψε: Στις 6/11/2013 5:25 μμ, ο/η Νίκος Γκρ33κ έγραψε: Okey let the hacker try again to mess with my database!!! He is done it twice, lets see if he will make it again! I'am waiting! I have to congratulate the hacher because as it se

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 6/11/2013 5:25 μμ, ο/η Νίκος Γκρ33κ έγραψε: Okey let the hacker try again to mess with my database!!! He is done it twice, lets see if he will make it again! I'am waiting! I have to congratulate the hacher because as it seems s/he's done it again. S/he's manages to actually pass fake f

Re: datetime question

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 9/11/2013 12:49 πμ, ο/η Denis McMahon έγραψε: On Sat, 09 Nov 2013 00:01:37 +0200, Νίκος Αλεξόπουλος wrote: I saw the link and i'm wondering if it can be written in 1-liner. Yes, but you have to rewrite all your code in perl to do this. Please tell me and as a git i will provid

Re: datetime question

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 11:29 μμ, ο/η Mark Lawrence έγραψε: On 08/11/2013 21:11, Νίκος Αλεξόπουλος wrote: Is there someway to write the following line even better with the ability to detect daylight saving time by itself so i don't have to alter the line manually when time changes? last

datetime question

2013-11-08 Thread Νίκος Αλεξόπουλος
Is there someway to write the following line even better with the ability to detect daylight saving time by itself so i don't have to alter the line manually when time changes? lastvisit = ( datetime.utcnow() + timedelta(hours=2) ).strftime( '%y-%m-%d %H:%M:%S' )# MySQL datetime format

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 7:11 μμ, ο/η ru...@yahoo.com έγραψε: On 11/08/2013 03:05 AM, Νίκος Αλεξόπουλος wrote: I never ignore advices. I read all answers as carefully as i can. But nevertheless sometimes i feel things should have been better implemented using my way. Not of course that i know better

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 8:19 μμ, ο/η Denis McMahon έγραψε: On Fri, 08 Nov 2013 01:28:19 +0200, Νίκος Αλεξόπουλος wrote: If i was completely incompetent i wouldn't had a working website and i wasn't able to design my customers' webpages. If your website is working, why do you keep post

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 7:01 μμ, ο/η unknown έγραψε: On Fri, 08 Nov 2013 18:57:21 +0200, Νίκος Αλεξόπουλος wrote: Στις 8/11/2013 6:48 μμ, ο/η unknown έγραψε: On Fri, 08 Nov 2013 18:28:39 +0200, Νίκος Αλεξόπουλος wrote: Στις 8/11/2013 6:06 μμ, ο/η Mark Lawrence έγραψε: But let's not waste any

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 6:48 μμ, ο/η unknown έγραψε: On Fri, 08 Nov 2013 18:28:39 +0200, Νίκος Αλεξόπουλος wrote: Στις 8/11/2013 6:06 μμ, ο/η Mark Lawrence έγραψε: But let's not waste any more time on this. Please get back to checking your web site. She might have been hacking again. Or l

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 6:06 μμ, ο/η Mark Lawrence έγραψε: But let's not waste any more time on this. Please get back to checking your web site. She might have been hacking again. Or little fingers from one of my highly paid contractors might have been up to no good. Oh but I forgot, you've made it ha

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 4:02 μμ, ο/η Mark Lawrence έγραψε: On 08/11/2013 10:09, Chris Angelico wrote: On Fri, Nov 8, 2013 at 9:00 PM, Mark Lawrence wrote: On 08/11/2013 09:52, Chris Angelico wrote: Mar-Kal El-awrence! Able to leap tall bridges in a single bound, more powerful than a steaming (and fumi

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 3:30 μμ, ο/η Mark Lawrence έγραψε: On 08/11/2013 10:00, Νίκος Αλεξόπουλος wrote: I have never exposed my client's data. Prove otherwise. If your site has successfully been hacked *TWICE* then by definition your clients data has been exposed. Didn't you also han

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 3:12 μμ, ο/η Tim Delaney έγραψε: On 8 November 2013 21:00, Νίκος Αλεξόπουλος mailto:nikos.gr...@gmail.com>> wrote: I have never exposed my client's data. Prove otherwise. https://mail.python.org/pipermail/python-list/2013-June/648550.html Or don't you con

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 11:55 πμ, ο/η Mark Lawrence έγραψε: On 08/11/2013 09:39, Νίκος Αλεξόπουλος wrote: You wouldn't be able to write the scripts i have written. All you do is criticize me, but you never ever have posted code to anything i have asked. Perhaps you can't even write a sim

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 11:52 πμ, ο/η Mark Lawrence έγραψε: On 08/11/2013 09:34, Νίκος Αλεξόπουλος wrote: Στις 8/11/2013 11:15 πμ, ο/η Mark Lawrence έγραψε: On 08/11/2013 01:32, alex23 wrote: On 8/11/2013 7:39 AM, Ian Kelly wrote: Unless the Python installation on Nikos' system has become self-

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 11:19 πμ, ο/η Mark Lawrence έγραψε: On 08/11/2013 08:59, Νίκος Αλεξόπουλος wrote: Στις 8/11/2013 10:31 πμ, ο/η Chris Angelico έγραψε: On Fri, Nov 8, 2013 at 7:20 PM, Νίκος Αλεξόπουλος wrote: Fortunately for me they have all failed. That means that i have *actually* made

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 11:19 πμ, ο/η Mark Lawrence έγραψε: On 08/11/2013 08:59, Νίκος Αλεξόπουλος wrote: Στις 8/11/2013 10:31 πμ, ο/η Chris Angelico έγραψε: On Fri, Nov 8, 2013 at 7:20 PM, Νίκος Αλεξόπουλος wrote: Fortunately for me they have all failed. That means that i have *actually* made

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 11:15 πμ, ο/η Mark Lawrence έγραψε: On 08/11/2013 01:32, alex23 wrote: On 8/11/2013 7:39 AM, Ian Kelly wrote: Unless the Python installation on Nikos' system has become self-aware and is actively objecting to his code, I think that messages like "Read a manual" and "Learn to code

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 10:31 πμ, ο/η Chris Angelico έγραψε: On Fri, Nov 8, 2013 at 7:20 PM, Νίκος Αλεξόπουλος wrote: Fortunately for me they have all failed. That means that i have *actually* made security of my scripts stronger. Now whoever called me incompetent should think again before he accused

Re: To whoever hacked into my Database

2013-11-08 Thread Νίκος Αλεξόπουλος
Στις 6/11/2013 5:25 μμ, ο/η Νίκος Γκρ33κ έγραψε: Okey let the hacker try again to mess with my database!!! He is done it twice, lets see if he will make it again! I'am waiting! I'am pleased to see that various ppl have tried to mess my db by 1. submitted my webiste to netcraft.com for secuc

Re: To whoever hacked into my Database

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 1:18 πμ, ο/η Grant Edwards έγραψε: On 2013-11-07, ?? ?? wrote: 8/11/2013 1:04 , ??/?? Chris Angelico : On Fri, Nov 8, 2013 at 9:56 AM, ?? ?? wrote: Also i never claimed i was a professional cod

Re: To whoever hacked into my Database

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 1:04 πμ, ο/η Chris Angelico έγραψε: On Fri, Nov 8, 2013 at 9:56 AM, Νίκος Αλεξόπουλος wrote: Also i never claimed i was a professional coder, i am an amateur at a beginner level and i do it out of hobby. You've stated a number of times that your problems are critical be

Re: To whoever hacked into my Database

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 8/11/2013 12:46 πμ, ο/η Tim Delaney έγραψε: On 8 November 2013 09:45, Tim Delaney mailto:timothy.c.dela...@gmail.com>> wrote: On 8 November 2013 09:18, Νίκος Αλεξόπουλος mailto:nikos.gr...@gmail.com>> wrote: I feel a bit proud because as it seems i have manag

Re: To whoever hacked into my Database

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 7/11/2013 11:29 μμ, ο/η Denis McMahon έγραψε: On Thu, 07 Nov 2013 01:01:38 -0800, Ferrous Cranus wrote: Τη Πέμπτη, 7 Νοεμβρίου 2013 12:11:20 π.μ. UTC+2, ο χρήστης Mark Lawrence έγραψε: ... hope that this time she destroys ... So she is a SHE! How do you know that the person hacked in

Re: To whoever hacked into my Database

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 7/11/2013 11:45 μμ, ο/η Joel Goldstick έγραψε: On Thu, Nov 7, 2013 at 4:39 PM, Ian Kelly wrote: On Thu, Nov 7, 2013 at 2:20 PM, Denis McMahon wrote: I think the hacker is a figment of Nick's imagination, or rather a consequence of his broken python code corrupting his data. Unless the

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 7/11/2013 8:08 μμ, ο/η Neil Cerutti έγραψε: On 2013-11-07, ?? ?? wrote: I called you an idiot, because in your previous and current message you called me too. I know that splitting information across tables and maintain foreign keys for retain relationships bet

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 7/11/2013 5:11 μμ, ο/η Joel Goldstick έγραψε: On Thu, Nov 7, 2013 at 9:37 AM, Chris Angelico wrote: On Fri, Nov 8, 2013 at 1:09 AM, Νίκος Αλεξόπουλος wrote: Why create a whole new 'downloads' table and associate it with the with a foreign key with the 'visitors' tabl

Re: To whoever hacked into my Database

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 7/11/2013 6:45 μμ, ο/η Joel Goldstick έγραψε: On Thu, Nov 7, 2013 at 11:34 AM, Mark Lawrence wrote: On 07/11/2013 13:47, Νίκος Αλεξόπουλος wrote: Στις 7/11/2013 11:31 πμ, ο/η Ferrous Cranus έγραψε: Τη Πέμπτη, 7 Νοεμβρίου 2013 11:15:02 π.μ. UTC+2, ο χρήστης Steve Simmons έγραψε

Re: To whoever hacked into my Database

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 7/11/2013 6:34 μμ, ο/η Mark Lawrence έγραψε: On 07/11/2013 13:47, Νίκος Αλεξόπουλος wrote: Στις 7/11/2013 11:31 πμ, ο/η Ferrous Cranus έγραψε: Τη Πέμπτη, 7 Νοεμβρίου 2013 11:15:02 π.μ. UTC+2, ο χρήστης Steve Simmons έγραψε: Please tell me you aren't storing details of customer

Re: To whoever hacked into my Database

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 7/11/2013 3:59 μμ, ο/η Chris Angelico έγραψε: On Fri, Nov 8, 2013 at 12:46 AM, Νίκος Αλεξόπουλος wrote: How much will it cost to take to convert my current 'counters.py' script to a 'webpy' framework style? Please make a really good price. We are talking about a smal

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 7/11/2013 3:52 μμ, ο/η Joel Goldstick έγραψε: 2. the download is remained associated with the person that made the download since all this info is placed in the same record. just think, all those folks who figured out databases were wrong. Nikos has shown that you just need to put everythin

Re: To whoever hacked into my Database

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 7/11/2013 11:31 πμ, ο/η Ferrous Cranus έγραψε: Τη Πέμπτη, 7 Νοεμβρίου 2013 11:15:02 π.μ. UTC+2, ο χρήστης Steve Simmons έγραψε: Please tell me you aren't storing details of customers and payments on your Web > server. Oh but i do! I need this information to be accessible ONLY FOR ME vi

Re: To whoever hacked into my Database

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 7/11/2013 12:06 μμ, ο/η Alister έγραψε: On Thu, 07 Nov 2013 01:31:17 -0800, Ferrous Cranus wrote: Τη Πέμπτη, 7 Νοεμβρίου 2013 11:15:02 π.μ. UTC+2, ο χρήστης Steve Simmons έγραψε: Please tell me you aren't storing details of customers and payments on your Web > server. Oh but i do! I n

Re: Adding 'download' column to existing 'visitors' table (as requested)

2013-11-07 Thread Νίκος Αλεξόπουλος
Στις 6/11/2013 7:59 μμ, ο/η Denis McMahon έγραψε: On Wed, 06 Nov 2013 09:30:03 +0200, Nick the Gr33k wrote: I have decided to take your advice. No you haven't. You only think you have, but really you either haven't understood the advice at all. My implementation is like the following. I do

Cookie aint retrieving when visiting happens from a backlink.

2013-10-25 Thread Νίκος Αλεξόπουλος
[code] Hello, i was happy to see that a python module for geoip2 came out. But unfortunately when i tried to install it: root@secure [~]# pip install geoip2[DB] Downloading/unpacking geoip2[db] Running setup.py egg_info for package geoip2 Traceback (most recent call last): File "", l

Re: Cookie aint retrieving when visiting happens from a backlink.

2013-10-25 Thread Νίκος Αλεξόπουλος
Στις 25/10/2013 11:33 πμ, ο/η Chris Angelico έγραψε: On Fri, Oct 25, 2013 at 7:25 PM, Νίκος Αλεξόπουλος wrote: Isn't this strange? No matter if you visit a webpage as a direct hit or via a referer the cookie on the visitor's browser should have been present. But it can only can be

Re: Cookie aint retrieving when visiting happens from a backlink.

2013-10-25 Thread Νίκος Αλεξόπουλος
Στις 25/10/2013 10:32 πμ, ο/η Chris Angelico έγραψε: On Fri, Oct 25, 2013 at 6:22 PM, Νίκος Αλεξόπουλος wrote: Can somebody explain why this is happening? You can see this action yourself by hitting: 1. superhost.gr as a direct hit 2. by clicking superhost.gr's backlink from ypsiland

Re: Cookie aint retrieving when visiting happens from a backlink.

2013-10-25 Thread Νίκος Αλεξόπουλος
Στις 25/10/2013 10:32 πμ, ο/η Chris Angelico έγραψε: On Fri, Oct 25, 2013 at 6:22 PM, Νίκος Αλεξόπουλος wrote: Can somebody explain why this is happening? You can see this action yourself by hitting: 1. superhost.gr as a direct hit 2. by clicking superhost.gr's backlink from ypsiland

Cookie aint retrieving when visiting happens from a backlink.

2013-10-25 Thread Νίκος Αλεξόπουλος
Hello i having the following code to try and retrieve the visitor's saved cookie form the browser. [CODE] # initialize cookie and retrieve cookie from clients browser try: cookie = cookies.SimpleCookie( os.environ['HTTP_COOKIE'] ) cookieID = cookie['name'].value except: c

Re: Printing a drop down menu for a specific field.

2013-10-21 Thread Νίκος Αλεξόπουλος
Στις 21/10/2013 9:58 πμ, ο/η Steven D'Aprano έγραψε: On Mon, 21 Oct 2013 09:07:17 +0300, Νίκος Αλεξόπουλος wrote: for row in data: (host, city, useros, browser, ref, hits, lastvisit) = row lastvisit = lastvisit.strftime('%A %e %b, %H:%M')

Re: Printing a drop down menu for a specific field.

2013-10-20 Thread Νίκος Αλεξόπουλος
Στις 21/10/2013 2:30 πμ, ο/η Νίκος Αλεξόπουλος έγραψε: try: cur.execute( '''SELECT host, city, useros, browser, ref, hits, lastvisit FROM visitors WHERE counterID = (SELECT ID FROM counters WHERE url = %s) ORDER BY lastvisit DESC''', page ) data = cur.fe

Printing a drop down menu for a specific field.

2013-10-20 Thread Νίκος Αλεξόπουλος
try: cur.execute( '''SELECT host, city, useros, browser, ref, hits, lastvisit FROM visitors WHERE counterID = (SELECT ID FROM counters WHERE url = %s) ORDER BY lastvisit DESC''', page ) data = cur.fetchall() for row in data: (host, city, useros,

Re: Cookie gets changed when hit comes from a referrer

2013-10-09 Thread Νίκος Αλεξόπουλος
Στις 9/10/2013 9:36 μμ, ο/η Piet van Oostrum έγραψε: Νίκος Αλεξόπουλος writes: # initialize cookie and retrieve cookie from clients browser cookie = cookies.SimpleCookie( os.environ['HTTP_COOKIE'] ) if cookie.get('ID') is not None: cookieID = coo

Re: Cookie gets changed when hit comes from a referrer

2013-10-09 Thread Νίκος Αλεξόπουλος
Στις 9/10/2013 5:43 μμ, ο/η Denis McMahon έγραψε: On Wed, 09 Oct 2013 01:52:44 +0300, Νίκος Αλεξόπουλος wrote: Στις 8/10/2013 10:29 μμ, ο/η Denis McMahon έγραψε: Have you checked the cookie jar in the browser to see what value the cookie has? Is that the value you think it should have? Note

Re: Cookie gets changed when hit comes from a referrer

2013-10-09 Thread Νίκος Αλεξόπουλος
Στις 9/10/2013 4:33 πμ, ο/η Steven D'Aprano έγραψε: On Wed, 09 Oct 2013 01:52:44 +0300, Νίκος Αλεξόπουλος wrote: Is there something i can try to isolate the problem and make it work? Of course there is. That is part of the job of the developer: hard work trying dozens, maybe hundre

Re: Cookie gets changed when hit comes from a referrer

2013-10-08 Thread Νίκος Αλεξόπουλος
Στις 9/10/2013 7:53 πμ, ο/η Ian Kelly έγραψε: On Tue, Oct 8, 2013 at 8:18 AM, Νίκος Αλεξόπουλος wrote: Also i have set: ookie['ID']['expires'] = 60*60*24*365 #this cookie will expire in a year The Expires attribute takes a date. If you're passing an int

Re: Cookie gets changed when hit comes from a referrer

2013-10-08 Thread Νίκος Αλεξόπουλος
Στις 8/10/2013 10:29 μμ, ο/η Denis McMahon έγραψε: On Tue, 08 Oct 2013 19:04:37 +0300, Νίκος Αλεξόπουλος wrote: Can you help me with this particuler problem please? Unfortunately I can't, because I am unable to reproduce the problem you describe. When I load my test page in the br

Re: Cookie gets changed when hit comes from a referrer

2013-10-08 Thread Νίκος Αλεξόπουλος
Is there any better way to identif a previous visitor? i tried cookies which failed for me for the reason i opened this thread and host like follows: # try to locate the visitor cur.execute('''SELECT * FROM visitors WHERE counterID = %s and host = %s''', (cID, host) )

Re: Cookie gets changed when hit comes from a referrer

2013-10-08 Thread Νίκος Αλεξόπουλος
Στις 8/10/2013 6:55 μμ, ο/η Denis McMahon έγραψε: On Tue, 08 Oct 2013 13:04:34 +0300, Νίκος Αλεξόπουλος wrote: I use this code to retrive or set a cookie to the visitor's browser if present and identify him bu it. You are aware that using cookies to track a user who doesn't

Re: Cookie gets changed when hit comes from a referrer

2013-10-08 Thread Νίκος Αλεξόπουλος
Στις 8/10/2013 2:08 μμ, ο/η Ian Kelly έγραψε: This question is really about HTTP, not Python, so you'd have better luck asking elsewhere. The most likely possibility is that the domain doesn't match. For example, the cookie is set for the domain www.foo.com, and the other webpage is linking to

Re: Cookie gets changed when hit comes from a referrer

2013-10-08 Thread Νίκος Αλεξόπουλος
Στις 8/10/2013 2:08 μμ, ο/η Ian Kelly έγραψε: On Tue, Oct 8, 2013 at 4:04 AM, Νίκος Αλεξόπουλος wrote: I use this code to retrive or set a cookie to the visitor's browser if present and identify him bu it. All work well except the situation where the user visits my webpage by click

Cookie gets changed when hit comes from a referrer

2013-10-08 Thread Νίκος Αλεξόπουλος
# initialize cookie and retrieve cookie from clients browser cookie = cookies.SimpleCookie( os.environ.get('HTTP_COOKIE') ) if cookie.get('ID') is not None: cookieID = cookie['ID'].value else: cookieID = random.randrange(0, ) cookie['ID'] = cookieID cookie['ID'

Re: inserting or updating appropriately

2013-10-08 Thread Νίκος Αλεξόπουλος
Στις 8/10/2013 12:15 μμ, ο/η Νίκος Αλεξόπουλος έγραψε: Hello, i'am trying to insert a new record or update an existing one in case counterID(stands for the page's URL) and cookieID(random number) is the same: try: # if first time for webpage; create new record( prim

inserting or updating appropriately

2013-10-08 Thread Νίκος Αλεξόπουλος
Hello, i'am trying to insert a new record or update an existing one in case counterID(stands for the page's URL) and cookieID(random number) is the same: try: # if first time for webpage; create new record( primary key is automatic, hit is defaulted ), if page exists then update reco

Re: Database statements via python but database left intact

2013-10-06 Thread Νίκος Αλεξόπουλος
Στις 6/10/2013 6:52 μμ, ο/η Adam Tauno Williams έγραψε: Are you sure that you're committing your changes (either by having autocommit set or using an explicit con.commit() call)? http://geert.vanderkelen.org/dont-forget-the-commit-in-mysql/ I dont think that is the issue, because up until now i

Re: Database statements via python but database left intact

2013-10-06 Thread Νίκος Αλεξόπουλος
Στις 6/10/2013 12:45 πμ, ο/η Zero Piraeus έγραψε: : On Sun, Oct 06, 2013 at 12:02:14AM +0300, Νίκος Αλεξόπουλος wrote: I neved had though of than an engine type could make so much mess. MyISAM is the way to go then for my web development? Why InnoDB failed to execute the queries? Because you

Re: Select fails when cookie tried to get a numeric value

2013-10-05 Thread Νίκος Αλεξόπουλος
Στις 6/10/2013 2:36 πμ, ο/η Denis McMahon έγραψε: On Sat, 05 Oct 2013 16:38:14 +0300, Νίκος Αλεξόπουλος wrote: [my cookie code is fucked] Hi Nick I had never used python for www before yesterday. I had never used python before about 6 months ago. In the last 24 hours I have installed mod

Re: Database statements via python but database left intact

2013-10-05 Thread Νίκος Αλεξόπουλος
Στις 5/10/2013 11:31 μμ, ο/η Ian Kelly έγραψε: Well, have you changed anything in your database configuration? Whether MySQL uses transactions or not depends on which storage engine is being used. I suggest running a test insert with and without commit to check whether you actually need it or no

Re: Database statements via python but database left intact

2013-10-05 Thread Νίκος Αλεξόπουλος
Στις 5/10/2013 10:29 μμ, ο/η Zero Piraeus έγραψε: : On Sat, Oct 05, 2013 at 10:16:46PM +0300, Νίκος Αλεξόπουλος wrote: Excuse me for asking again today, but i see no error in the following code, yes no isertion or update happens into the database: [...] When this code runs i check instantly

Re: Database statements via python but database left intact

2013-10-05 Thread Νίκος Αλεξόπουλος
Actually the whole code is this: # = # DATABASE INSERTS - # = if cooki

Database statements via python but database left intact

2013-10-05 Thread Νίκος Αλεξόπουλος
Excuse me for asking again today, but i see no error in the following code, yes no isertion or update happens into the database: try: # locate the ID of the page's URL cur.execute('''SELECT ID FROM counters WHERE url = %s''', page ) data = cur.fetchone() #URL is unique, so should only

Re: Select fails when cookie tried to get a numeric value

2013-10-05 Thread Νίκος Αλεξόπουλος
Στις 5/10/2013 7:56 μμ, ο/η Andreas Perstinger έγραψε: On 05.10.2013 16:24, Νίκος Αλεξόπουλος wrote: # initialize cookie cookie = cookies.SimpleCookie( os.environ.get('HTTP_COOKIE') ) cookie.load( cookie ) Watch: >>> cookie1 = cookies.SimpleCookie('ID=42

Re: Select fails when cookie tried to get a numeric value

2013-10-05 Thread Νίκος Αλεξόπουλος
Στις 5/10/2013 7:42 μμ, ο/η Ned Batchelder έγραψε: A better solution is to check to see if you got None: if cookie.get('ID') is None: # make a new cookie I have tried everythign even wgat you suggested right now: here is is: # initialize cookie and retrieve cookie from clie

Re: Select fails when cookie tried to get a numeric value

2013-10-05 Thread Νίκος Αλεξόπουλος
Στις 5/10/2013 7:14 μμ, ο/η Νίκος Αλεξόπουλος έγραψε: Στις 5/10/2013 7:08 μμ, ο/η Ned Batchelder έγραψε: On 10/5/13 11:52 AM, Νίκος Αλεξόπουλος wrote: Στις 5/10/2013 6:12 μμ, ο/η Ned Batchelder έγραψε: On 10/5/13 10:40 AM, Νίκος Αλεξόπουλος wrote: Στις 5/10/2013 4:53 μμ, ο/η Ned Batchelder

Re: Select fails when cookie tried to get a numeric value

2013-10-05 Thread Νίκος Αλεξόπουλος
Στις 5/10/2013 7:08 μμ, ο/η Ned Batchelder έγραψε: On 10/5/13 11:52 AM, Νίκος Αλεξόπουλος wrote: Στις 5/10/2013 6:12 μμ, ο/η Ned Batchelder έγραψε: On 10/5/13 10:40 AM, Νίκος Αλεξόπουλος wrote: Στις 5/10/2013 4:53 μμ, ο/η Ned Batchelder έγραψε: From reading the bottom-most frame, you can

Re: Select fails when cookie tried to get a numeric value

2013-10-05 Thread Νίκος Αλεξόπουλος
Στις 5/10/2013 6:12 μμ, ο/η Ned Batchelder έγραψε: On 10/5/13 10:40 AM, Νίκος Αλεξόπουλος wrote: Στις 5/10/2013 4:53 μμ, ο/η Ned Batchelder έγραψε: From reading the bottom-most frame, you can see that the problem is that "val" is an http.cookies.Morsel object. This means you prob

Re: Select fails when cookie tried to get a numeric value

2013-10-05 Thread Νίκος Αλεξόπουλος
Στις 5/10/2013 6:06 μμ, ο/η Zero Piraeus έγραψε: : On Sat, Oct 05, 2013 at 05:40:23PM +0300, Νίκος Αλεξόπουλος wrote: When i print CookieID i was under the impression i would see a random number like '5369' but instead it display the follwong. Set-Cookie: ID="Set-Cookie: ID

Re: Select fails when cookie tried to get a numeric value

2013-10-05 Thread Νίκος Αλεξόπουλος
Στις 5/10/2013 6:12 μμ, ο/η Ned Batchelder έγραψε: On 10/5/13 10:40 AM, Νίκος Αλεξόπουλος wrote: Στις 5/10/2013 4:53 μμ, ο/η Ned Batchelder έγραψε: From reading the bottom-most frame, you can see that the problem is that "val" is an http.cookies.Morsel object. This means you prob

Re: Select fails when cookie tried to get a numeric value

2013-10-05 Thread Νίκος Αλεξόπουλος
Στις 5/10/2013 5:43 μμ, ο/η Ned Batchelder έγραψε: On 10/5/13 10:30 AM, Νίκος Αλεξόπουλος wrote: Στις 5/10/2013 5:28 μμ, ο/η Chris Angelico έγραψε: On Sun, Oct 6, 2013 at 12:24 AM, Νίκος Αλεξόπουλος wrote: But i have given you the line that produces the error: The statement you quoted is

Re: Select fails when cookie tried to get a numeric value

2013-10-05 Thread Νίκος Αλεξόπουλος
Στις 5/10/2013 4:53 μμ, ο/η Ned Batchelder έγραψε: From reading the bottom-most frame, you can see that the problem is that "val" is an http.cookies.Morsel object. This means you probably tried to use a cookie object as data in your SQL query, and MySQL doesn't know what to do with that object

Re: Select fails when cookie tried to get a numeric value

2013-10-05 Thread Νίκος Αλεξόπουλος
Στις 5/10/2013 5:28 μμ, ο/η Chris Angelico έγραψε: On Sun, Oct 6, 2013 at 12:24 AM, Νίκος Αλεξόπουλος wrote: But i have given you the line that produces the error: The statement you quoted is an INSERT. The traceback quotes a SELECT. These are not the same line of code. You still have not

Re: Select fails when cookie tried to get a numeric value

2013-10-05 Thread Νίκος Αλεξόπουλος
Στις 5/10/2013 5:24 μμ, ο/η Νίκος Αλεξόπουλος έγραψε: Στις 5/10/2013 4:59 μμ, ο/η Chris Angelico έγραψε: On Sat, Oct 5, 2013 at 11:38 PM, Νίκος Αλεξόπουλος wrote: cur.execute('''INSERT INTO visitors (counterID, cookieID, host, city, useros, browser, ref, lastvisit) VALUES (%s,

Re: Select fails when cookie tried to get a numeric value

2013-10-05 Thread Νίκος Αλεξόπουλος
Στις 5/10/2013 4:59 μμ, ο/η Chris Angelico έγραψε: On Sat, Oct 5, 2013 at 11:38 PM, Νίκος Αλεξόπουλος wrote: cur.execute('''INSERT INTO visitors (counterID, cookieID, host, city, useros, browser, ref, lastvisit) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)''', (cID, vi

Select fails when cookie tried to get a numeric value

2013-10-05 Thread Νίκος Αλεξόπουλος
# initialize cookie cookie = cookies.SimpleCookie( os.environ.get('HTTP_COOKIE') ) cookie.load( cookie ) vip = cookie.get('ID') ... ... # if browser cookie does not exist, set it vip = random.randrange(0, 1) cookie['ID'] = vip cookie['ID']['path'] = '/' # fir

Re: Can arbitrary code run in a server if someone's know just the MySQL password?

2013-10-02 Thread Νίκος Αλεξόπουλος
Στις 2/10/2013 8:39 μμ, ο/η Steven D'Aprano έγραψε: On Wed, 02 Oct 2013 16:41:40 +0300, Νίκος wrote: Στις 2/10/2013 4:25 μμ, ο/η Steven D'Aprano έγραψε: On Wed, 02 Oct 2013 15:20:00 +0300, Νίκος wrote: Is it possible for someone that knows the MYSQL password of a server to run arbitrary code