my.ini
IOF>>
# CLIENT SECTION
# ———————————————————————-
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]
port=3306
[mysql]
default-character-set=utf8
# SERVER SECTION
# ———————————————————————-
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir=”D:/MySQL_BIN/”
#Path to the database root
datadir=”D:/MySQL_DATA/Data/”
#Log the slow queries
log-slow-queries = “D:/MySQL_LOG/lowqueries.log”
#log-bin = “D:/MySQL_LOG/bin.log”
log-error = “D:/MySQL_LOG/error.log”
#log = “D:/MySQL_LOG/log.log”
#Query cache (KB)
query_alloc_block_size = 8192
query_cache_limit = 1048576
query_cache_min_res_unit = 4096
query_cache_size = 49999872
query_cache_type = 1
query_cache_wlock_invalidate = 0
query_prealloc_size = 8192
#Parameters changed by recommendations sqltuner
join-buffer-size = 256K
tmp-table-size = 90M
max-heap-table-size = 90M
thread-cache-size = 4
innodb-buffer-pool-size = 4M
#Parameters changed by recommendarions PMB
max_allowed_packet = 16M
<<EOF
php.ini
PHP Version 5.2.2
System Windows NT 5.2 build 3790
IOF>>
…
; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.
extension=php_bz2.dll
extension=php_curl.dll
extension=php_gd2.dll
extension=php_mysql.dll
extension=php_soap.dll
extension=php_sockets.dll
extension=php_xsl.dll
extension=php_yaz.dll
extension=php_zip.dll
…
<<EOF
./includes/db_param.inc.php
IOF>>
…
switch(LOCATION):
case ‘remote’: // mettre ici les valeurs pour l’accés distant
define(‘SQL_SERVER’, ‘remote’); // nom du serveur . exemple : http://sql.free.fr
define(‘USER_NAME’, ‘username’); // nom utilisateur
define(‘USER_PASS’, ‘userpwd’); // mot de passe
define(‘DATA_BASE’, ‘dbname’); // nom base de données
define(‘SQL_TYPE’, ‘mysql’); // Type de serveur de base de données
break;
default: // valeurs pour l’accès local
define(‘SQL_SERVER’, ‘sek-sql-server.simonalsa.com:3306′); // nom du serveur
define(‘USER_NAME’, ‘biblio_pmb’); // nom utilisateur
define(‘USER_PASS’, password’); // mot de passe
define(‘DATA_BASE’, ‘biblio’); // nom base de données
define(‘SQL_TYPE’, ‘mysql’); // Type de serveur de base de données
break;
endswitch;
…
<<EOF
./opac_css/includes/opac_db_param.inc.php
IOF>>
…
switch(LOCATION):
case ‘remote’: // mettre ici les valeurs pour l’accés distant
define(‘SQL_SERVER’, ‘remote’); // nom du serveur . exemple : http://sql.free.fr
define(‘USER_NAME’, ‘username’); // nom utilisateur
define(‘USER_PASS’, ‘userpwd’); // mot de passe
define(‘DATA_BASE’, ‘dbname’); // nom base de données
define(‘SQL_TYPE’, ‘mysql’); // Type de serveur de base de données
break;
default: // valeurs pour l’accès local
define(‘SQL_SERVER’, ‘sek-sql-server.simonalsa.com:3306′); // nom du serveur
define(‘USER_NAME’, ‘biblio_pmb’); // nom utilisateur
define(‘USER_PASS’, password’); // mot de passe
define(‘DATA_BASE’, ‘biblio’); // nom base de données
define(‘SQL_TYPE’, ‘mysql’); // Type de serveur de base de données
break;
endswitch;
…
<<EOF
Tags: configuration, database, db_param.inc.php, files, MySQL, OPAC, opac_db_param.inc.php, PMB
MySQL, PHP, PMB | salonso | 
December 1, 2010 7:31 pm | 
Comments (0)
PMB es un software libre de gestión integral de recursos orientados para bibliotecas = SIGB.
Está compuesto por dos grandes bloques una GUI que permite administrar y otra GUI que permite acceder al usuario final al catálogo de servicios ofertados por la biblioteca.
Técnicamente está desarrollado en PHP y utiliza bases de datos en MySQL.
Puedes consultar más información en su página oficial.
Web oficial PMB: http://www.sigb.net
Histórico de versiones:
PMB 3.1.27
PMB 3.2.2
PMB 3.2.6
PMB 3.2.10
PMB 3.2.11
PMB 3.3.RC3
Subscribe