xoops forums

Rickb

Not too shy to talk
Posted on: 2008/10/19 21:37
Rickb
Rickb (Show more)
Not too shy to talk
Posts: 118
Since: 2004/10/24
#1

Can not connect to Mysql Db - however I intalled many Xoops

The new servers will not allow me to go pass the data base connection menu. When I intentionally enter the incorrect data I receive the expected, "Ca not connect to the DB" error. However when I enter the correct data, the field get blank, the only field that remains is ServerHost=localhost.

According to the setup. all of the extensions are correct.

Please help,

Rick

script_fu

Friend of XOOPS
Posted on: 2008/10/19 22:04
script_fu
script_fu (Show more)
Friend of XOOPS
Posts: 1494
Since: 2002/12/27
#2

Re: Can not connect to Mysql Db - however I intalled many Xoops

What version are you trying to
install?

apache?
php?
mysql?

Rickb

Not too shy to talk
Posted on: 2008/10/19 23:00
Rickb
Rickb (Show more)
Not too shy to talk
Posts: 118
Since: 2004/10/24
#3

Re: Can not connect to Mysql Db - however I intalled many Xoops

Fixed, the temp folder was incorrectly named.

Thank you so much.

Rick

triwaca

Just popping in
Posted on: 2008/11/18 0:38
triwaca
triwaca (Show more)
Just popping in
Posts: 11
Since: 2007/1/3 2
#4

Re: Can not connect to Mysql Db - however I intalled many Xoops

I am having the exactly same problem!

Xoops 2.3.1 portuguese
Platform Type Debian
PHP Version 4.4.7
MySQL Version 5.0.45

My instalation didn't go trough the step 5/11. Putting the right data, it just reloads the page without the values I entered. If I put wrong values, it shows the error message.

I tried to install XOOPS 2.0.18 in the same host with the same database and everything run just fine.

What exactly temp name is wrong?

triwaca

Just popping in
Posted on: 2008/11/18 0:47
triwaca
triwaca (Show more)
Just popping in
Posts: 11
Since: 2007/1/3 2
#5

Re: Can not connect to Mysql Db - however I intalled many Xoops

Another test: I pick up the same XOOPS package (2.3.1 ptBr) and installed in XAMPP under my XP, and works fine too. So the XOOPS package is OK.

Does this temp folder is related to the server (Apache)?

Rickb

Not too shy to talk
Posted on: 2008/11/18 1:18
Rickb
Rickb (Show more)
Not too shy to talk
Posts: 118
Since: 2004/10/24
#6

Re: Can not connect to Mysql Db - however I intalled many Xoops

You may need to give write permissions, the session will not write. Please check on the PHP ini file.

Rick

triwaca

Just popping in
Posted on: 2008/11/18 2:32
triwaca
triwaca (Show more)
Just popping in
Posts: 11
Since: 2007/1/3 2
#7

Re: Can not connect to Mysql Db - however I intalled many Xoops

I'm sorry, but again you are not clear wich folder should have permissions changed.

About the PHP ini, I don't have access to it, as i'm installing on a internet host (dot5hosting.com).

Rickb

Not too shy to talk
Posted on: 2008/11/18 3:01
Rickb
Rickb (Show more)
Not too shy to talk
Posts: 118
Since: 2004/10/24
#8

Re: Can not connect to Mysql Db - however I intalled many Xoops

Lets try tomorrow morning, Pacific time. I can better help you. If you are unable to get pass saving the database settings then it is a good change it is not a XOOPS issue. You may want to ask your web tech that you are unable to save your config file with php and that there may be a possible ini file that needs write access.

Rick

ghia

Community Support Member
Posted on: 2008/11/18 10:13
ghia
ghia (Show more)
Community Support Member
Posts: 4954
Since: 2008/7/3 1
#9

Re: Can not connect to Mysql Db - however I intalled many Xoops

Some hosters forbid to create datbases programmaticaly. You must do it by hand with your web site admin panel eg. in cPanel with the MySQL database Wizard.
It can also be that there are only a limited number of databases possible. If you are on your maximum, you have to incorporate the XOOPS tables in an existing database. Due to the xoops_prefix system, there are no problems to be expected.
Creating a database is a four step process:
Create a database.
Create a database user.
Assign the user to the database.
Give the user privileges.

triwaca

Just popping in
Posted on: 2008/11/18 11:46
triwaca
triwaca (Show more)
Just popping in
Posts: 11
Since: 2007/1/3 2
#10

Re: Can not connect to Mysql Db - however I intalled many Xoops

No, the problem isn't the database limit, cause I have an unlimited plan. And I just create the database before the instalation, with all privileges. I know it's ok because I just installed XOOPS 2.0.18 in the same database!

For those who want to see (I create a database just for tests):

http://www.cacimba.com.br/install

Database testxoops
Database User xoopsuser
Password 12345
Database is on calango.dot5hostingmysql.com

If you put wrong values, it will show the error message.

If you put the right values, it just reloads the page without the entered values.