SA-MP Forums Archive
No conecta la base de datos MYSQL(VPS, Ubuntu) - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Español/Spanish (https://sampforum.blast.hk/forumdisplay.php?fid=29)
+---- Thread: No conecta la base de datos MYSQL(VPS, Ubuntu) (/showthread.php?tid=594118)


No conecta la base de datos MYSQL(VPS, Ubuntu) - MaikelRincon - 13.11.2015

Buenas, logrй que la Gamemode abriera correctamente en el VPS, se instalу otro sistema operativo(https://sampforum.blast.hk/showthread.php?tid=594020), pero ahora se me presenta que la Gamemode no conecta con la base de datos, en el mysql.log dice lo siguiente:

Error que mбs se repite

Код:
[18:04:29] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[18:04:29] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
acб el server log completo, alguien me podrнa dar alguna soluciуn urgente por favor..

Код:
[18:04:29] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "basededatos", password: "****", port: 3306, autoreconnect: true
[18:04:29] [DEBUG] CMySQLHandle::Create - creating new connection..
[18:04:29] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[18:04:29] [DEBUG] CMySQLHandle::Create - connection created with ID = 1
[18:04:29] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[18:04:29] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[18:04:29] [DEBUG] mysql_query - connection: 1, query: "SELECT SQLID FROM vehiculos ORDER BY SQLID DESC", use_cache: true
[18:04:29] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[18:04:29] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[18:04:29] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[18:04:29] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[18:04:29] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[18:04:29] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[18:04:29] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[18:04:29] [DEBUG] cache_get_row_count - connection: 1
[18:04:29] [WARNING] cache_get_row_count - no active cache
[18:04:29] [DEBUG] cache_get_field_count - connection: 1
[18:04:29] [WARNING] cache_get_field_count - no active cache
[18:04:29] [DEBUG] mysql_query - connection: 1, query: "SELECT ID FROM casas ORDER BY ID DESC", use_cache: true
[18:04:29] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[18:04:29] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[18:04:29] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[18:04:29] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[18:04:29] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[18:04:29] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[18:04:29] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[18:04:29] [DEBUG] cache_get_row_count - connection: 1
[18:04:29] [WARNING] cache_get_row_count - no active cache
[18:04:29] [DEBUG] cache_get_field_count - connection: 1
[18:04:29] [WARNING] cache_get_field_count - no active cache
[18:04:29] [DEBUG] mysql_query - connection: 1, query: "SELECT ID FROM negocios ORDER BY ID DESC", use_cache: true
[18:04:29] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[18:04:29] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[18:04:29] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[18:04:29] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[18:04:29] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[18:04:29] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[18:04:29] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[18:04:29] [DEBUG] cache_get_row_count - connection: 1
[18:04:29] [WARNING] cache_get_row_count - no active cache
[18:04:29] [DEBUG] cache_get_field_count - connection: 1
[18:04:29] [WARNING] cache_get_field_count - no active cache
[18:04:29] [DEBUG] mysql_query - connection: 1, query: "SELECT ID FROM turfs ORDER BY ID DESC", use_cache: true
[18:04:29] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[18:04:29] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[18:04:29] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[18:04:29] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[18:04:29] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[18:04:29] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[18:04:29] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[18:04:29] [DEBUG] cache_get_row_count - connection: 1
[18:04:29] [WARNING] cache_get_row_count - no active cache
[18:04:29] [DEBUG] cache_get_field_count - connection: 1
[18:04:29] [WARNING] cache_get_field_count - no active cache
[18:04:29] [DEBUG] mysql_query - connection: 1, query: "SELECT ID FROM facciones ORDER BY ID DESC", use_cache: true
[18:04:29] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[18:04:29] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[18:04:29] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[18:04:29] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[18:04:29] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[18:04:29] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[18:04:29] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[18:04:29] [DEBUG] cache_get_row_count - connection: 1
[18:04:29] [WARNING] cache_get_row_count - no active cache
[18:04:29] [DEBUG] cache_get_field_count - connection: 1
[18:04:29] [WARNING] cache_get_field_count - no active cache
[18:04:29] [DEBUG] mysql_format - connection: 1, len: 180, format: "SELECT * FROM `facciones` WHERE `ID` = %d"
[18:04:29] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM `facciones` WHERE `ID` = 0", use_cache: true
[18:04:29] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[18:04:29] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[18:04:29] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[18:04:29] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[18:04:29] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[18:04:29] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[18:04:29] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[18:04:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[18:04:29] [WARNING] cache_get_field_content_int - no active cache
[18:04:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Nombre", connection: 1, max_len: 60
[18:04:29] [WARNING] cache_get_field_content - no active cache
[18:04:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango1", connection: 1, max_len: 60
[18:04:29] [WARNING] cache_get_field_content - no active cache
[18:04:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango2", connection: 1, max_len: 60
[18:04:29] [WARNING] cache_get_field_content - no active cache
[18:04:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango3", connection: 1, max_len: 60
[18:04:29] [WARNING] cache_get_field_content - no active cache
[18:04:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango4", connection: 1, max_len: 60
[18:04:29] [WARNING] cache_get_field_content - no active cache
[18:04:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango5", connection: 1, max_len: 60
[18:04:29] [WARNING] cache_get_field_content - no active cache
[18:04:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango6", connection: 1, max_len: 60
[18:04:29] [WARNING] cache_get_field_content - no active cache
[18:04:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango7", connection: 1, max_len: 60
[18:04:29] [WARNING] cache_get_field_content - no active cache
[18:04:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Rango8", connection: 1, max_len: 60
[18:04:29] [WARNING] cache_get_field_content - no active cache
[18:04:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Lider", connection: 1, max_len: 60
[18:04:29] [WARNING] cache_get_field_content - no active cache
[18:04:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Tipo", connection: 1
[18:04:29] [WARNING] cache_get_field_content_int - no active cache
[18:04:29] [DEBUG] cache_get_field_content - row: 0, field_name: "Color", connection: 1, max_len: 60
[18:04:29] [WARNING] cache_get_field_content - no active cache
[18:04:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "PuntosExpansion", connection: 1
[18:04:29] [WARNING] cache_get_field_content_int - no active cache
[18:04:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "TiempoArmas", connection: 1
[18:04:29] [WARNING] cache_get_field_content_int - no active cache
[18:04:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "TiempoDrogas", connection: 1
[18:04:29] [WARNING] cache_get_field_content_int - no active cache
[18:04:29] [DEBUG] mysql_query - connection: 1, query: "SELECT SQLID FROM plantaciones ORDER BY SQLID DESC", use_cache: true
[18:04:29] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[18:04:29] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[18:04:29] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[18:04:29] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[18:04:29] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[18:04:29] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[18:04:29] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[18:04:29] [DEBUG] cache_get_row_count - connection: 1
[18:04:29] [WARNING] cache_get_row_count - no active cache
[18:04:29] [DEBUG] cache_get_field_count - connection: 1
[18:04:29] [WARNING] cache_get_field_count - no active cache
[18:04:29] [DEBUG] mysql_format - connection: 1, len: 180, format: "SELECT * FROM `plantaciones` WHERE `SQLID` = %d"
[18:04:29] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM `plantaciones` WHERE `SQLID` = 0", use_cache: true
[18:04:29] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[18:04:29] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[18:04:29] [ERROR] CMySQLQuery::Execute[()] - (error #2006) MySQL server has gone away
[18:04:29] [WARNING] CMySQLQuery::Execute[()] - lost connection, reconnecting..
[18:04:29] [DEBUG] CMySQLConnection::Disconnect - connection was closed
[18:04:29] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
[18:04:29] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[18:04:29] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Estado", connection: 1
[18:04:29] [WARNING] cache_get_field_content_int - no active cache
un amigo que me esta ayudando me dijo que se logra conectar, pero colapsa... uso de sistema operativo: Ubuntu 15.04 Server (64 bits)

Re: No conecta la base de datos MYSQL(VPS, Ubuntu) - Alex18 - 13.11.2015

Lo que pasa cuando noobs abren servidores.

Re: No conecta la base de datos MYSQL(VPS, Ubuntu) - OnlyI - 13.11.2015

Quote:
Originally Posted by Alex18
Посмотреть сообщение
Lo que pasa cuando noobs abren servidores.
Gente como tъ no deberнa estar por estos foros sin animo de ofender a nadie, sabemos que es noob o novato como quieras llamarlo para eso a posteado aquн y para eso estamos todos para ayudarlo y si no sabes como o no te apetece echarle un cable no postees cosas que desvirtuen el post;

@MaikelRincon en host tienes "localhost" Tienes la base de datos ahн con el MySQL?

Respuesta: Re: No conecta la base de datos MYSQL(VPS, Ubuntu) - Brocky - 13.11.2015

Quote:
Originally Posted by OnlyI
Посмотреть сообщение
Gente como tъ no deberнa estar por estos foros sin animo de ofender a nadie, sabemos que es noob o novato como quieras llamarlo para eso a posteado aquн y para eso estamos todos para ayudarlo y si no sabes como o no te apetece echarle un cable no postees cosas que desvirtuen el post;

@MaikelRincon en host tienes "localhost" Tienes la base de datos ahн con el MySQL?
Buena contestacion man cada uno el libre y es un foro para ayudar uno al otro no para ofender ala jente pero hoy en dia solo hay jente asin que se va acer espero que pronto aya un admin espanich para poner pilas en la seccion

Maykol fijate si el vps tiene mysql si no es tendras que instalarlo el phmyadmin hay subes tu bd y luego lo %defines la coneccion y listo

Re: No conecta la base de datos MYSQL(VPS, Ubuntu) - Alex18 - 13.11.2015

Quote:
Originally Posted by OnlyI
Посмотреть сообщение
Gente como tъ no deberнa estar por estos foros sin animo de ofender a nadie, sabemos que es noob o novato como quieras llamarlo para eso a posteado aquн y para eso estamos todos para ayudarlo y si no sabes como o no te apetece echarle un cable no postees cosas que desvirtuen el post;

@MaikelRincon en host tienes "localhost" Tienes la base de datos ahн con el MySQL?
Te tomas las cosas demasiado en serio. No me importa eso, lo que pasa es que noobs como este luego abren servidores y tienen usuarios sin saber ni como subir una db a un vps.

Respuesta: Re: No conecta la base de datos MYSQL(VPS, Ubuntu) - MaikelRincon - 13.11.2015

Quote:
Originally Posted by OnlyI
Посмотреть сообщение
Gente como tъ no deberнa estar por estos foros sin animo de ofender a nadie, sabemos que es noob o novato como quieras llamarlo para eso a posteado aquн y para eso estamos todos para ayudarlo y si no sabes como o no te apetece echarle un cable no postees cosas que desvirtuen el post;

@MaikelRincon en host tienes "localhost" Tienes la base de datos ahн con el MySQL?
Sн, todo esta bien configurado en mi computadora desde que comencй con la programaciуn del Gamemode siempre anduvo perfecto en mi PC, ahora me esta dando problemas con esto del Linux en el VPS...

Respuesta: Re: No conecta la base de datos MYSQL(VPS, Ubuntu) - MaikelRincon - 13.11.2015

Quote:
Originally Posted by Brocky
Посмотреть сообщение
Buena contestacion man cada uno el libre y es un foro para ayudar uno al otro no para ofender ala jente pero hoy en dia solo hay jente asin que se va acer espero que pronto aya un admin espanich para poner pilas en la seccion

Maykol fijate si el vps tiene mysql si no es tendras que instalarlo el phmyadmin hay subes tu bd y luego lo %defines la coneccion y listo
Lo sй, vuelvo a repetir todo esta configurado bien mбs tira esos errores en el server.log y no carga nada de la base de datos..

Respuesta: No conecta la base de datos MYSQL(VPS, Ubuntu) - MaikelRincon - 13.11.2015

Si solo fuera un error simple y fбcil de solucionar ya lo fuйramos reparado, por algo acб elaborй el post esperando ayuda de personas con conocimiento sobre este tipo de errores que me den una soluciуn ya que llevamos todo el dнa con esto, se configurу la protecciуn al VPS, TS3 y Gamemode instalado correctamente mбs el phpmyadmin que puedo acceder perfectamente desde mi computadora donde esta la base de datos bien instalada como siempre lo estuvo en mi computadora.

Respuesta: No conecta la base de datos MYSQL(VPS, Ubuntu) - MaikelRincon - 14.11.2015

Solucionado, Gracias.