MySQL Problems on Stoli? Follow this tutorial!

Status
Not open for further replies.

mr kennedy

Member
Messages
524
Reaction score
1
Points
18
very nice tutorial thanx for posting
helped alot with my joomla site :D

*edit* (why am i thanking!!)

i was soo stuck with joomla installation step 1 :p cause i couldn't find the correct hostname..

so thanx again

mysql.x10hosting.com
 

TTIOttio

New Member
Messages
7
Reaction score
0
Points
0
3 questions:

1. How do you find out which server you are on? (I think I am on Stoli, as I have heard the name before, but I'm not certain)

2. Is this the solution to the "General Error
SQL ERROR [ mysql4 ] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [2002] An sql error occurred while fetching this page." problem?

and 3. If it is, what should I do for phpBBv3?

Thanks.
 

mr kennedy

Member
Messages
524
Reaction score
1
Points
18
3 questions:

1. How do you find out which server you are on? (I think I am on Stoli, as I have heard the name before, but I'm not certain)

2. Is this the solution to the "General Error
SQL ERROR [ mysql4 ] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [2002] An sql error occurred while fetching this page." problem?

and 3. If it is, what should I do for phpBBv3?

Thanks.


1. find it here, It is here somewhere so find it yourself..

2. I don't know to be frank, so just try it

3. read number 2
 

TTIOttio

New Member
Messages
7
Reaction score
0
Points
0
I tried that, but there is no section in config.php that mentions localhost...

However, there is also no url for the database, should I change that instead?
 

butcher

New Member
Messages
7
Reaction score
0
Points
0
I have corrected localhost setting with success, but now MySql fail to connect again. (Error reported as: [6]: Unable to form a valid connection to mySQL. )
Server status:
Disk /dev/sda3 (/usr) 92 % (red flash) <- ???
 

mr kennedy

Member
Messages
524
Reaction score
1
Points
18
I tried that, but there is no section in config.php that mentions localhost...

However, there is also no url for the database, should I change that instead?

try finding 127.0.0.1...

what version of PHPBB 3 do you run? the final or the RC's?
 
Last edited:

olcamperdibei

New Member
Messages
3
Reaction score
0
Points
0
remove 'stoli.x10hosting.com' and instead put '%.x10hosting.com'
I can't put anything in the Access Host: I try
%.x10hosting.com
stoli.x10hosting.com

"%.x10hosting.com"
"stoli.x10hosting.com"

'%.x10hosting.com'
'stoli.x10hosting.com'

Everytime it say to me: Added Host ******* to the access list BUT my access list is empty.

Suggest?
 

Brokenfor

New Member
Messages
55
Reaction score
0
Points
0
Hi guys,

I can't seem to create another MySQL database through Cpanel. I've got 2 already but it says I can create 3. Any ideas why it isn't working?

Thanks
 

dirtracer36

New Member
Messages
130
Reaction score
0
Points
0
Hi guys,

I can't seem to create another MySQL database through Cpanel. I've got 2 already but it says I can create 3. Any ideas why it isn't working?

Thanks

same problem I am getting. Got the localhost changed to mysql.x10 and my two dbases work okay. Not able to create a third dbase.

Thanks
 

TTIOttio

New Member
Messages
7
Reaction score
0
Points
0
what version of PHPBB 3 do you run? the final or the RC's?

Umm... I don't actually know. My friend downloaded it for me and then sent it to me, so...

I would give you a link to the forum itself to see if you could work it out, but it isn't working right now anyway. It worked for a while, but the same error is coming up again so I really don't know what is going on.
 

RcRoderick

New Member
Messages
10
Reaction score
0
Points
0
So after reading every post to make sure i have not missed anything, here is my current situation.

Have changed the "localhost" in my config.php for joomla
Have added %.mysql.x10hosting.com and just mysql.x10hosting.com (for some reason when i tried adding stoli.mysql.x10hosting.com, just to try, it added absolut instead.
So i have

%.mysql.x10hosting.com
absolut.x10hosting.com (no idea why its there, because i did not add it)
mysql.x10hosting.com

and what looks like 2 differant shared ip addresses from the servers, and a local one. the main index works, if i pull up the site, but to try and navigate anywhere else is a big fat 404. Any suggestions?
 

Chris73

New Member
Messages
5,356
Reaction score
1
Points
0
It should be just %.x10hosting.com as an access host in your remote mysql section of your cpanel. Not %.mysql.x10hosting.com
 

famikon

New Member
Messages
6
Reaction score
0
Points
0
help i just got my site up today for 5 mins but now all my db's are delted why is this and how do i fix
 

RcRoderick

New Member
Messages
10
Reaction score
0
Points
0
Alright changed the %.mysql.x10hosting.com to the %.x10hosting.com as suggested. And am still having the same problem, i can connect the admin section of my joomla, edit etc, and load the main page, but if i try navigating anywhere else in the site still a 404.
 

Chris73

New Member
Messages
5,356
Reaction score
1
Points
0
I don't even see an index on your page. That tells me that you don't have the files installed properly. Make sure that if you are installing joomla via "Fantastico" that you leave the install directory blank.
 

neo87

New Member
Messages
12
Reaction score
0
Points
0
General Error
SQL ERROR [ mysql4 ]

Table './neo87_bb3/phpbb_config' was created with a different version of MySQL and cannot be read [1033]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

plzzz help
 
Status
Not open for further replies.
Top