WIll not work, need help

Submitted by tthdoc on Tue, 12/08/2008 - 23:03

I cannot get it to work. I have narrowed it down to what I believe is the issue, but not sure where to modify the code. First, it appears to default to localhost, but my host has a different name and I believe this is causing an issue. Also, my host sent a test php file that used my mysql_connect and put in the host, user, and password, but they all had single quotes around them. (mysql_connect('hostname', 'username', 'password'). If I took the quotes out, no connect. Looking at the reusable.php code, I see it is defaulting to localhost and I think it is putting the variables in with no quotes. In any case, I get a can't connect to database error when I put the proper host, user, and password.

Any help appreciated.

Doc

Using TM in CMS ›

Hi Doc, It wont be the

Submitted by AppCreator on Thu, 14/08/2008 - 10:40.

Hi Doc,
It wont be the quotes.
Do you have the TBM on the same server as the database?
You could try the ip address of the database server.
Uncomment the line about 40 of reuseable.php and add your host address to the array. $hostdefault=array("localhost", "127.0.0.1");

Then comment out the //$hostdefault="localhost";

I had the same problem with

Submitted by Thumper on Sun, 24/08/2008 - 01:01.

I had the same problem with not being able to connect.
I had to look for another solution as yours didn't work for me.

My fix was;

Changed line 41
$hostdefault="example.com";
just to hide the host address

Changed line 109
$link = mysql_connect('1.2.3.4:1234', $user, $pass);
(1.2.3.4:1234 is just an example)

It then connected no problem.
Only draw back is that using this method locks you into 1 mysql server but thats fine for my personal needs.
Still not sure why it would not accept my IP:PORT

I have a different problem now though.
I can't see the View Drop Alter Search icons in the table viewer.
I know I have the correct permissions to alter the database because I have created a few php scripts that change, alter and drop tables, so I am not sure why these icons do not appear beside each table listed.

Hi Thumper, I really need to

Submitted by AppCreator on Mon, 25/08/2008 - 09:50.

Hi Thumper,
I really need to find some time to have a good look at this issue.
Different versions of MySQL use different methods of storing privileges.

Have a look at this post as a way of bypassing the restrictions.
http://www.appcreator.com/topic/where-did-functionality-go#comment-8