In Plesk 12.0.18 #4 I checked Grant the ALTER DATABASE permission to all Microsoft SQL Server database users . The problem is I cannot rename database tables or other functions with myLittleAdmin for SQL provided with Plesk.
My question is: Am I doing something wrong or is needed to upgrade the myLittleAdmin license to Full version?
The upgrade has an error when manage the users database.
PRODUCT, VERSION, VERSION OF MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE
OS Microsoft Windows Server 2008 R2 Service Pack 1 x64
Panel version 11.5.30 Update #13, last updated at Sept 1, 2013 03:30 PM
PROBLEM DESCRIPTION
In a costumer panel have a one database MSSQL, and assign to this DB 3 users, but the tab option "Users" don't work fot his costumer and show this error:
Error Javascript:
TypeError: template is null
this.template = template.toString(); in protototype.js 8472831 (lÃnea 807)
ACTUAL RESULT
Error Javascript:
TypeError: template is null
this.template = template.toString(); in protototype.js 8472831 (lÃnea 807)
EXPECTED RESULT
Show users in the tab users for database.
I tried grant a user to have access to a database via a shell script.
Database 'userdb' and user 'user1' are already setup.
This is my code .
Code:
#!/bin/sh
mysql -u root -pROOTPASS <<!
grant all privileges on userdb.* to user1@localhost
identified by 'dbpasswd' with grant option;
!
The code doesn't work.
I tried use mylittleadmin or asp.net manager and booth tools NOT working on my windows plesk.
I tried remove and install again but still not working.
Tried run PLesk Reconfigurator and still nothing.
Can I use this edition for hosting on dedicated server, and how does it compare to the enterprise edition ? Can it be used with hosting? The web edition sucks as I can not install ms sql on it, so it is useless. Anyone use sbs server to host his website, because most of the link i read never mention it for hosting, and only for print sharing/ filesharing/ business applications, but where is it's use for hosting?
So what do you think ? IO looked at its infor and it did not provide much?
I have daily backups for all accounts setup on our Plesk 11 server and was wondering how I would go about restoring a single database from the backup manager? I could restore the entire zip file, but that would make a mess of any other databases which of course isn't optimal. I see if I download a client's zip file that within the zip_file/databases/db_name there is another zip file which contains a tmp file which for a MySQL database it looks fairly standard, for MSSQL it looks to be in their format but is this what's really necessary? Can I even use those tmp files to restore manually through the Backup Manager -> Database Backup Repository? Why isn't there a simple way for a client to restore a database with the existing backups?
View 2 Replies View Relatedmy plesk server was running OK for the last 13 months and suddenly it breaks apart on its own and I cant make it work again. [URL]
Is there a way to backup database at this stage? How?
Planning to reformat my windows server. and start over.
I would like to change the alias host from webmail.domain.com webmail to domain.com/webmail.
View 1 Replies View RelatedWINDOWS SERVER Plesk Panel version 12.0.18
Error: Test the database server connection failed:
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
After Plesk Panel upgrade to 12.x I found a warning showing at Home>Tools & Settings> Database Servers
Warning: Unable to determine the TCP port number used by Microsoft SQL server '.SQLEXPRESS': TCP/IP protocol is not enabled in the server network configuration or the server is configured to use dynamic TCP ports.
To allow your customers to automatically configure firewall for remote database access, manually configure the SQL server to listen on a specific fixed TCP port.Click to expand...
How can I restore/update permission for all domains -> only web-stats permission?
P.S. When users rename username for FTP access, web-stat remove old username and don't add new username to nfts permission.
On my server, users can connect to any database as long as they have the database user and password. This makes it easier to hack any database on the server.
What I want to do is to make the users can only connect to their own databases and not other's.
I tried changing the localhost ip address but it didn't work ( I assume I didn't do it the right way)
I'm working on one of my customer's server but i have a permission problem.
I want to run some commands via php but there is a permission problem with commands.
If my php file having root user and group permissions i can check and use the executable files.
Otherwise, if the php files have normal hosting account user and group permissions i can't be able to use needed commands/executable files.
I tried to change commands group to same group but it didn't work.
What should i do for solve this?
I'm having a problem with Plesk Panel 11.0.9 update #64. All other page running perfect. But when I go to "Backup Manager --> Database Backup Repository --> Upload Backup File" then Plesk Panel show error: Internal Server Error 500.0.
On server, it show detail below: .....
For one of may domains I'm receiving the following error when someone tries to send mail to it. Also I never receive the mail as it seems to just sit on the server. When the permission were changed on the file, it seemed to have changed back on its on when ever a new address is added. Any solutions?
421 fopen('users/assign') failed (#5.7.10) Permission denied
Code:
-rw------- 1 root qmail 2772 Apr 22 10:38 assign
Plesk+CentOs
Any user that logs in, even with the format domainusername, get's the following error message: 530 User cannot log in.I have already tried the following:
net stop MSFTPSvc
net start MSFTPSvc
Problem with FTP Users on Plesk 11 after updating from Plesk 10.
SO: Windows Server 2008 R2 Standard Edition
Panel: Plesk for Windows 11.0.4
I noticed that users cannot FTP, when trying to connect they receive an error: 530 User cannot log in, home directory inaccessible.
Doing further investigation, I confirmed that only users created after upgrade have this issue, that created before upgrade works fine.
I already discovered that home directory is missing on IIS 7.5 FTP. Creating a symbolic link on NTFS using MKLINK command pointing to home folder and configuring permissions to user solved the problem.I think its a bug on Plesk Panel 11.0.4 as I can see same the same problem on two distinct servers after upgrading from Plesk 10 to 11.
I tried to run Plesk Reconfigurator utility with all options, without success.I can fix home directory by myself manually but it will be great if Plesk Panel handle this again.
I have setup a test server at home, Datacenter edition 2008.
Now, is there a way to allow only a certain username and password combination to access an FTP session/site?
I currently have a server (Xeon 1x5310, 4gb RAM, 4x500gb hdd in Raid 10) with Windows 2003. Now do to a project I'm looking at installing Windows 2008 and upgrading to 2x5310 and 16gb of RAM on my server.
I'm looking to create a virtualized test environment for development of a new web service I'm working on. What I'm looking to develop right now is 2 file servers, 3 web servers, 3 MS SQL database servers and 1 DNS server (would prefer but not sure if hardware can handle it. Virtualization would be ideal as this is very similar to what we believe will we have when we launch the service.
I have a few questions I'm hoping you might be able to answer:
1) With the upgraded hardware specs, should it be able to handle the load if I assign each virtual entity 1 core with 2gb of RAM each?
2) I would like to create each of the multiple servers in a cluster (ie cluster of webservers) as this is how it will be in production. But, I've never worked with clusters before so:
a) where can I learn about clustering windows 2008 servers?
b) is this possible to do in a virtualized environment?
3) How does MS work the licensing? I want to have each server running Windows 2008 and 2-3 of them running SQL Server 2005.
a) Do they charge extra for each virtualized server?
b) Does this mean I have to purchase 3 complete copies of SQL Server or is there a way I can pay a low license fee for use in a non-commercial, non-production environment?
4) Does anyone see any problems with this setup or have any suggestions for me?
* I do have money available to spend on a good solution, so if you have suggestions that cost please let me know. I just thought virtualization would be the way to go as the project will be in development for at least a year with no public access.
** I realize that Hyper-V hasn't been released yet (that I know of) so information on it might be limited
I got this error when i try to active an account in Plesk.
Error: DNSZone::Table::select() failed: no such row in the table
And when o try to solve issue by the following steps,
1) Login to mysql psa database using the plesk administrator password,
cd %plesk_dir%Mysqlin
mysql -h 127.0.0.1 -uadmin -p -P 8306 psa
I got : Unknown psa Database...I'm ensure that database is founded on the server under C:Program Files(86x)MysqlData
Trying to restore a database in plesk 11 I got the following error.
Error: dbbackup failed: Unable to restore database 'database_name'Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
There is no wrong with the db, when I restore from it on local machine everything works.
when i try to make backup of mssql 2012 on plesk 11.5 i have the following error:Error: dbbackup failed: Unable to backup database 'DBANME'. Unable to open connection: A specified logon session does not exist. It may already have been terminated.i already configured temp/network directory,
View 6 Replies View RelatedI created a mssql database. When I click on the weasmin link I go to a 404.Also when I log in as administrator and go to Tools & Settings >>>Database Servers >>>>>click on the .MSSQLSERVER2012 then webadmin it will open myLittleAdmin for SQ Server and I can see the datases.
View 4 Replies View RelatedI have a problem with restore ms sql server 2008 database after restoring the message...Error: Unable to creste database user: Database user name is invalid. Only latin letters are allowed in the database user nameerror
View 1 Replies View RelatedI installed plesk win 12 with mssql2012 , but nobody as abale to restore DB via plesk we recive this error Error: dbbackup failed: Unable to restore database 'degardis'Format of the initialization string does not conform to specification starting at index 29.the backup file is restored straight via sql management studio.
View 1 Replies View RelatedI restored some some databases outside of Plesk in a MSSQL 2008 instance. Plesk knows about the MSSQL intance but is not aware of the databases. I want to add them to Plesk so they will be backed up.
View 2 Replies View RelatedUnable to restore database '17'
Not valid backup:
Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupclub-panel.irdatabases171.bak'. Operating system error 5(Access is denied.).
VERIFY DATABASE is terminating abnormally.
(Error code 22)
---------------------- Debug Info -------------------------------
I've created a website for a client using Sitefinity CMS and MS SQL Server 2008 R2. I've transferred the database from my local SQL server to the production server using SQL Management Studio.
I've created a customer and subscription for hosting the website and it's all up and running perfectly. However, I want to automate the backup of the SQL database for the website which I can only do if the subscription knows about the SQL database for that website. So, how do I associate the two? How do I get the database to show up in plesk for that customer such that it can be part of the scheduled backups - and of course also somethign I could restore via plesk if I had too?
The database exists. It wasn't create via plesk in any way, but I want plesk to be able to back it up, and ideally for it to show up in the customers subscription, etc.