[{"_1":2,"_162":-5,"_163":-5},"loaderData",{"_3":4,"_17":18,"_25":26,"_141":142},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7,"_13":14,"_15":16},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","theme","system","contrast","normal","routes/_layout",{"_19":-5,"_20":21,"_22":21,"_23":11,"_24":21},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_27":28,"_29":-5,"_30":11,"_31":11,"_32":33,"_34":35,"_36":-5,"_37":11,"_38":39,"_88":-5,"_89":90,"_130":-5,"_131":11,"_132":21,"_133":11,"_134":-5,"_135":11,"_136":-5,"_137":138,"_139":91,"_140":-7},"canonicalUrl","https://hub.docker.com/r/dsalazar1982/debian/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","dsalazar1982","reponame","debian","cloudBuildSource","isAutobuildsAvailable","repo",{"_40":41,"_42":43,"_45":46,"_47":48,"_49":11,"_50":51,"_52":53,"_54":55,"_57":35,"_32":33,"_58":59,"_60":44,"_61":62,"_63":64,"_65":66,"_67":-5,"_68":62,"_69":70,"_71":11,"_72":33,"_73":74,"_79":11,"_80":81,"_85":33,"_86":87},"categories",[],"content_types",[44],"image","date_registered","2020-05-07T16:47:15.562719Z","description","Imagen con GNU/Linux Debian10, Apache2.4.38, PHP7.4.5, ODBC17, Drivers PHP SQLServer2019 y MariaDB.","is_private","last_updated","2020-05-09T06:51:39.811408Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[56],"application/vnd.docker.container.image.v1+json","name","pull_count",85,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","# Referencia rapida\n\n- Generado por: [Daniel Salazar Erazo](https://opensed.wordpress.com/)\n- Donde obtener ayuda: [Debian en Docker Hub](https://hub.docker.com/_/debian), [Pagina oficial de Apache2](https://httpd.apache.org/), [Pagina oficial de PHP](https://www.php.net/manual/es/), [Documentacion de Microsoft SQL Server](https://docs.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver15)\n\n# Etiquetas compatibles y enlaces `Dockerfile` respectivos\n\n- [10](https://github.com/dsalazar1982/Dockerfile/tree/master/Debian10%2C%20Apache2%2C%20PHP7)\n\n# Que es dsalazar1982/debian:10?\n\n> Es una imagen generada con el sistema operativo GNU/Linux Debian 10 \"buster\", el servicio Apache 2.4.38, integrado con PHP 7.4.5, el driver Microsoft ODBC17 para SQL Server y los drvier para PHP de Microsoft SQL Server 2019, asi como los modulos para conexion con base de datos MariaDB o MySQL.\n\n## Sistema base\nGNU/Linux Debian 10 \"buster \"\n\n## Paquetes instalados\n\n- vim\n- curl\n- apt-transport-https\n- wget\n- lsb-release\n- locales \n- php7.4\n- php7.4-dev\n- php7.4-xml\n- php7.4-intl\n- msodbcsql17\n- unixodbc-dev\n- sqlsrv\n- pdo_sqlsrv\n- apache2\n- libapache2-mod-php7.4\n- php7.4-mysql\n- openssl\n- apache2-ssl-dev\n\n\n## Ficheros adicionales\n\nLos siguientes ficheros se encunetran ubucados en la ruta __/var/www/html/__ dentro del contenedor generado.\n\n- phpinfo.php: \n```php\n\n```\n- conexion_mssql.php\n```php\n \"def.db\", // Cambiar def.db por nombre de la base de datos.\n \"uid\" => \"def.user\", // Cambiar def.user por el usuario de la base de datos.\n \"pwd\" => \"def.password\" // Cambiar def.password por la clave de acceso del usuario con permisos en la base de datos.\n );\n // Establece la conexión.\n $conn = sqlsrv_connect($serverName, $connectionOptions);\n if ($conn === false) {\n die(formatErrors(sqlsrv_errors()));\n }\n // Seleccionar consulta\n $tsql = \"SELECT @@Version AS SQL_VERSION\";\n // Ejecuta la consulta\n $stmt = sqlsrv_query($conn, $tsql);\n // Manejo de errores\n if ($stmt === false) {\n die(formatErrors(sqlsrv_errors()));\n }\n?>\n

Resultado :

\nFallo la conexion \";\n echo \"

Informacion de error:

\";\n foreach ($errors as $error) {\n echo \"SQLSTATE: \". $error['SQLSTATE'] . \"
\";\n echo \"Codigo: \". $error['code'] . \"
\";\n echo \"Mensaje: \". $error['message'] . \"
\";\n }\n }\n?>\n```\n\nLos siguientes ficheros se encunetran ubucados en la ruta __/etc/apache2/sites-available__ dentro del contenedor generado.\n\n- ssl-cert-snakeoil.pem\n- ssl-cert-snakeoil.cert\n\n> Estos dos ficheros deben ser creados por medio de OpenSSL con la informacion de su sitio web (Consultar en Internet como habilitar SSL en Apache), estos dos ficheros fueron generados por medio del comando __openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /ssl-cert-snakeoil.key\" -out /ssl-cert-snakeoil.pem__\n\n## Crear contenedor con base en la imagen\n\nIniciando contenedor basico con exposicion de los puertos 80 y 443:\n\n```docker\ndocker container run -itd -p 80:80 -p 443:443 dsalazar1982/debian:10\n```\n\n> Despues de inciar contenedor, editar el fichero __conexion_mssql.php__ mencionado en la seccion de __`Ficheros adicionales`__ con la informacion de su servidor MS SQL Server para probar conexion con su servidor MS SQL Server, sin embargo se recomienda montar un volumen para contar con persistencia de informacion (Recuerde que la edicion de ficheros en un contenedor es temporal)\n\nIniciando contenedor con persistencia de informacion y exposicion de los puertos 80 y 443:\n\n```docker\ndocker container run -v :/var/www/html -itd -p 80:80 -p 443:443 dsalazar1982/debian:10\n```\n\n## Links\n\n- [Imagen oficial de GNU/Linux Debian en Docker Hub](https://hub.docker.com/_/debian)\n- [Tutorial de instalación de Linux y macOS para los controladores de Microsoft para PHP para SQL Server](https://docs.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver15)\n- [Instale el controlador ODBC de Microsoft para SQL Server (Linux)](https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15)","has_starred","hub_user","immutable_tags_settings",{"_75":11,"_76":77},"enabled","rules",[78],".*","is_automated","permissions",{"_82":21,"_83":11,"_84":11},"read","write","admin","user","storage_size",452912350,"orgData","recentTags",[91],{"_92":44,"_93":94,"_95":96,"_97":98,"_99":100,"_50":119,"_120":94,"_121":33,"_122":56,"_57":123,"_124":125,"_126":109,"_127":119,"_128":117,"_129":21},"content_type","creator",9696654,"full_size",266612062,"id",99369875,"images",[101],{"_102":103,"_104":105,"_106":107,"_108":109,"_110":111,"_112":113,"_114":107,"_115":-5,"_116":96,"_63":117,"_118":-5},"architecture","amd64","digest","sha256:aab5fcf9c8a64a7e34db9996820b2e01e7fbbe29460253f28fc52ff27ab8073e","features","","last_pulled","2026-08-15T01:33:28.548460089Z","last_pushed","2020-05-09T06:46:11Z","os","linux","os_features","os_version","size","inactive","variant","2020-05-09T06:51:39.463222Z","last_updater","last_updater_username","media_type","10","repository",8992993,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","showSbxLogoOverride","sbxTrademarkText","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"selectedTag","attestationsUrl","routes/_layout.r.$namespace.$reponame.tags",{"_38":143,"_150":151,"_137":160,"_161":11},{"_40":144,"_42":145,"_45":46,"_47":48,"_49":11,"_50":51,"_52":53,"_54":146,"_57":35,"_32":33,"_58":59,"_60":44,"_61":62,"_63":64,"_65":66,"_67":-5,"_68":62,"_69":70,"_71":11,"_72":33,"_73":147,"_79":11,"_80":149,"_85":33,"_86":87},[],[44],[56],{"_75":11,"_76":148},[78],{"_82":21,"_83":11,"_84":11},"tags",{"_152":64,"_153":-5,"_154":-5,"_155":156},"count","next","previous","results",[157],{"_92":44,"_93":94,"_95":96,"_97":98,"_99":158,"_50":119,"_120":94,"_121":33,"_122":56,"_57":123,"_124":125,"_126":109,"_127":119,"_128":117,"_129":21},[159],{"_102":103,"_104":105,"_106":107,"_108":109,"_110":111,"_112":113,"_114":107,"_115":-5,"_116":96,"_63":117,"_118":-5},[],"canDeleteTags","actionData","errors"]

dsalazar1982/debian

Tags for dsalazar1982/debian