Author Topic: New Cisco 7970 SmallUI Skin inside.  (Read 3547 times)

tschak909

  • LinuxMCE God
  • ****
  • Posts: 5549
  • DOES work for LinuxMCE.
    • View Profile
New Cisco 7970 SmallUI Skin inside.
« on: September 06, 2008, 11:33:02 pm »
I have been working on a replacement skin for SmallUI, and the current revision can be found here:

http://www.localeconcept.com/private/SmallUI.tar.bz2

There is also a replacement Proxy Orbiter, incorporating both my push fixes, and a necessary ScreenHandler fix for my replacement file list data grid:

http://www.localeconcept.com/pub/Proxy_Orbiter_Update.tar.gz

You need to get both.


you then need to do an sqlcvs update of the 'designer' repository to get the latest UI changes to SmallUI.


to use:

Unpack Proxy_Orbiter_Update.tar.gz, and copy the Proxy_Orbiter into /usr/pluto/bin ... this file is probably in use because the system is running, so you will need to do a quick trick of quick reloading the router, and copying the file into /usr/pluto/bin using sudo before the core restarts everything.

unpack SmallUI.tar.bz2 to /usr/pluto/orbiter/skins/ ... new folder called SmallUI will be created
go into mysql pluto_main -uroot

UPDATE Skin SET DataSubdirectory = 'SmallUI' WHERE PK_Skin = 6;
quit;

then go into the Web Admin, Full Regen your Cisco orbiters.

Wait, and see the results.

Let me know what you think.

-Thom
« Last Edit: September 07, 2008, 01:11:37 am by tschak909 »

dlewis

  • Guru
  • ****
  • Posts: 401
    • View Profile
Re: New Cisco 7970 SmallUI Skin inside.
« Reply #1 on: November 09, 2008, 04:30:07 pm »
I ge the following error when trying to update mysql for the new skin:

Code: [Select]
mysql> pluto_main -uroot
    -> UPDATE Skin SET DataSubdirectory = 'SmallUI' WHERE PK_Skin = 6;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pluto_main -uroot
UPDATE Skin SET DataSubdirectory = 'SmallUI' WHERE PK_Skin = 6' at line 1
mysql>

Any suggestions? Thanks!

-D

niz23

  • Guru
  • ****
  • Posts: 361
    • View Profile
Re: New Cisco 7970 SmallUI Skin inside.
« Reply #2 on: November 09, 2008, 05:01:35 pm »
dlewis.
I ge the following error when trying to update mysql for the new skin:

Code: [Select]
mysql> pluto_main -uroot
    -> UPDATE Skin SET DataSubdirectory = 'SmallUI' WHERE PK_Skin = 6;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pluto_main -uroot
UPDATE Skin SET DataSubdirectory = 'SmallUI' WHERE PK_Skin = 6' at line 1
mysql>

Any suggestions? Thanks!

-D

Looks like you use wrong syntax from command-line.
From the top of my head.

From command line(linux shell) do:
"mysql -u root pluto_main" (should log you in to pluto_main database as user root)
If everything work fine you are now at a mysql shell promt.

Insert row below and hit enter.
UPDATE Skin SET DataSubdirectory = 'SmallUI' WHERE PK_Skin = 6;

If everything is ok the update is complete.

/niz23

Zaerc

  • Alumni
  • LinuxMCE God
  • *
  • Posts: 2256
  • Department of Redundancy Department.
    • View Profile
Re: New Cisco 7970 SmallUI Skin inside.
« Reply #3 on: November 09, 2008, 05:23:36 pm »
Or to do it all at once directly from the command line:
Code: [Select]
pluto_main -u root -e "UPDATE Skin SET DataSubdirectory = 'SmallUI' WHERE PK_Skin = 6"
"Change is inevitable. Progress is optional."
-- Anonymous


dlewis

  • Guru
  • ****
  • Posts: 401
    • View Profile
Re: New Cisco 7970 SmallUI Skin inside.
« Reply #4 on: November 09, 2008, 08:18:24 pm »
thanks!