LinuxMCE Forums

General => Users => Topic started by: tschak909 on September 06, 2008, 11:33:02 pm

Title: New Cisco 7970 SmallUI Skin inside.
Post by: tschak909 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

Title: Re: New Cisco 7970 SmallUI Skin inside.
Post by: dlewis 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

Title: Re: New Cisco 7970 SmallUI Skin inside.
Post by: niz23 on November 09, 2008, 05:01:35 pm

dlewis.

Quote from: dlewis 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

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

Title: Re: New Cisco 7970 SmallUI Skin inside.
Post by: Zaerc 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"

Title: Re: New Cisco 7970 SmallUI Skin inside.
Post by: dlewis on November 09, 2008, 08:18:24 pm

thanks!