Magellan Linux

  • Back to homepage
    • /[alx-svn]/alx-src/trunk/alx-config/import_to_mysql_db.sh

    Annotation of /alx-src/trunk/alx-config/import_to_mysql_db.sh

    Parent Directory Parent Directory | Revision Log Revision Log

    Revision 217 - (hide annotations) (download) (as text)
    Sat Mar 5 17:08:18 2005 UTC (19 years, 2 months ago) by niro
    File MIME type: application/x-sh
    File size: 3598 byte(s) 
    test; not ready for public
    1 niro 217 #!/bin/bash
    2    
    3     # functions_mysql_update
    4    
    5     source /etc/alx-config/config.rc
    6     source /opt/alx-config/functions/mysqlfunctions
    7     source /etc/alx-config/serial
    8    
    9    
    10     #get all settings
    11    
    12     #network
    13     if [ -f $SETTINGS_TEMPLATE/system/network/networking ]
    14     then
    15     networking="$( < $SETTINGS_TEMPLATE/system/network/networking)"
    16     else
    17     networking=""
    18     fi
    19    
    20     if [ -f $SETTINGS_TEMPLATE/system/network/hostname ]
    21     then
    22     hostname="$( < $SETTINGS_TEMPLATE/system/network/hostname)"
    23     else
    24     hostname=""
    25     fi
    26    
    27     if [ -f $SETTINGS_TEMPLATE/system/network/domain ]
    28     then
    29     domain="$( < $SETTINGS_TEMPLATE/system/network/domain)"
    30     else
    31     domain=""
    32     fi
    33    
    34     if [ -f $SETTINGS_TEMPLATE/system/network/ip ]
    35     then
    36     ip="$( < $SETTINGS_TEMPLATE/system/network/ip)"
    37     else
    38     ip=""
    39     fi
    40    
    41     if [ -f $SETTINGS_TEMPLATE/system/network/netmask ]
    42     then
    43     netmask="$( < $SETTINGS_TEMPLATE/system/network/netmask)"
    44     else
    45     netmask=""
    46     fi
    47    
    48     if [ -f $SETTINGS_TEMPLATE/system/network/broadcast ]
    49     then
    50     broadcast="$( < $SETTINGS_TEMPLATE/system/network/broadcast)"
    51     else
    52     broadcast=""
    53     fi
    54    
    55     if [ -f $SETTINGS_TEMPLATE/system/network/gateway ]
    56     then
    57     gateway="$( < $SETTINGS_TEMPLATE/system/network/gateway)"
    58     else
    59     gateway=""
    60     fi
    61    
    62     if [ -f $SETTINGS_TEMPLATE/system/network/dns ]
    63     then
    64     dns="$( < $SETTINGS_TEMPLATE/system/network/dns)"
    65     else
    66     dns=""
    67     fi
    68    
    69     if [ -f $SETTINGS_TEMPLATE/system/modules/modules ]
    70     then
    71     modules="$( < $SETTINGS_TEMPLATE/system/modules/modules)"
    72     else
    73     modules=""
    74     fi
    75    
    76    
    77     #write the stuff to mysql db
    78     mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
    79     "update cfg_network set
    80     module='${modules}',
    81     domain='${domain}',
    82     networking='${networking}',
    83     netmask='${netmask}',
    84     dns='${dns}',
    85     gateway='${gateway}',
    86     broadcast='${broadcast}',
    87     ip='${ip}'
    88     where serial=${ALX_SERIAL};"
    89    
    90     #update hostname
    91     mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
    92     "update cfg_serial set
    93     hostname='${hostname}'
    94     where id=${ALX_SERIAL};"
    95    
    96     #vga
    97     if [ -f $SETTINGS_TEMPLATE/system/mouse/mouse ]
    98     then
    99     mouseprot="$( < $SETTINGS_TEMPLATE/system/mouse/mouse)"
    100     else
    101     mouseprot=""
    102     fi
    103    
    104     if [ -f $SETTINGS_TEMPLATE/system/vga/vga ]
    105     then
    106     vgadrv="$( < $SETTINGS_TEMPLATE/system/vga/vga)"
    107     else
    108     vgadrv=""
    109     fi
    110    
    111     if [ -f $SETTINGS_TEMPLATE/system/vga/vgadepth ]
    112     then
    113     vgadepth="$( < $SETTINGS_TEMPLATE/system/vga/vgadepth)"
    114     else
    115     vgadepth=""
    116     fi
    117    
    118     if [ -f $SETTINGS_TEMPLATE/system/vga/vgares ]
    119     then
    120     resolution="$( < $SETTINGS_TEMPLATE/system/vga/vgares)"
    121     else
    122     resolution=""
    123     fi
    124    
    125     mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
    126     "update cfg_grafik set
    127     module='${vgadrv}',
    128     resolution='${resolution}',
    129     depth='${vgadepth}',
    130     mouse='${mouseprot}'
    131     where serial=${ALX_SERIAL};"
    132    
    133     #sessions
    134     if [ -f $SETTINGS_TEMPLATE/system/sessions/sessions ]
    135     then
    136     sessions="$( < $SETTINGS_TEMPLATE/system/sessions/sessions)"
    137     else
    138     sessions=""
    139     fi
    140    
    141     if [ -n "${sessions}" ]
    142     then
    143    
    144     #first delete all sessions with serial=${ALX_SERIAL}
    145     mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
    146     "delete from cfg_session where serial='${ALX_SERIAL}';"
    147    
    148     #than add them
    149     for i in ${sessions}
    150     do
    151     mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
    152     "insert into cfg_session(
    153     serial,
    154     session
    155     )
    156     values(
    157     '${ALX_SERIAL}',
    158     '${i}'
    159     );"
    160     done
    161     fi
    162    
    163     #printers
    164    
    165     #monitors
    166     if [ -f $SETTINGS_TEMPLATE/system/monitor/monitor ]
    167     then
    168     source $SETTINGS_TEMPLATE/system/monitor/monitor
    169     else
    170     myvendor=""
    171     mymodel=""
    172     hsync=""
    173     vref=""
    174     fi
    175    
    176     mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
    177     "update cfg_monitor set
    178     vendor='${myvendor}',
    179     model='${mymodel}',
    180     hsync='${hsync}',
    181     vrefresh='${vref}'
    182     where serial=${ALX_SERIAL};"