XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / Database problem
Register
41
Skoiler
Re: Database problem

  • 2004/5/29 9:33

  • Skoiler

  • Just popping in

  • Posts: 1

  • Since: 2004/3/5 2


I aws going to create a MySQL DB, i log phpmyadmin and the page was loaded, but i see this:
Create new database: [Documentation]
No Privileges
I cant create one DB because there is no hyperlink
42
dcg1259
Re: HELP!!!!!!!!!!!

  • 2004/6/5 18:30

  • dcg1259

  • Just popping in

  • Posts: 1

  • Since: 2004/6/4 1


I do not understand all this. I just want to install a program as usual and then use it. I installed the XOOPS and it says it's in the root directory now nothing, no icons nothing to use???? To be honest I don't know how to find the thing other than on the installation page.


Diana
43
D_Cloud
Re: HELP!!!!!!!!!!!

  • 2004/6/14 7:51

  • D_Cloud

  • Just popping in

  • Posts: 3

  • Since: 2004/2/27


are u using IIS or Apache?
44
kjaer
Re: Database problem

  • 2004/7/26 13:58

  • kjaer

  • Just popping in

  • Posts: 2

  • Since: 2004/7/19


If you are getting the error message that the XOOPS installer isn´t connecting to the MySQL DB, remember that sometimes you must change the DB hostname (default is "localhost") by the IP number of the MySQL, because some ISP have MySQL DB in other computers than the one that host your XOOPS PHP/html code. Valdemar K. Kjaer, Brazil
45
slgan
Re: Database problem

  • 2004/8/21 18:44

  • slgan

  • Just popping in

  • Posts: 5

  • Since: 2004/8/21


Hi everyone,

OK. I got the same problem initially and read through the forum about this but still could not get it to work and
my MySQL install works just fine and database can do
what it should just that install says still cannot
connect???.

Finally, I decided to look at the php.ini file in /etc/apache
in my linux and saw quite a number of blank items for mysql.

After filling them to match with my /etc/my.cnf, it works !!


They are:
mysql.default_port = 3306
mysql.default_socket = /tmp/mysql.sock
mysql.default_host = localhost

You shoud match whatever you have setup your MySQL with.
After changing this, you need to start apache

Now, I have gone forward and see a blank home page, which
I recall seeing someone having the same problem.
So, I am going to check that and see if a solution
has been posted in the forum.

Gan

46
thongchai
Re:Database problem

  • 2004/10/7 18:48

  • thongchai

  • Just popping in

  • Posts: 5

  • Since: 2004/10/7


Warning: copy(../mainfile.php): failed to open stream: Permission denied in D:\inetpub\vhosts\isanclub.com\httpdocs\install\class\mainfilemanager.php on line 52

install for windows
thaixoops
47
thongchai
Re:Database problem

  • 2004/10/7 18:51

  • thongchai

  • Just popping in

  • Posts: 5

  • Since: 2004/10/7


Warning: copy(../mainfile.php): failed to open stream: Permission denied in D:inetpubvhostsisanclub.comhttpdocsinstallclassmainfilemanager.php on line 52

isanclub
thailand for windows
48
thongchai
Re:Database problem

  • 2004/10/7 18:55

  • thongchai

  • Just popping in

  • Posts: 5

  • Since: 2004/10/7


Warning: copy(../mainfile.php): failed to open stream: Permission denied in D:inetpubvhostsisanclub.comhttpdocsinstallclassmainfilemanager.php on line 52
49
The_DoubleU
Re:Database problem

  • 2004/11/28 20:13

  • The_DoubleU

  • Just popping in

  • Posts: 9

  • Since: 2004/11/28


Hi all,
First post here and it looks like that I'm not the only one with this "could not connect to the database server".
My system (everything running on local host)
Windows XP pro
Apache/2.0.52 (Win32)
PHP/4.3.9 Server
Mysql 4.1.7-nt

I have created a new user called XOOPS and I'm able to connect to the MySQL database via the dos prompt.
C:Program FilesMySQLMySQL Server 4.1bin>mysql -u XOOPS -p mysql
Enter password: *******
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 5 to server version: 4.1.7-nt

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> status
--------------
mysql  Ver 14.7 Distrib 4.1.7, for Win95/Win98 (i32)

Connection id:          5
Current database:       mysql
Current user:           xoops@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         4.1.7-nt
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
TCP port:               3306
Uptime:                 17 min 32 sec


But if I try to connect with the same user/pw I get the "can't connect to database server" error.
Database Hostname localhost
Database Username xoops
Database Name website
Table Prefix xoops

One time I was able to fix this but that was because I disabled the grant tables of mysql. Not a wise thing to do.
But why can I connect via a dos prompt but not during XOOPS install?

I'm completely new with mysql/xoops. But I have tried several options. Read several tutorials but no avail.
Thanks for your help in advance!
50
The_DoubleU
Re: Database problem

  • 2004/11/29 0:29

  • The_DoubleU

  • Just popping in

  • Posts: 9

  • Since: 2004/11/28


I have found the problem why I was unable to connect with XOOPS to MySQL.
MySQL was rejecting the authentication because I had an "old client".
After I installed phpMyAdmin, I got also an error during connecting but at least this was an error that explained me something. "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Then I searched on google and found this Post
In that thread you find the solution on how to setup MySQL to use old style passwords.

Soltion:
First edit my.ini and add the line
#Use old password encryption method (needed for 4.0 and older clients).
old_passwords

If you now create a new user the old password will be used.
If you want to change your existing users then use the following command.
SET PASSWORD FOR user@localhost = OLD_PASSWORD('mypassword');


I hope this helps some people around here.
And a suggestion to the XOOPS developers. Is it possible to create a more clearer error message? "Can't connect, because......."
This will help a lot of people I think.
« 1 2 3 4 (5) 6 7 8 ... 10 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

238 user(s) are online (145 user(s) are browsing Support Forums)

Members: 0

Guests: 238

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits