doctor-doc-tech
|
From: <doctor-doc-tech@li...> - 2012-07-26 13:24:06
|
Hi Markus, there is no indication of an error in catalina.out. The database is up-to-date. I've compared the field format and information of the table 'konto' with the values in the master dump, and they are the same. If I swap out the .war for rev. 416 with the old .war from rev.175, ip-based access works. Regards, Sebastian -----Ursprüngliche Nachricht----- Von: doctor-doc-tech@... [mailto:doctor-doc-tech@...] Gesendet: Donnerstag, 26. Juli 2012 14:59 An: doctor-doc-tech@... Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more after upgrade Hi Sebastian what says catalina.out? Are there any errors, at the end of the file, after trying to take IP-based access? Did you update the database: http://doctor-doc.svn.sourceforge.net/viewvc/doctor-doc/trunk/db/dbchanges_forUpdate?revision=377&view=markup Could easily be, that fetching the account from the DB fails, if there are fields missing e.g. in the table 'konto'. There has been a change with Rev. 202 in this table. Let me know, if this helps. Markus Am 26.07.2012 14:31, schrieb doctor-doc-tech@...: > Hi Markus, > > Thank you for your answer. Besides of the revision, nothing was changed, and it worked in rev. 175. > I have an entry in the table 'text' with TID 22 (auto-increment value), KID 1 (that's the correct account), and TYID 9 with content '192.168.*'. Once I noticed it didn't work I tried adding additional entries with content '192.168.2.1-254' and '192.168.2.34' to check whether the wildcard is the problem, but with no success. > > Any other ideas? > > Regards, > Sebastian > > > -----Ursprüngliche Nachricht----- > Von: doctor-doc-tech@... > [mailto:doctor-doc-tech@...] > Gesendet: Donnerstag, 26. Juli 2012 14:17 > An: doctor-doc-tech@... > Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more > after upgrade > > Hi Sebastian > > do you use IPv6? > > If so, you would need to add your IPs as IPv6 in the database, table 'text'. IPs must have TYID set to 9. Use your KID (Konto-ID) for your account, which is probably 1. Look it up in the table 'konto'. > > I hope this helps. > > Markus > > > Am 26.07.2012 13:01, schrieb doctor-doc-tech@...: >> Hello, >> >> I tried upgrading our local doctor-doc installation from rev. 175 to >> rev. 416. So far, everything seems to have worked fine, only the >> wildcard ip activated for loginless ordering isn't recognised any more. >> I already tried entering an ip address range as well as a single ip >> address, but without change. >> >> Could somebody please check whether it's a problem with our >> installation or a general problem? Anything I could try to remedy this problem? >> >> With kind regards, >> >> Sebastian Schipper >> >> _____________________________________ >> >> Paul-Ehrlich-Institute >> >> Federal Institute for Vaccines and Biomedicines >> >> Paul-Ehrlich-Straße 51-59 >> >> 63225 Langen >> >> Germany >> >> Tel .: 06103 77 1518 >> >> Fax .: 06103 77 1261 >> >> eMail: sebastian.schipper@... >> >> >> >> --------------------------------------------------------------------- >> - >> -------- >> Live Security Virtual Conference >> Exclusive live event will cover all the ways today's security and >> threat landscape has changed and how IT managers can respond. >> Discussions will include endpoint security, mobile security and the >> latest in malware threats. >> http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ >> >> >> >> _______________________________________________ >> Doctor-Doc-tech mailing list >> Doctor-Doc-tech@... >> https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech >> > > ---------------------------------------------------------------------- > -------- > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. > Discussions will include endpoint security, mobile security and the > latest in malware threats. > http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Doctor-Doc-tech mailing list > Doctor-Doc-tech@... > https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech > > ---------------------------------------------------------------------- > -------- > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. > Discussions will include endpoint security, mobile security and the > latest in malware threats. > http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Doctor-Doc-tech mailing list > Doctor-Doc-tech@... > https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech > ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Doctor-Doc-tech mailing list Doctor-Doc-tech@... https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech |
|
From: <doctor-doc-tech@li...> - 2012-07-26 13:45:46
|
Hi Sebastian there have been some changes in IPChecker.java, which may produce different behaviour from Rev. 175 to Rev. 416, although you do not change your IPs in the database. I fear we have to debug this issue... Firt thing to know would be, what looks the IP like, which then will be checked against the DB. Could you maybe add a simple System.out.println(ip); on line 49 of http://doctor-doc.svn.sourceforge.net/viewvc/doctor-doc/trunk/source/util/IPChecker.java?revision=397&view=markup You find this file in source/util/IPChecker.java Markus Am 26.07.2012 15:23, schrieb doctor-doc-tech@...: > Hi Markus, > > there is no indication of an error in catalina.out. The database is up-to-date. I've compared the field format and information of the table 'konto' with the values in the master dump, and they are the same. > > If I swap out the .war for rev. 416 with the old .war from rev.175, ip-based access works. > > Regards, > Sebastian > > > > > -----Ursprüngliche Nachricht----- > Von: doctor-doc-tech@... [mailto:doctor-doc-tech@...] > Gesendet: Donnerstag, 26. Juli 2012 14:59 > An: doctor-doc-tech@... > Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more after upgrade > > Hi Sebastian > > what says catalina.out? Are there any errors, at the end of the file, after trying to take IP-based access? > > Did you update the database: > > http://doctor-doc.svn.sourceforge.net/viewvc/doctor-doc/trunk/db/dbchanges_forUpdate?revision=377&view=markup > > Could easily be, that fetching the account from the DB fails, if there are fields missing e.g. in the table 'konto'. There has been a change with Rev. 202 in this table. > > Let me know, if this helps. > > Markus > > > Am 26.07.2012 14:31, schrieb doctor-doc-tech@...: >> Hi Markus, >> >> Thank you for your answer. Besides of the revision, nothing was changed, and it worked in rev. 175. >> I have an entry in the table 'text' with TID 22 (auto-increment value), KID 1 (that's the correct account), and TYID 9 with content '192.168.*'. Once I noticed it didn't work I tried adding additional entries with content '192.168.2.1-254' and '192.168.2.34' to check whether the wildcard is the problem, but with no success. >> >> Any other ideas? >> >> Regards, >> Sebastian >> >> >> -----Ursprüngliche Nachricht----- >> Von: doctor-doc-tech@... >> [mailto:doctor-doc-tech@...] >> Gesendet: Donnerstag, 26. Juli 2012 14:17 >> An: doctor-doc-tech@... >> Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more >> after upgrade >> >> Hi Sebastian >> >> do you use IPv6? >> >> If so, you would need to add your IPs as IPv6 in the database, table 'text'. IPs must have TYID set to 9. Use your KID (Konto-ID) for your account, which is probably 1. Look it up in the table 'konto'. >> >> I hope this helps. >> >> Markus >> >> >> Am 26.07.2012 13:01, schrieb doctor-doc-tech@...: >>> Hello, >>> >>> I tried upgrading our local doctor-doc installation from rev. 175 to >>> rev. 416. So far, everything seems to have worked fine, only the >>> wildcard ip activated for loginless ordering isn't recognised any more. >>> I already tried entering an ip address range as well as a single ip >>> address, but without change. >>> >>> Could somebody please check whether it's a problem with our >>> installation or a general problem? Anything I could try to remedy this problem? >>> >>> With kind regards, >>> >>> Sebastian Schipper >>> >>> _____________________________________ >>> >>> Paul-Ehrlich-Institute >>> >>> Federal Institute for Vaccines and Biomedicines >>> >>> Paul-Ehrlich-Straße 51-59 >>> >>> 63225 Langen >>> >>> Germany >>> >>> Tel .: 06103 77 1518 >>> >>> Fax .: 06103 77 1261 >>> >>> eMail: sebastian.schipper@... >>> >>> >>> >>> --------------------------------------------------------------------- >>> - >>> -------- >>> Live Security Virtual Conference >>> Exclusive live event will cover all the ways today's security and >>> threat landscape has changed and how IT managers can respond. >>> Discussions will include endpoint security, mobile security and the >>> latest in malware threats. >>> http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ >>> >>> >>> >>> _______________________________________________ >>> Doctor-Doc-tech mailing list >>> Doctor-Doc-tech@... >>> https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech >>> >> >> ---------------------------------------------------------------------- >> -------- >> Live Security Virtual Conference >> Exclusive live event will cover all the ways today's security and >> threat landscape has changed and how IT managers can respond. >> Discussions will include endpoint security, mobile security and the >> latest in malware threats. >> http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ >> _______________________________________________ >> Doctor-Doc-tech mailing list >> Doctor-Doc-tech@... >> https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech >> >> ---------------------------------------------------------------------- >> -------- >> Live Security Virtual Conference >> Exclusive live event will cover all the ways today's security and >> threat landscape has changed and how IT managers can respond. >> Discussions will include endpoint security, mobile security and the >> latest in malware threats. >> http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ >> _______________________________________________ >> Doctor-Doc-tech mailing list >> Doctor-Doc-tech@... >> https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech >> > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Doctor-Doc-tech mailing list > Doctor-Doc-tech@... > https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Doctor-Doc-tech mailing list > Doctor-Doc-tech@... > https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech > |
|
From: <doctor-doc-tech@li...> - 2012-07-26 14:07:26
|
Hi Markus, the output of this change in catalina.out is: 192.168.2.59 Regards, Sebastian -----Ursprüngliche Nachricht----- Von: doctor-doc-tech@... [mailto:doctor-doc-tech@...] Gesendet: Donnerstag, 26. Juli 2012 15:46 An: doctor-doc-tech@... Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more after upgrade Hi Sebastian there have been some changes in IPChecker.java, which may produce different behaviour from Rev. 175 to Rev. 416, although you do not change your IPs in the database. I fear we have to debug this issue... Firt thing to know would be, what looks the IP like, which then will be checked against the DB. Could you maybe add a simple System.out.println(ip); on line 49 of http://doctor-doc.svn.sourceforge.net/viewvc/doctor-doc/trunk/source/util/IPChecker.java?revision=397&view=markup You find this file in source/util/IPChecker.java Markus Am 26.07.2012 15:23, schrieb doctor-doc-tech@...: > Hi Markus, > > there is no indication of an error in catalina.out. The database is up-to-date. I've compared the field format and information of the table 'konto' with the values in the master dump, and they are the same. > > If I swap out the .war for rev. 416 with the old .war from rev.175, ip-based access works. > > Regards, > Sebastian > > > > > -----Ursprüngliche Nachricht----- > Von: doctor-doc-tech@... > [mailto:doctor-doc-tech@...] > Gesendet: Donnerstag, 26. Juli 2012 14:59 > An: doctor-doc-tech@... > Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more > after upgrade > > Hi Sebastian > > what says catalina.out? Are there any errors, at the end of the file, after trying to take IP-based access? > > Did you update the database: > > http://doctor-doc.svn.sourceforge.net/viewvc/doctor-doc/trunk/db/dbcha > nges_forUpdate?revision=377&view=markup > > Could easily be, that fetching the account from the DB fails, if there are fields missing e.g. in the table 'konto'. There has been a change with Rev. 202 in this table. > > Let me know, if this helps. > > Markus > > > Am 26.07.2012 14:31, schrieb doctor-doc-tech@...: >> Hi Markus, >> >> Thank you for your answer. Besides of the revision, nothing was changed, and it worked in rev. 175. >> I have an entry in the table 'text' with TID 22 (auto-increment value), KID 1 (that's the correct account), and TYID 9 with content '192.168.*'. Once I noticed it didn't work I tried adding additional entries with content '192.168.2.1-254' and '192.168.2.34' to check whether the wildcard is the problem, but with no success. >> >> Any other ideas? >> >> Regards, >> Sebastian >> [omitted older mail] |
|
From: <doctor-doc-tech@li...> - 2012-07-26 14:14:48
|
Hi Sebastian how does the corresponding entry in the DB look like? I really wonder... Markus Am 26.07.2012 16:06, schrieb doctor-doc-tech@...: > Hi Markus, > > the output of this change in catalina.out is: > 192.168.2.59 > > Regards, > Sebastian > > > -----Ursprüngliche Nachricht----- > Von: doctor-doc-tech@... [mailto:doctor-doc-tech@...] > Gesendet: Donnerstag, 26. Juli 2012 15:46 > An: doctor-doc-tech@... > Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more after upgrade > > Hi Sebastian > > there have been some changes in IPChecker.java, which may produce different behaviour from Rev. 175 to Rev. 416, although you do not change your IPs in the database. > > I fear we have to debug this issue... > > Firt thing to know would be, what looks the IP like, which then will be checked against the DB. > > Could you maybe add a simple > > System.out.println(ip); > > on line 49 of > http://doctor-doc.svn.sourceforge.net/viewvc/doctor-doc/trunk/source/util/IPChecker.java?revision=397&view=markup > > You find this file in source/util/IPChecker.java > > Markus > > Am 26.07.2012 15:23, schrieb doctor-doc-tech@...: >> Hi Markus, >> >> there is no indication of an error in catalina.out. The database is up-to-date. I've compared the field format and information of the table 'konto' with the values in the master dump, and they are the same. >> >> If I swap out the .war for rev. 416 with the old .war from rev.175, ip-based access works. >> >> Regards, >> Sebastian >> >> >> >> >> -----Ursprüngliche Nachricht----- >> Von: doctor-doc-tech@... >> [mailto:doctor-doc-tech@...] >> Gesendet: Donnerstag, 26. Juli 2012 14:59 >> An: doctor-doc-tech@... >> Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more >> after upgrade >> >> Hi Sebastian >> >> what says catalina.out? Are there any errors, at the end of the file, after trying to take IP-based access? >> >> Did you update the database: >> >> http://doctor-doc.svn.sourceforge.net/viewvc/doctor-doc/trunk/db/dbcha >> nges_forUpdate?revision=377&view=markup >> >> Could easily be, that fetching the account from the DB fails, if there are fields missing e.g. in the table 'konto'. There has been a change with Rev. 202 in this table. >> >> Let me know, if this helps. >> >> Markus >> >> >> Am 26.07.2012 14:31, schrieb doctor-doc-tech@...: >>> Hi Markus, >>> >>> Thank you for your answer. Besides of the revision, nothing was changed, and it worked in rev. 175. >>> I have an entry in the table 'text' with TID 22 (auto-increment value), KID 1 (that's the correct account), and TYID 9 with content '192.168.*'. Once I noticed it didn't work I tried adding additional entries with content '192.168.2.1-254' and '192.168.2.34' to check whether the wildcard is the problem, but with no success. >>> >>> Any other ideas? >>> >>> Regards, >>> Sebastian >>> > [omitted older mail] > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Doctor-Doc-tech mailing list > Doctor-Doc-tech@... > https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech > |
|
From: <doctor-doc-tech@li...> - 2012-07-26 14:21:31
|
Hi Markus, The DB entry is: 192.168.* But as I mentioned, I tried 192.168.2.1-254 as well, and I just created another IP-specific entry for 192.168.2.59 - both without success. Regards, Sebastian -----Ursprüngliche Nachricht----- Von: doctor-doc-tech@... [mailto:doctor-doc-tech@...] Gesendet: Donnerstag, 26. Juli 2012 16:14 An: doctor-doc-tech@... Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more after upgrade Hi Sebastian how does the corresponding entry in the DB look like? I really wonder... Markus Am 26.07.2012 16:06, schrieb doctor-doc-tech@...: > Hi Markus, > > the output of this change in catalina.out is: > 192.168.2.59 > > Regards, > Sebastian > > > -----Ursprüngliche Nachricht----- > Von: doctor-doc-tech@... > [mailto:doctor-doc-tech@...] > Gesendet: Donnerstag, 26. Juli 2012 15:46 > An: doctor-doc-tech@... > Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more > after upgrade > > Hi Sebastian > > there have been some changes in IPChecker.java, which may produce different behaviour from Rev. 175 to Rev. 416, although you do not change your IPs in the database. > > I fear we have to debug this issue... > > Firt thing to know would be, what looks the IP like, which then will be checked against the DB. > > Could you maybe add a simple > > System.out.println(ip); > > on line 49 of > http://doctor-doc.svn.sourceforge.net/viewvc/doctor-doc/trunk/source/u > til/IPChecker.java?revision=397&view=markup > > You find this file in source/util/IPChecker.java > > Markus > > Am 26.07.2012 15:23, schrieb doctor-doc-tech@...: >> Hi Markus, >> >> there is no indication of an error in catalina.out. The database is up-to-date. I've compared the field format and information of the table 'konto' with the values in the master dump, and they are the same. >> >> If I swap out the .war for rev. 416 with the old .war from rev.175, ip-based access works. >> >> Regards, >> Sebastian >> >> >> >> >> -----Ursprüngliche Nachricht----- >> Von: doctor-doc-tech@... >> [mailto:doctor-doc-tech@...] >> Gesendet: Donnerstag, 26. Juli 2012 14:59 >> An: doctor-doc-tech@... >> Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more >> after upgrade >> >> Hi Sebastian >> >> what says catalina.out? Are there any errors, at the end of the file, after trying to take IP-based access? >> >> Did you update the database: >> >> http://doctor-doc.svn.sourceforge.net/viewvc/doctor-doc/trunk/db/dbch >> a nges_forUpdate?revision=377&view=markup >> >> Could easily be, that fetching the account from the DB fails, if there are fields missing e.g. in the table 'konto'. There has been a change with Rev. 202 in this table. >> >> Let me know, if this helps. >> >> Markus >> >> >> Am 26.07.2012 14:31, schrieb doctor-doc-tech@...: >>> Hi Markus, >>> >>> Thank you for your answer. Besides of the revision, nothing was changed, and it worked in rev. 175. >>> I have an entry in the table 'text' with TID 22 (auto-increment value), KID 1 (that's the correct account), and TYID 9 with content '192.168.*'. Once I noticed it didn't work I tried adding additional entries with content '192.168.2.1-254' and '192.168.2.34' to check whether the wildcard is the problem, but with no success. >>> >>> Any other ideas? >>> >>> Regards, >>> Sebastian >>> > [omitted older mail] > > ---------------------------------------------------------------------- > -------- > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. > Discussions will include endpoint security, mobile security and the > latest in malware threats. > http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Doctor-Doc-tech mailing list > Doctor-Doc-tech@... > https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech > ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Doctor-Doc-tech mailing list Doctor-Doc-tech@... https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech |
|
From: <doctor-doc-tech@li...> - 2012-07-26 14:31:37
|
Hi Sebastian Your values are correct! And if I override the IP on line 49 of IPChecker.java to 192.168.2.59 and add in 'text" INSERT INTO `text` (`TID`, `KID`, `TYID`, `inhalt`) VALUES (NULL, '1', '9', '192.168.*'); (1 stands for my account-ID here locally). IP-based access works here locally. Could you send me a dump of 'text' and 'konto' from your database? You may empty any sensitive values in the sql dump, as you wish. You may send this also to my private Email: info at flyingfischer.ch Markus Am 26.07.2012 16:21, schrieb doctor-doc-tech@...: > Hi Markus, > > The DB entry is: > 192.168.* > > But as I mentioned, I tried 192.168.2.1-254 as well, and I just created another IP-specific entry for 192.168.2.59 - both without success. > > Regards, > Sebastian > > -----Ursprüngliche Nachricht----- > Von: doctor-doc-tech@... [mailto:doctor-doc-tech@...] > Gesendet: Donnerstag, 26. Juli 2012 16:14 > An: doctor-doc-tech@... > Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more after upgrade > > Hi Sebastian > > how does the corresponding entry in the DB look like? > > I really wonder... > > Markus > > > Am 26.07.2012 16:06, schrieb doctor-doc-tech@...: >> Hi Markus, >> >> the output of this change in catalina.out is: >> 192.168.2.59 >> >> Regards, >> Sebastian >> >> >> -----Ursprüngliche Nachricht----- >> Von: doctor-doc-tech@... >> [mailto:doctor-doc-tech@...] >> Gesendet: Donnerstag, 26. Juli 2012 15:46 >> An: doctor-doc-tech@... >> Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more >> after upgrade >> >> Hi Sebastian >> >> there have been some changes in IPChecker.java, which may produce different behaviour from Rev. 175 to Rev. 416, although you do not change your IPs in the database. >> >> I fear we have to debug this issue... >> >> Firt thing to know would be, what looks the IP like, which then will be checked against the DB. >> >> Could you maybe add a simple >> >> System.out.println(ip); >> >> on line 49 of >> http://doctor-doc.svn.sourceforge.net/viewvc/doctor-doc/trunk/source/u >> til/IPChecker.java?revision=397&view=markup >> >> You find this file in source/util/IPChecker.java >> >> Markus >> >> Am 26.07.2012 15:23, schrieb doctor-doc-tech@...: >>> Hi Markus, >>> >>> there is no indication of an error in catalina.out. The database is up-to-date. I've compared the field format and information of the table 'konto' with the values in the master dump, and they are the same. >>> >>> If I swap out the .war for rev. 416 with the old .war from rev.175, ip-based access works. >>> >>> Regards, >>> Sebastian >>> >>> >>> >>> >>> -----Ursprüngliche Nachricht----- >>> Von: doctor-doc-tech@... >>> [mailto:doctor-doc-tech@...] >>> Gesendet: Donnerstag, 26. Juli 2012 14:59 >>> An: doctor-doc-tech@... >>> Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more >>> after upgrade >>> >>> Hi Sebastian >>> >>> what says catalina.out? Are there any errors, at the end of the file, after trying to take IP-based access? >>> >>> Did you update the database: >>> >>> http://doctor-doc.svn.sourceforge.net/viewvc/doctor-doc/trunk/db/dbch >>> a nges_forUpdate?revision=377&view=markup >>> >>> Could easily be, that fetching the account from the DB fails, if there are fields missing e.g. in the table 'konto'. There has been a change with Rev. 202 in this table. >>> >>> Let me know, if this helps. >>> >>> Markus >>> >>> >>> Am 26.07.2012 14:31, schrieb doctor-doc-tech@...: >>>> Hi Markus, >>>> >>>> Thank you for your answer. Besides of the revision, nothing was changed, and it worked in rev. 175. >>>> I have an entry in the table 'text' with TID 22 (auto-increment value), KID 1 (that's the correct account), and TYID 9 with content '192.168.*'. Once I noticed it didn't work I tried adding additional entries with content '192.168.2.1-254' and '192.168.2.34' to check whether the wildcard is the problem, but with no success. >>>> >>>> Any other ideas? >>>> >>>> Regards, >>>> Sebastian >>>> >> [omitted older mail] >> >> ---------------------------------------------------------------------- >> -------- >> Live Security Virtual Conference >> Exclusive live event will cover all the ways today's security and >> threat landscape has changed and how IT managers can respond. >> Discussions will include endpoint security, mobile security and the >> latest in malware threats. >> http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ >> _______________________________________________ >> Doctor-Doc-tech mailing list >> Doctor-Doc-tech@... >> https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech >> > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Doctor-Doc-tech mailing list > Doctor-Doc-tech@... > https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Doctor-Doc-tech mailing list > Doctor-Doc-tech@... > https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech > |
|
From: <doctor-doc-tech@li...> - 2012-07-26 14:45:29
|
...what you maybe also could try, is: INSERT INTO `text` ( `TID` , `KID` , `TYID` , `inhalt` ) VALUES ( NULL , '1', '12', 'pei' ); Relace 1 by your KID. And then try to access the order form by: .../bestellform.do?method=validate&activemenu=bestellform&kkid=pei If this does not work also, there may be a more genral problem with the database connection. You didn't forget to replace source/resources/SystemConfiguration.properties with the one you cutomized in the old installation? Markus Am 26.07.2012 16:31, schrieb doctor-doc-tech@...: > Hi Sebastian > > Your values are correct! > > And if I override the IP on line 49 of IPChecker.java to 192.168.2.59 > and add in 'text" > > INSERT INTO `text` (`TID`, `KID`, `TYID`, `inhalt`) VALUES (NULL, '1', > '9', '192.168.*'); > > (1 stands for my account-ID here locally). > > IP-based access works here locally. > > Could you send me a dump of 'text' and 'konto' from your database? You > may empty any sensitive values in the sql dump, as you wish. > > You may send this also to my private Email: info at flyingfischer.ch > > Markus > > Am 26.07.2012 16:21, schrieb doctor-doc-tech@...: >> Hi Markus, >> >> The DB entry is: >> 192.168.* >> >> But as I mentioned, I tried 192.168.2.1-254 as well, and I just created another IP-specific entry for 192.168.2.59 - both without success. >> >> Regards, >> Sebastian >> >> -----Ursprüngliche Nachricht----- >> Von: doctor-doc-tech@... [mailto:doctor-doc-tech@...] >> Gesendet: Donnerstag, 26. Juli 2012 16:14 >> An: doctor-doc-tech@... >> Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more after upgrade >> >> Hi Sebastian >> >> how does the corresponding entry in the DB look like? >> >> I really wonder... >> >> Markus >> >> >> Am 26.07.2012 16:06, schrieb doctor-doc-tech@...: >>> Hi Markus, >>> >>> the output of this change in catalina.out is: >>> 192.168.2.59 >>> >>> Regards, >>> Sebastian >>> >>> >>> -----Ursprüngliche Nachricht----- >>> Von: doctor-doc-tech@... >>> [mailto:doctor-doc-tech@...] >>> Gesendet: Donnerstag, 26. Juli 2012 15:46 >>> An: doctor-doc-tech@... >>> Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more >>> after upgrade >>> >>> Hi Sebastian >>> >>> there have been some changes in IPChecker.java, which may produce different behaviour from Rev. 175 to Rev. 416, although you do not change your IPs in the database. >>> >>> I fear we have to debug this issue... >>> >>> Firt thing to know would be, what looks the IP like, which then will be checked against the DB. >>> >>> Could you maybe add a simple >>> >>> System.out.println(ip); >>> >>> on line 49 of >>> http://doctor-doc.svn.sourceforge.net/viewvc/doctor-doc/trunk/source/u >>> til/IPChecker.java?revision=397&view=markup >>> >>> You find this file in source/util/IPChecker.java >>> >>> Markus >>> >>> Am 26.07.2012 15:23, schrieb doctor-doc-tech@...: >>>> Hi Markus, >>>> >>>> there is no indication of an error in catalina.out. The database is up-to-date. I've compared the field format and information of the table 'konto' with the values in the master dump, and they are the same. >>>> >>>> If I swap out the .war for rev. 416 with the old .war from rev.175, ip-based access works. >>>> >>>> Regards, >>>> Sebastian >>>> >>>> >>>> >>>> >>>> -----Ursprüngliche Nachricht----- >>>> Von: doctor-doc-tech@... >>>> [mailto:doctor-doc-tech@...] >>>> Gesendet: Donnerstag, 26. Juli 2012 14:59 >>>> An: doctor-doc-tech@... >>>> Betreff: Re: [Doctor-Doc-tech] Activated IP doesn't work any more >>>> after upgrade >>>> >>>> Hi Sebastian >>>> >>>> what says catalina.out? Are there any errors, at the end of the file, after trying to take IP-based access? >>>> >>>> Did you update the database: >>>> >>>> http://doctor-doc.svn.sourceforge.net/viewvc/doctor-doc/trunk/db/dbch >>>> a nges_forUpdate?revision=377&view=markup >>>> >>>> Could easily be, that fetching the account from the DB fails, if there are fields missing e.g. in the table 'konto'. There has been a change with Rev. 202 in this table. >>>> >>>> Let me know, if this helps. >>>> >>>> Markus >>>> >>>> >>>> Am 26.07.2012 14:31, schrieb doctor-doc-tech@...: >>>>> Hi Markus, >>>>> >>>>> Thank you for your answer. Besides of the revision, nothing was changed, and it worked in rev. 175. >>>>> I have an entry in the table 'text' with TID 22 (auto-increment value), KID 1 (that's the correct account), and TYID 9 with content '192.168.*'. Once I noticed it didn't work I tried adding additional entries with content '192.168.2.1-254' and '192.168.2.34' to check whether the wildcard is the problem, but with no success. >>>>> >>>>> Any other ideas? >>>>> >>>>> Regards, >>>>> Sebastian >>>>> >>> [omitted older mail] >>> >>> ---------------------------------------------------------------------- >>> -------- >>> Live Security Virtual Conference >>> Exclusive live event will cover all the ways today's security and >>> threat landscape has changed and how IT managers can respond. >>> Discussions will include endpoint security, mobile security and the >>> latest in malware threats. >>> http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ >>> _______________________________________________ >>> Doctor-Doc-tech mailing list >>> Doctor-Doc-tech@... >>> https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech >>> >> >> ------------------------------------------------------------------------------ >> Live Security Virtual Conference >> Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ >> _______________________________________________ >> Doctor-Doc-tech mailing list >> Doctor-Doc-tech@... >> https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech >> >> ------------------------------------------------------------------------------ >> Live Security Virtual Conference >> Exclusive live event will cover all the ways today's security and >> threat landscape has changed and how IT managers can respond. Discussions >> will include endpoint security, mobile security and the latest in malware >> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ >> _______________________________________________ >> Doctor-Doc-tech mailing list >> Doctor-Doc-tech@... >> https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech >> > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Doctor-Doc-tech mailing list > Doctor-Doc-tech@... > https://lists.sourceforge.net/lists/listinfo/doctor-doc-tech > |