Magellan Linux

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

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

    Parent Directory Parent Directory | Revision Log Revision Log

    Revision 217 - (show annotations) (download) (as text)
    Sat Mar 5 17:08:18 2005 UTC (19 years, 1 month ago) by niro
    File MIME type: application/x-sh
    File size: 3598 byte(s) 
    test; not ready for public
    1 #!/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};"