Announcement

#1 2010-12-13 22:02:26

bkcorwin
Member
2010-12-13
52

[resolved] Change mysql user

Hello all, piwigo is working great!  Install was a snap and I'm very impressed.  However, I need to change the mysql user from what I specified during the install.  I cannot find an option to do this in the administration panel.  How do I do this?

Second,  I am trying to upload large files (> 2.0mb) to my database but it says they exceed the max size.
I have found some older threads saying that the only way to change this is to manually edit the config file.  The threads I found were old and I was wondering if such a change was possible via the admin panel.


Thank you much

Brian

Offline

 

#2 2010-12-13 22:44:47

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7215

Re: [resolved] Change mysql user

bkcorwin wrote:

Hello all, piwigo is working great!  Install was a snap and I'm very impressed.  However, I need to change the mysql user from what I specified during the install.  I cannot find an option to do this in the administration panel.  How do I do this?

Hi :-)

Which release of Piwigo you used?


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#3 2010-12-13 22:53:07

bkcorwin
Member
2010-12-13
52

Re: [resolved] Change mysql user

Sorry about that.  I am using Piwigo 2.1.5.

Brian

Offline

 

#4 2010-12-13 23:03:46

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7215

Re: [resolved] Change mysql user

bkcorwin wrote:

Sorry about that.  I am using Piwigo 2.1.5.

Brian

look local/config/database.inc.php


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#5 2010-12-13 23:11:26

bkcorwin
Member
2010-12-13
52

Re: [resolved] Change mysql user

OK thanks,
as an aside, I want to make it so that non admin users can upload images from the gallery without having to resort to an application such as ploader.  I installed 'community' but it appears this is just for users uploading via ploader.

How can I configure it so a regular non admin user can contribute photos to an existing category?

Thanks so much
b

Offline

 

#6 2010-12-13 23:31:12

bkcorwin
Member
2010-12-13
52

Re: [resolved] Change mysql user

Oops I managed to figure that out.  It requires a physical category in the galleries directory. 

It attempts to let a non admin user upload now but requires that the picture not exceed 200kb?  How can I get around this limit?  Is this the same config file that limits the admin file size?

B

Last edited by bkcorwin (2010-12-13 23:34:25)

Offline

 

#7 2010-12-13 23:36:23

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7215

Re: [resolved] Change mysql user

add for change in local config (with pluging localfile editor


// +-----------------------------------------------------------------------+
// |                                upload                                 |
// +-----------------------------------------------------------------------+

// upload_maxfilesize: maximum filesize for the uploaded pictures. In
// kilobytes.
$conf['upload_maxfilesize'] = 200;

// upload_maxheight: maximum height authorized for the uploaded images. In
// pixels.
$conf['upload_maxheight'] = 800;

// upload_maxwidth: maximum width authorized for the uploaded images. In
// pixels.
$conf['upload_maxwidth'] = 800;

// upload_maxheight_thumbnail: maximum height authorized for the uploaded
// thumbnails
$conf['upload_maxheight_thumbnail'] = 128;

// upload_maxwidth_thumbnail: maximum width authorized for the uploaded
// thumbnails
$conf['upload_maxwidth_thumbnail'] = 128;


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#8 2010-12-14 00:04:02

bkcorwin
Member
2010-12-13
52

Re: [resolved] Change mysql user

Excellent, I modified the local config file, and the max upload size in php.ini and I can now upload large images.

The last issue remaining is that if I as the admin upload an image, it automatically makes a resize for web image, that can then be clicked for the full resolution version.  If I upload an image as a regular user and then validate and synch the image, it does no such resizing and attempts to display what is possibly a huge 3000x4000 image. 

How can I get user uploaded images to have the same sort of automatic resizing that admin submitted images do?

Thanks much
brian

Offline

 

#9 2010-12-14 00:05:45

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13795

Re: [resolved] Change mysql user

bkcorwin wrote:

How can I get user uploaded images to have the same sort of automatic resizing that admin submitted images do?

Waiting for Piwigo 2.2 and a new version of the Community plugin, see [Forum, topic 16779] Piwigo 2.2, user upload form and Community plugin

Offline

 

#10 2010-12-14 01:56:40

bkcorwin
Member
2010-12-13
52

Re: [resolved] Change mysql user

Thanks much,
I'll be waiting for piwigo 2.2!

b

Offline

 

#11 2010-12-15 00:57:18

bkcorwin
Member
2010-12-13
52

Re: [resolved] Change mysql user

How is the mysql username stored in piwigo?  I am looking at /local/config/data*.php config file and it has the username I previously entered but the password is blank?  I believe my db requires a password and I entered one during install.

Thanks!
b

Offline

 

#12 2010-12-16 05:59:49

bkcorwin
Member
2010-12-13
52

Re: [resolved] Change mysql user

Anyone?  I am still confused why it has my mysql PW as blank in the config file?

As a test I tried putting a password into my database.inc.php file, the correct one mind you, and it breaks the gallery and denies access to the mysql database. 

When I restore the database.inc.php file back such that there is no password specified just '';  I can once again access the database.

I am confused again then as to how I can alter this file database.inc.php file to switch mysql user



Thanks!
b

Last edited by bkcorwin (2010-12-16 06:12:17)

Offline

 

#13 2010-12-16 08:22:03

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7215

Re: [resolved] Change mysql user

Does your Piwigo installation is locally ?

It is possible to have a database without password
If your site is accessible from the Web, You must add a password


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#14 2010-12-16 15:13:19

bkcorwin
Member
2010-12-13
52

Re: [resolved] Change mysql user

Piwigo is installed on a server I administer so yes its local.  I know the database requires a password to access as I cannot get into mysql without having  *-p <password>* as I log into it.  Should there be a password listed in plain text in that database*.php file?

Perhaps I should try to create a new user in mysql and see what that does.

B

Offline

 

#15 2010-12-16 15:17:26

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13795

Re: [resolved] Change mysql user

local/config/database.inc.php contains the database password, in plain text. The database password is nowhere else.

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact