Google Chrome Kiosk screen does not maximize

Question

The creation of the below 2 tables are failing. Can anyone please help me?

Error is MySQL: Can't create table (errno: 150)

CREATE TABLE PSODEMO.APPLICATION (
    APPLICATION_ID INT NOT NULL AUTO_INCREMENT
    , APPLICATION_TYPE VARCHAR(10)
    , APPLICATION_STATUS VARCHAR(10)
    , CREATE_DATE DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL
    , MODIFIED_DATE DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL
    , DEALER_ID INT
    , COMPANY_NAME VARCHAR(120)
    , WEBSITE VARCHAR(128)
    , EMAIL VARCHAR(64)
    , PHONE VARCHAR(32)
    , STREET VARCHAR(124)
    , CITY VARCHAR(64)
    , ZIPCODE INT NOT NULL
    , COUNTRY VARCHAR(64)
    , DEALER_STATUS VARCHAR(32)
    , REMARKS VARCHAR(128)
    , INVOICE_ID INT
    , PAYMENT_MODE VARCHAR(64)
    , INVOICE_DATE DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL
    , PAYMENT_DATE DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL
    , PAYMENT_STATUS VARCHAR(64)
    , PRIMARY KEY (APPLICATION_ID)
    , KEY ix_APPLICATION_Applicationid(aplication_id)
    , KEY ix_APPLICATION_dealerid(dealer_id)
    );

CREATE TABLE LOGIN (
    LOGIN_ID INT NOT NULL AUTO_INCREMENT
    , USERNAME VARCHAR(10) NOT NULL
    , PASSWORD VARCHAR(10) NOT NULL
    , USER_TYPE VARCHAR(1) NOT NULL
    , APPLICATION_ID_FK INT
    , DEALER_ID_FK INT
    , PRIMARY KEY (LOGIN_ID)
    , FOREIGN KEY (APPLICATION_ID_FK) REFERENCES APPLICATION(APPLICATION_ID)
    , FOREIGN KEY (DEALER_ID_FK) REFERENCES DEALER(DEALER_ID)
    , UNIQUE (USERNAME)
    );

Solution 1

Not sure why Chrome is doing this, but if you have a look at:

/home/{kiosk_user}/.config/google-chrome/Default/Preferences  

-- you will see browser.window_placement and you should see a difference of about 20 pixels between bottom and work_area_bottom, and right and work_area_right.

I edited the values to be the full extents of the display size, and saved Preferences, then chown'd then to root:root and chmod'd them to 644 so that Chrome (running as the kiosk_user) cannot modify the settings.

I restarted the kiosk_user session and tada, Chrome was running full full screen.

Hope this helps you.

Solution 2

You are just about to done it... see my codes:

[Desktop Entry]
Name=Chrome
Comment=This session logs you into Google Chrome
google-chrome --start-maximized --kiosk http://google.com
Icon=
Type=Application
Encoding=UTF-8

now you need to edit Chrome configuration for user
open location: ~/.config/google-chrome/Default/
and then open Preferences.
Search for "browser": { and modify followings:

   "browser": {
      "check_default_browser": false,
      "clear_lso_data_enabled": true,
      "custom_chrome_frame": true,
      "pepper_flash_settings_enabled": true,
      "window_placement": {
         "bottom": 803,
         "left": 1,
         "maximized": false,
         "right": 1366,
         "top": 35,
         "work_area_bottom": 768,
         "work_area_left": 0,
         "work_area_right": 1366,
         "work_area_top": 37
      },

In my PC I've 1366x768 please adjust as you need.

(you may also add this file in /etc/skel location, this will solve the problem while creating new user you don't need to re-config)

Comments

[Chris Woollard]

I have only tested this on Ubuntu 12.04, so I don't know if it is specific to that version.

[윤이래]

But this would make it specific to the device, you cannot create a generic mass manufactured solution.

[윤이래]

See question askubuntu.com/questions/184610/…

[John Woo]

i can't see your caode.. maybe you have error on your sql syntax right? this is because you are using MySQL Reserved Keywords. in order to skip that, you should enclosed the keywords with backtick ` ...

[JochemQuery]

explained here in my question: stackoverflow.com/questions/10338661/…

[Shankar Guru]

Below is what am using now, with back ticks, still same issue.. CREATE TABLE psodemo.LOGIN ( LOGIN_ID INTEGER ZEROFILL NOT NULL AUTO_INCREMENT, USERNAME VARCHAR(45) NOT NULL DEFAULT '', PASSWORD VARCHAR(45) NOT NULL DEFAULT '', USER_TYPE VARCHAR(1) NOT NULL DEFAULT '', APPLICATION_ID_FK INTEGER NOT NULL DEFAULT 0, DEALER_ID_FK INTEGER NOT NULL DEFAULT 0, PRIMARY KEY(LOGIN_ID), CONSTRAINT APPLICATION_ID_FK FOREIGN KEY APPLICATION_ID_FK (APPLICATION_ID_FK) REFERENCES application (APPLICATION_ID) ON DELETE RESTRICT

[Shankar Guru]

I used backticks, but still the same error. Also I used the same query as you posted above. I am using MySQL 5.0 version. Please suggest

[Subhasom]

Sorry to say that, you cant escape or log-out from Chrome kiosk mode then you need to do a simple tricks: ALT+CTRL+F1 then login and now type sudo gdm restart or sudo lightdm restart. I'm still looking for code to RUN TERMIANAL CODE from BROWSER I found something like apt: for firefox, it opens ubuntu software center with specific system call.