Pixelator thanks. I appreciate the help.
When I get the PPOE info from VZ. (the techs are actually pretty decent) What do I do with the info?
to get PPPOE set up:
run pppoeconfig from a terminal and follow the on-screen instructions.
It will ask for your account name and password provided by VZ.
Then there is the small tricky part of manually editing the MySql table containing the interface connection info.
First you need to get into mysql using a terminal and use this command
mysql use pluto_main
then display the contents of the Device_DeviceData table to get your current network settings stored in LMCE by applying the following command at the mysql prompt:
select * from Device_DeviceData where FK_Device=1 and FK_DeviceData=32;
My results looked like this
+-----------+---------------+-------------------------------------------+--------+-----------+----------+------------+----------------+--------------+
| FK_Device | FK_DeviceData | IK_DeviceData | psc_id | psc_batch | psc_user | psc_frozen | psc_mod | psc_restrict |
+-----------+---------------+-------------------------------------------+--------+-----------+----------+------------+----------------+--------------+
| 1 | 32 | eth0,dhcp|eth1,192.168.15.2,255.255.255.0 | NULL | NULL | NULL | 0 | 20070405221738 | NULL |
+-----------+---------------+-------------------------------------------+--------+-----------+----------+------------+----------------+--------------+
the important piece here is the IK_DeviceData field value: eth0,dhcp|eth1,192.168.15.2,255.255.255.0
this field contains the network interface info that LMCE uses. Each interface is seperated by a "|" character.
for my two interfaces the field contains "eth0,DHCP" and "eth1,192.168.15.2,255.255.255.0 "
The trick is to make sure you change the interface info for you external interface to "ppp0"
in my case, the external interface was eth0 so I needed to change the field value from "eth0,dhcp|eth1,192.168.15.2,255.255.255.0", to "ppp0,dhcp|eth1,192.168.15.2,255.255.255.0"
note the difference between eth0 and ppp0.
To make this change in the mysql table, you would execute the sql command
update Device_DeviceData set IK_DeviceData="ppp0,dhcp|eth1,192.168.15.2,255.255.255.0" where FK_Device=1 and FK_DeviceData=32;
then if you execute the sql command
mysql> select * from Device_DeviceData where FK_Device=1 and FK_DeviceData=32;
+-----------+---------------+-------------------------------------------+--------+-----------+----------+------------+----------------+--------------+
| FK_Device | FK_DeviceData | IK_DeviceData | psc_id | psc_batch | psc_user | psc_frozen | psc_mod | psc_restrict |
+-----------+---------------+-------------------------------------------+--------+-----------+----------+------------+----------------+--------------+
| 1 | 32 | ppp0,dhcp|eth1,192.168.15.2,255.255.255.0 | NULL | NULL | NULL | 0 | 20070520193528 | NULL |
+-----------+---------------+-------------------------------------------+--------+-----------+----------+------------+----------------+--------------+
you will notice that eth0 has been updated to ppp0 in the IK_DeviceData field
That's it.