Risultati da 1 a 7 di 7

Discussione: Configurazione file config

  1. #1

    Configurazione file config

    Ciao a tutti!
    Ho un problema. Non riesco a configurare il file config per poter accedere alla "query SQL"...ho seguito le istruzioni qui riportate ma niente da fare
    Qualcuno mi sa dare qualche consiglio?
    Grazie in anticipo
    Alex

  2. #2
    Borg L'avatar di y2ksw
    Data Registrazione
    Nov 2004
    Località
    Bologna, Italia
    Età
    63
    Messaggi
    9,026
    Metti nel file config.php:

    $config['SpecialUsers']['canrunqueries'] = '1,2,3';

    dove 1,2,3 sono gli ID degli utenti che possono accedere alle query. Aggiorna anche la pagina dopo la modifica del file
    Giovanni
    http://www.trimelli.com/

    Per favore non mandatemi PM, ma scrivete sul forum. Vi sarà risposto prima.

  3. #3
    Niente, non sono riuscito a risolvere e ancora non posso accedere alla query SQL
    Posso postare il testo del file config? Così se potete controllate se c'è qualcosa che non va. Grazie
    Alex

  4. #4
    Senior Member
    Data Registrazione
    Dec 2005
    Località
    Rome, Italy, Italy
    Messaggi
    945
    si certo togli i tuoi dati..................

  5. #5
    Ecco qua, in rosso i dati personali cancellati. Grazie

    <?php
    /*================================================= =====================*\
    || ################################################## ################## ||
    || # vBulletin 4.0.5
    || # ---------------------------------------------------------------- # ||
    || # All PHP code in this file is ©2000-2010 vBulletin Solutions Inc. # ||
    || # This file may not be redistributed in whole or significant part. # ||
    || # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # ||
    || # http://www.vbulletin.com | http://www.vbulletin.com/license.html # ||
    || ################################################## ################## ||
    \*================================================ ======================*/

    /*-------------------------------------------------------*\
    | ****** NOTE REGARDING THE VARIABLES IN THIS FILE ****** |
    +---------------------------------------------------------+
    | If you get any errors while attempting to connect to |
    | MySQL, you will need to email your webhost because we |
    | cannot tell you the correct values for the variables |
    | in this file. |
    \*-------------------------------------------------------*/

    // ****** DATABASE TYPE ******
    // This is the type of the database server on which your vBulletin database will be located.
    // Valid options are mysql and mysqli, for slave support add _slave. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
    // for slave options just append _slave to your preferred database type.
    $config['Database']['dbtype'] = 'mysql';

    // ****** DATABASE NAME ******
    // This is the name of the database where your vBulletin will be located.
    // This must be created by your webhost.
    $config['Database']['dbname'] = 'xxxxxxxxxxx';

    // ****** TABLE PREFIX ******
    // Prefix that your vBulletin tables have in the database.
    $config['Database']['tableprefix'] = '';

    // ****** TECHNICAL EMAIL ADDRESS ******
    // If any database errors occur, they will be emailed to the address specified here.
    // Leave this blank to not send any emails when there is a database error.
    $config['Database']['technicalemail'] = 'xxxxxxxxxxxxxxx';

    // ****** FORCE EMPTY SQL MODE ******
    // New versions of MySQL (4.1+) have introduced some behaviors that are
    // incompatible with vBulletin. Setting this value to "true" disables those
    // behaviors. You only need to modify this value if vBulletin recommends it.
    $config['Database']['force_sql_mode'] = false;



    // ****** MASTER DATABASE SERVER NAME AND PORT ******
    // This is the hostname or IP address and port of the database server.
    // If you are unsure of what to put here, leave the default values.
    $config['MasterServer']['servername'] ='62.149.150.118';
    $config['MasterServer']['port'] = 3306;

    // ****** MASTER DATABASE USERNAME & PASSWORD ******
    // This is the username and password you use to access MySQL.
    // These must be obtained through your webhost.

    $config['MasterServer']['username'] = 'xxxxxxxxx';
    $config['MasterServer']['password'] = 'xxxxxx';

    // ****** MASTER DATABASE PERSISTENT CONNECTIONS ******
    // This option allows you to turn persistent connections to MySQL on or off.
    // The difference in performance is negligible for all but the largest boards.
    // If you are unsure what this should be, leave it off. (0 = off; 1 = on)
    $config['MasterServer']['usepconnect'] = 0;



    // ****** SLAVE DATABASE CONFIGURATION ******
    // If you have multiple database backends, this is the information for your slave
    // server. If you are not 100% sure you need to fill in this information,
    // do not change any of the values here.
    $config['SlaveServer']['servername'] = '';
    $config['SlaveServer']['port'] = 3306;
    $config['SlaveServer']['username'] = '';
    $config['SlaveServer']['password'] = '';
    $config['SlaveServer']['usepconnect'] = 0;



    // ****** PATH TO ADMIN & MODERATOR CONTROL PANELS ******
    // This setting allows you to change the name of the folders that the admin and
    // moderator control panels reside in. You may wish to do this for security purposes.
    // Please note that if you change the name of the directory here, you will still need
    // to manually change the name of the directory on the server.
    $config['Misc']['admincpdir'] = 'admincp';
    $config['Misc']['modcpdir'] = 'modcp';

    // Prefix that all vBulletin cookies will have
    // Keep this short and only use numbers and letters, i.e. 1-9 and a-Z
    $config['Misc']['cookieprefix'] = 'bb';

    // ******** FULL PATH TO FORUMS DIRECTORY ******
    // On a few systems it may be necessary to input the full path to your forums directory
    // for vBulletin to function normally. You can ignore this setting unless vBulletin
    // tells you to fill this in. Do not include a trailing slash!
    // Example Unix:
    // $config['Misc']['forumpath'] = '/home/users/public_html/forums';
    // Example Win32:
    // $config['Misc']['forumpath'] = 'c:\program files\apache group\apache\htdocs\vb3';
    $config['Misc']['forumpath'] = '';



    // ****** USERS WITH ADMIN LOG VIEWING PERMISSIONS ******
    // The users specified here will be allowed to view the admin log in the control panel.
    // Users must be specified by *ID number* here. To obtain a user's ID number,
    // view their profile via the control panel. If this is a new installation, leave
    // the first user created will have a user ID of 1. Seperate each userid with a comma.
    $config['SpecialUsers']['canviewadminlog'] = '1';

    // ****** USERS WITH ADMIN LOG PRUNING PERMISSIONS ******
    // The users specified here will be allowed to remove ("prune") entries from the admin
    // log. See the above entry for more information on the format.
    $config['SpecialUsers']['canpruneadminlog'] = '1';

    // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    // The users specified here will be allowed to run queries from the control panel.
    // See the above entries for more information on the format.
    // Please note that the ability to run queries is quite powerful. You may wish
    // to remove all user IDs from this list for security reasons.
    $config['SpecialUsers']['canrunqueries'] = 'Camminante';

    // ****** UNDELETABLE / UNALTERABLE USERS ******
    // The users specified here will not be deletable or alterable from the control panel by any users.
    // To specify more than one user, separate userids with commas.
    $config['SpecialUsers']['undeletableusers'] = '';

    // ****** SUPER ADMINISTRATORS ******
    // The users specified below will have permission to access the administrator permissions
    // page, which controls the permissions of other administrators
    $config['SpecialUsers']['superadministrators'] = '1';

    // ****** DATASTORE CACHE CONFIGURATION *****
    // Here you can configure different methods for caching datastore items.
    // vB_Datastore_Filecache - to use includes/datastore/datastore_cache.php
    // vB_Datastore_APC - to use APC
    // vB_Datastore_XCache - to use XCache
    // vB_Datastore_Memcached - to use a Memcache server, more configuration below
    // $config['Datastore']['class'] = 'vB_Datastore_Filecache';

    // ******** DATASTORE PREFIX ******
    // If you are using a PHP Caching system (APC, XCache, eAccelerator) with more
    // than one set of forums installed on your host, you *may* need to use a prefix
    // so that they do not try to use the same variable within the cache.
    // This works in a similar manner to the database table prefix.
    // $config['Datastore']['prefix'] = '';

    // It is also necessary to specify the hostname or IP address and the port the server is listening on
    /*
    $config['Datastore']['class'] = 'vB_Datastore_Memcached';
    $i = 0;
    // First Server
    $i++;
    $config['Misc']['memcacheserver'][$i] = '127.0.0.1';
    $config['Misc']['memcacheport'][$i] = 11211;
    $config['Misc']['memcachepersistent'][$i] = true;
    $config['Misc']['memcacheweight'][$i] = 1;
    $config['Misc']['memcachetimeout'][$i] = 1;
    $config['Misc']['memcacheretry_interval'][$i] = 15;
    */

    // ****** The following options are only needed in special cases ******

    // ****** MySQLI OPTIONS *****
    // When using MySQL 4.1+, MySQLi should be used to connect to the database.
    // If you need to set the default connection charset because your database
    // is using a charset other than latin1, you can set the charset here.
    // If you don't set the charset to be the same as your database, you
    // may receive collation errors. Ignore this setting unless you
    // are sure you need to use it.
    // $config['Mysqli']['charset'] = 'utf8';

    // Optionally, PHP can be instructed to set connection parameters by reading from the
    // file named in 'ini_file'. Please use a full path to the file.
    // Example:
    // $config['Mysqli']['ini_file'] = 'c:\program files\MySQL\MySQL Server 4.1\my.ini';
    $config['Mysqli']['ini_file'] = '';

    // Image Processing Options
    // Images that exceed either dimension below will not be resized by vBulletin. If you need to resize larger images, alter these settings.
    $config['Misc']['maxwidth'] = 2592;
    $config['Misc']['maxheight'] = 1944;

    /*================================================= =====================*\
    || ################################################## ##################
    || # Downloaded: 16:53, Thu Jul 15th 2010
    || # CVS: $RCSfile$ - $Revision: 32878 $
    || ################################################## ##################
    \*================================================ ======================*/

  6. #6
    Senior Member
    Data Registrazione
    Dec 2005
    Località
    Rome, Italy, Italy
    Messaggi
    945
    $ Config ['SpecialUsers'] ['canrunqueries'] = '1';

  7. #7
    Borg L'avatar di y2ksw
    Data Registrazione
    Nov 2004
    Località
    Bologna, Italia
    Età
    63
    Messaggi
    9,026
    Al posto di $config['SpecialUsers']['canrunqueries'] = 'Camminante'; devi mettere $config['SpecialUsers']['canrunqueries'] = '1';, se 1 è l'ID dellutente amministratore = tuo
    Giovanni
    http://www.trimelli.com/

    Per favore non mandatemi PM, ma scrivete sul forum. Vi sarà risposto prima.

Discussioni Simili

  1. [PROBLEMA] Configurazione Config.PHP
    Di #iCE+# nel forum Come faccio
    Risposte: 2
    Ultimo Messaggio: 27-03-2010, 12:46
  2. vBulletin 3.7.x non riesco a trovare il file config.php.new perke?
    Di pako95 nel forum VBulletin 3
    Risposte: 2
    Ultimo Messaggio: 18-10-2008, 12:27
  3. vBulletin 3.6.x Problema File Config.php
    Di Bozerman nel forum VBulletin 3
    Risposte: 9
    Ultimo Messaggio: 18-09-2008, 19:12
  4. vBulletin 3.5.x Con quale programma devo aprire il file Config.php.new ?
    Di werk90 nel forum VBulletin 3
    Risposte: 8
    Ultimo Messaggio: 06-05-2008, 18:54
  5. vBulletin 3.6.x Aiuto configurazione config.php
    Di xLuca94 nel forum VBulletin 3
    Risposte: 6
    Ultimo Messaggio: 26-01-2008, 14:09

Tag per Questa Discussione

Segnalibri

Permessi di Scrittura

  • Tu non puoi inviare nuove discussioni
  • Tu non puoi inviare risposte
  • Tu non puoi inviare allegati
  • Tu non puoi modificare i tuoi messaggi
  •