No privileges to create new database in phpMyAdmin

[ROUBOS]

Hi, I created a mySQL database in the plesk control panel, created a user for the database. Made the user the default, and then when I hit DB webAdmin, I get the following:

Create new database:
No Privileges

When I enter the url of  the website so the elxis installation can start, i get a blank page.

Ant thoughts ?

[Ivan Trebješanin]

On panels such as cPanel you can create DB, but not via PhpMyAdmin. Maybe Plesk works the same way. You said you created DB, so it's OK.
Blank page however, means some PHP error, so there is some problem there. Ask you host admin.

[ROUBOS]

ok,

So could it be something wrong with the creation of the domain?

[ROUBOS]

re-created the domain, and i now can see the index.html
need to upload elxis.

but before the install i need to create the DB. that's where things go wrong I think

EDIT: Must be a php error. will need to contact the ISP. I created the Domain. It works with a normal index.html file, not with the index.php

[CREATIVE Options]

In plesk you MUST create the DB from the plesk panel, look around the plesk panel, it has many hidden features.

1 PS: avoid PLESK if you can, install ISP (open source) or any other you like.
2 PS: Cpanel is far away good & secure from plesk.
3 PS: Apply this IF you have privilege:

Slightly modified version from the original post found at rackerhacker.com

Change the umask in ‘/etc/proftpd.conf’ from ‘022′ to ‘002′.

Then, update the directory permissions by running the following at the command line:

Code: [Select]

cd /var/www/vhosts/[domain.com]
chown -R [username]:psacln httpdocs
chmod -R g+w httpdocs
find httpdocs -type d -exec chmod g+s {} ;

Add the ‘apache’ user to the ‘psacln’ group by editing ‘/etc/group’.

Change

Code: [Select]

psacln:x:2524:

to

Code: [Select]

psacln:x:2524:apache

For my server I also had to add psaftp,psaadm:

Code: [Select]

psacln:x:2524:apache,psaftp,psaadm

About some PHP settings, sometimes including not being able to write to ‘/var/lib/php/session’. To fix the issues, make some adjustments to the ‘/var/www/vhosts/[domain]/conf/vhost.conf’ for the domain (you may have to create this file):

Code: [Select]

<Directory /var/www/vhosts/[domain]/httpdocs>
php_admin_flag magic_quotes_gpc on
php_admin_flag display_errors on
php_admin_value session.save_path /tmp
</Directory>

If the vhost.conf is brand new, then run:

Code: [Select]

/usr/local/psa/admin/bin/websrvmng -av

Make sure Apache runs with your new configuration:

Code: [Select]

# httpd -t (check your work)
# /etc/init.d/httpd reload (service httpd restart on my server)
Done! No more errors on the install screen and no more apache/ftpuser issues with uploading files.

[ROUBOS]

these can be done if I have my own server right?
The service provider (hosting space) has plesk.

[CREATIVE Options]

Yes ONLY if you have VPS or Dedicate

[ROUBOS]

strange
I put up a simple php info file and it works.
It displays PHP info, but the Elxis install does not start up.

Any thoughts?

[Ivan Trebješanin]

Which version of PHP do you have there?

[ROUBOS]

PHP Version 4.4.9

[ks-net]

http://wiki.elxis.org/wiki/Elxis_Requirements
http://wiki.elxis.org/wiki/Troubleshooting#I_can.27t_access_elxis_installer.2C_MySQL_or_PHP_errors

[ROUBOS]

yes I saw that... Need to find an older version of Elxis...

[ks-net]

might be the opposite?

as i can see you have many problems with your server.... almost every post of yours is about permissions-server setup- etc...
i think that worth to throw it away... leave it in it's fate.. go else where!

Need to find an older version of Elxis...

2008.0

[Ivan Trebješanin]

yes I saw that... Need to find an older version of Elxis...

... or newer version of server ...

Imagine you are using hammer and the chisle to carve in stone, but everybody else use paper these days. So you say: "I must find paper which can stand carving.."
It is by far better to simply take a pen and write on paper!

[ROUBOS]

yes you are right. The thing is that I'm doing this for someone who has purchased hosting space on this server.

Do you have a hosting space to recommend   for my own web site soon ?

EDIT >>> : It's ok. Sending them an email to upgrade the version of PHP. It's says that they will do it.