Web Hosting Vodahost    

Home Take The Royal Tour! Order Now Features Prices
Go Back   Web Hosting > VodaHost Web Hosting Support > mySQL & PHP

Notices

mySQL & PHP Discussions, information and help with mySQL and PHP.

Reply
 
LinkBack Thread Tools
  #1  
Old 10-27-2006, 02:32 PM
econstas's Avatar
Second Lieutenant
 
Join Date: Jul 2006
Location: Durham, NC
Posts: 101
Send a message via AIM to econstas Send a message via MSN to econstas
Default MYSQL DB problem

Hello all,
I was doing some cleanup work within my acct and I messed up something I shouldn't have done. I am trying to figure out what I need to or how to reinstall certain parts of the DB. I know this link I am about to post is for the webcalendar php script downloaded from fantastico. But, I am thinking that the error message is affecting other PHP scripts on my acct. Any ideas on what or how to fix this problem?

LINK: http://www.holleyjohnson.net/phcal/
===error message on the page===

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'webcalendar'@'localhost' (using password: YES) in /home/cncmmdly/public_html/phcal/includes/dbi4php.php on line 104

Warning: mysql_query() [function.mysql-query]: Access denied for user 'cncmmdly'@'localhost' (using password: NO) in /home/cncmmdly/public_html/phcal/includes/dbi4php.php on line 368

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/cncmmdly/public_html/phcal/includes/dbi4php.php on line 368
Error

Access denied for user 'cncmmdly'@'localhost' (using password: NO)
SELECT cal_value FROM webcal_config WHERE cal_setting = 'WEBCAL_PROGRAM_VERSION'

=======

Thanks,
Stratis
__________________
Thanks,
Stratis

www.holleyjohnson.net
mailto: stratis.constas@holleyjohnson.net
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2  
Old 10-28-2006, 04:16 AM
econstas's Avatar
Second Lieutenant
 
Join Date: Jul 2006
Location: Durham, NC
Posts: 101
Send a message via AIM to econstas Send a message via MSN to econstas
Default Re: MYSQL DB problem

I also uninstalled and reinstalled the php webcalendar.. Still same error message.
__________________
Thanks,
Stratis

www.holleyjohnson.net
mailto: stratis.constas@holleyjohnson.net
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3  
Old 10-28-2006, 07:11 AM
navaldesign's Avatar
General & Forum Moderator
 
Join Date: Oct 2005
Location: Italy
Posts: 9,288
Default Re: MYSQL DB problem

Seems to be a user permissions issue. Try recreating the same database users and add them to your webcalendar database again.
__________________
Navaldesign
Logger Lite: Low Cost, Customizable, multifeatured Login script
Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4  
Old 10-29-2006, 01:40 AM
econstas's Avatar
Second Lieutenant
 
Join Date: Jul 2006
Location: Durham, NC
Posts: 101
Send a message via AIM to econstas Send a message via MSN to econstas
Default Re: MYSQL DB problem

I am not sure if I am missing something here. I did reset the access for the accounts mentioned. I also gave access to the accounts mentioned for these dbs. no go. Any ideas on where to search?

Also, is there any backup for mysql with Voda? Not sure if this is something that gets backed up?
__________________
Thanks,
Stratis

www.holleyjohnson.net
mailto: stratis.constas@holleyjohnson.net
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5  
Old 10-30-2006, 02:17 PM
Mook25's Avatar
Brigadier General
 
Join Date: Oct 2005
Location: UK
Posts: 1,447
Default Re: MYSQL DB problem

The only way the db would be backed up is if you specified a backup before you started the changes, it's not a automatic thing i'm afraid.
I would double check the config file of the script to make sure that it has the correct details input so that it points at the correct db. HTH
__________________
Voda Picks >> Prices| Tutorials | BV Download | FAQ | Your First Webpage


Want a banner like above? Contact me here with details.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #6  
Old 10-31-2006, 09:05 AM
econstas's Avatar
Second Lieutenant
 
Join Date: Jul 2006
Location: Durham, NC
Posts: 101
Send a message via AIM to econstas Send a message via MSN to econstas
Default Re: MYSQL DB problem

You talk about one lucky bumb...! My server, voda5, went down due to emergency maint. When my website was restored, the old site and calendar was back. Now, I did notice that I need to load some galleries but honestly.. that doesn't bother me at all since the webcalendar is back up and running!
:)
__________________
Thanks,
Stratis

www.holleyjohnson.net
mailto: stratis.constas@holleyjohnson.net
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #7  
Old 11-01-2006, 04:46 AM
econstas's Avatar
Second Lieutenant
 
Join Date: Jul 2006
Location: Durham, NC
Posts: 101
Send a message via AIM to econstas Send a message via MSN to econstas
Default Re: MYSQL DB problem

Looks like I was wrong.. back at it again.. problems. Looks like now after db is back up and probably resets back to more current info on server. I am now seeing a problem. Hmm.



Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'cncmmdly_wcln1'@'localhost' (using password: YES) in /home/cncmmdly/public_html/phpcal/includes/php-dbi.php on line 99
WebCalendar Error

Error connecting to database:
Access denied for user 'cncmmdly_wcln1'@'localhost' (using password: YES)
__________________
Thanks,
Stratis

www.holleyjohnson.net
mailto: stratis.constas@holleyjohnson.net
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT +1. The time now is 11:00 AM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC7
2005-2009 VodaHost Web Hosting Your Perfect Web Host - All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176