Okay, I've done a tcpdump on the server and I found out that it never
queries for the unattendedfile by mac address.
Am I misunderstanding the description of the search pattern at the top of
conf-mysql.pl?
Shouldn't it check for unattendedfile by mac address even if that's the
only thing associated with the mac address?
Here's the relevant exchange:
16:17:06.366204 IP (tos 0x8, ttl 62, id 42696, offset 0, flags [DF],
proto 6, length: 142) ua-client.1027 > mysql-server.mysql: P [tcp sum ok]
32:122(90) ack 66 win 1460 <nop,nop,timestamp 4294704715 3640240723>
0x0000: 4508 008e a6c8 4000 3e06 ac21 80c5 376b [EMAIL
PROTECTED]>..!..7k
0x0010: 80c5 b082 0403 0cea 23e6 5459 9316 35aa ........#.TY..5.
0x0020: 8018 05b4 8088 0000 0101 080a fffb fe4b ...............K
0x0030: d8f9 aa53 5600 0000 0353 454c 4543 5420 ...SV....SELECT.
0x0040: 5661 6c75 6520 4652 4f4d 2075 6e61 7474 Value.FROM.unatt
0x0050: 656e 6465 6420 5748 4552 4520 4c6f 6f6b ended.WHERE.Look
0x0060: 7570 203d 2027 3030 3037 4539 3134 4233 up.=.'0007E914B3
0x0070: 3435 2720 616e 6420 5072 6f70 6572 7479 45'.and.Property
0x0080: 203d 2027 4f53 5f6d 6564 6961 273b .=.'OS_media';
16:17:06.366437 IP (tos 0x8, ttl 64, id 40766, offset 0, flags [DF],
proto 6, length: 98) mysql-server.mysql > ua-client.1027: P [bad tcp cksum
e9cc (->9628)!] 66:112(46) ack 122 win 5792 <nop,nop,timestamp 3640240734
4294704715>
0x0000: 4508 0062 9f3e 4000 4006 b1d7 80c5 b082 E..b.>@[EMAIL
PROTECTED]
0x0010: 80c5 376b 0cea 0403 9316 35aa 23e6 54b3 ..7k......5.#.T.
0x0020: 8018 16a0 e9cc 0000 0101 080a d8f9 aa5e ...............^
0x0030: fffb fe4b 0100 0001 011b 0000 020a 756e ...K..........un
0x0040: 6174 7465 6e64 6564 0556 616c 7565 03ff attended.Value..
0x0050: 0000 01fd 0301 0000 0100 0003 fe01 0000 ................
0x0060: 04fe ..
16:17:06.368537 IP (tos 0x8, ttl 62, id 42698, offset 0, flags [DF],
proto 6, length: 146) ua-client.1027 > mysql-server.mysql: P [tcp sum ok]
122:216(94) ack 112 win 1460 <nop,nop,timestamp 4294704717 3640240734>
0x0000: 4508 0092 a6ca 4000 3e06 ac1b 80c5 376b [EMAIL
PROTECTED]>.....7k
0x0010: 80c5 b082 0403 0cea 23e6 54b3 9316 35d8 ........#.T...5.
0x0020: 8018 05b4 b1e8 0000 0101 080a fffb fe4d ...............M
0x0030: d8f9 aa5e 5a00 0000 0353 454c 4543 5420 ...^Z....SELECT.
0x0040: 5661 6c75 6520 4652 4f4d 2075 6e61 7474 Value.FROM.unatt
0x0050: 656e 6465 6420 5748 4552 4520 4c6f 6f6b ended.WHERE.Look
0x0060: 7570 203d 2027 3030 3037 4539 3134 4233 up.=.'0007E914B3
0x0070: 3435 2720 616e 6420 5072 6f70 6572 7479 45'.and.Property
0x0080: 203d 2027 436f 6d70 7574 6572 4e61 6d65 .=.'ComputerName
0x0090: 273b ';
16:17:06.368734 IP (tos 0x8, ttl 64, id 40767, offset 0, flags [DF],
proto 6, length: 98) mysql-server.mysql > ua-client.1027: P [bad tcp cksum
e9cc (->9598)!] 112:158(46) ack 216 win 5792 <nop,nop,timestamp 3640240736
4294704717>
0x0000: 4508 0062 9f3f 4000 4006 b1d6 80c5 b082 [EMAIL
PROTECTED]@.......
0x0010: 80c5 376b 0cea 0403 9316 35d8 23e6 5511 ..7k......5.#.U.
0x0020: 8018 16a0 e9cc 0000 0101 080a d8f9 aa60 ...............`
0x0030: fffb fe4d 0100 0001 011b 0000 020a 756e ...M..........un
0x0040: 6174 7465 6e64 6564 0556 616c 7565 03ff attended.Value..
0x0050: 0000 01fd 0301 0000 0100 0003 fe01 0000 ................
0x0060: 04fe ..
16:17:06.369536 IP (tos 0x8, ttl 62, id 42700, offset 0, flags [DF],
proto 6, length: 141) ua-client.1027 > mysql-server.mysql: P [tcp sum ok]
216:305(89) ack 158 win 1460 <nop,nop,timestamp 4294704718 3640240736>
0x0000: 4508 008d a6cc 4000 3e06 ac1e 80c5 376b [EMAIL
PROTECTED]>.....7k
0x0010: 80c5 b082 0403 0cea 23e6 5511 9316 3606 ........#.U...6.
0x0020: 8018 05b4 fadc 0000 0101 080a fffb fe4e ...............N
0x0030: d8f9 aa60 5500 0000 0353 454c 4543 5420 ...`U....SELECT.
0x0040: 5661 6c75 6520 4652 4f4d 2075 6e61 7474 Value.FROM.unatt
0x0050: 656e 6465 6420 5748 4552 4520 4c6f 6f6b ended.WHERE.Look
0x0060: 7570 203d 2027 4465 6661 756c 7427 2061 up.=.'Default'.a
0x0070: 6e64 2050 726f 7065 7274 7920 3d20 2743 nd.Property.=.'C
0x0080: 6f6d 7075 7465 724e 616d 6527 3b omputerName';
16:17:06.369687 IP (tos 0x8, ttl 64, id 40768, offset 0, flags [DF],
proto 6, length: 98) mysql-server.mysql > ua-client.1027: P [bad tcp cksum
e9cc (->950f)!] 158:204(46) ack 305 win 5792 <nop,nop,timestamp 3640240737
4294704718>
0x0000: 4508 0062 9f40 4000 4006 b1d5 80c5 b082 E..b.@@[EMAIL
PROTECTED]
0x0010: 80c5 376b 0cea 0403 9316 3606 23e6 556a ..7k......6.#.Uj
0x0020: 8018 16a0 e9cc 0000 0101 080a d8f9 aa61 ...............a
0x0030: fffb fe4e 0100 0001 011b 0000 020a 756e ...N..........un
0x0040: 6174 7465 6e64 6564 0556 616c 7565 03ff attended.Value..
0x0050: 0000 01fd 0301 0000 0100 0003 fe01 0000 ................
0x0060: 04fe ..
Thanks!
-Jeff
-----------------------------------------------------------
Jeffrey Albro | Systems Administrator | Boston University
- Department of Electrical and Computer Engineering -
[EMAIL PROTECTED] | Photonics, Room 305 | 617-358-2785
-----------------------------------------------------------
On Fri, 22 Apr 2005, Jeffrey C Albro wrote:
>
> Thanks for the tips Niels...
>
> I've upgraded to 4.6, and I've double checked my MySQL settings. File
> permissions are fine. I still can't pull the setting out of the file.
>
> I'm going to get medieval on the problem and tcpdump the MySQL
> interaction.
>
> -Jeff
>
>
> -----------------------------------------------------------
> Jeffrey Albro | Systems Administrator | Boston University
> - Department of Electrical and Computer Engineering -
> [EMAIL PROTECTED] | Photonics, Room 305 | 617-358-2785
> -----------------------------------------------------------
>
>
>
> On Mon, 21 Mar 2005, Niels S. Richthof wrote:
>
> > Hi Jeffrey!
> >
> > > I assume ece-test-ua-2.txt belongs in /unattended/site/ (/z/site/),
> >
> > ack
> >
> > > and I've moved sample-config.pl to config.pl, but unattended still
> > > pulls the default unattend.txt
> > >
> > > If I remove the default unattend.txt it acts like there is none and
> > > starts asking for a computer name.
> >
> > Ok. As far as I see, everything is okay. Maybe it is a security
> > issue? Do you have -rw-r--r-- on those unattend files?
> >
> > You should double-check your database-settings, on the server and in
> > install/site/config.pl (below "# Set db for mysql interface").
> >
> > Do you use the sample-config.pl version that shipps with release 4.6?
> > The previous version had two bugs.
> >
> > cu
> > Niels
> >
> >
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from real users.
> > Discover which products truly live up to the hype. Start reading now.
> > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> > _______________________________________________
> > unattended-info mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/unattended-info
> >
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> unattended-info mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/unattended-info
>
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
unattended-info mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/unattended-info
