I need to create a server for a database that has a .db file that is over 800Gb. now my first disk is 50Gb and i do the standard
100m ext2 boot
2000m swap
* / ext3
now I have a second 1.2T that i want to be /opt is there a way to set up 4kib block size in ext3 in the os install? or should I do it after the install? Is this block size even big enough?
I have installed on a remote server phpmyadmin 3.3.1 and mysql 5.1.46 on a centos 5.4 OS.
Any newly created user with phamyadmin is unable to login both from mysql command line (from localhost) and phpmyadmin (localhost and remotely).
No prob when the user is created with mysql command line (from localhost). All of the users created with phpmyadmin, are not "visible" recognized from the show user command via the mysql command line. The setting I used when I create any user was the same as the ones with the mysql command line creation.
The error message I get when accessing from mysql command line (from localhost) is the following: "Access denied for user ... @localhost (using password: yes)"
I am now able to create the database using PHP and SQL. But it seems I can only do it as MySQL root user.. $dbuser = 'root'; but is there a way to do that as a regular MySQL user?
View 2 Replies View RelatedI just ordered a new unmanagd VPS I have already Apache, PHP and Mysql the only problem I have now is how to create a A,NS and MX record in CentOS. I dont know where the DNS zone file is in CentoS
View 2 Replies View Relatedi installed Fedora 14 on my machine,then i installed postgresql in it i started it and configured it after seeing link [URL] i am able to do su - postgres but when i am trying to create database in it am getting error,It is asking for password then i am giving my root password
createdb company
Password:
createdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
I tried creating a database in mysql but couldn't do so...here is the message i got from the shell:
Code:
I install a Bind 9 with chroot in Centos 5, but the issue is the Reverse Name Resolution Zone File didn't create by default like other zone files, so i look into /var/named directory i don't find the reverse name resolution zone file even if i add this zone on named.conf
zone "1.168.192.in-addr.arpa" IN {
type master;
file "1.168.192.testsip.com.zone";
allow-update { key "rndckey"; };
notify yes;
};
I want to create redhat cluster on(vmware) OS Redhat Enterprise Server 5.5
Install Luci on node1
Install ricci on node2
Install ricci on node3
All the computer name records in all system host file. When I try to create new cluster( luci_install init) then showing error...
Status messages:
* Host stationx.example.com is already authenticated
* Host stationy.example.com is already authenticated
[dismiss]
The following errors occurred:
* Unable to create the cluster Luci database objects
***No any cluster.conf file created on any node
I have reinstall the node, but getting same error.
I'm trying to create new RAM image file to get my server load raid1 module upon start, I was following redhat documentation & it suggested to use the following command mkinited --with=raid1 inited-raid1-$(uname -r).img $(uname -r) However after running this command I'm getting this message No Kernel available for 'inited-2.6.18-128.el5"
View 4 Replies View RelatedI'm looking for a way to put a MySQL database in a server's memory. The disks aren't fast enough to keep up with the usage and I don't feel like going for a splitted web&db server yet because of the costs.
Because this involves risks (unless there's a way to read from the memory and write to the memory AND disks?), so I'd prefer that the DB gets copied automatically every hour or so to the local disks.
I just installed mysql and need to move the databases to a new location.I say 'no problem' I shutdown mysql (service mysqld stop) I configure my.cnf to point to the new location, which in my case is: /mnt/data/mysql. I know not very original naming. I do the old chown -R mysql:mysql /mnt/datal/mysql AND I copy all the files over (cp -R /var/lib/mysql /mnt/cgsvol/mysql) chmod 777 /mnt/data/mysql I ensure the chown worked (ls -a -l) and the files are there from the old directory. I can't load the daemon again. I check the log (/var/log/mysqld.log) and it can't write any test file to that directory.
(log file exact data).
091107 23:22:21 mysqld started
091107 23:22:22 [Warning] option 'max_join_size': unsigned value 18446744073709$
091107 23:22:22 [Warning] option 'max_join_size': unsigned value 18446744073709$
[code]....
We purchased a new database system at work last October, ditching the old system because of a lack of support from the vendor. This is a retail Point of Sale and Backoffice database system. I am not sure what system the new one runs on, but the system we replaced was a Firebird data base. The reason I am posting is because we are now in need of the information contained in the old database which was not completely imported into the new system. Unfortunately, we parted company with the old vendor under extremely hostile conditions, and they are not a source of help for this problem, nor are the new vendors.
Basically the problem is this: The database in on a Windows XP system and I found a copy of SQL Manager Lite 2008 on the system, which after quite a bit of studying, I figured out how to extract the database into a removable file. I have this file (178MB) on a USB stick in a file called Backoffice.fbd. I can get into this database with MySQL. All I want to be able to do get into the database and create tab deliminated spreadsheet files for each of the database sections (Customers, Repairs, Sales History, stock files, etc.) Is it possible to do this with Ubuntu and MySQL and if so, can an expert suggest one or two things to get me started.
i am having a problem while hosting a website on rhel apache server.when i write the url on browser than its doesnt show any page ,neither it displays any error.However when i am hosting a simple php webpage apart from that website its works fine.i also want to know how can i import a databe file in mysql which is a part of that website.
View 3 Replies View RelatedWe have Nagios and Pnp4nagios which saves performance data in hostperfdata and serviceperfdata files.Now we are migrating our system to centreon which will have NDO.
This will save the performance data to Mysql database.The requirement here is to feed current performance data file to NDO mysql database.
Code:
kenny_strawn@kenny-AOA110:~$ sqlite3 -html -line /var/www/fluxbb/ProprietarySuckware 'select o_base_url from memos'
Error: unable to open database "/var/www/fluxbb/ProprietarySuckware": unable to open database file
kenny_strawn@kenny-AOA110:~$
This database was automatically generated by FluxBB, so I am wondering just why it isn't opening.
I installed the latest CentOS 5.5 in my PC. I added some public domain projects on it. Now how can I make another boot-able CentOS iso file with all the new projects I just added? In the other words, I try to create a boot-able CD with the CentOS and all the projects on it.
View 1 Replies View RelatedI have a huge issue on this error on mysql. Can't create/write to file '/tmp/#sql the full error message is Can't create/write to file '/tmp/#sql_4761_0.MYI' (Errcode: 30)
View 9 Replies View RelatedHow to Create 20 min long "silence" GSM file using Sox ?
View 8 Replies View RelatedI have a centos 5.4 64-bit machine. I installed the directory server following those steps.
I then added some users using the Centos Management Consolecentos-idm-console -a http://localhost:3890 &
I have a php script that I want to create a file and allow it to be downloaded. I know the dangers of chmodding a directory to 777 so I am trying to avoid this.
What I have done is logged in through ssl as root.
Navigated to the directory where the directory I want to chown is located. I then perform:
chown -R apache directory
I am trying to create a database and tables. Does anyone know a reference website that can help me with this or does anyone know how to do this?
View 3 Replies View Relatedubuntu 9.10 64 biti try to install XAMPP and i want to create new database by use phpMyAdmin
at MySQL localhost create new database it show No Privileges how to create new database from terminal
I'm running Apache on Centos 5.5, with active SELinux, and I'm having trouble getting my Perl script to write a file that doesn't yet exist to a folder which has the proper security context.
View 9 Replies View RelatedI would like to know how to create a A,NS and MX record in centos.
I dont know where the DNS zone file is in CentoS
I'm trying to create some PHP extensions. I have installed php-devel as well as the other preqs I thought were required. However I'm not able to find ext_skel. The file README.EXT_SKEL was installed, but not the actual program (find / -name ext_skel). My understanding was ext_skel was installed with php-devel. I know it is in the source code, but I'm not sure where to get the source for PHP 5.1.6 for my version of CentOS.
I'm running linux 5.3
2.6.18-128.1.10.el5
i386
I would like to create a customized CentOS server, or it will serve me as a server (postfis) postfixadmin, Hylafax, webmail (Roundcube for example) and may be I would integrate suger crm.
If I create it all this server and it runs perfectly. my goal is I create a compilation or for example I install this distrubution and wonder just some configuration (eg IP address or the time just) knowing that by the end of the installation I find hylafax, postfix , and all AC roundecube install it remains for me to set them up! Taking the example of Elastix cd: www.elastix.org/ or it can make all AC (but its main role is the PABX).
I was trying to create a centos box with xfs partition,how can we install centos enabling the partion with xfs filesystem. rather than doing after installation.
View 1 Replies View RelatedI want to create a new LDAP database.
Part of the new configuration is
Code:
dn: olcDatabase={1}hdb,cn=config
objectClass: olcDatabaseConfig
objectClass: olcHdbConfig
olcDatabase: {1}hdb
[Code].....
I'm attempting to install OpenBiblio to give it a test drive. I'm having trouble with one of the first steps within the openbiblio install guide. The step is dealing with MySQL in creating user priveleges to the db created. The step is:
Create an OpenBiblio database user. To do this, login to MySQL under the admin userid and run the following SQL command, substituting obiblio_user and obiblio_password with the userid and password of your choice.
mysql> grant all privileges on OpenBiblio.* to obiblio_user@localhost
-> identified by 'obiblio_password';
When I run the "grant all priveleges" command I receive a syntax error. I've spent some time googleing and it comes up with the same command. There has been a few variations attempted such as 'obiblio_user'@'localhost' but still recieve a syntax error.
Have been playing with Centos 5 and finally got it installed and have done most of the updates. Before I proceed much further it would be nice if I could create a backup/install disc of how it is now. No Data,just the setup and software used etc.Have a dvd rw on the server.I recall mondo rescue installed years ago on a linux server we used.
View 9 Replies View Related