WebSite X5Help Center

 
Kobus D.
Kobus D.
User

Where does the SQL Data Base reside that I create in MYSQL  en

Author: Kobus D.
Visited 5155, Followers 1, Shared 0  

PLEASE.....PLEASE.....PLEASE...... How do I link the Database in MYSQL with the Public_html area where my website is resident.

I keep on getting "Unable to connect to db"

When I do http://test.kobusdippenaar.co.za/admin

http://test.kobusdippenaar.co.za/admin/login.php appears and the sceen stays blank.

Hey Guys, I need some help.

Much Appreciated.

Kobus

Posted on the
12 ANSWERS - 1 CORRECT
Incomedia
Claudio D.
Incomedia

Hello Kobus,

Can you please explain me how you want to link the folder with the Database?

This function is not present in the program.

You can add the database connection data in the program in step 4 in data management and then this database can be used in the email form to receive the sent data.

The Admin Login page is visible. Try to reload the page to see if then it appears correctly.

Many thanks!

Read more
Posted on the from Claudio D.
Kobus D.
Kobus D.
User
Author

Claudio,

Hello there,

I have added a powerpoint file showing all my steps, as well as the step where I created a database on the hosting server.

See if you can understand the screen dumps?

Looking forward to your reply.

Blessings

Read more
Posted on the from Kobus D.
Incomedia
Claudio D.
Incomedia

Hello Kobus,

Did you verify if the DB data is correct?

I see form the images you added 127.0.0.1 but you wrote the hostname is localhost.

Try to write localhost instead of 127.0.0.1 and then check again.

From the error you receive the DB data seems to not be correct and it cannot find the database.

Many thanks!

Read more
Posted on the from Claudio D.
Kobus D.
Kobus D.
User
Author

Claudio,

Hello there,

I have tried hostname with:

localhost

www.kobusdippenaar.co.za

test.kobusdippenaar.co.za

None of the three possibilities worked. In all cases I get "unable to connect to db"

My question remains "How do I link the website page with the DataBase?" I have done all I know, and all I have been advised, but I need some breakthrough on this.

Blessings.

Kobus

Read more
Posted on the from Kobus D.
Incomedia
Claudio D.
Incomedia

Hello Kobus,

Are these the Db Data you got from your hosting provider?

Can you please try also to add to the host the port number used on your hosting server like this localhost:port number ?

Many thanks!

Read more
Posted on the from Claudio D.
Kobus D.
Kobus D.
User
Author

Claudio,

I created a DB called kobusdip_db1000.sql in My Admin on the host server within the section MYSQL. See attachment above.

I used kobusdip_db1000 as the Data base name within the Data Management Section of X5. I also tried the name with the file extention, kobusdip_db1000.sql but still the web page and its generated html code does'nt find the Db!!!

Have you got a website that is making use of a the X5 Data Management section?

I will try the post number, the support guy said it would not work, but I'll try it anyway.

speak again Monday.

Blessings.

Read more
Posted on the from Kobus D.
Barry R.
Barry R.
User

Using localhost as the database server worked for me. You have to upload your site to you web host for it to work, of course, assuming the database is actually deployed there. Some hosting services have cPanel, which allows you to create an empty MySQL database. Don't forget to create at least one username/password and add it the database.

If all else fails, try installing MySQL on your machine and see if you can use Workbench to connect to your database.

I dropped the whole idea when I discovered that X5 can only write rows (tuples) into the database. It can't look up a row and display the data in a form for update purposes. I'm now using a separate shopping cart package that includes a working security domain and a what appears to be a typical shopping cart database schema with customers and products as dimension tables and orders as the fact table.

Read more
Posted on the from Barry R.
Incomedia
Claudio D.
Incomedia

Hello Kobus,

Are you uploading the .sql file in the hosting space or are you using the SQL Management option on your hosting space to create and manage it like as example MyPHPadmin?

Did you ask your hosting provider for the DB connection data?

Many thanks!

Read more
Posted on the from Claudio D.
Kobus D.
Kobus D.
User
Author

@Barry,

I don't know where the data base resides? It is on my cPanel. Within cPanel I notice the menu bar, or status line displays server:localhost, Database Name:kobusdip_db1000, and the table:BidInData

I assume the db is uploaded when it is created via MyPHPAdmin. I even copied it into the area where my files reside ie. test within public_html.

I am trying to capture a lot number, an Amount, and a email address as a test to setup a auction website.

Maybe I'll have to download MYSQL as suggested.

URL test.kobusdippenaar.co.za the second tab "Bidding Form" (Test site) should you like to look. using X5 login (test.kobusdippenaar.co.za/admin) is there a way to verify that the db is working?

Read more
Posted on the from Kobus D.
Kobus D.
Kobus D.
User
Author

Hello Claudio,

I believe I have it right. Check out the powerpoint zip file above.

Blessings.

Read more
Posted on the from Kobus D.
Incomedia
Claudio D.
Incomedia

Hello Kobus,

The Database needs to be inside the MyPHPAdmin but you need to ask for the exact connection parameters to your Hosting Provider. Ask as host name what you need to use and what port is used for the connection since probably this parameter is not correct and the program is not connecting to the database.

Once you got these informations add these in the program. As example localhost:3306 or similar depepeding on what your hosting provider replied you.

Many thanks!

Read more
Posted on the from Claudio D.