phpmyadmin error

Discussion in 'Installation/Configuration' started by lifeisboost, Aug 8, 2008.

  1. lifeisboost

    lifeisboost New Member

    OKay,

    server is FC9 on the perfect setup. Everything runs great except when i log into phpmyadmin. I can login fine but on the right panel it says
    Cookies must be enabled past this point.

    I have cleared cookies, tried multiple browser, multiple computers and even deleted and installed he package multiple times. I cannot edit any DB's because of this. Any help is appreciated.
     
    lifeisboost, Aug 8, 2008
    #1
  2. falko

    falko Super Moderator ISPConfig Developer

    What's in phpMyAdmin's config.php file?
     
    falko, Aug 8, 2008
    #2
  3. bekche

    bekche New Member

    Hi falko, i have the same problem falko what shuld be in to the phpmyadmins config.php :confused:
     
    bekche, Aug 9, 2008
    #3
  4. el-sid

    el-sid New Member

    hi,

    i saw this problem though i never quite followed through. am not sure this will work but try checking ur firewall settings. if you have SELinux turned on, try turning it off and try to login again
     
    Last edited: Aug 10, 2008
    el-sid, Aug 10, 2008
    #4
  5. bekche

    bekche New Member

    SELinux is off it dosent work why:confused:
     
    bekche, Aug 10, 2008
    #5
  6. falko

    falko Super Moderator ISPConfig Developer

    What's in phpMyAdmin's config.php file?
     
    falko, Aug 11, 2008
    #6
  7. lifeisboost

    lifeisboost New Member

    Sorry for my late reply work has me all over the place. I edited out the export lines as did not think they where needed. The config was set from the package install. I disabled all firewalls and still the same problem.

    PHP:
    if (!isset($old_error_reporting)) {
            error_reporting(E_ALL);
        @    ini_set('display_errors', '1');
    }


    include(    "../../lib/config.inc.php");
    $cfg['PmaAbsoluteUri'] = $go_info["server"]["server_url"].'/phpmyadmin/';

    $cfg['PmaNoRelation_DisableWarning']  = FALSE;

    $cfg['blowfish_secret'] = '';


    $i = 0;

    $i++;
    $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
    $cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
    $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
    $cfg['Servers'][$i]['ssl']           = false;        // Use SSL for connecting to MySQL server?
    $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
    $cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')
    $cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
                                                        // (requires PHP >= 4.3.0)
    $cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
                                                        // (this user must have read-only
    $cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
                                                        // and "mysql/db" tables).
                                                        // The controluser is also
                                                        // used for all relational
                                                        // features (pmadb)
    $cfg['Servers'][$i]['auth_type']     = 'http';    // Authentication method (valid choices: config, http, HTTP, signon or cookie)
    $cfg['Servers'][$i]['user']          = '***';      // MySQL user
    $cfg['Servers'][$i]['password']      = '***';          // MySQL password (only needed
                                                        // with 'config' auth_type)
    $cfg['Servers'][$i]['SignonSession'] = '';          // Session to use for 'signon' auth method
    $cfg['Servers'][$i]['SignonURL']     = '';          // URL where to redirect user to login for 'signon' auth method
    $cfg['Servers'][$i]['LogoutURL']     = '';          // URL where to redirect user after logout
    $cfg['Servers'][$i]['nopassword']    = FALSE;       // Whether to try to connect without password
    $cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
                                                        // this db is displayed in left frame
                                                        // It may also be an array of db-names, where sorting order is relevant.
    $cfg['Servers'][$i]['hide_db'] = '(information_schema|mysql|pmadb|test)';          // Database name to be hidden from listings
    $cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname

    $cfg['Servers'][$i]['pmadb']         = '';          // Database used for Relation, Bookmark and PDF Features
                                                        // (see scripts/create_tables.sql)
                                                        //   - leave blank for no support
                                                        //     DEFAULT: 'phpmyadmin'
    $cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table
                                                        //   - leave blank for no bookmark support
                                                        //     DEFAULT: 'pma_bookmark'
    $cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
                                                        //   - leave blank for no relation-links support
                                                        //     DEFAULT: 'pma_relation'
    $cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
                                                        //   - leave blank for no display fields support
                                                        //     DEFAULT: 'pma_table_info'
    $cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF schema
                                                        //   - leave blank for no PDF schema support
                                                        //     DEFAULT: 'pma_table_coords'
    $cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpdf
                                                        //   - leave blank if you don't want to use this
                                                        //     DEFAULT: 'pma_pdf_pages'
    $cfg['Servers'][$i]['column_info']   = '';          // table to store column information
                                                        //   - leave blank for no column comments/mime types
                                                        //     DEFAULT: 'pma_column_info'
    $cfg['Servers'][$i]['history']       = '';          // table to store SQL history
                                                        //   - leave blank for no SQL query history
                                                        //     DEFAULT: 'pma_history'
    $cfg['Servers'][$i]['designer_coords'] = '';        // table to store the coordinates for Designer
                                                        //   - leave blank for no Designer feature
                                                        //     DEFAULT: 'pma_designer_coords'
    $cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your pma_* tables
                                                        // are up to date. This prevents compatibility
                                                        // checks and thereby increases performance.
    $cfg['Servers'][$i]['AllowRoot']     = TRUE;        // whether to allow root login
    $cfg['Servers'][$i]['AllowDeny']['order']           // Host authentication order, leave blank to not use
                                             = '';
    $cfg['Servers'][$i]['AllowDeny']['rules']           // Host authentication rules, leave blank for defaults
                                             = array();


    $cfg['ServerDefault'] = 1;              // Default server (0 = no default server)

    $cfg['MaxDbList']               = 100;    // maximum number of db's displayed in left frame and databaes list
    $cfg['OBGzip']                  = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto')
    $cfg['PersistentConnections']   = FALSE;  // use persistent connections to MySQL database
    $cfg['ForceSSL']                = FALSE;  // whether to force using https
    $cfg['ExecTimeLimit']           = 300;    // maximum execution time in seconds (0 for no limit)
    $cfg['MemoryLimit']             = 0;      // maximum allocated bytes (0 for no limit)
    $cfg['SkipLockedTables']        = FALSE;  // mark used tables, make possible to show
                                              // locked tables (since MySQL 3.23.30)
    $cfg['ShowSQL']                 = TRUE;   // show SQL queries as run
    $cfg['AllowUserDropDatabase']   = FALSE;  // show a 'Drop database' link to normal users
    $cfg['Confirm']                 = TRUE;   // confirm 'DROP TABLE' & 'DROP DATABASE'
    $cfg['LoginCookieRecall']       = TRUE;   // recall previous login in cookie auth. mode or not
    $cfg['LoginCookieValidity']     = 1800;   // validity of cookie login (in seconds)
    $cfg['LoginCookieStore']        = 0;      // how long login cookie should be stored (in seconds)
    $cfg['LoginCookieDeleteAll']    = TRUE;   // whether to delete all login cookies on logout
    $cfg['UseDbSearch']             = TRUE;   // whether to enable the "database search" feature
                                              // or not
    $cfg['IgnoreMultiSubmitErrors'] = FALSE;  // if set to true, PMA continues computing multiple-statement queries
                                              // even if one of the queries failed
    $cfg['VerboseMultiSubmit']      = TRUE;   // if set to true, PMA will show the affected rows of EACH statement on
                                              // multiple-statement queries. See the libraries/import.php file for
                                              // hardcoded defaults on how many queries a statement may contain!
    $cfg['AllowArbitraryServer']    = FALSE;  // allow login to any user entered server in cookie based auth

    // Left frame setup
    $cfg['LeftFrameLight']        = TRUE;    // use a select-based menu and display only the
                                             // current tables in the left frame.
    $cfg['LeftFrameDBTree']       = TRUE;    // turn the select-based light menu into a tree
    $cfg['LeftFrameDBSeparator']  = '_';     // the separator to sub-tree the select-based light menu tree
    $cfg['LeftFrameTableSeparator']= '__';   // Which string will be used to generate table prefixes
                                             // to split/nest tables into multiple categories
    $cfg['LeftFrameTableLevel']   = '1';     // How many sublevels should be displayed when splitting
                                             // up tables by the above Separator
    $cfg['ShowTooltip']           = TRUE;    // display table comment as tooltip in left frame
    $cfg['ShowTooltipAliasDB']    = FALSE;   // if ShowToolTip is enabled, this defines that table/db comments
    $cfg['ShowTooltipAliasTB']    = FALSE;   // are shown (in the left menu and db_structure) instead of
                                             // table/db names. Setting ShowTooltipAliasTB to 'nested' will only
                                             // use the Aliases for nested descriptors, not the table itself.

    $cfg['LeftDisplayLogo']       = TRUE;   // display logo at top of left frame
    $cfg['LeftLogoLink']          = 'main.php';   // where should logo link point to
                        // (can also contain an external URL)
    $cfg['LeftLogoLinkWindow']    = 'main'; // whether to open the linked page
                        // in the main window ('main')
                        // or in a new window ('new')
    $cfg['LeftDisplayServers']    = FALSE;  // display server choice at top of left frame
    $cfg['DisplayServersList']    = FALSE;  // server choice as links
    $cfg['DisplayDatabasesList']  = FALSE;  // database choice in light as links

    // In the main frame, at startup...
    $cfg['ShowStats']             = TRUE;   // allow to display statistics and space usage in
                                            // the pages about database details and table
                                            // properties
    $cfg['ShowPhpInfo']           = FALSE;  // show php info link
    $cfg['ShowServerInfo']        = TRUE;   // show MySQL server information
    $cfg['ShowChgPassword']       = FALSE;  // show change password link
    $cfg['ShowCreateDb']          = TRUE;   // show create database form
    $cfg['SuggestDBName']         = TRUE;   // suggest a new DB name if possible (false = keep empty)

    // In browse mode...
    $cfg['ShowBlob']              = FALSE;  // display blob field contents
    $cfg['NavigationBarIconic']   = 'both'; // Use icons instead of text for the navigation bar buttons
                                            // and on right panel top menu (server db table) (TRUE|FALSE|'both')
    $cfg['ShowAll']               = FALSE;  // allows to display all the rows
    $cfg['MaxRows']               = 30;     // maximum number of rows to display
    $cfg['Order']                 = 'ASC';  // default for 'ORDER BY' clause (valid
                                            // values are 'ASC', 'DESC' or 'SMART' -ie
                                            // descending order for fields of type
                                            // TIME, DATE, DATETIME & TIMESTAMP,
                                            // ascending order else-)


    $cfg['ProtectBinary']         = 'blob'; // disallow editing of binary fields
                                            // valid values are:
                                            //   FALSE  allow editing
                                            //   'blob' allow editing except for BLOB fields
                                            //   'all'  disallow editing
    $cfg['ShowFunctionFields']    = TRUE;   // Display the function fields in edit/insert mode
    $cfg['CharEditing']           = 'input';
                                                // Which editor should be used for CHAR/VARCHAR fields:
                                            //  input - allows limiting of input length
                                            //  textarea - allows newlines in fields
    $cfg['InsertRows']            = 2;      // How many rows can be inserted at one time

    $cfg['ForeignKeyDropdownOrder'] =       // Sort order for items in a foreign-key dropdown box.
            array( 'content-id', 'id-content'); // 'content' is the referenced data, 'id' is the key value.
    $cfg['ForeignKeyMaxLimit'] = 100;       // A dropdown will be used if fewer items are present


    $cfg['ZipDump']               = TRUE;   // Allow the use of zip/gzip/bzip
    $cfg['GZipDump']              = TRUE;   // compression for
    $cfg['BZipDump']              = TRUE;   // dump files
    $cfg['CompressOnFly']         = TRUE;   // Will compress gzip/bzip2 exports on
                                            // fly without need for much memory.
                                            // If you encounter problems with
                                            // created gzip/bzip2 files disable
                                            // this feature.

    // Tabs display settings
    $cfg['LightTabs']             = FALSE;  // use graphically less intense menu tabs
    $cfg['PropertiesIconic']      = TRUE;   // Use icons instead of text for the table display of a database (TRUE|FALSE|'both')
    $cfg['PropertiesNumColumns']  = 1;      // How many columns should be used for table display of a database?
                                            // (a value larger than 1 results in some information being hidden)

    $cfg['DefaultTabServer']      = 'main.php';
                                           // Possible values:
                                       // 'main.php' = the welcome page
                                       // (recommended for multiuser setups)
                                       // 'server_databases.php' = list of databases
                                       // 'server_status.php' = runtime information
                                       // 'server_variables.php' = MySQL server variables
                                       // 'server_privileges.php' = user management
                                       // 'server_processlist.php' = process list
    $cfg['DefaultTabDatabase']    = 'db_structure.php';
                                           // Possible values:
                                       // 'db_structure.php' = tables list
                                       // 'db_sql.php' = sql form
                                       // 'db_search.php' = search query
                                       // 'db_operations.php' = operations on database
    $cfg['DefaultTabTable']       = 'tbl_structure.php';
                                           // Possible values:
                                       // 'tbl_structure.php' = fields list
                                       // 'tbl_sql.php' = sql form
                                       // 'tbl_select.php' = select page
                                       // 'tbl_change.php' = insert row page
                                       // 'sql.php' = browse page

    $cfg['PDFPageSizes']        = array('A3', 'A4', 'A5', 'letter', 'legal');
    $cfg['PDFDefaultPageSize']  = 'A4';


    /    $cfg['DefaultLang'] = 'en-iso-8859-1';

    $cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci';

    $cfg['FilterLanguages'] = '';

    $cfg['DefaultCharset'] = 'iso-8859-1';


    $cfg['AllowAnywhereRecoding'] = FALSE;

    $cfg['RecodingEngine'] = 'auto';


    $cfg['IconvExtraParams'] = '//TRANSLIT';

    .
    $cfg['AvailableCharsets'] = array(
            'iso-8859-1',
            'iso-8859-2',
            'iso-8859-3',
            'iso-8859-4',
            'iso-8859-5',
            'iso-8859-6',
            'iso-8859-7',
            'iso-8859-8',
            'iso-8859-9',
            'iso-8859-10',
            'iso-8859-11',
            'iso-8859-12',
            'iso-8859-13',
            'iso-8859-14',
            'iso-8859-15',
            'windows-1250',
            'windows-1251',
            'windows-1252',
            'windows-1256',
            'windows-1257',
            'koi8-r',
            'big5',
            'gb2312',
            'utf-16',
            'utf-8',
            'utf-7',
            'x-user-defined',
            'euc-jp',
            'ks_c_5601-1987',
            'tis-620',
            'SHIFT_JIS'
    );



    $cfg['LeftPointerEnable']   = TRUE;         // enable the left panel pointer
                                                // (used when LeftFrameLight is FALSE)
                                                // see also LeftPointerColor
                                                // in layout.inc.php

    $cfg['BrowsePointerEnable'] = TRUE;        // enable the browse pointer
                                                // see also BrowsePointerColor
                                                // in layout.inc.php

    $cfg['BrowseMarkerEnable'] = TRUE;         // enable the browse marker
                                                // see also BrowseMarkerColor
                                                // in layout.inc.php

    $cfg['TextareaCols']        = 40;           // textarea size (columns) in edit mode
                                                // (this value will be emphasized (*2) for sql
                                                // query textareas and (*1.25) for query window)
    $cfg['TextareaRows']        = 7;            // textarea size (rows) in edit mode
    $cfg['LongtextDoubleTextarea'] = TRUE;      // double size of textarea size for longtext fields
    $cfg['TextareaAutoSelect']  = TRUE;         // autoselect when clicking in the textarea of the querybox
    $cfg['CharTextareaCols']    = 40;           // textarea size (columns) for CHAR/VARCHAR
    $cfg['CharTextareaRows']    = 2;            // textarea size (rows) for CHAR/VARCHAR
    $cfg['CtrlArrowsMoving']    = TRUE;         // Enable Ctrl+Arrows moving between fields when editing?
    $cfg['LimitChars']          = 50;           // Max field data length in browse mode for all non-numeric fields
    $cfg['ModifyDeleteAtLeft']  = TRUE;         // show edit/delete links on left side of browse
                                                // (or at the top with vertical browse)
    $cfg['ModifyDeleteAtRight'] = FALSE;        // show edit/delete links on right side of browse
                                                // (or at the bottom with vertical browse)
    $cfg['DefaultDisplay']      = 'horizontal'; // default display direction
                                                // (horizontal|vertical|horizontalflipped)
    $cfg['DefaultPropDisplay']  = 3;            // default display direction for altering/
                                                // creating columns (tbl_properties)
                                                // (horizontal|vertical|<number>)
                                                // number indicates maximal number for which vertical model is used

    $cfg['HeaderFlipType']      = 'css';        // table-header rotation via faking or css? (css|fake)
                                                // NOTE: CSS only works in IE browsers!
    $cfg['ShowBrowseComments']  = TRUE;         // shows stored relation-comments in 'browse' mode.
    $cfg['ShowPropertyComments']= TRUE;         // shows stored relation-comments in 'table property' mode.
    $cfg['RepeatCells']         = 100;          // repeat header names every X cells? (0 = deactivate)

    $cfg['EditInWindow']        = TRUE;         // Set to TRUE if Edit link should open the query to edit in the query window (assuming Javascript is enabled), and to FALSE if we should edit in the right panel
    $cfg['QueryWindowWidth']    = 550;          // Width of Query window
    $cfg['QueryWindowHeight']   = 310;          // Height of Query window
    $cfg['QueryHistoryDB']      = FALSE;         // Set to TRUE if you want DB-based query history.
                                                // If FALSE, this utilizes JS-routines to display
                                                // query history (lost by window close)
    $cfg['QueryWindowDefTab']   = 'sql';        // which tab to display in the querywindow on startup
                                                // (sql|files|history|full)
    $cfg['QueryHistoryMax']     = 25;           // When using DB-based query history, how many entries
                                                // should be kept?
    $cfg['BrowseMIME']          = TRUE;         // Use MIME-Types (stored in column comments table) for
    $cfg['MaxExactCount']       = 20000;        // When approximate count < this, PMA will get exact count for table rows.
    $cfg['MaxExactCountViews']  = 0;            // Zero means that no row count is done for views; see the doc 
    $cfg['WYSIWYG-PDF']         = TRUE;         // Utilize DHTML/JS capabilities to allow WYSIWYG editing of
                                                // the PDF page editor. Requires an IE6/Mozilla based browser.

    $cfg['NaturalOrder']        = TRUE;         // Sort table and database in natural order


    $cfg['TitleTable']          = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
    $cfg['TitleDatabase']       = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
    $cfg['TitleServer']         = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
    $cfg['TitleDefault']        = '@HTTP_HOST@ | @PHPMYADMIN@';

    $cfg['ErrorIconic']          = TRUE;    // show some icons for warning, error and information messages (true|false)?
    $cfg['MainPageIconic']       = TRUE;    // show icons in list on main page and on menu tabs (true|false)?
    $cfg['ReplaceHelpImg']       = TRUE;    // show help button instead of strDocu (true|false)?

    // theme manager
    $cfg['ThemePath']           = './themes';    // using themes manager please set up here the path to 'themes'
                                                 // else leave empty
    $cfg['ThemeManager']        = TRUE;          // if you want to use selectable themes and if ThemesPath not empty
                                                 // set it to true, else set it to false (default is false);
    $cfg['ThemeDefault']        = 'original';         // set up default theme, if ThemePath not empty
                                                 // you can set up here an valid path to themes or 'original' for
                                                 // the original pma-theme
    $cfg['ThemePerServer']      = FALSE;         // allow different theme for each configured server

    //-----------------------------------------------------------------------------


    /**
     * Default queries
     * %d will be replaced by the database name.
     * %t will be replaced by the table name.
     * %f will be replaced by a list of field names.
     * (%t and %f only applies to DefaultQueryTable)
     */
    $cfg['DefaultQueryTable']    = 'SELECT * FROM %t WHERE 1';
    $cfg['DefaultQueryDatabase'] = '';

    /**
     * SQL Query box settings
     * These are the links display in all of the SQL Query boxes
     */
    $cfg['SQLQuery']['Edit']      = TRUE;       // Edit link to change a query
    $cfg['SQLQuery']['Explain']   = TRUE;       // EXPLAIN on SELECT queries
    $cfg['SQLQuery']['ShowAsPHP'] = TRUE;       // Wrap a query in PHP
    $cfg['SQLQuery']['Validate']  = FALSE;      // Validate a query (see $cfg['SQLValidator'] as well)
    $cfg['SQLQuery']['Refresh']   = TRUE;       // Refresh the results page


    /**
     * Webserver upload/save/import directories
     */
    $cfg['UploadDir']             = '';         // Directory for uploaded files that can be executed by
                                                // phpMyAdmin. For example './upload'. Leave empty for
                                                // no upload directory support. Use %u for username
                                                // inclusion.
    $cfg['SaveDir']               = '';         // Directory where phpMyAdmin can save exported data on
                                                // server. For example './save'. Leave empty for no save
                                                // directory support. Use %u for username inclusion.
    $cfg['TempDir']               = '';         // Directory where phpMyAdmin can save temporary files.
                                                // This is needed for MS Excel export, see documentation
                                                // how to enable that.


    /**
     * Misc. settings
     */
    $cfg['GD2Available']          = 'auto';     // Is GD >= 2 available? Set to yes/no/auto. 'auto'
                                                // does autodetection, which is a bit expensive for
                                                // php < 4.3.0, but it is the only safe vay how to
                                                // determine GD version.
    $cfg['TrustedProxies']        = array();    // List of trusted proxies for IP allow/deny

    /**
     * SQL Parser Settings
     */
    $cfg['SQP']['fmtType']      = 'html';       // Pretty-printing style to use on queries (html, text, none)
    $cfg['SQP']['fmtInd']       = '1';          // Amount to indent each level (floats ok)
    $cfg['SQP']['fmtIndUnit']   = 'em';         // Units for indenting each level (CSS Types - {em,px,pt})
    // The graphical settings are now located in themes/themename/layout.inc.php

    /**
     * If you wish to use the SQL Validator service, you should be
     * aware of the following:
     * All SQL statements are stored anonymously for statistical purposes.
     * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
     * All rights reserved.
     */
    $cfg['SQLValidator']['use']      = FALSE;   // Make the SQL Validator available
    $cfg['SQLValidator']['username'] = '';      // If you have a custom username, specify it here (defaults to anonymous)
    $cfg['SQLValidator']['password'] = '';      // Password for username

    /**
     * Developers ONLY!
     * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
     */
    $cfg['DBG']['enable'] = FALSE;              // Make the DBG stuff available
    $cfg['DBG']['profile']['enable'] = FALSE;   // Produce profiling results of PHP
    $cfg['DBG']['profile']['threshold'] = 0.5;  // Threshold of long running code to display
                                                // Anything below the threshold is not displayed


    /**
     * MySQL settings
     */
    // Column types;
    // varchar, tinyint, text and date are listed first, based on estimated popularity
    $cfg['ColumnTypes'] = array(
           'VARCHAR',
           'TINYINT',
           'TEXT',
           'DATE',
           'SMALLINT',
           'MEDIUMINT',
           'INT',
           'BIGINT',
           'FLOAT',
           'DOUBLE',
           'DECIMAL',
           'DATETIME',
           'TIMESTAMP',
           'TIME',
           'YEAR',
           'CHAR',
           'TINYBLOB',
           'TINYTEXT',
           'BLOB',
           'MEDIUMBLOB',
           'MEDIUMTEXT',
           'LONGBLOB',
           'LONGTEXT',
           'ENUM',
           'SET',
           'BOOL'
    );

    // Attributes
    // Note: the "ON UPDATE CURRENT_TIMESTAMP" attribute is added dynamically
    // for MySQL >= 4.1.2, in libraries/tbl_properties.inc.php

    $cfg['AttributeTypes'] = array(
           '',
           'BINARY',
           'UNSIGNED',
           'UNSIGNED ZEROFILL'
    );

    // Available functions
    if ($cfg['ShowFunctionFields']) {
            $cfg['Functions'] = array(
               'ASCII',
               'CHAR',
               'SOUNDEX',
               'LCASE',
               'UCASE',
               'NOW',
               'PASSWORD',
               'OLD_PASSWORD',
               'MD5',
               'SHA1',
               'ENCRYPT',
               'COMPRESS',
               'UNCOMPRESS',
               'RAND',
               'LAST_INSERT_ID',
               'COUNT',
               'AVG',
               'SUM',
               'CURDATE',
               'CURTIME',
               'UTC_DATE',
               'UTC_TIME',
               'UTC_TIMESTAMP',
               'FROM_DAYS',
               'FROM_UNIXTIME',
               'PERIOD_ADD',
               'PERIOD_DIFF',
               'TO_DAYS',
               'UNIX_TIMESTAMP',
               'USER',
               'WEEKDAY',
               'CONCAT',
               'HEX',
               'UNHEX'
            );

            // Which column types will be mapped to which Group?
            $cfg['RestrictColumnTypes'] = array(
               'VARCHAR'      => 'FUNC_CHAR',
               'TINYINT'      => 'FUNC_NUMBER',
               'TEXT'         => 'FUNC_CHAR',
               'DATE'         => 'FUNC_DATE',
               'SMALLINT'     => 'FUNC_NUMBER',
               'MEDIUMINT'    => 'FUNC_NUMBER',
               'INT'          => 'FUNC_NUMBER',
               'BIGINT'       => 'FUNC_NUMBER',
               'FLOAT'        => 'FUNC_NUMBER',
               'DOUBLE'       => 'FUNC_NUMBER',
               'DECIMAL'      => 'FUNC_NUMBER',
               'DATETIME'     => 'FUNC_DATE',
               'TIMESTAMP'    => 'FUNC_DATE',
               'TIME'         => 'FUNC_DATE',
               'YEAR'         => 'FUNC_DATE',
               'CHAR'         => 'FUNC_CHAR',
               'TINYBLOB'     => 'FUNC_CHAR',
               'TINYTEXT'     => 'FUNC_CHAR',
               'BLOB'         => 'FUNC_CHAR',
               'MEDIUMBLOB'   => 'FUNC_CHAR',
               'MEDIUMTEXT'   => 'FUNC_CHAR',
               'LONGBLOB'     => 'FUNC_CHAR',
               'LONGTEXT'     => 'FUNC_CHAR',
               'ENUM'         => '',
               'SET'          => ''
            );

            // Map above defined groups to any function
            $cfg['RestrictFunctions'] = array(
                'FUNC_CHAR'   => array(
                    'ASCII',
                    'CHAR',
                    'SOUNDEX',
                    'LCASE',
                    'UCASE',
                    'PASSWORD',
                    'OLD_PASSWORD',
                    'MD5',
                    'SHA1',
                    'ENCRYPT',
                    'COMPRESS',
                    'UNCOMPRESS',
                    'LAST_INSERT_ID',
                    'USER',
                    'CONCAT',
                    'HEX',
                    'UNHEX'
                ),

                'FUNC_DATE'   => array(
                    'NOW',
                    'CURDATE',
                    'CURTIME',
                    'FROM_DAYS',
                    'FROM_UNIXTIME',
                    'PERIOD_ADD',
                    'PERIOD_DIFF',
                    'TO_DAYS',
                    'UNIX_TIMESTAMP',
                    'UTC_DATE',
                    'UTC_TIME',
                    'UTC_TIMESTAMP',
                    'WEEKDAY'
                ),

                'FUNC_NUMBER' => array(
                    'ASCII',
                    'CHAR',
                    'MD5',
                    'SHA1',
                    'ENCRYPT',
                    'RAND',
                    'LAST_INSERT_ID',
                    'UNIX_TIMESTAMP',
                    'COUNT',
                    'AVG',
                    'SUM'
                )
        );

            // Default functions for above defined groups
            $cfg['DefaultFunctions'] = array(
                'FUNC_CHAR'         => '',
                'FUNC_DATE'         => '',
                'FUNC_NUMBER'       => '',
                'first_timestamp'   => 'NOW'
            );


    }     // end if

    // Search operators
    $cfg['NumOperators'] = array(
           '=',
           '>',
           '>=',
           '<',
           '<=',
           '!=',
           'LIKE',
           'NOT LIKE'
    );

    $cfg['TextOperators'] = array(
           'LIKE',
           'LIKE %...%',
           'NOT LIKE',
           '=',
           '!=',
           'REGEXP',
           'NOT REGEXP'
    );

    $cfg['EnumOperators'] = array(
           '=',
           '!='
    );

    $cfg['SetOperators'] = array(
           'IN',
           'NOT IN'
    );

    $cfg['NullOperators'] = array(
           'IS NULL',
           'IS NOT NULL'
    );

    $cfg['UnaryOperators'] = array(
           'IS NULL'     => 1,
           'IS NOT NULL' => 1
    );

    /**
     * Unset magic_quotes_runtime - do not change!
     */
    set_magic_quotes_runtime(0);
    ?>
     
    lifeisboost, Aug 12, 2008
    #7
  8. falko

    falko Super Moderator ISPConfig Developer

    Looks ok. Have you tried to google for the exact error message?
     
    falko, Aug 12, 2008
    #8
  9. lifeisboost

    lifeisboost New Member

    Yes i have this is the only error

    Cookies must be enabled past this point.

    comes up with fixes i have tried but none of them worked.
     
    lifeisboost, Aug 12, 2008
    #9
  10. lifeisboost

    lifeisboost New Member

    Well, i manually installed phpmyadmin and it works but not the package installed on ispconfig. im not sure what is wrong with the packaged installed version....
     
    lifeisboost, Aug 14, 2008
    #10

Share This Page