Guest Posted October 17, 2008 Posted October 17, 2008 According to the osC documentation, the IP Address is automatically stored in the database for customer accounts and orders. So...how do I go about finding a customer's IP address? I have their name. I have their customer ID number. I have previous order numbers from purchases made in the past. Where do I look? I assume I'll be using phpMyAdmin or something, but...what do I do? Their IP address was not stored in the Admin side of my website. - Andrea
Guest Posted October 17, 2008 Posted October 17, 2008 Why do you need this? you now that the IP of the client could have changed + some (like my one) even change 2 to 3 time a month.
Guest Posted October 17, 2008 Posted October 17, 2008 I want to block him because he is practicing theft of the intellectual property of my website for financial gain. I believe he does this from his home, late at night. He sells some of the same items I do. Some IP addresses are static, some are not. If I could research his orders in the database...I'd find out real fast if he's using a static IP address or one that is dynamically created every time he gets on-line. I just don't know how. - Andrea
Guest Posted October 17, 2008 Posted October 17, 2008 it only get stored on a per session and that is in the table whos_online but if you have cPanel you could look at one of the logs or ask you host for the log? also if it is the images then look at putting on the HotLink Protection
failsafe Posted October 18, 2008 Posted October 18, 2008 Yes, the place you need to look is your detailed web server logs, not in the osCommerce database, unless you can catch them 'at it'. The osC whos_online table is viewable in your admin, and contains the IP address of folks currently (very recently) online. Check your ISP docs for info on how to view your detailed web server logs. An online resource that pulls info out of them to make pretty charts and graphs won't drill down enough to get the info you want. You need the raw server log text files themselves, so you can search for the info you mention. Good luck.
Guest Posted October 18, 2008 Posted October 18, 2008 The raw access log link in Cpanel only prompts me to download a .gz file dated TODAY. I need to find this guy from a month or two ago. I can't open the file, either. The other link, Raw Log Manager, simply tells me I have no archived logs. I'm messing around in phpMyAdmin with the Who's Online table but it's only giving me results from today, as well. - Andrea
germ Posted October 18, 2008 Posted October 18, 2008 In my cPanel, if I go up one level from my public html folder, there is a fodler called logs, and in that is a folder with my domain name. In there are the log files. They look like this in the directory listing: bobscurrency.com.1223683200 gz bobscurrency.com.1223769600 gz bobscurrency.com.1223856000 gz bobscurrency.com.1223942400 gz bobscurrency.com.1224028800 gz bobscurrency.com.1224115200 gz bobscurrency.com 1224201600 bobscurrency.com 1224288000 The ones that have gz in them are zipped and I can't view them. The last two are always raw access logs. I can download then and view them in Wordpad. My server zips them every day, but the backups only go back about 5 days. Yours may be different. Unless you know exactly what you're looking for, I don't think they'll be much good to you. :blush: If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Guest Posted October 18, 2008 Posted October 18, 2008 No, he's not linking to my site. It's not theft of photos. Everyone seems to get worked in a frenzy over photos. Hotlinking is one thing, but this problem has nothing to do with that. He's copying and pasting all of my item descriptions into his own item listings on eBay. I also continue to sell a bit on eBay. I had an eBay store for quite some time until the fees became outrageous. I sell back issues of magazines on my website. Most sellers just say...title, date, maybe condition and price. I take the time to write up a comprehensive bible of sorts. You can find material on your favorite actors/actresses via my website because of the time I spend on these magazine descriptions. Very time-intensive and this guy is copying and pasting my hard work into his item listings so he doesn't have to do the work. Think...long, lengthy descriptions regarding every interview, every person photographed, etc. I expect we're all working harder to sell something in 2008 than we were in 2007. The economy is affecting all of us. He and I have been emailing all night. I contacted him earlier this evening when I saw a few of his items on eBay and read him the riot act. I also filed a complaint with Vero...the part of eBay that deals with website theft. I don't expect any help whatsoever there, but...he knows I did and that's what matters right now. We've been chatting back and forth all evening thru eBay's message system. He seems quite apologetic and promises to stop. I think he's a bit panicked over my tone, much less the fact that he was turned in. Hopefully, he'll knock it off and all will be well again. I'm calming down now, I suppose. But, I will keep my eye on him. - Andrea
failsafe Posted October 18, 2008 Posted October 18, 2008 The archived logs are what you'd want (the ones in .gz format), but those from the time you're interested in, obviously. Different ISPs save the logs for different lengths of time, mine for instance lets me access the past 8 weeks worth. I archive them by downloading once a month so I can keep a record if I ever want to check something (such as hacking) to see exactly what happened. FTP is quite sufficient for this. The .gz is 'gzip compression' which is different than the windows zip compression. Gzip is primarily used on UNIX and Linux systems. You could get a gzip/gunzip program for Windows if you want, I'm sure there'll be a free one somewhere on the web you could download. When gunzipped, you'd end up with a text file (usually quite a large one). Each individual file access request made of your web server will be on a single line. There will be a lot of lines. Every single line will have the ip address of the requestor, plus the exact URL they were requesting. It sounds though that you're not that bothered to download them now that you've had the lengthy dialogue with the perpetrator. :)
Guest Posted October 20, 2008 Posted October 20, 2008 Has he stopped?? The dirty bugger. What a lazy sot, stealing all your work! I'm not english, but I like to take the opportunity to call someone a sot whenever possible. And you can tell him I said so too! ;) What is your url? I have a pug/pom (cuter than yours! haha!! Just kidding) so I want to look at your website, whether it has anything to do with our similar taste in dogs or not... Mine doesn't. Mine is jewellery, and I spell it the long way. B) I just like to look at websites... Nicole
Benny125 Posted October 20, 2008 Posted October 20, 2008 This site has good information of internet but give me more information of IP address I like this online merchant ________________________________________________________________________________ _________________________ Gmail Rocks Yahoo Mail Rocks
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.