Raised This Month: $51 Target: $400
 12% 

Advertisements - MySQL Updated 2/5/09


Post New Thread Reply   
 
Thread Tools Display Modes
eric0279
AlliedModders Donor
Join Date: May 2007
Old 03-17-2010 , 08:26   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #291

Hi,

Solved

Last edited by eric0279; 03-17-2010 at 13:43.
eric0279 is offline
CreepySteve
New Member
Join Date: Jun 2007
Old 03-18-2010 , 11:41   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #292

Quote:
Originally Posted by mobofever View Post
I ran into this problem too. /tmp/mysql.sock did not exist for me. Unfortunately, not all Linux distributions put files in the same places. I'm running Ubuntu 9.10, and my mysql.sock was located in /var/run/mysqld named as mysqld.sock.

I fixed this by creating a soft link to the file.
Code:
ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock
I hope this helps anyone else that has this problem.
I am running CentOS 5.4, so what you suggest won't work.

I did this:
Code:
$> find -name "mysql.sock"
/var/lib/mysql/mysql.sock
$> ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
Resuts are:
Code:
AdsMYSQL - Connected Successfully to Database
L 03/18/2010 - 09:36:46: [sm_adsmysql.smx] AdsMYSQL - Connected Successfully to Database
So there is the CentOS solution. If you have a server that is Fedora based, it should work in that too.
CreepySteve is offline
RasterMan
Senior Member
Join Date: Mar 2004
Location: Luton, UK
Old 03-24-2010 , 14:11   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #293

I get -bash: /var/lib/mysql/mysql.sock: Permission denied

I'm using centOS 5.4 and I have full root access on my dedi
__________________
RasterMan is offline
Send a message via MSN to RasterMan
kwski43
Senior Member
Join Date: Mar 2009
Old 03-24-2010 , 14:21   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #294

Quote:
Originally Posted by RasterMan View Post
I get -bash: /var/lib/mysql/mysql.sock: Permission denied

I'm using centOS 5.4 and I have full root access on my dedi
Code:
chmod 777 /var/lib/mysql/mysql.sock
__________________
kwski43 is offline
RasterMan
Senior Member
Join Date: Mar 2004
Location: Luton, UK
Old 03-25-2010 , 06:53   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #295

Sorted thx m8
__________________
RasterMan is offline
Send a message via MSN to RasterMan
Matysh
BANNED
Join Date: Aug 2009
Old 03-29-2010 , 11:30   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #296

Hello. I have a problem with charset. When I set on .sp file charset utf-8, it not compilied. In ANSI I have ????? in adverts on server. In database I use utf8.

Can anybody help me? I need in utf-8 =)

Sorry for bad english =)
Matysh is offline
XxDragoNxX
Junior Member
Join Date: Mar 2010
Old 04-03-2010 , 07:00   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #297

Anyone willing to help me out here.

Quote:
11:56:20 L 04/03/2010 - 05:56:20: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
11:56:20 L 04/03/2010 - 05:56:20: [SM] Displaying call stack trace for plugin "sm_adsmysql.smx":
11:56:20 L 04/03/2010 - 05:56:20: [SM] [0] Line 516, /home/groups/alliedmodders/forums/files/2/4/5/7/3/38158.attach::Admin_ReloadAds()
11:56:20 L 04/03/2010 - 05:56:20: rcon from "**.***.**.**": command "sm_reloadads"
I'm lost, this error keep's coming up when I try and reload my ad's. And when I first start the server.

Anyone else has this?

There is probublly a answear in here somewere, however I don't have the time to look through 30 page's of replies to find it.

Thank's in advance,

Dragon.
XxDragoNxX is offline
XxDragoNxX
Junior Member
Join Date: Mar 2010
Old 04-04-2010 , 10:08   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #298

Anyone at all able to help?
XxDragoNxX is offline
kwski43
Senior Member
Join Date: Mar 2009
Old 04-04-2010 , 10:57   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #299

Quote:
Originally Posted by XxDragoNxX View Post
Anyone willing to help me out here.



I'm lost, this error keep's coming up when I try and reload my ad's. And when I first start the server.

Anyone else has this?

There is probublly a answear in here somewere, however I don't have the time to look through 30 page's of replies to find it.

Thank's in advance,

Dragon.
Something with database.cfg record, wrong data?
__________________
kwski43 is offline
strontiumdog
Veteran Member
Join Date: Jan 2007
Location: BC, Canada
Old 04-04-2010 , 11:10   Re: Advertisements - MySQL Updated 2/5/09
Reply With Quote #300

It means it's unable to contact your database server.
__________________
Plugins | TheVille
Zombie Mod for DoD:S - l4dod.theville.org
strontiumdog is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 03:15.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode