Database Connection

[edward19283]

I am installing Tikiwiki 1.8.5 and as far as I can tell, have successfully FTP'd to its own directory, set the appropriate folder permissions, and created the MySQL database. On install, I keep getting the error message that it cannot find the database connection. I am providing the following:

 

Database type: MySQL 4.0.x (my cPanel shows version 4.0.22-standard)

Hostname: localhost

User: mysitename_admin

Password: password

Database name: mysitename_tiki

 

mysitename is that provided by TCH when I created the account, not my domain name

 

Is there something very obvious that I am not doing properly? Any other recommendations? Thanks.

[TCH-Don]

did you add the user to the database in MySql?

[edward19283]

did you add the user to the database in MySql?

<{POST_SNAPBACK}>

 

 

Yes.

[TCH-Don]

Database type: MySQL 4.0.x (my cPanel shows version 4.0.22-standard)

 

 

you have just

Database type: MySQL

 

right?

[edward19283]

I have multiple choices, from simply 'MySQL' to 'MySQL 3.0.X', 'MySQL 4.0.x', etc. Since you asked, I chose simply 'MySQL' and it seemed to have accepted, although now I am encountering the following error:

 

Call to undefined function: mssql_get_last_message() in /home/dkqopvli/public_html/tiki/lib/adodb/drivers/adodb-mssql.inc.php on line 470

[TCH-Don]

Well now that the database is connected,

do you have to use some setup script to start with?

and do they (Tikiwiki) have a faq or help page on their site,

this must be a common questio for them.

[edward19283]

Yes, there is a setp script, and there are fairly detailed setup instructions, which are easy to follow. I am trying to search through their forums now to ID the source for this latest problem...nothing so far. I will see what I can find and report back here. Thanks

[edward19283]

I have not found documentation about the problem yet, and I duplicated the install on another domain on another server that I have at TCH and came up with the same issue.

 

However, while I am at it, one issue I came across in my search through the TikiWiki forums probably needs comfirmation. The PHP script memory size must be at least 8 mb (16 or 32 is recommended). What is the size at TCH?

[edward19283]

I seem to have fixed my problem, although not exactly sure what it was. After repeatedly trying to install again, I did a fresh downloaded of the tar.gz file, instead of the .zip file I was working with, uploaded to my server, then unzipped from there. I also opened up permissions on all top level folders, in addition to the subfolders required, and went through the install. All worked fine from here.

[TCH-Don]

Good to hear you have it working.

That may be the best way as some times an ftp program may change something while uploading

I found mine was capitalizing the files names at first until I found a setting to turn that off.

Its also faster to upload a compressed file and extract it on your server.

 

Thanks for the update.