Moderators Kyle Posted February 26, 2010 Moderators Report Share Posted February 26, 2010 Hi, my freind is trying to install phpvms, but it won't find the database. But we have the database in the same server. My ferind and I been kinking out all night why won't phpvms find the databse and recreated the database over a hundred times and redownloaded the files and reinstall everything but it won't still find the database. Do you know whats wrong? One Point for someone who helped us getting it work. Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted February 26, 2010 Moderators Report Share Posted February 26, 2010 Hi, my freind is trying to install phpvms, but it won't find the database. But we have the database in the same server. My ferind and I been kinking out all night why won't phpvms find the databse and recreated the database over a hundred times and redownloaded the files and reinstall everything but it won't still find the database. Do you know whats wrong? One Point for someone who helped us getting it work. you got an url to look at Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted February 26, 2010 Author Moderators Report Share Posted February 26, 2010 you got an url to look at Nope, sorry it's still in server IP. I can't release it, becasue my ferind said no. What he has on his system is 1) PHP 5 2) MYSQL 5 3) Lunix Server 4) PHPVMS 2.840 Hope it might help. Also we did try granting permissons on the database and the files. They are writeable. Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted February 26, 2010 Moderators Report Share Posted February 26, 2010 Nope, sorry it's still in server IP. I can't release it, becasue my ferind said no. What he has on his system is 1) PHP 5 2) MYSQL 5 3) Lunix Server 4) PHPVMS 2.840 Hope it might help. Also we did try granting permissons on the database and the files. They are writeable. vms is current 2.877 the rest looks good it will be difficould to help iff you can't look at it Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted February 26, 2010 Author Moderators Report Share Posted February 26, 2010 vms is current 2.877 the rest looks good it will be difficould to help iff you can't look at it I know it's hard but my firned doesn't want to release his server ip. The url is not set yet. Yup that is the current version he has. I been restarting the servers and everything. The error is saying database is not found. But it is in our server and it has the grant permissons. It should find that database. I don't know why. Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted February 26, 2010 Moderators Report Share Posted February 26, 2010 I know it's hard but my firned doesn't want to release his server ip. The url is not set yet. Yup that is the current version he has. I been restarting the servers and everything. The error is saying database is not found. But it is in our server and it has the grant permissons. It should find that database. I don't know why. how are you calling the database(localhost) or different Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted February 26, 2010 Author Moderators Report Share Posted February 26, 2010 how are you calling the database(localhost) or different the database is called phpvms and i'm enetering in localhost. We are installing by from the server. And in phpmyadmin. It saying in localhost. I'm just tryoing to browese around the server to see what is the problem. But i can't find the source of a problem. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted February 27, 2010 Administrators Report Share Posted February 27, 2010 I would goto your ISP and find out the database address Quote Link to comment Share on other sites More sharing options...
Administrators simpilot Posted February 27, 2010 Administrators Report Share Posted February 27, 2010 Is this a dedicated server? If so what you are showing should be working. If it is a shared server your database and username are probably appended by "username_" If it is free hostsing the db probably resides on another server all together and will need to have a url to connect. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted February 27, 2010 Administrators Report Share Posted February 27, 2010 Yes what simpilot said. Also try connecting in the command line: mysql -uUSER -p DATABASE_NAME If you can't connect that way, then there's an issue with your database install Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted February 27, 2010 Author Moderators Report Share Posted February 27, 2010 Yes what simpilot said. Also try connecting in the command line: mysql -uUSER -p DATABASE_NAME If you can't connect that way, then there's an issue with your database install he has dedicated server. His own apple server. like me. And we tried pointing the username but it can't find the database. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted February 27, 2010 Administrators Report Share Posted February 27, 2010 he has dedicated server. His own apple server. like me. And we tried pointing the username but it can't find the database. Then the database is not setup properly. Login to mysql as root mysql -uroot -p Then type SHOW DATABASES; And see if the db shows up under there. If it does, then your user above probably doesn't have privledges to that db` Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted February 27, 2010 Author Moderators Report Share Posted February 27, 2010 Then the database is not setup properly. Login to mysql as root mysql -uroot -p Then type SHOW DATABASES; And see if the db shows up under there. If it does, then your user above probably doesn't have privledges to that db` I granted permisson for that database as root and i type in root and the password. And he has the same server as mine. My own hosting and his own hosting and we were doing the same process like mine. Mine was ok. but his is not finding the database. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted February 27, 2010 Administrators Report Share Posted February 27, 2010 Check it on his though, it's not always the same. You shouldn't be accessing as root from your scripts. There should be another user setup. When you do SHOW DATABASES; (on his server), does that database you setup show? And then log out and log back in as that user, and do SHOW DATABASES again, and make sure that's showing up. Its a DB issue somewhere Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted February 27, 2010 Author Moderators Report Share Posted February 27, 2010 Check it on his though, it's not always the same. You shouldn't be accessing as root from your scripts. There should be another user setup. When you do SHOW DATABASES; (on his server), does that database you setup show? And then log out and log back in as that user, and do SHOW DATABASES again, and make sure that's showing up. Its a DB issue somewhere K i restarted the whole server and i checked the database and its there and inside the db is emtpy. But we used another program a php based and its finding that database. But phphvms is not finding that database. Also i tried deleting the database and created a new one but it won't still find it. And we had the server tech came in, and its the phpvms issue. 1 Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted February 27, 2010 Administrators Report Share Posted February 27, 2010 K i restarted the whole server and i checked the database and its there and inside the db is emtpy. But we used another program a php based and its finding that database. But phphvms is not finding that database. Also i tried deleting the database and created a new one but it won't still find it. You didn't follow what I said. Did you check the user that you've created for that database? What databases does that user show? If you do "use phpvms" (if that's the databse name), does it change to the database? If you're using phpMyAdmin, goto Privileges on the front page page, create a new user called phpvms, and have it create a database and grant all privledges for that user. Then try that. phpMyAdmin accesses it as root if that's how you're logging in, and it sees all databases Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted February 27, 2010 Author Moderators Report Share Posted February 27, 2010 You didn't follow what I said. Did you check the user that you've created for that database? What databases does that user show? If you do "use phpvms" (if that's the databse name), does it change to the database? If you're using phpMyAdmin, goto Privileges on the front page page, create a new user called phpvms, and have it create a database and grant all privledges for that user. Then try that. phpMyAdmin accesses it as root if that's how you're logging in, and it sees all databases K i created a new user called phpvms and granted permissons to data:phpvmsand i enter everything in there and its still not finding the database. Also we reinstalled the system couple hours ago and no problems. I don't understand why phpvms is not finding that database but the other php program is finding that db and it works. 1 Quote Link to comment Share on other sites More sharing options...
Moderators mark1million Posted February 27, 2010 Moderators Report Share Posted February 27, 2010 What box are you on, linux or windows? Do you use phpmyadmin? Next thing is to create a test php connect file to see if you can connect, it will spit out errors if there are some. There are well over 1000 installs of phpvms so its defiantly not a problem there. 3 Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted February 27, 2010 Moderators Report Share Posted February 27, 2010 There are well over 1000 installs of phpvms so its defiantly not a problem there. +1 for you 1 Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted February 27, 2010 Author Moderators Report Share Posted February 27, 2010 What box are you on, linux or windows? Do you use phpmyadmin? Next thing is to create a test php connect file to see if you can connect, it will spit out errors if there are some. There are well over 1000 installs of phpvms so its defiantly not a problem there. K i did a test php connect file and there is no probelms but the PHPVMS won't find the database is already created. Yes he uses phpmyadmin 1 Quote Link to comment Share on other sites More sharing options...
VAFrance Posted February 27, 2010 Report Share Posted February 27, 2010 K i did a test php connect file and there is no probelms but the PHPVMS won't find the database is already created. Yes he uses phpmyadmin Vansers! I don't understand why you are having this problem. I installed phpvms last week and it was ok. And mark is right, alot of people shouldn't have this issue. When i installed phpvms, it was quick step! Easy, maybe your making a mistake on the db which setting you shouldn't have on. Check your server again in phpmyadmin and make sure the db is correct becasue we shouldn't have this issue tht its not finding the database and its already there. Also make sure your phpmyadmin is in the same server ip to your install. Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted February 27, 2010 Author Moderators Report Share Posted February 27, 2010 Vansers! I don't understand why you are having this problem. I installed phpvms last week and it was ok. And mark is right, alot of people shouldn't have this issue. When i installed phpvms, it was quick step! Easy, maybe your making a mistake on the db which setting you shouldn't have on. Check your server again in phpmyadmin and make sure the db is correct becasue we shouldn't have this issue tht its not finding the database and its already there. Also make sure your phpmyadmin is in the same server ip to your install. It is in there in the same ip address and the database is correct. Look it's been going on for a week, and we can't get it working. Quote Link to comment Share on other sites More sharing options...
VAFrance Posted February 27, 2010 Report Share Posted February 27, 2010 It is in there in the same ip address and the database is correct. Look it's been going on for a week, and we can't get it working. Do you have a URL so i can take a look. And before this post you said it is in the server ip and YOUR Friend can't release it. I think it might be the issue on that. GET HIM TO SET UP HIS URL and it should be working. I used to had it in ip while i was installing and it was messed up. Then i got a new url that masks over the server ip. I think it is a url issue. Get the url set up and you should not have any problems. Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted February 27, 2010 Author Moderators Report Share Posted February 27, 2010 Do you have a URL so i can take a look. And before this post you said it is in the server ip and YOUR Friend can't release it. I think it might be the issue on that. GET HIM TO SET UP HIS URL and it should be working. I used to had it in ip while i was installing and it was messed up. Then i got a new url that masks over the server ip. I think it is a url issue. Get the url set up and you should not have any problems. Yeah your right VAFrance. It's working now. Thanks alot VAFrance. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted February 27, 2010 Administrators Report Share Posted February 27, 2010 Yes you have to make sure hostnames are working properly, and that mysql is setup to listen on those hostnames Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.