[imported_Anth0ny]

... and will be useful command sm_sql_listadmins (with SQl support) for "who admins now" checking =)

[Solltex]

[sql-admin-manager.smx] Could not connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

where find problem?

[^BuGs^]

Originally Posted by imported_Anth0ny ... and will be useful command sm_sql_listadmins (with SQl support) for "who admins now" checking =)

I have coded this and awaiting BAILOPAN approval.

[BAILOPAN]

Solltex: What did you put for the hostname?

[[Arnold]]

Originally Posted by Solltex [sql-admin-manager.smx] Could not connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) where find problem?

Using a recent Debian based Linux? If that's true try to set up a symlink to where the mysqld socket is located here and see if it works:

ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock

Arnold

[Solltex]

Originally Posted by BAILOPAN Solltex: What did you put for the hostname?

localhost

Originally Posted by [Arnold] Using a recent Debian based Linux? If that's true try to set up a symlink to where the mysqld socket is located here and see if it works: ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock Arnold

Linux slackware

root@***:~# ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock
ln: `/tmp/mysql.sock': File exists

this ok, but in server console anyway have problem:
08/24/2007 - 23:08:28: [sql-admin-manager.smx] Could not connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)


P.S sorry need not mysqld/mysqld.sock , but mysql/mysql.sock. WORKS

[BAILOPAN]

Try using 127.0.0.1 instead of localhost

If that doesn't work post a feature request for using a direct socket through the host string.

[khap]

try hostname

localhost:/var/run/mysqld/mysqld.sock

[imported_Anth0ny]

=)

We offer to chage default mysql codepage for plugin from latin1 to utf8 for native supporting multilanguage.

i hope this code right...

details:

admin-sql-threaded.sp

public OnRebuildAdminCache(AdminCachePart:part)
{
/* First try to get a database connection */
decl String:error[255];
new Handle:db;
 
if (SQL_CheckConfig("admins"))
{
db = SQL_Connect("admins", true, error, sizeof(error));
} else {
db = SQL_Connect("default", true, error, sizeof(error));
}
 
if (db == INVALID_HANDLE)
{
LogError("Could not connect to database \"default\": %s", error);
return;
}

/* Set codepage to utf8 */
 
decl String:query[255];
Format(query, sizeof(query), "SET NAMES 'utf8'");
if (!SQL_FastQuery(db, query))
{
LogError("Can't select character set (%s)", query);
}

/* End of Set codepage to utf8 */
 
if (part == AdminCache_Overrides)
{
FetchOverrides(db);
} else if (part == AdminCache_Groups) {
FetchGroups(db);
} else if (part == AdminCache_Admins) {
FetchUsers(db);
}
 
CloseHandle(db);
}

sql-admin-manager.sp

Handle:Connect()
{
decl String:error[255];
new Handle:db;
 
if (SQL_CheckConfig("admins"))
{
db = SQL_Connect("admins", true, error, sizeof(error));
} else {
db = SQL_Connect("default", true, error, sizeof(error));
}
 
if (db == INVALID_HANDLE)
{
LogError("Could not connect to database: %s", error);
}

/* Set codepage to utf8 */
 
decl String:query[255];
Format(query, sizeof(query), "SET NAMES 'utf8'");
if (!SQL_FastQuery(db, query))
{
LogError("Can't select character set (%s)", query);
}

/* End of Set codepage to utf8 */
 
return db;
}

or much better include it to dbi.inc....

[BAILOPAN]

MySQL-specific table properties should go in the mysql setup script.