FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Database Privilege





siruhan
Im trying to install Smart Guest Book PHP 1.0 for MySQL Database, when I go to phpMyadmin it says I dont have privilege to make a new database. How do I get this privilege? Please Help.
wumingsden
siruhan wrote:
Im trying to install Smart Guest Book PHP 1.0 for MySQL Database, when I go to phpMyadmin it says I dont have privilege to make a new database. How do I get this privilege? Please Help.


You create a new database in your DirectAdmin Panel.

Login to your DA ---->
MySQL Management ---->
Create new Database ---->

(the Database Name and Database Username should be kept the same)
siruhan
Thank you for your help. I seem to have a read me file with this guest book it explains to create a database using phpAdmin, using a query in phpAdmin. I myself dont have much experience in creating a new database for a guest book.
Is it possible for me to run this query file even without using phpAdmin, I mean after creating Database?
wumingsden
siruhan wrote:
Thank you for your help. I seem to have a read me file with this guest book it explains to create a database using phpAdmin, using a query in phpAdmin. I myself dont have much experience in creating a new database for a guest book.
Is it possible for me to run this query file even without using phpAdmin, I mean after creating Database?


No, there isn't. But it is extremely simple, non-the-less.

Simply create a database in your DA like I mentioned above, then go to www.frih.net/phpmyadmin and login with the username and password that you set when making it.
On the left hand site frame click the db (or choose from the drop-down menu; it depends on how many db's you have).
Now at the top of the screen you'll be able to see "SQL", click it. Now in the textbox copy/paste the query.
siruhan
wumingsden wrote
Quote:
No, there isn't. But it is extremely simple, non-the-less.

Simply create a database in your DA like I mentioned above, then go to www.frih.net/phpmyadmin and login with the username and password that you set when making it.
On the left hand site frame click the db (or choose from the drop-down menu; it depends on how many db's you have).
Now at the top of the screen you'll be able to see "SQL", click it. Now in the textbox copy/paste the query.


I think my doubt is clear now. I really appreciate for the prompt reply.
Thanks a lot
wumingsden
Your welcome.

Could you please give an update on whether you've successfully installed the Smart Guest Book?

Thank You.
siruhan
I think I have run the query and it worked pretty well, But I am not able to call my guest book the following is what the readme file which came along with the Guestbook:

Quote:
Installing Smart Guest Book PHP 1.0 for MySQL Database: Updated: 11th Dec 2003



A.Contents of the zip file

In the zip file you downloaded you will find the following files:

1. SmartGuestbook.sql (SQL Scripts file)
2. SmartGuestBook.swf (Flash Interface)
3. SmartGuestBook.html (HTML file where the Flash interface is placed)
4. SmartGuestBookCode.php (PHP file accessed by the .swf file)
5. scripts.js (Javascript code)
6. badwordfilter.txt (comma delimited bad words list)
7. CloseWindow.htm (to automatically close the window)

B. Installation steps

1. Place all the above files in a folder called SmartGuestBook under your site root.

2. To create the required table run the sql scripts file (SmartGuestbook.sql) inside your MySQL database. You can use an administration tool like MyPHPAdmin (download it free from www.myphpadmin.com) or any other database administration tools for the MySQL. Under the database of your choice run the SQL script. In MyPHPAdmin, to run 'SQL query/queries' click the "SQL" option and locate the 'SmartGuestbook.sql' using the browse button. Click go and your database is ready. To double check this see if your database has a table called 'tblguestbook' added to it.


3. Important: To make your SmartGuestBook work you need to give the connection parameters to your MySQL Database in the SmartGuestBookCode.php page. Open the code view of this page and you will find the following lines at the top clearly marked out for your convenience.

//----------- Give your MySQL Database connection parameters here ----------

$strServer="localhost"; // Server IP Address Or Name
$strDatabase="guestbook"; // Database Name
$strUser="sa"; // User ID
$strPwd=""; // Password

//----------- End of MySQL Database connection parameters ----------

Now substitute the dummy values (inside the quotes) with your database details.


4. Now you are ready to call your Guestbook from anywhere in your site.
To do this, use the following link in your page (Hint: If you are using dreamweaver, copy and paste the following link in the Code View):
<a href="javascript:{var xwin=window.open('/SmartGuestBook/SmartGuestBook.html','GuestBook','width=350,height=350, resize=no')}">Guest Book</a>


5. If you wish to keep the guest-book inside one of your site pages (i.e. the guestbook will be visible always on the page instead of popping out on clicking a link), you should place the SmartGuestBook.swf file and related scripts in your page body by adding the following code wherever you want the Guest-Book to appear (do not copy the 'Start of Code' and 'End of Code' lines). After you copy-paste the code please follow the important directions given below it.

-------------------------- Start of Code --------------------------

<SCRIPT LANGUAGE="VBScript">
Sub guestbook_FSCommand(ByVal command, ByVal args)
call guestbook_DoFSCommand(command, args)
end sub
</SCRIPT>
<script language="JavaScript">
var moviecolor = '#000000';
</SCRIPT>
<script language="JavaScript" src="scripts.js"></SCRIPT>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#5,0,0,0" width="350" height="350" id=guestbook><param name="MOVIE" value="SmartGuestBook.swf"><PARAM NAME=bgcolor VALUE="#4B88C4"><param name="menu" value="false"><param name="QUALITY" value="high"><param name="LOOP" value="false"><embed src="SmartGuestBook.swf" name="guestbook" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="350" height="350" bgcolor="#4B88C4" menu="false" loop="false" quality="high" swliveconnect="true"></embed></object>

-------------------------- End of Code --------------------------

Important Directions:
a. Place this page of your site inside the SmartGuestBook folder only.
b. Change the path to the SWF file in the param tag named 'MOVIE' and embed tag 'src' value for a site hosted by another site.
c. Change the background color of the guest book in the param tag named 'bgcolor'.
d. CAUTION: Do not change any other part of the code in any other place as the guest-book will not function properly.
e. DO NOT place the code inside a form i.e., in between a <form> </form> tags (since the guestbook add new entry page will not work).

6. The CloseWindow.htm page can be used to close any web page in your site. Use it if required by using a simple link as below.
<a href="/SmartGuestBook/CloseWindow.htm">Close</a>


C. Troubleshooting

1. If your Smart Guest Book is stuck i.e., just displaying the "loading guestbook entries" frame, then please check if the URL : http://Your_site_path/SmartGuestBook/SmartGuestBookCode.php?size=50&NAV=1 is giving an error. If yes please contact us.
2. If your guestbook is still not working please check if your site supports PHP and MySQL Server databases. If yes check if your installation steps were correct.
3. If you have any other problems please visit our FAQs page (http://www.smartwebby.com/web_products/PHP/flash_guestbook/FAQs.asp) or email us (products@smartwebby.com). Your suggestions and comments are always welcome Smile


Copyright SmartWebby.com, 2001-2005, All Rights Reserved.

This product has been created by SmartWebby.com for free distribution.
We will not be held responsible for any unwanted effects due to the usage of
this product or any derivative. No warrantees for usability are given or implied.


I changed the server name to 216.32.85.170 i think it is correct
And in place of database name I wrote my database name siruhan_guest
And username i wrote the username I put while creating the database siruhan_guest
And as a password I wrote the password created during database creation.


I am able to see the guestbook when I call it from this link

http://siruhan.frih.net/SmartGuestBook/SmartGuestBook.html

But the message it displays is Loading Guest Book entries and it doesnt work

As the read me has mentioned i tried to see the error message with this link URL : http://siruhan.frih.net/SmartGuestBookCode.php?size=50&NAV=1

But the message says

Warning: mysql_connect(): Access denied for user: 'siruhan_guest@host.frih.net' (Using password: YES) in /home/siruhan/domains/siruhan.frih.net/public_html/SmartGuestBook/SmartGuestBookCode.php on line 42

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/siruhan/domains/siruhan.frih.net/public_html/SmartGuestBook/SmartGuestBookCode.php on line 43

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/siruhan/domains/siruhan.frih.net/public_html/SmartGuestBook/SmartGuestBookCode.php on line 44
Access denied for user: 'siruhan_guest@host.frih.net' (Using password: YES)

If anyone could help me with this problem?
SpellcasterDX
It's most likely that your MySQL data was not inserted right. Check that you ran the queries right.
wumingsden
Check the db info again. If all seems correct then change 216.32.85.170 to localhost
siruhan
Its working I added a host in the Mysql management window as host.frih.net

thanks for the help.
wumingsden
siruhan wrote:
Its working I added a host in the Mysql management window as host.frih.net

thanks for the help.


Your welcome, -locked-
Related topics
WTF! A strange database just appeared lol
script backup database
How much database
database problem
Implementing your database access in PHP as a layer.
Navigation Script (javascript) Help Please!
how can i change password in my database?
Database Problem
How to restore database?
Need help with database, can anyone help?
I can't upload my Database SQL script ! Helllppppp!!!!
Strange Mysql-database
MySql Database
create new database privilege
This topic is locked: you cannot edit posts or make replies.    Frihost Forum Index -> Support and Web Hosting -> Web Hosting Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.